Online SQL Server / Database Administration Training Courses

SQL for U:
SQL for U offers online / distance learning training for SQL Server (MSSQL) and Sybase Database administration, Database development and Business Intelligence (BI). SQL for U is a group of people who have extensive industry knowledge in SQL Server and SYBASE ASE administration, development and implementation.

SQL Server 2008 R2 Administration:

Module 1: Installation and configuring SQL Server 2008 R2:

· Introduction to SQL Server Platform
· Preparing to Install SQL Server 2008 R2
· Review hardware and software requirements for SQL Server installation
· Installing SQL Server instance
· Working with SQL Server Tools
· Configuring SQL Server Services
· SQL Server client and server protocol
· Upgrading and Automating Installation

Module 2: Database and Data files:

· Overview of SQL Server 2008 R2 Architecture
· Overview of SQL Server Databases
· Working with Files and Filegroups
· Database states
· Moving Database Files
· Attaching and detaching databases
· Shrinking database and files

Module 3: Disaster Recovery:

· Backup Strategies
· Understanding SQL Server Transaction Logging
· SQL Server 2008 R2 Recovery Models
· SQL Server 2008 R2 backup types
· Planning a SQL Server Backup Strategy
· Backing up Databases and Transaction Logs
· Managing Database Backups
· Working with Backup Options
· Backup compression and other advanced backup concepts
· Understanding the Restore Process
· Restoring Databases
· Working with Point-in-time Recovery
· Restoring System Databases and Individual Files

Module 4: Security:

· SQL Server authentication modes
· Authenticating Connections to SQL Server
· Authorizing Logins to Access Databases
· Authorization Across Servers
· Create Logins
· Correct an Application Login Issue
· Create Database Users
· Correct Access to Restored Database
· Working with Server Roles
· Working with Fixed Database Roles
· Creating User-defined Database Roles
· Authorizing User Access to Objects
· Authorizing Users to Execute Code
· Configuring Permissions at the Schema Level

Module 5: Data transfer:

· Transferring Data To/From SQL Server 2008 R2
· Importing & Exporting Table Data
· BCP utility
· Import/Export wizard
· Data transfer using SSIS

Module 6: Automating SQL Server 2008 R2 Management:

· Automating SQL Server Management
· Working with SQL Server Agent
· Managing SQL Server Agent Jobs
· Understanding SQL Server Agent Security
· Configuring Credentials
· Configuring Proxy Accounts

Module 7: Monitoring SQL Server 2008 R2 with Alerts, Notifications and Database Maintenance:

· Configuration of Database Mail
· Monitoring SQL Server Errors
· Configuring Operators, Alerts and Notifications
· Ensuring Database Integrity
· Maintaining Indexes
· Automating Routine Database Maintenance
· Capturing Activity using SQL Server Profiler
· Improving Performance with the Database Engine Tuning Advisor
· Working with Tracing Options
· Monitoring Activity
· Capturing and Managing Performance Data
· Analyzing Collected Performance Data

Module 8: Implementing Replication:

· Overview of Replication
· Implementing Replication
· Configuring Replication in Some Common Scenarios

Module 9: Maintaining High Availability:

· Introduction to High Availability
· Implementing Server Clustering
· Implementing Database Mirroring
· Implementing Log Shipping
· Implementing Peer-to-Peer Replication

Module 10: Planning for SQL Server Indexing:

· Basics of indexes
· Types of indexes
· Basics of index implementation

SQL Server 2008 R2 Developer (T-SQL):

Module 1: Introduction to SQL Server and its Toolset:

· Introduction to SQL Server Platform
· SQL Server versions
· SQL Server 2008 R2editions
· Working with SQL Server Tools
· Configuring SQL Server Services
· Working with SQL Server protocols

Module 2: Working with Data Types: 

· Using Data Types
· Working with Character Data
· Converting Data Types
· Working with Specialized Data Types
· Choosing Appropriate Data Types
· Writing Queries With Data Type Conversions
· Designing and Creating Alias Data Types

Module 3: Designing and Implementing Tables and Views: 

· Designing Tables
· Working with Schemas
· Creating and Altering Tables
· Introduction to Views
· Creating and Managing Views
· Performance Considerations for Views

Module 4: Joins, Sub Queries and other TSQL concepts:

