Database Design

SQL Server 2014
  • 9 Videos | 1h 18m 34s
  • Includes Assessment
  • Earns a Badge
Likes 71 Likes 71
A Database Management System, also known as a DBMS, is used to control, store, organize, and retrieve that data. Discover databases,  DBMS, and RDBMS, and explore different database models.

WHAT YOU WILL LEARN

  • define a database, describe how data is stored in tables containing records and fields, and describe flat, hierarchal, and relational databases
    define database management systems (DBMS) and relational database management systems (RDBMS)
    describe the purpose of and navigate SQL Server Management Studio (SSMS), a SQL Server instance, and its objects
    describe the data types supported by SQL Server
    describe the importance of data integrity to related database tables and list the methods for enforcement
  • define the standards used in tables for data storage such as removing duplicates, breaking down fields, and the use of primary keys in the context of SQL Server examples
    define the standards used in column design and its properties such as auto increment columns, default and null values, and modifying size and format in the context of SQL Server examples
    define the table and column properties such as collation, data type, size, and field properties in the context of SQL Server examples
    define relationships in a database such as one-to-many, one-to-one, and many-to-many, outlining the role of primary, composite, and foreign keys in the context of SQL Server examples

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 58 Likes 58  
Likes 14 Likes 14  
CHANNEL MySQL
Likes 194 Likes 194  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 141 Likes 141  
Likes 57 Likes 57  
Likes 36 Likes 36