Login

Register

SQL Server DBA Course

Course includes SQL Server Architecture in detail, Understanding Query Design, Query Performance Tuning, Upgrades, Migrations, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG).

SQL Server DBA Training

This course is carefully designed for starters as well as for working professionals.

Course includes SQL Server Architecture in detail, Understanding Query Design, Query Performance Tuning, Upgrades, Migrations, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG).

This SQL DBA Course also includes One Real-time Project, Resume and Placement Support.

ARCHITECTURE

• SQL server architecture
• Protocols
• Storage structure
• Database Architecture
• Transactional Architecture
• Memory Architecture

INSTALLATION

• Requirements
• 2005 Installation
• Steps 2008 installation steps
• 2012 installation steps

ENHANCEMENTS FROM 2008
CONFIGURATION SETTINGS

• Memory setting
• Processor
• Connections
Database Settings
SYSTEM DATABASES
CREATING USER DATABASES
DATABASE OPTIONS

BACKUPS

• Recovery Models
• Backup Types
• Backup Strategy’s
• Backup destination
• Backup Options
• Enhancements
• Permissions and History

RESTORATIONS

• Types of Restorations
• Restoration Options
• SQL SERVER DBA
• Restorations
• Recovery Process
• Recovery Options

AUTOMATION

• Creating Jobs
• Schedules
• Viewing
• Job History

SECURITY

• Types of Logins
• Authentication
• Creating Logins
• Server Roles
• Database Roles
• Encryption
• Schema
• Creating new role
• Digital Certificate
• Orphaned Users

MIGRATION

• Situations
• Steps in Migrations
• Migrating System Databases
• Migrating to other

RDBMS
UPGRADATION

• Types of Up gradation
• Planning for up gradation
• Upgrade Advisor

HIGH AVAILABILITY

• LOGSHIPPING
• Configuring log shipping
• Failover Process
• Database Mirroring
• Steps in Mirroring
• Types of Mirroring
• Configuring Mirroring
• Failover Steps

REPLICATION

• Types of Replication
• Configuring Replication

CLUSTERING

• Concepts of clustering
• Types of Clustering
• Requirements
• Configuring clustering

PERFORMANCE TUNING

• Locks
• Isolations levels
• Blocking
• Deadlocks
• Performance Monitor
• Profiler
• Execution plans
• Indexes
• DBCC And DMV’s

Want to have a course urgently or on Fast track. We can arrange you for a specialised training aimed only for you. Please get in touch with us with your requirements by mail or just fill in the Batch Enquiry form. We will get in touch with you with the slot times and other details with in 24 hours

For Priority Training contact below
  • eITCafe: trainings@eitcafe.com
  • India: 040 6678 6677
  • US: 630-636-0198

Support services

We know how hard it can be to find and keep a job when there are so many other things to worry about. Our support team is here to help break down the barriers which are blocking your road to employment.
If you are a Working Chance candidate, please don’t hesitate to ask for advice or support on any issues which are affecting your chances of finding a job.
For further information, please email jobsupport@eitcafe.com our Support and Training Manager.

Job Preparation

• Assistance with learning job seeking skills
• Resume creation
• Master application completion
• Dressing for success
• Job interview preparation

Job Development

• Assistance with completing applications online or in person
• Job development online, on foot, networking events, job fairs and established employer relationships to locate available positions in your job goal
• Job leads and information on attending hiring events
• Follow-ups on applications placed to request interviews.

Which command using Query Analyzer will give you the version of SQL server and operating system?

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition').

What is SQL Server Agent?

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools for SQL Server management. Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts.

Name 3 ways to get an accurate count of the number of records in a table?

SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2

What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.

What is the difference between a Local and a Global temporary table?

  1. A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
  2. A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection is closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.

Key Features

metricsnew-75x75

Overview of Course and Learning analytic’s

teacher-75x75

Learn from Certified and Expert Trainers

Customized Course as per your requirement

24/7 online support for the course learners

High Quality E-learning Content for learning

videos

Access to the Recorded Sessions and classes

Flexible Course timing and Payment terms

Live Practical Oriented Approach for learners

Course Curriculam

SQL Server DBA course Module

Hadoop framework includes following four modules:

  • Hadoop Common: These are Java libraries and utilities required by other Hadoop modules. These libraries provides filesystem and OS level abstractions and contains the necessary Java files and scripts required to start Hadoop.
  • Hadoop YARN: This is a framework for job scheduling and cluster resource management.
  • Hadoop Distributed File System (HDFS™): A distributed file system that provides high-throughput access to application data.
  • Hadoop MapReduce: This is YARN-based system for parallel processing of large data sets.

Duration: 45 Days

Support: 24×7

Video: Yes

SQL Server DBACertified Professional