About Course

Course Information

Microsoft SQL Server is a database management and anaylsis system for e-commerce, line-of-business, and data warehousing solutions. Microsoft SQL is designed to help with the workload of a wde range of audiences from small application based organization to large and vast data processing organizations which have a number of computer units to retrieve and access the data on servers.

SQL Server 2014 delivers new in-memory capabilities built into the core database for online transaction processing (OLTP) and data warehousing, which complement our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution on the market. SQL Server 2014 also provides new disaster recovery, backup and hybrid architecture solutions with Microsoft Azure, enabling customers to use their existing skills with on-premise features that leverage Microsoft’s global datacenters.

SQL Server 2012’s new features and enhancements include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a sets of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhacements including new spatial features, metadata discovery, sequence objects, performance enhancements such as ColumnStore Indexes, Online and partition level operations and security enhancements, new permissions, improved role management and default schema assignment for groups.

SQL Server 2008 R2 adds certain features to SQL Server 2008 including master data management system branded as Master data services, a central management of master data entities and hierarchies. Also multi server management, a centrailized console to manage multiple SQL Server 2008 instances and services including relational databases, reporting services, analysis services & Integration Services. SQL Server 2008 R2 includes a number of new services, including PowerPivot for Excel, and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services.

SQL Server 2008 includes support for structured and semi-structured data, including media formats for pictures, audio, video and other multimedia data. The full-text serach functionality has been integrated with the database engine. It also includes Resource Governor that allows reserving resources for certain users or workflows. It also includes capabilities for transaparent encryption of data (TDE) as wells as compression of backups. SQL Server 2008 supports ADO.NET Entity Framework and the reporting tools, replication and data definition. SQL Server 2008 also makes the databases available via Windows Powershell providers.

SQL Server 2005 introduced Database Mirroring, a high availability option that provides redundancy and failover capabilities at the database level. SQL Server 2005 introduces DMVs (Data Management Views) which are specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.

SQL Server 2000 includes support for XML and HTTP, performance and availability features to partition load and ensure uptime, and advanced management and tuning functionality to automate routine tasks and lower total cost of ownership.

SQL Server offers a sophisticated platform for enterprise data management. Organisations reply on database administrators who know how to manage their mission-critical databases correctly. This course targets those who are new to database administration and offers the essential skills you need to administer SQL Server.

Course Content

Please Download for Detailed Course Content

Core topics of SQL Server DBA Online Course

  • Chapter 1 : ARCHITECTURE

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

  • Chapter 2 : INSTALLATION

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

  • Chapter 3 : SQL SERVER ENHANCEMENTS FROM 2008
  • Chapter 4  : CONFIGURATION SETTINGS

• Memory setting
• Processor
• Connections
• Database Settings

  • Chapter 5 :  SYSTEM DATABASES
  • Chapter 6 : CREATING USER DATABASES
  • Chapter 7 : DATABASE OPTIONS
  • Chapter 8 : BACKUPS

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

  • Chapter 9 : RESTORATIONS

• Types of Restorations
• Restoration Options
• Point in Time Restorations
• Recovery Process
• Recovery Options

  • Chapter 10 : AUTOMATION

• Creating Jobs
• Schedules
• Viewing Job History

  • Chapter 11 : SECURITY

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

  • Chapter 12 : MIGRATION

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

  • Chapter 13 : UPGRADATION

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

  • Chapter 14 : 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

  • Chapter 15 : PERFORMANCE TUNING

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

  • Chapter 16 : INTERVIEW Questions

Demo Video

Watch SQL Server DBA Demo Video

About Trainer

Trainer Information

  • Having 9+ Years of hands on experience on Financial domain, Telecom and Health care
  • Working from last 9+ years on SQL Server and SQL Server DBA
  • Working from last 6+ years on SQL Server DBA
  • Having 4+ Years of Corporate and Online training Experience
  • SQL Server DBA Certified Consultant