Microsoft SQL Server 2019 Database Design
$199.00
Learn to design fast, reliable databases in Microsoft SQL Server 2019, from tables and indexes to triggers and Azure options. For DBAs, developers and data staff, with 6 hours 22 minutes across 37 videos.
- Login details sent straight after payment
- Self-paced. Study on any device
- StemBoss Certificate of Completion
- 14-day refund promise
Secure checkout. Pay by card, Apple Pay or Google Pay.
Microsoft SQL Server 2019 Database Design is a self-paced course that shows you how to plan and build sound databases in SQL Server 2019. It suits database administrators, developers and data analysts who want tables, keys and indexes that hold up as data grows. The course runs for 6 hours 22 minutes across 37 videos, with 75 test questions to check your progress.
What you will learn
- Plan a database and create tables with the right data types
- Group objects into schemas and change tables safely
- Enforce domain, entity and referential integrity
- Choose between heaps, clustered and nonclustered indexes
- Build single column and composite indexes
- Write stored procedures, user-defined functions and triggers
- Store large binary data with FILESTREAM and FileTables
- Set up full-text catalogs, indexes and queries
- Compare SQL Server on an Azure VM, Azure SQL Managed Instance and Azure SQL Database
Course outline
- Designing and building tables: database design basics, creating tables, data types, schemas and altering tables
- Enforcing data integrity: domain integrity, then entity and referential integrity
- Indexing: core concepts, heaps, clustered and nonclustered indexes, single and composite indexes
- Stored procedures, functions and triggers: an introduction to database programming
- BLOB and FILESTREAM data: working with binary data, with FILESTREAM and FileTable examples
- Full-text search: catalogs, indexes and queries
- Azure vs on-premises: the three main ways to run SQL Server in Azure, plus a course wrap-up
Who this course is for
- Database administrators who want stronger design skills
- Developers who build apps on SQL Server
- IT staff moving into database roles
- Data analysts and data engineers
- Students who are new to database management
Before you start
You do not need any formal qualifications to start. It helps if you have used SQL Server before and can write a simple query. If you are brand new to SQL, take a querying course first.
Jobs this course supports
- Database Administrator
- SQL Developer
- Data Engineer
- Business Intelligence Analyst
- Data Architect
- IT Consultant
| Skill level | Intermediate |
|---|---|
| Duration | 6 Hours 22 Minutes |
| Videos | 37 Course Videos |
| Questions | 75 Test Questions |
| Prerequisites | No formal prerequisites. Some basic SQL or database knowledge will help. |
| Best for | Database administrators, SQL developers, data engineers, BI analysts, data architects |
| Topics covered | Tables and schemas, data types, data integrity, indexing, stored procedures and triggers, FILESTREAM data, full-text search, Azure SQL options |
| Format | Online video lessons, self-paced |
| Language | English |
| Closed captions | Yes |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
7 modules and 37 lessons. Here is the full outline.
Module 1 - Designing and Building Tables7 lessons
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Database Design
- 1.4 Creating Tables
- 1.5 Data Types
- 1.6 Schemas
- 1.7 Altering Tables
Module 2 - Enforcing Data Integrity5 lessons
- 2.1 Module 2 Introduction
- 2.2 Introduction to Data Integrity
- 2.3 Data Domain Integrity
- 2.4 Implementing Data Domain Integrity
- 2.5 Implementing Entity and Referential Integrity
Module 3 - Indexing5 lessons
- 3.1 Module 3 Introduction
- 3.2 Core Indexing Concepts
- 3.3 Heaps, Clustered, and Nonclustered Indexes
- 3.4 Data Types and Indexes
- 3.5 Single Column and Composite Indexes
Module 4 - Stored Procedures, Functions, and Triggers5 lessons
- 4.1 Module 4 Introduction
- 4.2 Introduction to Database Programming
- 4.3 Creating Stored Procedures
- 4.4 Creating User-Defined Functions
- 4.5 Creating Triggers
Module 5 - Blob and Filestream Data5 lessons
- 5.1 Module 5 Introduction
- 5.2 Introduction to Binary Data
- 5.3 Considerations for BLOB data
- 5.4 FILESTREAM Example
- 5.5 File Table Example
Module 6 - Full-Text Search5 lessons
- 6.1 Module 6 Introduction
- 6.2 Introduction to Full-Text Search
- 6.3 Full-Text Catalogs
- 6.4 Full-Text Indexes
- 6.5 Full-Text Queries
Module 7 - Azure vs On-Prem5 lessons
- 7.1 Module 7 Introduction
- 7.2 SQL Server on Azure VM
- 7.3 Azure Managed SQL Instance
- 7.4 Azure SQL Database
- 7.5 Course Wrap Up
Your learning path
Where Microsoft SQL Server 2019 Database Design fits. Build your skills one step at a time.
Frequently asked questions
Does this course cover SQL Server in Azure?
Yes. The last module compares SQL Server on an Azure virtual machine, Azure SQL Managed Instance and Azure SQL Database, so you can see which fits a project.
Will I learn how to index tables?
Yes. A full module covers heaps, clustered and nonclustered indexes, how data types affect indexes, and single column versus composite indexes.
Is this a querying course?
No. It focuses on design: tables, integrity rules, indexes and database code. Pair it with Learn SQL Server 2019, Querying SQL Server if you need query skills first.
Does it cover stored procedures and triggers?
Yes. One module introduces database programming and walks through stored procedures, user-defined functions and triggers.
What is FILESTREAM and is it covered?
FILESTREAM lets SQL Server store large files such as images on the file system while keeping them linked to the database. The course explains when to use it, with FILESTREAM and FileTable examples.
Do I get a certificate?
Yes. You get a StemBoss Certificate of Completion when you finish the course.
Can I get a refund?
Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.