· Introduction to joins
· Types of Joins
· Introduction to Sub Queries
· Union and Union All
· CASE
· WHILE loop
· If else statements

Module 5: SQL Server transactions and Ensuring Data Integrity through Constraints:

· Introduction to Transactions
· Introduction to Locks
· Management of Locking
· Transaction Isolation Levels
· Detecting Deadlocks
· Enforcing Data Integrity
· Implementing Domain Integrity
· Implementing Entity and Referential Integrity

Module 6: Designing and Implementing Stored Procedures: 

· Introduction to Stored Procedures
· Working With Stored Procedures
· Implementing Parameterized Stored Procedures
· Controlling Execution Context

Module 7: Designing and Implementing User-Defined Functions: 

· Designing and Implementing Scalar Functions
· Designing and Implementing Table-valued Functions
· Implementation Considerations for Functions
· Alternatives To Functions

Module 8: Responding to Data Manipulation via Triggers: 

· Designing DML Triggers
· Implementing DML Triggers
· Advanced Trigger Concepts

Module 9: Error Handling and Advanced T - SQL concepts:

· Using the MERGE Statement
· Implementing Table Types
· Using Table Types as Parameters
· Designing T-SQL Error Handling
· Implementing T-SQL Error Handling
· Implementing Structured Exception Handling

Module 10: Implementing Managed Code in SQL Server:

· Introduction to SQL CLR Integration
· Importing and Configuring Assemblies
· Implementing SQL CLR Integration

Module 11: XML Data in SQL Server: 

· Introduction to XML and XML Schemas
· Appropriate Usage of XML Data Storage in SQL Server
· Storing XML Data and Schemas in SQL Server
· Implementing the XML Data Type
· Using the T-SQL FOR XML Statement
· Getting Started with XQuery
· Shredding XML

Module 12: Working with SQL Server Spatial Data and Full-Text Indexes:

· Introduction to Spatial Data
· Working with SQL Server Spatial Data Types
· Using Spatial Data in Applications
· Introduction to Full-Text Indexing
· Implementing Full-Text Indexes in SQL Server
· Working with Full-Text Queries

Module 13: Indexes and Execution Plans for SQL Server: 

· Core Indexing Concepts
· Data Types and Indexes
· Clustered and Non Clustered Indexes
· Designing and implementing Effective indexes
· Single Column and Composite Indexes
· Execution Plan Core Concepts
· Common Execution Plan Elements
· Working with Execution Plans
· Using the Database Engine Tuning Advisor

SQL Server 2008 R2 Business Intelligence:
SQL Server Integration Service
SQL Server Analysis Service
SQL Server Reporting Service

SQL Server 2008/2008 R2 Integration Services:

Module 1: Introduction to SQL Server 2008 Integration Services:

· Overview of SQL Server Integration Services
· Using Integration Services Tools
· Using the Import and Export Wizard
· Running an Integration Services Package

Module 2: Developing Integration Services Solutions:

· Creating an Integration Services Solution
· Using Variables
· Building and Running a Solution

Module 3: Implementing Control Flow:

· Control Flow Tasks
· Control Flow Precedent Constraints
· Control Flow Containers

Module 4: Implementing Data Flow:  

· Data Flow Sources and Destinations
· Basic Data Flow Transformations
· Advanced Data Flow Transformations
· Data Flow Paths

Module 5: Implementing Logging: 

· Overview of Integration Services Logging
· Enabling and Configuring Logging

Module 6: Debugging and Error Handling:  

· Debugging a Package
· Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions:  

· Implementing Checkpoints
· Implementing Transactions

Module 8: Configuring and Deploying Packages:

· Package Configurations
· Deploying Packages

Module 9: Managing and Securing Packages:  

· Managing Packages
· Securing Packages

SQL Server 2008/2008 R2 Analysis Services:

Module 1: Introduction to Microsoft SQL Server Analysis Services:  

· Overview of Data Analysis Solutions
· Overview of SQL Server Analysis Services
· Installing SQL Server Analysis Services

Module 2: Creating Multidimensional Analysis Solutions:  

· Developing Analysis Services Solutions
· Creating Data Sources and Data Source Views
· Creating a Cube

Module 3: Working with Cubes and Dimensions:  

