SQL Server Programming

CBIT Canadian Beaver Training Ottawa
Ottawa, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' Module 0: Rdbms Essentials
| About the Relational Database Management System
SQL Server and the .NET Framework
SQL Server Terminology: Databases, Tables, Columns, Rows, Keys, Etc
Application Development and SQL Server
Oltp: The Transactional Server
Olap: The Analysis Server
XML Integration
Core SQL Server Services
Other SQL Server Services
The Role of ADO .NET

| Module 1: Database Planning
| Planning Overview
Normal Forms
The Analysis
The Design
Er Notation
Generalizations
Aggregations
Putting It Together

| Module 2: Creating the Database
| Planning the Installation
SQL Server Installation
Data Storage Architecture
Creating Database Files
Using File Groups
Optimizing Data Storage

| Module 3: Creating Tables
| Integrity Overview
Creating Data Types
Creating Rules and Defaults
Creating a Table
Primary and Foreign Keys
About Constraints: Default and Check
Creating Triggers

| Module 4: Structured Query Language Basics
| SQL Overview
The Select Statement
Aggregate Values
The Insert Statement
The Update Statement
The Delete Statement
Using Views

| Module 5: Tsql Language Elements
| SQL Data Types
Stored Procedures and Metadata Views
Using Variables
Type Conversion
Dealing with Null Values
Dealing with Dates
Conditional Constructs
Looping Constructs
Useful Functions
Error Handling

| Module 6: Advanced Structured Query Language
| Join Strategies
Inner, Outer and Cross Joins
About Self-joins
Sub-queries
Using Temporary Objects

| Module 7: Stored Procedures
| Architectural Overview
Benefits of Stored Procedures
Using Built-in Stored Procedures
Creating Stored Procedures
Using Input and Output Parameters
Stored Procedure Optimization

| Module 8: Indexing
| Index Overview
Index Architecture
Clustered Indexes
Non-clustered Indexes
Unique Indexes
Indexes and Keys
Indexed Views

| Module 9: Optimizing Performance
| Optimization Overview
Using Query Analyzer
Gathering Performance Data
Optimizing for Select
Optimizing for Insert, Update and Delete
Query Hints
Join Strategies
SQL Server Transactions and Locks
Deadlocks and Livelocks

| Module 10: Practical SQL
| Planning the Work
Process Oriented Tasks
Analysis Related Tasks
Statistical Tasks
Data Integrity Checks
Using Dts
...''

Elements of this syllabus are subject to change.

Phone:613 742-6800

School Address/Venue(s):

CBIT Canadian Beaver Training Ottawa
214 Montreal Rd
Suite 100
Ottawa, Ontario
K1L 8L8
Canada

Jobs & Resumes: Ottawa
Houses & Roommates: Ottawa
Travel Agencies: Ottawa

Search other schools for SQL Server Programming training resources.

Team Building and Workplace Efficiency
SQL Server Administration
SQL Server 2008
Oracle Server
Building a Data Warehouse with Oracle
Oracle Core Administration Skills

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.