Site icon EZDA Solutions

Microsoft SQL Server 2019 Database Design

Course Overview

This course focuses on skills necessary to architect well-performing databases in SQL Server. It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database. This includes a discussion of tables, data integrity, and indexes. As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups.

sql 2019 database design 300x200 1

Course objectives

You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases. Another major benefit of business-focused RDBMS (Relational Database Management Systems) is the use of enforced relationships and constraints. This course will cover all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations. One way of increasing both security and performance in a database is using stored procedures, functions, and triggers. 

0
Course Videos
0
Test Questions
0
E-BOOKS
0
Duration

Modules

Module 1: Designing and Building Tables

  • 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 Integrity

  • 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:  Indexing

  • 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 Triggers

  • 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 Data

  • 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 Search

  • 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-Prem

  • 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

Modes of Learning

Exit mobile version