MICROSOFT SQL SERVER 2019

 COURSE OUTLINE 

(THIS IS A 4 DAYs / 28 HOURS COURSE)

Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, beginners will learn the core skills they need to create and manage SQL Server databases.

You don't need any prior knowledge of databases or SQL query language.

This is a 4 days hands-on course. The trainer will explain how to make a database and maintain it using step-by-step practise. You will also be taught tips & tricks for good database management. You will design your own database and also modify existing databases. You will get ample practise so that you can apply them in practical situations in database management.


DAY 1 TRAINING

1. Getting Started Core concepts

SQL Server 2019 editions

Install SQL Server Developer Edition

Install Management Studio

Enable features with Configuration Manager


2. Log into the Server

Management Studio first steps Authentication and user permissions Create a new user account


3. Create Databases

Create the first database

Database configuration options Table structures

Create a simple table

Edit a table's structure

Enter data into a table using the GUI Import data from CSV files

Create tables from flat files

Install a sample database


WORKSHOP DAY 1

Getting started with SQL Server tools Exporting Data with the Import/Export Wizard

 Introducing database server components

Installing the Failover Cluster Feature

Designing and implementing an on-premises database infrastructure Designing Multiple Filegroups

Installing and configuring SQL Server instances and features Installing SQL Server Analysis Services

Installing SQL Server Integration Services

Installing and configuring SQL Server on Linux


DAY 2 TRAINING

4. Table Design for Healthy Databases Understand data types

Table column properties Primary key fields Establish a default value Check constraints Unique constraints Foreign keys

Create a foreign key column

Create relationships between tables


5. Structured Query Language Use the T-SQL editor

Create a table with T-SQL

Add data to a table

Retrieve records with SELECT Filter returned results with WHERE Sort records

Delete records from a table Update records in a table

Join related tables

LEFT JOIN and RIGHT JOIN Remove a table from the database


6. Query Performance

Create a view of the data

Data table indexes

Create additional indexes on a table Columnstore indexes

View execution plans

SQL Server's Query Store

Rebuild indexes


WORKSHOP DAY 2

Configuring SQL Server

Provisioning and configuring SQL Server databases

   Creating a SQL Login

Using the ALTER Command with the ROLLBACK IMMEDIATE Command Maintaining and monitoring SQL Server

Using CHECKDB

Managing Resource Utilization Using Resource Governor

Automating SQL Server administration

Configuring Database Mail


DAY 3 TRAINING

7. Query Programmability Aggregate functions

Use built-in functions

Leverage user-defined scalar functions Introduction to stored procedures Create stored procedures Parameterised stored procedures


8. Backup and Restore

Create a full backup of the database Create a differential backup

Restore a backup

Automate backups

Business continuity solutions


WORKSHOP DAY 3

Developing, deploying, and managing data recovery Creating a Differential Backup

Creating a Full Database Backup

Administering security and permissions

Granting Permissions to Create Tables

Protecting data through encryption, privacy and auditing

Creating a New Server Audit and Configuring a Server Audit Specification


DAY 4 TRAINING

9. Security

Database schemas

Dynamic data masking Always On data encryption


10. Monitoring and Management

Explore the role of system databases 

Prevent excessive tempdb autogrowth 

Review the SQL Server error log 

Dynamic management views


WORKSHOP DAY 4

Database Console Commands (DBCC) 

Performance tuning SQL Server 

Optimising Queries 

Understanding and designing indexes 

Creating a Non-Clustered Index 

Creating a Columnstore Index 

Configuring Full-Text Indexing

WHO SHOULD ATTEND

You must have some basic skills in HTML and:

RATIONALITY

LEARNING OUTCOME

You will learn:

 FOR PRICING AND BOOKING THIS COURSE, PLEASE E-MAIL US AT admin@marcnzed.com 

OR CALL +6012 451 4977 (MALAYSIA) OR  +65 9052 3859 (SINGAPORE)


Certificate

Upon successful completion of the course, participants will be awarded a verified digital certificate by Marc & Zed Training Singapore in collaboration with Marc & Zed SPACES Malaysia