Database Design

SQL Server 2014    |    Beginner
  • 9 Videos | 1h 14m 34s
  • Includes Assessment
  • Earns a Badge
Likes 109 Likes 109
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 132 Likes 132  
Likes 177 Likes 177  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 130 Likes 130  
COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 141 Likes 141