MS SQL DBA Training

 

Why become a Database Administrator

Are you ready for Learning again ? Unlock your potential in the Information Technology “evergreen” field called Database Administration (DBA). AI will not take away a DBA’s job. Start your career and retire as a Database Professional (provided you put in the effort and work hard).

SQL (Structured Query Language) is a prerequisite for this course and we hope you know SQL. If not, we do offer an SQL course too (a set of 20 recorded video lectures with lab work).

 

Training Instructor

This MS SQL DBA Training is conducted by our founder Srini Ramineni over ZOOM. But it is a LIVE instructor led training.

The training classes are held from Monday to Thursday for 5 weeks with a total of 40 hours (2 hours per day).

A custom written training material PDF book of about 300 pages will be provided to each student.

 

Fees/Cost for the training

The total cost is $699. This amount should be paid in advance at the time of registration for the training webinar using zoom. You can pay using your CREDIT/DEBIT Card, Bank Account (ACH), Google Pay (or) Apply Pay. We use Stripe for payment and therefore it is very secure. Click here to BUY.

This fee includes LIVE instructor led training online for 40 hours (5 weeks), dedicated remote lab access on a 24*7 basis for 3 months and a custom written training material PDF book of about 300 pages.

 

Training Timings – Monday to Thursday

7 pm Central Time to 9 pm Central Time (2 hours).

Total for 5 weeks (40 hours).

 

Lab Practical Exercises

Each student will be provided a dedicated Remote Desktop Connection with Linux operating system. Students can login remotely using their Windows PC or Apple MAC computer. The duration of the access will be for a period of 3 months from the start of the training program on a 24*7 basis.

 

Training Topics

 

Introduction to database management systems and databases

 

• What are a database and a database management system (DBMS?).
• Introduction to Microsoft SQL Server and its overall SQL Server Data Platform.
• History and Current trends of DBMS and Database Administration.
• Tasks of a Database Administrator.

 

Microsoft SQL Server 2019 Installation

 

• What are the editions of Microsoft SQL Server 2019 Data Platform ?
• Learn the hardware and software pre-requisites for a successful SQL Server 2019 installation.
• Understanding SQL Server 2019 components
• Perform a successful initial installation of Microsoft SQL Server 2019.
• Understanding SQL Server version identifiers, installed directories and conventions.
• Add features to an existing SQL Server 2019 installation including Analysis Services and Reporting
  Services.
• Install Microsoft SQL Server 2019 Management Studio.

 

Microsoft SQL Server Architecture

 

• Understanding SQL Server system databases and business (non-system) 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 2019.

 

How to create database objects using SQL Server  Management Studio

 

• Create two sample databases (“AdventureWorks” databases) for practice in the training.
• How to create tables and indexes using the SQL Server Management Studio (SSMS).
• How to manage indexes using SSMS including rebuilding indexes to reduce fragmentation.
• How to create primary key foreign key relationships between tables using SSMS.
• How to add new file groups in SQL Server using SSMS.

 

Microsoft SQL Server 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 with database users.
• Under database role memberships and how to grant permissions to database users.
• What is SQL Server Configuration Manager and how to change the ownership of a SQL Server
  database instance.
• How to enable login auditing in SQL Server.

 

Microsoft SQL Server database session administration

 

• Understand the differences between database connections and sessions.
• Learn about the details of various dynamic management views (DMVs) 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 Server.

 

SQL Server 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.

 

SQL Server Backup and Recovery – Part 2

 

• 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 Backup and Recovery – Part 3

 

• 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.

 

SQL Server database upgrade

 

• Installation of MS SQL Server 2022 Data Platform.
• How to upgrade databases from SQL Server 2019 to SQL Server 2022.

 

SQL Server Data Export and Import (Data Movement)

 

• Generate and Publish Scripts Wizard.
• Partial Data export and import using the command line tools – BCP command.
• Partial Data export and import using GUI tools – Export and Import Wizard.
• BULK INSERT (T-SQL statement).

 

SQL Server Performance Tuning

 

• Understand database indexes.
• Check index fragmentation and maintaining them.
• Learn to use SQL Server Activity Monitor.
• Understand and maintain SQL Server Database statistics.
• Understand SQL Server Profiler.
• How to create SQL Server traces.