Objective:

SQL is the premier relational database product from Microsoft Corporation. Right from the beginning SQL has been designed to run on / port to multiple platforms. We will teach these courses on any platform running the relevant Microsoft Products.

Contents:

• Installation
  Concepts
  Install SQL
  SQL Server Security
  Securing SQL Server 2005
  Authentication Modes Pt.1
  Authentication Modes Pt.2
  Principles
  Permissions
  Securables
  Managing Logins
  Managing Users
  Schemas
  Managing Schemas
  Managing Permissions
  Managing Server Permissions
  Managing Database Permissions
  SQL Permissions
  System Databases
  System Databases
  System Database Concerns
  Sample Database
  Creating A Database Pt.1
  Creating A Database Pt.2
  Database Properties & Options
  Generating Scripts
  Shrinking Database Files
  Creating Tables Pt.1
  Creating Tables Pt.2
  Datatypes Pt.1
  Datatypes Pt.2
  Primary & Foreign Keys
  Diagrams
  Transaction Logs
  How Transaction Logs Work
  Transactions Explained
  Explicit & Implicit Transactions
  Location, Location, Location
  Advantages Of Using Transactions Logs
  Transaction Log Options
  How SQL Server Stores Data
  Fillfactor
  DBCC Showcontig
  Profiler
  Using SQL Profiler Part1
  Using SQL Profiler Part2
  Automating SQL Server
  Automation Overview
  SQL Server Agent Service
  Creating Operators
  Creating Jobs Pt.1
  Creating Jobs Pt.2
  Creating Alerts
  Alert Considerations
  Database Backups
  Backup Strategy
  Database Recovery Models
  Which Files and When
  Performing A Backup
  SQL Backup Statement
  Transaction Log Backups
  Backup Types
  Restoring Data
  SQL Server Recovery Process
  Restoring A Database
  The Restore Statement
  High Availability
  SQL Server High Availability
  Clustering
  Standby Servers
  Log Shipping
  Database Mirroring
  Database Maintenance
  Memory Management Basics
  Maintenance Plan Creation

Instructors:

• Certified as MCDBA