Database Design
SQL Server
| Beginner
- 9 videos | 1h 14m 34s
- Includes Assessment
- Earns a Badge
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
-
1. Introducing Databases10m 26sIn 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
-
2. DBMS and RDBMS9m 39sDuring this video, you will learn how to define database management systems (DBMS) and relational database management systems (RDBMS). FREE ACCESS
-
3. Introducing SQL Server Management Studio (SSMS)7m 39sUpon 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
-
4. Data Types5m 12sAfter completing this video, you will be able to describe the data types supported by SQL Server. FREE ACCESS
-
5. Data Integrity and Constraints8m 18sAfter 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
-
6. Table Design8m 30sDuring 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
-
7. Column Design7m 5sLearn 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
-
8. Table and Column Properties8m 37sFind 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
-
9. Understanding Relationships9m 9sIn 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.
