MS SQL DBA

As you know a relational database is a set of tables, data sets stored in those tables have relations among them and Database Administrators (DBAs) are accountable for the design, execution, maintenance, enhancement and support of these databases in today's organizations. The role also includes architecting, designing and monitoring databases for data backups, restore, growth along with security, performance and availability of data to users and customers. All these tasks are achieved with the help of a Database Management System (DBMS) like Microsoft SQL Server Data Platform which is one of the most famous and widely used around the world.

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:
  1. Entirely Practical and Real-time Practical and Projects
  2. High quality e-learning material
  3. Remote LAB access,
  4. Extremely Interactive and Interesting
  5. Assignments to the students to challenge on course topics.
  6. 24x7 Server Access with Real-time DBs
  7. Certification Guidance for 70-462 Microsoft Exam
  8. Interview QAs and Placement Assistance 
After the course Candidate should be able to:
  1. Understand SQL Server Database Design and Tables
  2. Work with real-world issues on Views & Stored Procedures
  3. SQL Query Writing and Tuning with MERGE, CTE
  4. Hands on DR and HA Techniques in a Cluster Setting
  5. Troubleshoot Issues, Repairs and DB Down Alerts
  6. Accomplish Upgrades, Patches and Migrations in SQL Clusters
  7. Able to backup, Monitor and restore database
  8. Detect and solve performance tuning
  9. Work with SQL Server monitors and CCMS monitors
  10. Maintain and troubleshoot database servers 
Who should attend?
  1. MS SQL Server DBA training course is designed for:
  2. IT Developer who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases.
  3. Microsoft SQL Server 2012 Databases Certification aspirants
  4. SAP system administers
  5. Existing Database administrators
  6. IT professionals like Developers, Project team members
  7. All Technology consultants 
Pre-requisites
  1. Interested candidates should have good hands-on knowledge:
  2. Windows OS basic operations,
  3. Basic networking concepts such as domain and active directory.
  4. Basic network settings.

Curriculum


Introduction to database management systems and databases

  1. What is a database and a database management system (DBMS)
  2. Introduction to Microsoft SQL Server and its overall SQL Server Data Platform
  3. History and Current trends of DBMS and Database Administration
  4. Tasks of a Database Administrator

SQL Server 2012 Installation

  1. Editions of SQL Server 2012
  2. Hardware and Software pre-requisities for a successful SQL Server installation.
  3. Understanding SQL Server components.
  4. Perform a successful SQL Server 2012 installation
  5. Slipstreaming SQL Server installation with service packs
  6. Understanding SQL Server version identifiers, installed directories and conventions

SQL Server 2012 Administration and Development Tools

  1. Using SQL Server Books Online
  2. Using SQL Server Management Studio (SSMS)
  3. Using SQL Server Command Line interface
  4. Using SQL Server Configuration Manager

SQL Server 2012 Architecture

  1. Understanding SQL Server system databases.
  2. Understanding the SQL Server database structure
  3. SQL Server files and filegroups
  4. SQL Server Transactional logs, Recovery Models
  5. What is the difference between SQL Server instance and database
  6. Client-Server Communication
  7. Attaching and detaching SQL Server databases

SQL Server Database objects

  1. Understanding Schemas
  2. Understanding SQL Server data types
  3. Understanding column properties
  4. Creating tables, altering tables and adding constraints, relationships
  5. Understanding the filetable
  6. Creating database diagrams

SQL Server Backup and Recovery Part 1

  1. Introduction to Backup and Recovery strategy for databases
  2. Full Database backups using SIMPLE Recovery Model
  3. Full Database and Transactional log backups with FULL Recovery Model
  4. Backup history and maintenance
  5. Designing Maintenance plans for Backup Tasks
  6. SQL Server Agent for scheduling backups
  7. Database Mail for email notifications to DBAs

SQL Server Backup and Recovery Part 2

  1. Introduction to Database Restore and Recovery
  2. Full database restore
  3. Full database restore and recovery of transactional logs
  4. Restoring system databases

Database Objects

  1. Introduction
  2. Tables and Columns
  3. Indexes
  4. Packages, Stored procedures and Functions
  5. Database links
  6. Views and Synonyms
  7. SQL Server Data Dictionary
  8. Popular Data Dictionary views and accessing them

SQL Server Data Export and Import (Data Movement)

  1. Partial Data export and import using the command line BCP command
  2. Partial Data export and import using GUI tool Export and Import Wizard
  3. Move or copy a full database

SQL Server security

  1. SQL Server authentication vs. Windows authentication
  2. Auditing database logins using SQL Server Error Logging
  3. SQL Server server wide logins and database specific users
  4. Creating user-defined server roles
  5. Configuring contained databases

Performance Tuning Part 1

  1. Understanding database indexes
  2. Checking index fragmentation and maintaining them
  3. Database statistics
  4. Understanding SQL Server Profiler
  5. Creating Traces
  6. Running server-side traces

Performance Tuning Part 2

  1. Understanding the Extended Events architecture
  2. Creating and configuring an Extended Events session
  3. Using an extended events session to monitor system performance

SQL Server High Availability (Advance Topics)

  1. Database Mirroring
  2. Log Shipping
  3. AlwaysOn
  4. Failover cluster instance improvements
  5. Creating AlwaysOn availability groups
  6. Administering AlwaysOn Availability groups.
  7. Reading secondary database copies.


Who should attend this MS SQL DBA training?
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
Is there any 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.
How do you do tracing in SQL Server?
There is SQL Profiler in the SQL Server Utility which can be used to trace the amount of traffic on the SQL Server.
What is model database?
It assists as a pattern for all databases created on the same instance. Making changes to this model database will mechanically changes all subsequent databases created on that instance.
What types of replication are maintained in SQL Server?
These replication are maintained in SQL Server: Snapshot, Merge and Transaction
What is SQL Agent?
It is a job scheduling mechanism in SQL Server that permits jobs like SQL Scripts, SSIS packages to run at a pre-determined time. Most commonly SQL Agent is used to schedule administrative jobs such as backups.
What are options in SQL Server to rebuild indexes?
CREATE INDEX with DROP_EXISTING
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?

  1. IT Developer who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases.
  2. Microsoft SQL Server 2012 Databases Certification aspirants
  3. SAP system administers
  4. Existing Database administrators
  5. 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.

  1. Install and configure (19%)
  2. Maintain instances and databases (17%)
  3. Optimize and troubleshoot (14%)
  4. Manage data (19%)
  5. Implement security (18%)
  6. 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.

 

  Self Paced Learning

 149.00

 Contact Us

 848-200-0448
 +91 00000 00000

 Course Features

30 hrs of e-learning material
30 hrs of e-learning material
30+ hrs of Practical and Realtime
Entirely Practical and Real-time Practical and Projects
Certification Guidance
Certification Guidance for 70-462 Microsoft Exam
Daily Tasks and Weekly Assignments
Daily Tasks and Weekly Assignments
Interview QAs and Placement Assistance
Interview QAs and Placement Assistance

 Try out our FREE demo

* Enter name
* Enter mobile number
* Enter email * Invalid format.
* Enter your query