SQL Server 2019 Database Design

(6 customer reviews)
Sale!

Leading the way

SQL Server 2019 Database Design

(6 customer reviews)

| Total Course Video Hours: 6 Hrs 22 Min
|  Videos: 37
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute

Course Fee:

R1600,00

Current Special Ends in:

Days
Hours
Minutes
Seconds

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.  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.  You will learn what each of these objects is and how to write the T-SQL code to generate them.  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.
Course Prerequisites
  • Basic knowledge of the Microsoft Windows operating system
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
In this course, you will learn how to:
  • Design and Implement Tables.
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including Optimized and Columnstore indexes
  • Design and Implement Stored Procedures.
  • Design and Implement User Defined Functions.
  • Respond to data manipulation using triggers.
  • Store and Query Blobs and Text Documents.
Instructor: James Ring-Howell

Curriculum

SQL Server 2019 Database Design


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

6 reviews for SQL Server 2019 Database Design

  1. Amina

    Thank you for helping me get my dream job

  2. Zahara

    I am thrilled to have chosen CSI for this course. Thank you for exceeding my expectations!

  3. Nombulelo

    The course offered a wide range of topics, catering to different interests within the subject area.

  4. Lucas

    I got my dream job thanks to you

  5. Andile

    I’m so grateful for this course. Thank you, for helping me achieve my goals!

  6. Gabriel

    I appreciated the regular updates and additional resources provided throughout the course.

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.