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.
|
|
|
|
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
|