· Configuring Dimensions
· Defining Attribute Hierarchies
· Sorting and Grouping Attributes

Module 4: Working with Measures and Measure Groups:  

· Working With Measures
· Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions:  

· MDX Fundamentals
· Adding Calculations to a Cube

Module 6: Customizing Cube Functionality:  

· Implementing Key Performance Indicators
· Implementing Actions
· Implementing Perspectives
· Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database:  

· Deploying an Analysis Services Database
· Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution:  

· Configuring Processing
· Logging, Monitoring, and Optimizing an Analysis Services Solution
· Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining:  

· Overview of Data Mining
· Creating a Data Mining Solution
· Validating Data Mining Models

Microsoft SQL Server 2008/2008 R2 Reporting Service:

Module 1: Introduction to Microsoft SQL Server Reporting Services: 

· Overview of SQL Server Reporting Services
· Installing Reporting Services
· Reporting Services Tools

Module 2: Authoring Basic Reports:

· Creating a Basic Table Report
· Formatting Report Pages
· Calculating Values

Module 3: Enhancing Basic Reports:

· Interactive Navigation
· Displaying Data

Module 4: Manipulating Data Sets:

· Defining Report Data
· Using Parameters and Filters
· Using Parameter Lists

Module 5: Using Report Models: 

· Creating Report Models
· Using Report Builder

Module 6: Publishing and Executing Reports: 

· Publishing Reports
· Executing Reports
· Creating Cached Instances
· Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports: 

· Introduction to Report Subscriptions
· Creating Report Subscriptions
· Managing Report Subscriptions

Module 8: Administering Reporting Services: 

· Reporting Server Administration
· Performance and Reliability Monitoring
· Administering Report Server Databases
· Security Administration
· Upgrading to Reporting Services 2008

Module 9: Programming Reporting Services: 

· Querying for Server Information Using a Web Service
· Automating Report Management
· Rendering Reports
· Creating Custom Code

SQL Server 2008 and 2008 R2 Performance Tuning:

Module 1: SQL Server 2008 Tool sets: 

· SQL Server Management Studio
· SQLCMD Utility
· Business Intelligence Development Studio (BIDS)
· SQL Profiler
· Bulk Copy
· Adventure Works Sample Database
· Data Definition Language

Module 2: Data Types and New T-SQL Language Features: 

· SQL Server Data Types
· New Data Types
· Hierarchyid Data Type
· Spatial Data
· Date and Time
· FileStream Storage
· Grouping Sets

Module 3: Single Table Queries:

· Logical Query Processing
· Query Clauses (Listed in Logical Processing Order)
· FROM
· WHERE
· GROUP BY
· HAVING
· SELECT
· ORDER BY
· CASE
· NULLS

Module 4: Joining Multiple Tables: 

· Normalization
· Old Style vs. New Style
· Cross Join
· Inner Join
· Outer Join
· Self Join
· Joining Multiple Tables

Module 5: Subqueries, Common Table Expressions and Ranking Functions: 

· Subqueries
· Self-Contained Subqueries
· Correlated Subqueries
· EXISTS
· Views
· Derived Tables
· Common Table Expressions
· Analytic Ranking Functions

Module 6: Indexing: 

· Understanding Execution Plans
· Table and Index Structures
· Syntax
· Clustered Index
· Non Clustered Index on Heap
· Non Clustered Index on Clustered Index
· Syntax

Module 7: Query Tuning: 

· System Performance Analysis
· Query Analysis
· Database Engine Tuning Advisor
· Bookmark Lookup
· Statistics Analysis
· Query Design
· Performance Monitor
· Dynamic Management Views
· SQL Profiler
· Database Engine Tuning Advisor
· Query Design

Module 8: Data Modification, Transactions and Error Processing:

· Modifying Data INSERT
· Modifying Data UPDATE
· Modifying Data DELET
· Transactions
· Error Processing
· Debugging in SQL Server 2008

Module 9: Stored Procedures and Triggers:

· Stored Procedures
· Triggers

Module 10: XML:

· XML Introduction
· XML in SQL Server
· XML Data Type
· XML Indexes
· FOR XML Clause
· Create Table with an XML Column
· Register a Schema
· Query() Method
· Value() Method
· Exist() Method
· Modify() Method
· Nodes() Method

