Database Design

SQL Server 2014    |    Beginner
  • 9 Videos | 1h 18m 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

CHANNEL PostgreSQL
Likes 42 Likes 42  
Likes 38 Likes 38  
Likes 108 Likes 108  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE T-SQL Queries
Likes 173 Likes 173  
Likes 32 Likes 32  
COURSE SQL Views
Likes 60 Likes 60