|
Prerequisites:
Prior Knowledge Of
SQL, Basic Knowledge, Relational Database Theory
|
Key
Benefits:
-
Learn Client Server Concepts
Know The Features Of Microsoft SQL Server
Understand and Implement SQL Server Database objects
Get Ready to Become a Certified Microsoft Database
Designer
|
Other
Course Features:
-
How-To Pages! Step-By-Step Instructions On A Variety
Of ‘Cookbook’ Procedures
A
Comprehensive Course Workbook
|
| Course
Description:
Learn the basics of Microsoft SQL Server and the SQL
Server Language. Our instructors are hands-on
Programmers, Database Designers, and Database
Administrators who will share their experiences while
teaching the course material. |
Topics
Covered:
- Introduction To
SQL Server
SQL
Server Distributive Management Framework,
Roles and Responsibilities of the Implementers
Rules and
Defaults
Data Integrity, Rules, Defaults,
Rules and Defaults and User Defined Types
- Database Design
Tables, Columns, Domains, Keys, Referential
Integrity, Database Normalization
Views
Creating and Dropping Views, Uses
View Notes
System
Databases
Definition and Roles of System Databases, master,
model, tempdb
Constraints
Check Constraints, Key Constraints
System Tables
Definition of System Tables,
SQL Server Storage allocation (devices)
System Stored
Procedures
Details on Key Stored Procedures
Triggers and
Stored Procedures
Types of Stored Procedures, Executing a Stored
Procedure, Dropping a Stored Procedure, Showplan of
a Procedure, Creating a Trigger,
Dropping a Trigger, Trigger vs Stored Procedures,
Triggers vs Constraints vs Rules and Defaults
Databases
Creating, Altering, & Dropping Databases,
Database System Catalog Tables
Batches and
Scripts
Limitation, Use
Datatypes
System
Datatypes, Creating User Defined Datatypes, Removing
User Defined Datatypes, Nulls, Not Nulls
Transaction
Management
Transaction Management Statements, Transactions in
Stored Procedures, Distributive Transactions
Tables
Creating Tables, Table Placement,
Dropping Tables
Programming
Constructs
Cursors, Case Statement, Control-of-flow Statements,
Execute Statement
Retrieving Data
The
Select Statement, Limiting Columns, Limiting Rows,
Sorting Data, Using Select with Views, Aggregate
Functions, Group By, Having, Cube & Rollup,
Compute and Compute By, Unions, Subqueries
Distributive
Data
Two-Phase Commit, Open Data Services Library,
Function and Purpose, Benefits, Bulk Copy,
Replication, What is replication, Publishers,
Distributors, Subscribers, Replication Scenarios,
SQL Server Web Assistant
Modifying Data
Insert, Select Into, Delete, Update
SQL Server
Extensibility
SQL Server Extensions, SQL Executive Manager,
Extended Stored Procedures, MAPI, Using OLE,
Client-side and Server-side APIs, ODBC, DB-Lib
Indexes
Types and Characteristics of Indexes, Index Options,
Indexes and Performance
Certification
Preparation
Test Preparation, Sample Certification Test
|
|
|
|