Sybase ASE 15.0/15.5 Administration: 
Module 1: Introducing Adaptive Server
Module 2: Installing Servers
Module 3: Establishing Connectivity
Module 4: Configuring Server Behavior
Module 5: Configuring Memory
Module 6: Initializing and Using Devices
Module 7: Creating and Using Databases
Module 8: Suggested Disk Resource Strategies
Module 9: Auto Expansion
Module 10: Managing Tempdb and working with Multiple Tempdb
Module 11: Administering System Roles and Logins
Module 12: Managing Database Access and Users
Module 13: Implementing Object Permissions, Groups, and Roles
Module 14: Using Bulk Copy Utilities
Module 15: Overview of Automatic Recovery
Module 16: Checking and Fixing Database Consistency
Module 17: Planning for Backups
Module 18: Performing a Backup
Module 19: Practicing Advanced Backup Techniques
Module 20: Sybase Central
Module 21: Monitoring the System

Sybase ASE 15.0/15.5 development (T-SQL): 
Module 1: SQL and Transact-SQL
Module 2: Understanding SQL Basics
Module 3: Indexes and Search Arguments
Module 4: Joins and Subqueries
Module 5: Using Case Logic
Module 6: Transactions and Locking
Module 7: Writing Effective Transactions
Module 8: Using Cursors
Module 9: Manipulating Data
Module 10: Formatting Output Data
Module 11: Writing Effective Transact-SQL
Module 12: Writing Effective Stored Procedures
Module 13: Assigning Key Values
Module 14: Creating Hierarchies with SQL

Powershell Scripting:

Module 1: Introduction to Windows PowerShell - the Basics: 

· What Is Windows PowerShell?
· Installation
· Starting Windows PowerShell
· PowerShell Commands
· Shell Function Commands
· Script Commands
· Native Commands
· Command Line Interface (CLI) Navigation
· Windows PowerShell Cmdlets
· Wlindows PowerShell Snap-Ins
· Windows PowerShell Navigation
· Drives
· Aliases
· Parameters
· Help
· Variables
· Windows PowerShell Profiles
· Creating a Profile

Module 2: The Windows PowerShell Pipeline, Scripts, and Syntax: 

· Pipelines
· Scripts
· Properties and Methods
· Object Sorting
· Syntax, Special Characters, and Operators
· Quotes
· Output Redirection
· Command Continuation
· Special Characters
· Operator Precedence
· Operators Galore

Module 3: Variables and Data Types, Variable Scopes, and Arrays: 

· Variables and Data Types
· More Data Types
· Variables with Variables!
· Environment Variables
· Get-Variable
· Set-Variable
· New-Variable
· Clear-Variable
· Remove-Variable
· Variable Scopes
· Arrays
· Associative Arrays

Module 4: Security: 

· Script Execution
· Running a Script
· Execution Policy
· Group Policy for Execution
· Script Signing
· Local Certificate Authority Creation
· Signing Certificate Creation
· Signing Scripts Using Certificates
· Secure String Creation
· Whatif
· Requesting Credentials and Using Secure Strings

Module 5: Script Flow Control Statements: 

· Foreach and For
· Foreach
· For
· While/Do While/Do Until
· While
· Do While
· Do Until
· Branching with IF and SWITCH
· IF
· Switch
· Break/Continue
· Break
· Continue

Module 6: Formatting:

· Using Format-cmdlets
· Format-List (FL)
· Format-Table
· Format-Wide
· Format-Custom
· Groupby
· Group-Object
· Session Colors
· Using Sort-Object, Where-Object
· Sort-Object
· Where-Object
· Exporting Results to Files
· CSV
· XML
· HTML

Module 7: Regular Expressions: 

· Understanding Regular Expression Characters
· Using Regular Expressions
· Select-String

Module 8: Functions: 

· Functions, Filters, and Arguments
· Functions
· Filters
· Function Management
· Scripting with Functions and Parameters
· Passing Arguments into a Script

Module 9: Error Handling: 

· Error Handling
· Script Debugging

Module 10: Advanced Scripting for Administrators: 

· Manipulating Files and Folders
· Modifying Registry Data
· Retrieving Event Log Information
· Understanding ADSI and Windows PowerShell
· Using the New-Object cmdlet
· Understanding Timer Jobs