SQL Server

Rewrite the Rules


Microsoft SQL Server is a powerful relational database management system catering to high-end users with advanced needs which developed by Microsoft. Mind Bird Solutions provides sql server training according to the current requirement of IT industry. It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet).


After completion of 55% of course, student will go through Live Project Training, Interview Preparation and Recruitment process in Software Industry.



An Overview of SQL Server 2008
  • SQL Server 2008 Architecture
  • Available Features and Tools
  • New Capabilities
  • SQL Services
  • Product Licensing
  • Product Editions
 
Installing SQL Server 2008

  • Preparing for Installation
    • Creating Users for Service Accounts
    • Choosing Appropriate File Locations
    • Choosing Instance Names
  • Installing SQL Server 2008
    • Choosing Appropriate Features
    • Specifying Service User Accounts
    • Choosing Licensing Mode
    • Choosing Appropriate Collation
    • Installing Multiple Instances
  • Upgrading to SQL Server 2008
 
 
Configuring SQL Server 2008

  • Registering Servers
  • Using Metadata Views to Obtain Object Properties
  • Using Object Explorer
    • Configuring a SQL Server Instance
    • Configuring Object Properties
  • Using the Query Window
  • Creating Transact SQL Projects
  • Managing Services
  • Configuring Server Network Connections
  • Configuring Client Connections and Aliases
  • Configuring the Surface Area of SQL Server
  • Configuring Policy-Based Management
  • Creating a Central Management Server
  • Using the Dedicated Administrator Connection
  • Configuring Data Replication
  • Creation and Maintenance of Full-Text Catalogs
  • Describing Full-Text Search
 

Using SQL Server 2008 Management Tools

  • SQL Server Management Studio
  • SQL Server Configuration Manager
  • SQL Server Books Online
  • SQLCMD
 

Creating and Configuring a Database

  • Creating Databases
  • Creating Tables
  • Specifying Data Types
  • Creating Indexes
  • Describing Data File Structure
  • Describing Log File Structure and Function
  • Creating Filegroups
  • Configuring Filestream Storage
  • Creating and Using Database Snapshots
  • Moving a Database to Another SQL Server
 
Monitoring Data Structures

  • Creating DDL Triggers
  • Creating Event Notifications
  • Configuring SQL Server Audit
 
Monitoring SQL Server Performance

  • Using the Windows Performance Tool to Detect the Cause of a Bottleneck
  • Using SQL Server Profiler
  • Using Dynamic Management Functions
  • Interpreting Management Studio Reports
  • Using Activity Monitor
 
 
Optimizing SQL Server Performance

  • Describing Index Structures
    • Clustered Indexes
    • Nonclustered (NC) Indexes
  • Choosing Appropriate Clustered Index
  • Choosing Appropriate NC Indexes
  • Detecting Index Fragmentation
  • Rebuilding and Reorganizing Indexes
  • Using the Database Engine Tuning Advisor
  • Generating and Interpreting Query Plans
  • Configuring the Resource Governor
 

Securing SQL Server

  • SQL Server Security Architecture
  • Defining Principals and Securables
  • Using the Security Hierarchy
  • Applying Password Policies to SQL Logins
  • Creating Roles
  • Granting Permissions
  • Using SQLCMD to Test Permissions
  • Creating and Using Certificates
  • Setting Execution Context
  • Encrypting Data
  • Encrypting Databases
 

Automating Tasks

  • Creating Maintenance Plans
  • Job Creation and Execution
  • Creating Schedules for Jobs
  • Creating and Using Proxies
  • Configuring Alerts
  • Creating and Using Operators
  • Configuring and Using Database Mail
 

Importing and Exporting Data

  • Using bcp and BULK INSERT
  • Using the Import/Export Wizard
  • Using Integration Services to Import Data
 

Backing Up and Restoring Databases

  • Choosing Appropriate Database Recovery Model Option
  • Describing Automatic Recovery
  • Choosing an Appropriate Backup Strategy
  • Determining Backup File Contents
  • Designing a Database Recovery Plan
  • Using Backup Compression
  • Use of Filegroups in a Backup Strategy
  • Restoring the Master Database
  • Rebuilding System Databases
 

Maintaining Data Reliability

  • Maintaining Data Integrity
    • Creating Constraints
    • Describing and Using DML Triggers
  • Configure Data Compression
  • Setting Transaction Isolation Levels
  • Capturing Changed Data
 
 
Maintaining High Availability of Data

  • Purpose of Windows Clustering
  • Implementing Database Mirroring
  • Use of Log Shipping
 
Notes:
  • Recommend Practical hours for student except class hours is 60 Hrs.
  • We also provide weekend classes for all courses.
  • After completion of 55% of course, student will go through Live Project Training, Interview Preparation and Recruitment process in Software Industry.
  • Student will go through the training of DBMS and RDBMS concepts before starting of Sql Server 2008. This is optional.


To find out how Mind Bird Solutions' SQL Sever training program and expertise, contact Mind Bird Solutions today.

Our Brand