SQL Server Database Administration (Advanced Course)

SQL SERVER DBA COURSE CONTENT

SQL Server Introduction

This course is designed for professionals who wish to design and implement a database with Microsoft SQL Server. It is an instructor-led course that covers relational database fundamentals, database design, Structured Query Language (SQL) and database administration. (Online classes available)

Module -1(SQL SERVER DBA COURSE CONTENT)

INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS AND DATABASES
What is a database and a database management system (DBMS)
Introduction to Microsoft SQL Server and its overall SQL Server Data

Module-2 (Platform)

History and Current trends of DBMS and Database Administration
Tasks of a Database Administrator
MICROSOFT SQL SERVER 2016 INSTALLATION
What are the editions of Microsoft SQL Server 2016 Data Platform ?
Learn the hardware and software pre-requisites for a successful SQL

Module-3 (Server 2016 installation)

Understanding SQL Server 2016 components
Perform an successful initial installation of Microsoft SQL Server 2016
Understanding SQL Server version identifiers, installed directories and

Module-4 (conventions)

Add features to an existing SQL Server 2016 installation including Analysis

Module-5 (Services and Reporting Services)

Install Microsoft SQL Server 2016 Management Studio
MICROSOFT SQL SERVER 2016 ARCHITECTURE
Understanding SQL Server system databases and business (non-system)

Module-6 (databases)

Understanding the SQL Server database structure
What are SQL Server filegroups and datafiles
What are SQL Server Transactional logs and database recovery models
What is the difference between a SQL Server instance and database
Client-Server Communication in SQL Server 201
HOW TO CREATE DATABASE OBJECTS USING SQL SERVER 2016

Module-7 (MANAGEMENT STUDIO)

Create two sample databases (“AdventureWorks” databases) for

Module-8 (practice in the training)

How to create tables and indexes using the SQL Server Management

Module-9 (Studio (SSMS))

How to manage indexes using SSMS including rebuilding indexes to

Module-10 (reduce fragmentation)

How to create primary key foreign key relationships between tables using

Module-11 (SSMS)

How to add new file groups in SQL Server using SSMS
MICROSOFT SQL SERVER 2016 SECURITY
What are instance-level principals and database-level principals ?
Understand SQL Server fixed server roles
How to create a new database user and map it with an instance login
What are SQL Server database schemas and learn about their association

Module-12 (with database users)

Under database role memberships and how to grant permissions to
ownership of a SQL Server database instance
How to enable login auditing in SQL Server 2016
MICROSOFT SQL SERVER 2016 DATABASE SESSION ADMINISTRATION
Understand the differences between database connections and sessions
Learn about the details of various dynamic management views (DMVs)

Module-14 (for monitoring database activity)

How to kill (terminate) an SQL Server session id using SSMS
How to identify and run built-in reports in SSMS
Learn about the auto-commit, implicit and explicit transactions in SQL

Module-15 (Server)

SQL SERVER 2016 BACKUP AND RECOVERY PART 1
Introduction to Backup and Recovery strategy for databases
How to detach and attach databases in offline mode
How to copy databases using the Copy Database Wizard (CDW)
Full Database backups using the SIMPLE Recovery Model
Full Database and Transactional log backups with FULL Recovery Model
Differential database backups with FULL Recovery Model
How to view and maintain database backup history information
How to create maintenance plans for automating backups in SQL Server
How to create maintenance plans for purging old backups
Learn about the SQL Server Agent for scheduling backups
SQL SERVER 2016 BACKUP AND RECOVERY PART 2
Introduction to SQL Server Database Restore and Recovery
How to perform a full database restore and recovery
How to recover from SQL Server transactional logs
How to recover a database using time based recovery option (STOPAT)
How to use the checksum and compression options in backup operations
APPLYING SERVICE PACKS AND PERFORMING DATABASE UPGRADES
How to apply SQL Server 2012 Service Pack 3 (SP3) to SQL Server 2012 RTM

Module-16 (version)

How to upgrade databases from SQL Server 2012 SP3 to SQL Server 2016

Module-17 (RTM)

SQL SERVER 2016 DATA EXPORT AND IMPORT (DATA MOVEMENT)
Partial Data export and import using the command line tools – BCP

Module-18 (command)

Partial Data export and import using GUI tools – Export and Import Wizard
SQL SERVER 2016 PERFORMANCE TUNING
Understanding database indexes
Checking index fragmentation and maintaining them
Understanding and maintaining SQL Server Database statistics
Understanding SQL Server Profiler
How to create SQL Server traces
How to run server-side traces
SQL SERVER 2016 BACKUP TO URL (MICROSOFT CLOUD)
Create an account in Windows Azure
Create a storage account and containers within the Windows Azure

Module-19 (account)

Create SQL Server credentials for authenticating to the Windows Azure

Module-20 (URL)

Perform a full database backup to URL
Delete the database and restore it from the URL

Final Project

MySQL Database Management Final Project

Job Interview Questions

International Student Fees: USD350$

Skills Required
Fresh IT Student /No programming knowledge of SQL or MySQL is required. You should have basic experience of using computers and web browsers. This includes: