space
Search Courses  in 

Just fill this form to get COURSE FEE details from BEST Training Institutes Instantly !

 

My City

 

I need details for

 

My Name

My Mobile Number

My Email ID

Purpose

Tell us your expectation...

sql dba realtime live online,corporate training

 

Apex Online Training
Apex Online Training

 

 

Information

SQL DBA ONLINE TRAINING,COURSE CONTENT AND JOB SUPPORT,INTERVIEW SUPPORT BY SOFTWARE FACULTY

FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings.blogspot.in

Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

DATABASE ADMINISTRATOR Course OUTLINE (we can customize the course Curriculum as per your requirements)

SQL DBA Course Content


Module 01: Installation

The goal of this module is to get the DBA familiar with installing SQL Server and the configuration settings during installation. This module will discuss the installation process, how it differs in SQL Server 2005 and 2008, and some common best practices when it comes to installing SQL Server.


Module 02: Upgrading SQL Server


The goal of this module is to discuss the processes of upgrading and existing SQL Server environment to SQL Server 2005 or SQL Server 2008. This module will cover creating an upgrade plan, the upgrade process, and issues found when upgrading to SQL Server 2005 or SQL Server 2008 from earlier versions.


Module 03: SQL Server DB Architectural Overview


The goal of this module is to get the DBA familiar with the basic architecture of SQL Server. This module will discuss how SQL Server architecture, the system databases, files and filegroups, transaction log architecture, data page structure, basic and index structure.


Module 04: SQL Server Tools & Utilities


The goal of this module is to get the DBA familiar with the basic tools found in SQL Server. This module will discuss SQL Server Management Studio, Configuration Manager, Surface Area Configuration tool, SQL Server Profiler, System Monitor, Upgrade Advisor, Performance Studio, Declarative Management Framework, and Database Tuning Advisor.


Module 05: File & Filegroup


The goal of this module is to give the DBA a deeper understanding of the best practices surrounding file and filegroups. This module discuss topics such as: file placement, optimizing the tempdb, file size, growing files, shrinking files and placing objects into different filegroups.


Module 06: Understanding Concurrency


The goal of this module is to introduce the DBA to the concurrency mechanisms of SQL Server. This module will discuss topics such as: transactions, isolation levels, lock escalation, blocking, deadlocking, locking hints, and the new snapshot isolation.


Module 07: Understanding I/O

The goal of this module is to take the DBA deeper into how the disk subsystem works in SQL Server 2005 and SQL Server 2008.


Module 08: Understanding CPU


The goal of this module is to take the DBA deeper into how the processor schedulers work in SQL Server 2005 and SQL Server 2008.


Module 09: Understanding Memory


The goal of this module is to take the DBA deeper into how SQL Server interacts with memory.


Module 10: Disaster Recovery


The goal of this module is to introduce the DBA to SQL Server disaster recovery topics. This module will discuss SQL Server backups, backup strategies, database restore process and strategy, and follow up with a discussion on disaster recovery planning for very large databases.


Module 11: Understanding the SQL Server Query Optimizer


The goal of this module is to introduce the DBA to how the query optimizer an optimization process works in SQL Server. This module discuss the process of optimizing a query, query execution plans, the recompile process of queries, and wraps up with the basics of tuning SQL Server queries and stored procedures.


Module 12: Security


The goal of this module is to take the DBA deeper into SQL Server security. This module will discuss new security features, existing security features, security best practices, auditing, and security configurations.


Module 13: Indexing and Fragmentation

The goal of this module is to introduce the DBA to SQL Server indexes. This module will dive deep into indexes, index creation, index usage, index fragmentation, index maintenance, and the new index features found in SQL Server 2005 and SQL Server 2008.


Module 14: Database Maintenance


The goal of this module is to introduce the DBA to the changes made to database maintenance and maintenance plans in SQL Server 2005 and SQL Server 2008.


Module 15: Replication


The goal of this module is an introduction to replication in SQL Server. This module will discuss the types of replication, basic replication topics, setting up replication, and the best practices for replicated systems.


Module 16: Database Clustering


The goal of this module is an introduction to clustering in SQL Server. This module will discuss clustering basic topics, setting up clustering, and the best practices for clustered systems.


Module 17: Database Snapshots


The goal of this module is to introduce the DBA to the new database snapshot feature in SQL Server. The module will discuss how database snapshots area created and the usage of the snapshots.


Module 18: Log Shipping


The goal of this module is an introduction to log shipping in SQL Server. This module will discuss log shipping basic topics, setting up log shipping, and the best practices for log shipped environments.


Module 19: Database Mirroring

This goal of this module is to describe the guidelines and considerations for designing and administrating a high availability solution based on SQL Server Database Mirroring. This module provides the guidelines for determining a mirroring topology and explains the process of designing SQL Server Database Mirroring.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings.blogspot.in

 

Course Information

SQL DBA realtime training by corporate professionals, SQL DBA job support by realtime IT working faculty, SQL DBA online and corporate training from India usa uk canada, Raj@Apex

 

Contact Information

Address: Apex Online Training,
Hyderabad
, Hyderabad , Ameerpet
PH: 00-91-8500122107 , 00-91-8341056146
Website: www.apex-online-it-training.com
Email: raj@apex-online-it-training.com
Unix Academy Delhi Training

High Technologies Solutions - Delhi,Noida,Gurgaon

Embedded Technosolutions Mumbai

SHRISTI TECHNOLOGY LABS

GRRAS Institute Ahmedabad Jaipur Pune

Sun Infosystems Surat

Indian Institute of Technocrafts, Kolkata

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

Systems Domain Bangalore

vgit kilpauke learning, e-publishing, technical writting courses

HITS computer Education chennai

IIHT Bangalore

Core Mind Technologies Chennai

IICT Chrompet - SAP Training in ChennaiPMP Training in India

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

Peridot Systems Chennai

Dallas Technologies Bangalore

JITS Training

7 Eleven Arthashastra Chennai

IIHT Vadapalani Chennai

RIA Institute of Technology Bangalore

Training course fee & Discounts

 

 

 

 

   DMCA.com Protection Status