SQL Server DBA Training

SQL Server DBA online training

Is a course intended to prepare trainees to administer complex SQL Server Database. It starts with SQL Server 2008 overview & installation lessons and further takes the students to modules like creating & managing databases, managing tables, data manipulation & correlation, SQL server built-in functions, creating & managing views, T-SQL programming, triggers, SSIS, SSRS and ERWin Tool.

SQL Server DBA Training Course Content

SQL Server 2008 Overview and Installation

Overview of SQL Server
Installation Requirements (Hardware and Software)
Installation Walkthrough (Step-by-Step)
Overview of SQL Server Management Studio (SSMS)

Creating and Managing Databases

Creating Databases
Database
File Groups
Database Options
Managing database

Creating and Managing Tables and Implementing Data Integrity

Creating Tables
Defining Table Location
Modifying Tables
Dropping Tables
Data Types
Defining Constraints
Partitioned Table
Data Compression (New Feature in SQL Server 2008)

Data Manipulation and Data Correlation

Select/Update/Delete
Sub Queries
Joins
Union/UnionAll/Intersect

SQL Server Built in Functions

Mathematical Functions
String Functions
Date Functions
Convert Functions
Aggregate Functions

Creating and Managing Views

Create View
Alter View
Drop View
Check and Encryption Options

Introduction to T-SQL Programming

Variable Declaration
Temp Table Concepts
Variable Table Concepts
Loops

Creating and Modifying Procedures and Cursors

Creating Procedures
Parameter Types
Modifying Procedures
Using Temp Tables, Variable Tables and cursors in Procedures
How to use Dynamic SQL Statements in Procedures
Error Handling

...plus full content on Security, Indexes, Backup/Recovery, Monitoring, Clustering, SSIS, SSRS, ERWin and more

Target Audience

Database administrators
Students & professionals looking to make a career in database administration.

Why Choose Best Online Trainers?

Instant Access: Get instant access to self-paced training after signup.
Streaming video recording: Watch lessons any time at your schedule, free recording.
Exercises: Practical exercises help you test what you are learning as you go.
Free Demo: Sign up for free demo to check whether the course is right for you and interact with the faculty live.
Experienced Trainers: We only hire the industry’s best trainers
Live free interactive web sessions: Ask the Expert SQL Server DBA trainers about career prospects and clarify your questions any time after you complete the course.
Structured Curriculum Schedule: Progress with your complete daily interactive lessons and assignments.
Faculty Mentoring: Turn in daily and weekly homework for personalized feedback from faculty.
Virtual Office Hours: Live interaction with the faculty and other students around the world.
Hands on Live Projects: Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

Trainer Profile

Microsoft SQL Server DBA-certified trainers
10+ years SQL Server and admin experience
Leading SQL Server trainers for companies and universities
Interactive, student-centric learning approach

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K