Phone (416) 332-8727 ; Add to Favorites
Home Programs Admission Financial Aid e-Learning Events & News Career Services Contact
SQL Server

1: Overview of Programming SQL Server

Introducing SQL Server Databases

Working With SQL Server Programming Tools
Understanding Transact-SQL Elements
Programming Language Elements
The use of local variables and operators,
The use of functions,
The use of control-of-flow statements, and comments
Executing Transact-SQL Statements


2: Creating and Managing Databases

Defining Databases
Creating a database
Using Filegroups
Managing Databases


3: Creating Data Types and Tables

Working with Data Types
Working with Tables
Generating Column Values
Generating Scripts


4: Implementing Data Integrity

Introducing Data Integrity
Methods to enforce data integrity
Defining DEFAULT, CHECK Constraints
Defining PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.
Understanding Constraint Types
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use


5: Planning Indexes

Introducing Indexes
Understanding Index Architecture
Retrieving Stored Data with SQL Server
Maintaining Index and Heap Structures in SQL Server


6: Creating and Maintaining Indexes

Introducing Statistics
Creating Indexes
Use the CREATE INDEX options
Understanding Index Creation Options
Maintaining Indexes
Query optimizer creates, stores, maintains, and uses statistics to optimize queries.
Using the Index Tuning Wizard
Performance considerations


7: Implementing Views

Introducing Views
Defining and Using Views
Modifying data through views
Using Views to Optimize Performance


8: Implementing Stored Procedures

Introducing Stored Procedures
Using Parameters in Stored Procedures
Creating Stored Procedures
Modifying and Dropping Stored Procedures
Executing Stored Procedures
Handling Error Messages
Creating custom error messages.
Using dynamic SQL in stored procedures.



9: Implementing User-Defined Functions

Introducing User-Defined Functions
Implementing User-Defined Functions
Create and alter user-defined functions


10: Implementing Triggers

Introducing Triggers
Creating, Altering, and Dropping Triggers
Working with Triggers
Implementing Triggers
Create a trigger.
Drop a trigger.
Alter a trigger.
Evaluate the performance considerations that affect using triggers


11: Programming Across Multiple Servers

Introducing Distributed Queries
Writing ad hoc queries that access data stored on a remote computer
Setting up a linked server environment to access data stored on a remote computer
Writing queries that access data from a linked server.
Executing stored procedures on a remote server or linked server.
Managing distributed transactions.
Using distributed transactions to modify distributed data.
Using partitioned views to increase performance.



12: Optimizing Query Performance

Introducing the Query Optimizer
Tuning Performance Using SQL Utilities
Using various methods for obtaining execution plan information
Using an Index to Cover a Query
Identifying indexing strategies that reduce page reads
Overriding the Query Optimizer
Understanding Indexing Strategies and Guidelines
Evaluating when to override the query optimizer.

13: Performing Advance Query Analysis

Analyzing Queries That Use OR Operator
Analyzing Queries That Use the AND Operator
Analyzing Queries That Use Join Operations
Evaluating strategies for query optimization.



14: Managing Transactions and Locks

Introducing Transactions and Locks
Execute, cancel, or roll back a transaction
Understanding SQL Server Locking Architecture
Identifying locking concurrency issues
Identifying resource items that can be locked and the types of locks.
Locking compatibility.
SQL Server dynamic locking.
Setting locking options and displaying locking information.

The Trainers

Sean Tan

MCSE, MCDBA

Ms. Joan Lin
Ph.D. in Computer Application
Senior Scientisit
Senior Statistian

The Achievements
Achievement
Consultation

Fill out and submit this Form to ask any questions about this program. Our counsellor will get back to you shortly.

Name
Phone
Email
Questions
 

The Resources
Resources
Articles
Articles
OCOT Hotline

(phone) 416-332-8727

ACCPAC

OCOT Advantages

100 %Instructor-Led Class
State-of-the-Art Facilities
Unlimited Lab Time
Labs Open 7-days a Week
Free Repeat
Free Job Placement
Financial Aid Possible
Resume Writing
Interview Skills


© 2008 Ontario College of Technology