Database and Admin

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

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile

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

Creating and Modifying user defined Functions

  • Creating/Modifying Scalar functions
  • Creating/Modifying table functions

Creating and Modifying Triggers

  • Table Triggers
  • DDL Triggers

Working with distributed Data

  • Creating Linked Servers
  • How to use DML Statements against to the remote servers
  • How to use remote Procedure execution in SQL Servers

SQL Server Security

  • Authentication Methods
  • Server level Security
  • Database Level Security
  • Object Permissions

Creating and Managing Indexes

  • Clustered Index
  • Non Clustered Index
  • Unique index
  • Composite Indexes
  • Fill Factor /Pad Index

Backup/Recovery

  • Recovery Models
  • Backup Types
  • Full Database backup
  • Differential Backup
  • Transactional Log Backup
  • Restore Databases
  • Restore transaction Logs
  • Point of Recovery
  • Backup Compression (New Feature in SQL Server 2008)

Database Mail

SQL Server Scheduling and Notification

  • Managing jobs
  • Managing Alerts

Monitoring and Troubleshooting SQL Server Performance

  • Identify and Resolve Blocking issues
  • SQL Server trace
  • QUERY Execution Plan Analysis
  • DB Tuning Adviser
  • Performance Monitor
  • Setting Maintenance plans

SQL Server Clustering (High availability Solutions) Concept

Database Mirroring

Replication

Migrate or Upgrade to SQL Server 2008

Log Shipping

Resource Governor (new Feature in SQL Server 2008)

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

Database Design Concepts and Design Tool (ERWin Tool)

  • Normalization
  • De-Normalization

SQL Server DBA Training is intended for:

  • Database administrators
  • Students & professionals looking forward to make their career in database administration.

We guarantee learning at your convenience & pace.

  • 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 Shell Scripting trainers about the 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.

N/A

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:

 

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