Microsoft SQL Server 2019 Database Design

Take an extra 30% off this course! No coupon needed; auto applies in cart.

$49.00

Sale Ends Soon

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

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.

6  Training Hours
37 Videos
7  Topics
75 Practice Questions

Course Description

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

Your Training Instructor

James Ring-Howell

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.

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
Microsoft SQL Server 2019 Database Design
Microsoft SQL Server 2019 Database Design

$49.00

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.

Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
$39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

This extensive Microsoft 70-765 SQL – Provisioning SQL Databases course offers 23 hours of training and 102 videos, providing an in-depth explanation behind the procedures, influences, toolsets and operations related to running SQL Server on Cloud.

$49.00

The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.

$39.00

In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.

$49.00

In this Microsoft 70-487 course you will learn how to access data, query and manipulate data by using the entity framework, create and consume web API-based services, design and implement web services, and deploy in Microsoft Azure and Web Services.

UNLOCK

25% OFF

Sign up for updates, discounts, and more.