SQL Server DBA


  • Batch Timings :
  • Starting Date :

Course Overview

MS SQL Server is one of the industry’s leading and popular Microsoft data platforms that can be utilized to develop mission critical apps for online transaction processing (OLTP). Scalability, flexibility, high performance and availability are some of the best characteristics of this DB. MS SQL Server is the least vulnerable database that can provide advanced data security and protects data at rest and in motion.

COURSE FEATURES

  • Resume & Interviews Preparation Support
  • Hands on Experience on One Live Project.
  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Multiple Flexible Batches

At the end of SQL Server Developer Training Course, Participants will be able to:

  • Learn the SQL architecture, client/server relation and database types
  • Deploy various functions and operators to design relational databases
  • Modify data using T-SQL, Views and Stored Procedures
  • Concepts of Trigger and creation of Triggers
  • Use records for searching, sorting, indexing and grouping
  • Learn about Database Administrators, types, SQL Server tools and Services
  • Backup and restoration of databases

Course Duration

  • 50 – 60 Hours

Prerequisites :

  • There is NO pre requisites to learn SQL Server developer.
  • If you are already have basic idea on SQL and RDBMS, that will be quite easy for you to grasp the concepts. Otherwise, experts are here to help you from the basics of SQL Server DB.

Course

1.1 SQL Server 2008 Overview

  • Responsibilities of Database Administrator
  • Types of DBA’s
  • History of SQL Server – Versions
  • What’s new in SQL Server 2012 & 2014 for Administrators?
  • SQL Server 2008 & 2012 Service Packs

1.2 Installing and Configuring SQL Server 2012

  • SQL Server 2012 Editions
  • Installing Microsoft SQL Server
  • System Requirements
  • Preparing for a SQL 2012 Installation
  • Component Install
  • Unattended Installation
  • Upgrading from previous versions of SQL Server
  • To verify the Installation
  • Administrative Tools

1.3 SQL Server Management Studio and other tools

  • Management Studio Windows
  • Object Explorer
  • Review Database Objects
  • Modify Database Properties
  • SQL Server Management Studio SQLCMD Mode
  • SQL Server Command Line interface
  • SQL Server Configuration Manager

1.4 Monitoring the Database Server

  • Managing Metadata Views
  • Metadata Storage
  • System Views
  • Information Schema
  • Catalog Views

1.5 Database and Index Maintenance

  • ndex Management
  • New Index Features
  • Creating Indexes
  • Online Index Maintenance
  • Parallel (multiple CPU) Index Operations
  • Lock Options
  • Included Columns in Indexes
  • Partitioned Tables and Indexes
  • Altering an Index
  • Rebuilding an Index
  • Reorganising an Index
  • Disabling an Index
  • Dropping an Index
  • Index Fragmentation
  • Using the Database Tuning Advisor

1.6 Securing SQL Server 2012

  • Security in SQL Server 2012
  • Security Enhancements
  • Types of Authentications.
    • Windows Authentication
      • Creating logins from windows users and groups
      • Orphan logins
  • SQL Server Authentication
    • Creating SQL logins and testing logins
    • Setting Authentication Mode
    • Security Auditing
    • Understanding Server roles
    • Working with users
    • Resolving Orphan users
    • Understanding database roles
    • Understanding permissions
    • Working with certificates and schemas
    • Security catalogue views and stored procedures

1.7  SQL Server Backup & Recovery

  • SQL 2008 Disaster Recovery Feature
  • Database Snapshots
  • Creating a Snapshot
  • Common Snapshot Applications
  • Undeleting table rows
  • Undoing a table update
  • Recovering a dropped object
  • Backup and Restore concept and types
  • Backup and Restore options
  • Media Integrity Changes
  • Recovering the MASTER Database
  • Create a mirrored backup

1.9 Replicating Information

  • Replication and Advantages
  • New Features
  • Replication Entities
  • Replication Architecture
  • Replication Agents
  • Types of Replications
  • Configuring Replication
    • Snapshot Replication
    • Transactional Replication
    • Merge Replication
    • Peer to Peer replication
    • Managing Replication
    • Monitoring and Tuning Replication

1.10 Import and Export SQL Server Data

  • Data Import and export using command line tools.
  • Data Import and Export using GUI tools.

1.11 Performance Tuning

  • Blocking
  • Dead Locking
  • Index’s Rebuild & Reorganise
  • Locks Types
  • Trace Flags
  • DMV’s

FAQ

Criteria SQL PL/SQL
What it is Single query or command execution Full programming language
What it comprises Data source for reports, web pages Application language to build, format and display report, web pages
Characteristic Declarative in nature Procedural in nature
Used for Manipulating data Creating applications

Basic Hard ware requirement is useful to install the SQL Server Developer.

Quick Enquiry