Complete Microsoft SQL Server Database Administration Course

<div>Microsoft SQL Server continues to be one of the world's most popular and top databases.&nbsp; Database is a heart of IT which is needed to stored all critical data and information.&nbsp;</div><div><br></div><div><span style="font-size: 1rem;">If you want to become SQL database administrator then this is the PERFECT course for YOU.&nbsp; This training course will provide you all the necessary skills you need to be a successful database administrator.&nbsp; The "Complete Microsoft SQL Server Database Administration Course" is designed to provide a comprehensive understanding of database administration using Microsoft SQL Server. This course is ideal for IT professionals, database administrators, and anyone interested in learning about SQL Server infrastructure. It covers key aspects such as installation, configuration, maintenance, security, and performance tuning of SQL Server databases</span></div><div><br></div><div><span style="font-size: 1rem;">Here is the course outline:</span></div><div><br></div><div>Section 1 - Introduction</div><div><ul><li><span style="font-size: 1rem;">Introduction to Database</span></li><li><span style="font-size: 1rem;">RDBMS</span></li><li><span style="font-size: 1rem;">What is SQL?</span></li><li><span style="font-size: 1rem;">Top 5 RDBMS</span></li><li><span style="font-size: 1rem;">Introduction to MS SQL Server</span></li><li><span style="font-size: 1rem;">Different editions of MS SQL</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 2 - Download, Install and Configure Windows</span></div><div><ul><li><span style="font-size: 1rem;">MS SQL Server prerequisite</span></li><li><span style="font-size: 1rem;">Lab setup</span></li><li><span style="font-size: 1rem;">What is virtualization?</span></li><li><span style="font-size: 1rem;">Download and Install VMWare Workstation Player</span></li><li><span style="font-size: 1rem;">Optional - Download and Install Oracle VirtualBox</span></li><li><span style="font-size: 1rem;">Create a Virtual Machine</span></li><li><span style="font-size: 1rem;">Download and Install Windows Server</span></li><li><span style="font-size: 1rem;">Virtual Machine Management</span></li></ul></div><div><span style="font-size: 1rem;"><br></span></div><div><span style="font-size: 1rem;">Section 3 - Download, Install and Configure MS SQL Server</span></div><div><ul><li><span style="font-size: 1rem;">Prerequisites for MSSQL Installation</span></li><li><span style="font-size: 1rem;">Download MSSQL and SQL Server Management Studio</span></li><li><span style="font-size: 1rem;">Install and Configure MSSQL</span></li><li><span style="font-size: 1rem;">Install SQL Server Management Studio</span></li><li><span style="font-size: 1rem;">Download and Install AdventureWorks Database</span></li></ul></div><div><br></div><div>Section 4 - Database Fundamentals and Design</div><div><ul><li><span style="font-size: 1rem;">What is Data and Database?</span></li><li><span style="font-size: 1rem;">How is data stored?</span></li><li><span style="font-size: 1rem;">What is a Table, COLUMN and ROW ?</span></li><li><span style="font-size: 1rem;">What is a key? primary, foreign, unique keys etc.</span></li><li><span style="font-size: 1rem;">What is Relational Database and Relational Database Management System (RDBMS)?</span></li><li><span style="font-size: 1rem;">What is a Transaction and ACID properties?</span></li><li><span style="font-size: 1rem;">Database Normalization AND Different forms of Database Normalization</span></li><li><span style="font-size: 1rem;">Create your first Database, Table and Populate table with data…</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 5 - Introduction to SQL Commands</span></div><div><ul><li><span style="font-size: 1rem;">Welcome to Basic SQL Commands</span></li><li><span style="font-size: 1rem;">What is a SQL Statement and types of SQL statements</span></li><li><span style="font-size: 1rem;">DML Statement with examples</span></li><li><span style="font-size: 1rem;">DDL Statements with examples</span></li><li><span style="font-size: 1rem;">DCL Statement with examples</span></li><li><span style="font-size: 1rem;">TCL Statement with examples</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 6 - Query and Manipulation of Data using SQL</span></div><div><ul><li><span style="font-size: 1rem;">Create TABLE(s) and Temp Table(s)</span></li><li><span style="font-size: 1rem;">What Is a View?</span></li><li><span style="font-size: 1rem;">SELECT Statement in detail</span></li><li><span style="font-size: 1rem;">Operators, Expressions and Conditions</span></li><li><span style="font-size: 1rem;">WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause</span></li><li><span style="font-size: 1rem;">Select from two tables – JOINS</span></li><li><span style="font-size: 1rem;">Different Types of JOINS</span></li><li><span style="font-size: 1rem;">What is a Sub Query?</span></li><li><span style="font-size: 1rem;">INSERT, UPDATE, DELETE and Truncate Statements</span></li><li><span style="font-size: 1rem;">What is a Store Procedure?</span></li><li><span style="font-size: 1rem;">Function, Trigger and INDEX</span></li><li><span style="font-size: 1rem;">Clustered ,Non-clustered Indexes and Index Design considerations</span></li><li><span style="font-size: 1rem;">Index Fragmentation and Lab for Index</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 7 - Microsoft SQL Database Administration</span></div><div><ul><li><span style="font-size: 1rem;">Overview of MSSQL Management Tools</span></li><li><span style="font-size: 1rem;">Exploring SQL Server Management Studio (SSMS)</span></li><li><span style="font-size: 1rem;">Exploring SQL Server Configuration Manager</span></li><li><span style="font-size: 1rem;">MSSQL System Databases, DO's and DONT's of System databases</span></li><li><span style="font-size: 1rem;">What is master, etmpdb, msdb and other system databases?</span></li></ul></div><div><br></div><div>Section 8 - Deep Dive into MSSQL Working</div><div><ul><li><span style="font-size: 1rem;">What are Pages , Extents, Page Architecture and PFS?</span></li><li><span style="font-size: 1rem;">MSSQL Architecture</span></li><li><span style="font-size: 1rem;">MSSQL Database Architecture</span></li><li><span style="font-size: 1rem;">Operation and working of transaction log</span></li><li><span style="font-size: 1rem;">Configuring user Database</span></li><li><span style="font-size: 1rem;">Best practices while creating user Database</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 9 - MSSQL Backup and Restore</span></div><div><ul><li><span style="font-size: 1rem;">Backup of a Database, Importance for DBA and Different Media used for Backups</span></li><li><span style="font-size: 1rem;">Recovery Models in MSSQL and how that impact backups an restore</span></li><li><span style="font-size: 1rem;">Full and differential backups</span></li><li><span style="font-size: 1rem;">Transaction Log Backups, Log Backup Chain and Tail-log Backup</span></li><li><span style="font-size: 1rem;">Lab for Full, Differential and Transaction Log Backups</span></li><li><span style="font-size: 1rem;">Restore and Recovery Overview</span></li><li><span style="font-size: 1rem;">Full, Differential and Transaction Log database restore</span></li><li><span style="font-size: 1rem;">Point in time restore of a database</span></li><li><span style="font-size: 1rem;">Complete Backup , Restore and Restore in Time Lab</span></li><li><span style="font-size: 1rem;">MS SQL Server DBCC CHECKDB command</span></li><li><span style="font-size: 1rem;">Page Level Restore / Recovery using Full Backups</span></li><li><span style="font-size: 1rem;">Creating Maintenance Plan Backups/Re-indexing etc.</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 10 - MSSQL User Management</span></div><div><ul><li><span style="font-size: 1rem;">MSSQL Security Model</span></li><li><span style="font-size: 1rem;">MSSQL Server Authentication Modes</span></li><li><span style="font-size: 1rem;">Server Logins</span></li><li><span style="font-size: 1rem;">Server Roles</span></li><li><span style="font-size: 1rem;">Database Users</span></li><li><span style="font-size: 1rem;">Database Roles</span></li><li><span style="font-size: 1rem;">Permissions (GRANT , DENY, and REVOKE)</span></li></ul></div><div><br></div><div>Section 11 - MSSQL Server Agent Management</div><div><ul><li><span style="font-size: 1rem;">SQL Server Agent Introduction</span></li><li><span style="font-size: 1rem;">SQL Server Agent Jobs and Schedules</span></li><li><span style="font-size: 1rem;">Agent Alerts</span></li><li><span style="font-size: 1rem;">Operators</span></li><li><span style="font-size: 1rem;">Database Mail</span></li><li><span style="font-size: 1rem;">Activity Monitor</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 12 - Advanced SQL Server Administration Topics</span></div><div><ul><li><span style="font-size: 1rem;">High Availability and its Types</span></li><li><span style="font-size: 1rem;">What Is Replication and Transactional Replication</span></li><li><span style="font-size: 1rem;">Transactional Replication Setup (LAB)</span></li><li><span style="font-size: 1rem;">Log Shipping and Configuring Log Shipping</span></li><li><span style="font-size: 1rem;">SQL Server Encryption and Encryption Types</span></li><li><span style="font-size: 1rem;">Transparent Data Encryption (TDE) and configuration</span></li></ul></div><div><br></div><div><span style="font-size: 1rem;">Section 13 - Course Re-cap</span></div><div><ul><li><span style="font-size: 1rem;">Commands we have learned</span></li></ul></div>

What you'll learn:

• By the end of this course you will be a professional SQL database administrator and be able to apply for SQL jobs
• Administration of SQL database through Microsoft Windows
• You will learn 150+ SQL queries
• You will be able to troubleshoot everyday SQL related issues
• You will manage SQL servers in a corporate environment
• You will write basic to advance SQL queries
• Troubleshoot everyday SQL database related issues
• Know how to answer specific business questions by using SQL’s aggregate functions
• Students will be able to run reports for management so they can make financial decisions