SQL Server DBA Online Training and Placement

  SQL Server DBA Training for OPT CPT Students

Online Training Courses
.Net Online Training Courses Java Online Training Courses SAP Online Training Courses Oracle Online Training Courses Software Testing Online Training Courses C Programming Online Training Courses C++ Programming Online Training Courses jQuery Online Training Courses UI Design Online Training Courses UNIX Online Training Courses Javascript Online Training Courses SQL & PLSQL Online Training Courses SAS Online Training Courses BI Reporter Tool Online Training Courses Microstrategy Online Training Courses Mainframes Online Training Courses Business Objects Online Training Courses Business Analysis Online Training Courses BPM Online Training Courses Hadoop Online Training Courses DataStage Online Training Courses Android Online Training Courses Linux Online Training Courses OBIEE Online Training Courses IBM Tools Online Training Courses PHP Online Training Courses AJAX Online Training Courses BizTalk Online Training Courses Data Warehousing Online Training Courses Embedded Systems Online Training Courses Google Technologies Online Training Courses Microsoft Technologies Online Training Courses Oracle DBA Online Training Courses Oracle Datawarehouse Online Training Oracle E-Business Suite Online Training PeopleSoft Online Training Courses Project Management Online Training Courses Autocad Online Training Courses Salesforce Online Training Courses Sharepoint Online Training Courses Softskills Online Training Courses System Networking Online Training Courses Web Design Online Training Courses BizTalk Server Online Training Courses Database Online Training Courses iPhone App Development Online Training Ruby On Rails Online Training Courses SEO Online Training Courses Shell Scripting Online Training Courses VMWare Online Training Courses Webmethods Online Training Courses Websphere Online Training Courses Visual Basic Online Training Courses TIBCO SOA Online Training Courses COGNOS Online Training Courses Perl Scripting Online Training Courses Hyperion Online Training Courses Informatica Online Training Courses Python Online Training Courses QlikView Course Contents QA Online Training Courses Tableau Tool Online Training Courses Basic .Net Training Course
More    


SQL Server DBA Training


Course Topics:


Introduction to database management systems and databases

  • Database management system (DBMS)
  • Introduction to Microsoft SQL Server and its overall  SQL Server Data 
  • Platform Tasks of a Database Administrator 

SQL Server Installation

  • Editions of SQL Server
  • Hardware and Software pre-requisites for a successful SQL Server installation.
  • Understanding SQL Server components.
  • Perform a successful SQL Server Installation
  • Understanding SQL Server version identifiers, installed directories and conventions.

SQL Server Administration and Development Tools

  • Using SQL Server Books Online
  • Using SQL Server Management Studio (SSMS)
  • Using SQL Server Configuration Manager

SQL Server Architecture

  • Understanding SQL Server system databases.
  • Understanding the SQL Server database structure.
  • Data files and file groups.
  • SQL Server Transactional logs, Recovery Models.
  • Difference between SQL Server instance and database. 
  • SQL Server Database objects
  • Understanding SQL Server data types 
  • Understanding column properties
  • Creating tables, altering tables and adding constraints, relationships.

SQL Server Backup

  • 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 Restore and Recovery

  • Introduction to Database Restore and Recovery Full database restore
  • Full database restores and recovery of transactional logs Restoring system databases

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.

SQL Server Memory Management

  • SQL Server Buffer, Worker Threads, Checkpoint, Lazy writer PAE, AWE
  • Memory allocation for Multiple Instances

Indexing In SQL Server

  • Query Execution Plans , Query Optimizer
  • Understanding database indexes
  • Checking index fragmentation and maintaining them
  • Database statistics

Database Health Checks

  • DBCC Commands
  • System/ Extended procedures to check Database Health
  • Dynamic Management Views

 Moving Databases

  • Moving System Databases
  • Moving TempDB
  • Attach & Detach Databases

SQL Server Data Export and Import (Data Movement)

  • Partial Data export and import using– Export and Import Wizard
  • Move or copy a full database.


Signup


Name: 

Phone No: 

Email:  

Password: 

Need Resume Preparation:     

 
Select Skills:
select skills and click ok to confirm
 
Select Sub Skills:    
select sub skills and click ok to confirm

Available Time:     (hold Ctrl to select multiple)

Register Now!

Free Demo Class
Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.






Which course is right for me?


Speak to an IT online learning consultant today


on 844-OPTGHAR for FREE Tailored Advice.

get free advice
course