dba_training_sqlops

SQL Server DBA MCSA Certification

Students can use this training to prepare for some of the topics required to pass the Administering Microsoft SQL Server 2012/2014 Databases Exam 70-462.

Course Description for SDBA 441

SDBA 441 (28 Credit Hours)
Offered In-Class and Remotely

Administering Microsoft SQL Server Databases

NOTE: Course comes with a free training in this course SSQL 401 – Click here – Querying Microsoft SQL Server with Transact-SQL – to learn more
Prerequisite: Prior IT course, IT experience, or instructor approval.

Target Audience: This training is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.This course will also fit very well for those who are very good at their Logical skills. This training will be suitable for;

  • Fresh Graduates
  • College / School Students
  • Database Developers
  • Job Seekers
  • IT Employees

Course Description: Introductory to Advanced coverage of the technical skills required to administering Microsoft SQL Server to put you right where you want to be in this competitive job market. This SQL DBA Training course will cover Building & Maintenance of SQL Server Databases from an Infrastructure standpoint. It will start with a discussion on SQL SERVER Architecture, Building SQL Server instance with best practices in current IT trend. Deep understanding of Backups & Restore concepts along with capacity planning. It enriches SQL DBA skillset of the person who pursues it with ways of handling performance issues with SQL Native tools. Sessions on SQL user audits & security added with advanced High Availability & Disaster Recovery planning.

Course Objectives: At end of this SQL Server DBA training you will be able to,

  • To make high profiled SQL Server DBA with much-needed infrastructure DBA knowledge.
  • The pursuer will be able to associate him/her with globalized IT firms very easily in competing with the huge available market.
  • The contents of the course designed with all real-time experiences & troubleshooting methods of the same helping students to bridge the gap between their view of IT exposure & Real-time expectations of current IT.

Course 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 2012/14/16 Installation
What are the editions of Microsoft SQL Server  Data Platform ?.
Learn the hardware and software pre-requisites for a successful SQL Server installation.
Understanding SQL Server components.
Perform a successful initial installation of Microsoft SQL Server.
Understanding SQL Server version identifiers, installed directories and conventions.
Add features to an existing SQL Server installation including Analysis Services and Reporting Services.
Install Microsoft SQL Server  Management Studio.

Microsoft SQL Server 2012/14/16 Architecture
Understanding SQL Server system databases and business (non-system) databases.
Understanding the SQL Server database structure.
What are SQL Server file groups and data files?
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.

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 filegroups in SQL Server using SSMS.

Microsoft SQL Server 2012/14/16 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 2012/14/16 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.
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 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 Service Packs, CUs, and GDRs.
How to upgrade SQL Server and databases

SQL Server 2012/14/16 Data Export and Import (Data Movement)
Partial Data export and import using the command line tools – BCP command.
Partial Data export and import using GUI tools – Export and Import Wizard.

SQL Server 2012/14/16 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 2012/14/16 Backup to URL (Microsoft Cloud)
Create an account in Windows Azure.
Create a storage account and containers within the Windows Azure account.
Create SQL Server credentials for authenticating to the Windows Azure URL.
Perform a full database backup to URL.
Delete the database and restore it from the URL.

SQL Server High Availability Features
Understanding SQL Server and High Availability Concepts
Install and configuring SQL Server Failover Cluster
Setting up and configuring Database Mirroring, Log Shipping, Replication, and AlwaysOn
Troubleshooting HA issues.