MS SQL DBA
ELearningLine is presently offering a world class Microsoft SQL Server 2012 database administration training programme for interested students and professionals. Registration for our SQL Server classes is open for anyone in the world because it is provided in 3 different mode, self-learning, Instructor led online and traditional classroom. This course is sensibly designed for beginners as well as for advance level professionals who wanted to start or enhance their knowledge on SQL Server Database Administration, Installing, Backup/Restore, Query Designing, Tuning, Troubleshooting and DR/HA including SQL Clustering. Course highpoints contain Performance Tuning, Policy Management, Server Upgrades, Migrations and Data Management Operations. This SQL DBA Course also includes many assignments and Real-time Projects
Key Features of our SQL DBA course:
- Entirely Practical and Real-time Practical and Projects
- High quality e-learning material
- Remote LAB access,
- Extremely Interactive and Interesting
- Assignments to the students to challenge on course topics.
- 24x7 Server Access with Real-time DBs
- Certification Guidance for 70-462 Microsoft Exam
- Interview QAs and Placement Assistance
After the course Candidate should be able to:
- Understand SQL Server Database Design and Tables
- Work with real-world issues on Views & Stored Procedures
- SQL Query Writing and Tuning with MERGE, CTE
- Hands on DR and HA Techniques in a Cluster Setting
- Troubleshoot Issues, Repairs and DB Down Alerts
- Accomplish Upgrades, Patches and Migrations in SQL Clusters
- Able to backup, Monitor and restore database
- Detect and solve performance tuning
- Work with SQL Server monitors and CCMS monitors
- Maintain and troubleshoot database servers
Who should attend?
- MS SQL Server DBA training course is designed for:
- IT Developer who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases.
- Microsoft SQL Server 2012 Databases Certification aspirants
- SAP system administers
- Existing Database administrators
- IT professionals like Developers, Project team members
- All Technology consultants
Pre-requisites
- Interested candidates should have good hands-on knowledge:
- Windows OS basic operations,
- Basic networking concepts such as domain and active directory.
- Basic network settings.
Curriculum
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 Platform
- History and Current trends of DBMS and Database Administration
- Tasks of a Database Administrator
SQL Server 2012 Installation
- Editions of SQL Server 2012
- Hardware and Software pre-requisities for a successful SQL Server installation.
- Understanding SQL Server components.
- Perform a successful SQL Server 2012 installation
- Slipstreaming SQL Server installation with service packs
- Understanding SQL Server version identifiers, installed directories and conventions
SQL Server 2012 Administration and Development Tools
- Using SQL Server Books Online
- Using SQL Server Management Studio (SSMS)
- Using SQL Server Command Line interface
- Using SQL Server Configuration Manager
SQL Server 2012 Architecture
- Understanding SQL Server system databases.
- Understanding the SQL Server database structure
- SQL Server files and filegroups
- SQL Server Transactional logs, Recovery Models
- What is the difference between SQL Server instance and database
- Client-Server Communication
- Attaching and detaching SQL Server databases
SQL Server Database objects
- Understanding Schemas
- Understanding SQL Server data types
- Understanding column properties
- Creating tables, altering tables and adding constraints, relationships
- Understanding the filetable
- Creating database diagrams
SQL Server Backup and Recovery Part 1
- Introduction to Backup and Recovery strategy for databases
- Full Database backups using SIMPLE Recovery Model
- Full Database and Transactional log backups with FULL Recovery Model
- Backup history and maintenance
- Designing Maintenance plans for Backup Tasks
- SQL Server Agent for scheduling backups
- Database Mail for email notifications to DBAs
SQL Server Backup and Recovery Part 2
- Introduction to Database Restore and Recovery
- Full database restore
- Full database restore and recovery of transactional logs
- Restoring system databases
Database Objects
- Introduction
- Tables and Columns
- Indexes
- Packages, Stored procedures and Functions
- Database links
- Views and Synonyms
- SQL Server Data Dictionary
- Popular Data Dictionary views and accessing them
SQL Server Data Export and Import (Data Movement)
- Partial Data export and import using the command line BCP command
- Partial Data export and import using GUI tool Export and Import Wizard
- Move or copy a full database
SQL Server security
- SQL Server authentication vs. Windows authentication
- Auditing database logins using SQL Server Error Logging
- SQL Server server wide logins and database specific users
- Creating user-defined server roles
- Configuring contained databases
Performance Tuning Part 1
- Understanding database indexes
- Checking index fragmentation and maintaining them
- Database statistics
- Understanding SQL Server Profiler
- Creating Traces
- Running server-side traces
Performance Tuning Part 2
- Understanding the Extended Events architecture
- Creating and configuring an Extended Events session
- Using an extended events session to monitor system performance
SQL Server High Availability (Advance Topics)
- Database Mirroring
- Log Shipping
- AlwaysOn
- Failover cluster instance improvements
- Creating AlwaysOn availability groups
- Administering AlwaysOn Availability groups.
- Reading secondary database copies.
IT Developer who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases.
Microsoft SQL Server 2012 Databases Certification aspirants
SAP system administers
Existing Database administrators
IT professionals like Developers, Project team members
All Technology consultants
DROP INDEX and CREATE INDEX
ALTER INDEX
Exam 70-462 Administering Microsoft SQL Server 2012 Databases
Why is this exam popular?
SQL Server 2012 is a influential platform that is extensively used in many critical systems based on enterprise and cloud. Exam 70-462 is part of a series of certifications that can make you a master of MS Database Administration role.
What is the eligibility to take the 70-462 exam?
There are no eligibility requirements to take up this course. Anyone can Register at the Microsoft website and select your exam.
Who should attend this MS SQL Cerfification Exam 70-462?
- IT Developer who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases.
- Microsoft SQL Server 2012 Databases Certification aspirants
- SAP system administers
- Existing Database administrators
- IT professionals like Developers, Project team members
The percentages specify the relative load of each major topic area on the exam. The more the %, the more questions you are expected to see on that content area on the exam.
- Install and configure (19%)
- Maintain instances and databases (17%)
- Optimize and troubleshoot (14%)
- Manage data (19%)
- Implement security (18%)
- Implement high availability (12%)

Ritu l
Hi, I am a software developer by profession. I have registered with Microsoft for the SQL Certification Exam. To get properly prepared for the exam I have taken a few demo classes with few online tutorial institutes. No one could make me happy but e-Learning Line could. The course curriculum was superbly designed and they have industry best practitioner as instructors. They have helped me a lot. Thank you e-Learning Line.

jendaud a
E-Learning Line self-paced training is one of a kind. I have registered with Microsoft for SQL Certification Exam 70-462 for becoming a master of SQL Database Administration. I started searching for a better tutor to prepare for the Exam and who else could be better than e-Learning Line. I will definitely recommend e-Learning Line to everyone who wants to get hands-on knowledge on SQL Database.

IamDelicioso c
I am a professional Microsoft Consultant working with a Governmental organisation. I have taken the Instructor led online MS SQL DBA course. Apart from the course material and other preparation I would like to mention about the instructor I had. He was very knowledgeable and we had an amazing time discussing real life issues in testing and configuration. He helped me with so many things that I regularly face in my working field. I am very satisfied and happy with E-Learning Line.

Sonal Gupta
E-Learning Line has some of the best trainers from the field of SQL. My trainer was superb and always made sure that each student of his will understand everything. He was very equipped about the subject and also shared a lot of real life experience with us. That helped us to get maximum knowledge on SQL DBA. Thank you e-Learning Line for thorough help and assistance.
Trainers Details
Contact Us


Online Class schedule (EST)
Course Features
Popular Courses







