Overview

This Microsoft SQL Server 2019 Database Design course emphasizes the skills needed to design high-functioning databases in SQL Server. Not only will you learn about the fundamentals and resources required for an efficient database, but also gain insight and skill into tables, data accuracy and indexes. Plus, we explore essential programming techniques, file storage solutions and full-text search capabilities. This Microsoft SQL Server 2019 Database Design course emphasizes the skills needed to design high-functioning databases in SQL Server. Not only will you learn about the fundamentals and resources required for an efficient database, but also gain insight and skill into tables, data accuracy and indexes. Plus, we explore essential programming techniques, file storage solutions and full-text search capabilities. In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. In this online training course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use. NO CREDIT CARD REQUIRED In this course you will learn how to start building enterprise web applications. This course will provide you with training in web development, C Sharp, HTML and CSS, SQL Server, JavaScript, Object Based JavaScript, Model View and Controller, and jQuery. Elevate your web development programming skills in this HTML5 and CSS3 training course. HTML5 and CSS3 are key web technologies that allow you to build up content for the internet. This training program showcases how to use innovative HTML5 multimedia features such as video, audio, and animation. With this course, you can unlock more creative possibilities with your digital media!

Your Training Instructor

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.

  • 6 Traning Hours
  • 37 Videos
  • 7 Topics
  • 75 Practice Questions

This IT online training course focuses on skills necessary to architect well-performing SQL Data Warehouse 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 Table structures, data integrity, and indexes. As well as basic programming, file storage, analytics queries, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups.

You will gain an in-depth understanding of 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 online training 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. You will learn what each of these objects is and how to write the T-SQL code to generate them.

Within this training program we will also cover the use of SQL Management Studio to perform these various operations using visual tools where possible. At the end of the course, you should be able to create a highly functional business database.

In this online IT course you will learn 

  • Database Administration and database applications
  • Table structures and managing them
  • Data types 
  • Schemas 
  • and so much more

Frequently Asked Questions About Microsoft SQL Server 2019 Database Design

What skills does the Microsoft SQL Server 2019 Database Design course emphasize?

This course focuses on developing the skills necessary to design high-functioning databases in SQL Server. You’ll learn about the fundamentals and resources required for an efficient database, and gain insight into tables, data accuracy, indexes, essential programming techniques, file storage solutions, and full-text search capabilities​.

What kind of practical tools and principles does the course cover?

The course covers the principles and practical tools necessary to understand and create all objects needed for a complete database. This includes a discussion of table structures, data integrity, indexes, basic programming, file storage, analytics queries, and full-text searching.

Will the course cover the use of indexes in databases?

Yes, you will gain an in-depth understanding of the benefits and requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups.

Will I learn about data integrity and validation?

Absolutely! The course covers all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations​.

What about learning to write SQL code for stored procedures, functions, and triggers?

The course will teach you what each of these objects is and how to write the T-SQL code to generate them, an important aspect of both database security and performance.

Course Outline

SQL Server 2019 Database Design Course Outline

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