COURSE OUTLINE 

(THIS IS A 4 DAYs TRAINING PROGrAMME)

DAY 1

1. Overview of NoSQL Databases

Core concepts

Setting the scene for NoSQL

Essential concepts: Relational Database Strengths of Relational Databases Limitations of Relational Databases

The role of NoSQL Databases

2. What is MongoDB?

Introduction to Atlas, and the MongoDB Shell

3. Importing, Exporting, and Querying Data

BSON, JSON, importing and exporting data, and Basic Queries 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

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

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

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