Database Design

SQL Server    |    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

Channel SQL Database Development & Design
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Course System Design Standards & Compliance
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Software Design and Development: Software Engineering & SDLC Phases
Rating 4.6 of 4717 users Rating 4.6 of 4717 users (4717)
Course REST API: Working with Methods & Formatters
Rating 4.5 of 72 users Rating 4.5 of 72 users (72)
Course Implementing Governance Strategies
Rating 4.6 of 48 users Rating 4.6 of 48 users (48)