SQL Server ’05/’08/’12

Course Overview

In this Microsoft SQL online training course, you will learn how to combine the power of cloud computing with deeper insights into customer data by covering topics on querying, administering and developing SQL Server databases, implementing data warehouses, data models, and reports, as well as designing database and business intelligence solutions with the Microsoft SQL Server.

Course Outline

SQL Server 2005

Implementing a Microsoft SQL Server 2005 Database

  • Introduction
  • Databases & Database Files
  • Data Types / Tables / Partitioned Tables
  • SQL Server 2005 XML
  • Planning / Creating / Tuning Indexes
  • Data Integrity Using Constraints
  • Data Integrity Using Triggers / XML Schemas
  • Implementing Views
  • Implementing Stored Procedures
  • Implementing Functions
  • Implementing Managed Code within SQL Server
  • Managing Transactions and Locks
  • Using Service Broker
  • Using Notification Services

Maintaining a Microsoft SQL Server 2005

  • Introduction
  • Installation and Configuration
  • Managing Databases and Files
  • Disaster Recovery
  • Managing Security
  • Monitoring SQL Server
  • Transferring Data
  • Automating Administrative Tasks
  • Implementing Replication
  • Maintaining High Availability
  • Summary

SQL Server 2008

Maintaining Microsoft SQL Server 2008                          

  • Installing SQL Server 2008
  • Managing SQL Server 2008 Database Files
  • Planning for a Disaster
  • Securing SQL Server 2008
  • Moving and Transforming Data
  • Automating Database Administration
  • Replicating Data
  • Configuring SQL Server 2008 for High Availability
  • Monitoring SQL Server 2008
  • Troubleshooting and Tuning

SQL Server 2012

Querying Microsoft SQL Server 2012

  • Microsoft SQL Server 2012 Overview
  • Introduction to Transact SQL Querying
  • Select Statements
  • Sorting and Filtering Data
  • Data Types
  • Built-in Functions
  • Grouping and Aggregating Data
  • Querying Multiple Tables
  • Subqueries
  • Table Expressions
  • Set Operator
  • Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Metadata
  • Stored Procedures
  • Programming with T-SQL
  • Error Handling
  • Transactions
  • Query Performance

Administering a Microsoft SQL Server 2012 Databases

  • Microsoft SQL Server 2012 Fundamentals
  • Recovery in SQL Server 2012
  • Security in SQL Server 2012
  • Maintenance in SQL Server 2012
  • Monitoring in SQL Server 2012

Implementing a Data Warehouse with SQL Server 2012

  • Course Outline Coming soon