Database Design

SQL Server 2014    |    Beginner
  • 9 videos | 1h 14m 34s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 224 users Rating 4.3 of 224 users (224)
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

  • Locked
    1.  Introducing Databases
    10m 26s
    In this video, you will define a database, describe how data is stored in tables containing records and fields, and describe flat, hierarchical, and relational databases. FREE ACCESS
  • Locked
    2.  DBMS and RDBMS
    9m 39s
    During this video, you will learn how to define database management systems (DBMS) and relational database management systems (RDBMS). FREE ACCESS
  • Locked
    3.  Introducing SQL Server Management Studio (SSMS)
    7m 39s
    Upon completion of this video, you will be able to describe the purpose of SQL Server Management Studio (SSMS), navigate a SQL Server instance, and its objects. FREE ACCESS
  • Locked
    4.  Data Types
    5m 12s
    After completing this video, you will be able to describe the data types supported by SQL Server. FREE ACCESS
  • Locked
    5.  Data Integrity and Constraints
    8m 18s
    After completing this video, you will be able to describe the importance of data integrity to related database tables and list the methods for enforcement. FREE ACCESS
  • Locked
    6.  Table Design
    8m 30s
    During this video, you will learn how to define standards for data storage in tables, such as removing duplicates, breaking down fields, and using primary keys, with examples from SQL Server. FREE ACCESS
  • Locked
    7.  Column Design
    7m 5s
    Learn how to define the standards used in column design, such as auto increment columns, default and null values, and modifying size and format, in the context of SQL Server examples. FREE ACCESS
  • Locked
    8.  Table and Column Properties
    8m 37s
    Find out how to define the table and column properties, such as collation, data type, size, and field properties, in the context of SQL Server examples. FREE ACCESS
  • Locked
    9.  Understanding Relationships
    9m 9s
    In this video, you will learn how to define relationships in a database, such as one-to-many, one-to-one, and many-to-many. You will also learn about primary, composite, and foreign keys in the context of SQL Server examples. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.6 of 122 users Rating 4.6 of 122 users (122)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Tables
Rating 4.5 of 390 users Rating 4.5 of 390 users (390)
Rating 4.7 of 18 users Rating 4.7 of 18 users (18)
Rating 4.6 of 274 users Rating 4.6 of 274 users (274)