Module 1
SQL Server & Database Concept
1.1 Introduction to SQL Server
1.2 SQL Server Services
1.3 Databases, Objects, & Systems Tables
1.4 Metadata retrieval
1.5 SQL Server Security
1.6 4 Stages of Implementing a SQL Server Database
1.7 Database Normalization
Module 2
Programming SQL Server
1.1 Layers
1.2 Data Access
1.3 Programming Tools
1.4 Transact- SQL
1.5 Statements
1.6 3 Language Statements
1.7 Batch Directives
1.8 Identifiers
1.9 Color Codes
1.10 Query Analyzer Demo
1.11 Additional Language Elements
1.12 Aggregate & Scalar Functions
1.13 Different Types of Statements
1.14 Executing Transact-SQL Statements
1.15 SQL Syntax Review
Module 3
Databases and Database Files
1.1 Defining Databases
1.2 Creating a Database
1.3 How the Transaction Log Works
1.4 Setting Database Options
1.5 Creating Filegroups
1.6 Recommendations
1.7 Review
Module 4
Creating Data Types & Tables
2.1 Data Types
2.2 Create & Drop a Table
2.3 User Defined Data Types
2.4 Data Type Guidelines
2.5 Generating Column Values
2.6 The Identity Property
2.7 Automatically Generating Scripts
2.8 Review
Module 5
Implementing Data Integrity
3.1 Data Integrity & Constraints
3.2 Adding a Default Constraint
3.3 CHECK Constraints
3.4 Adding a CHECK Constraint
3.5 Primary Key, Unique & Foreign Constraint
3.6 Review
Module 6
Indexing Overview
1.1 Storing & Retrieving Data
1.2 Storing Heaps
1.3 B-tree Structures
1.4 Clustered Indexes
1.5 Non-Clustered Indexes
1.6 Querying the Sysindexes Table
1.7 Page Splits, Design & Performance
1.8 Indexing Guidelines
1.9 Performance Considerations
1.10 Review
Module 7
Creating and Maintaining Indexes
2.1 Creating Indexes
2.2 Computed Columns
2.3 Viewing a List of Indexes
2.4 Indexing Options
2.5 Statistic Binary Column
2.6 Creating, Updating & Viewing Statistics
2.7 DBCC Command
2.8 The Turning Wizard & Performance Considerations
2.9 Review
|
Module 8
Implementing Views
3.1 Introduction to Views
3.2 Creating Views
3.3 Using Indexed Views
3.4 Review
Module 9
Transact-SQL Stored Procedure
1.1 Defining Stored Procedures
1.2 Looking at a Stored Procedure
1.3 Using Parameters
1.4 Creating & Calling a Stored Procedure
1.5 Recompiling Stored Procedures
1.6 Executing an Extended Stored Procedure
1.7 Handling Error Messages
1.8 Review
Module 10
User-defined Functions
2.1 What is a User Defined Function
2.2 Creating a User Defined Function
2.3 Examples of User Defined Functions
2.4 Review
Module 11
Implementing Triggers
3.1 Using & Creating Triggers
3.2 Different types of Triggers
3.3 Creating a Delete Trigger
3.4 Enforcing Data Integrity & Business Rules
3.5 Review
Module 12
Programming Multiple Servers
4.1 Interlocution to Distributed Queries
4.2 Setting Up a Linked Server
4.3 Working with Linked Servers
4.4 Review
Module 13
Optimizing Query Performance
1.1 Introduction to the Query Optimizer
1.2 Viewing STATISTICS Statements Output
1.3 STATISTICS & Show plan Options
1.4 The Graphical Execution Plan
1.5 Comer Queries
1.6 Creating Indexes That Cover a Query
1.7 Creating Indexes That Cover a Query
1.8 Review
1.9 Monitoring Functionality
1.10 SQL Profiler
1.11 Execution Plan
Module 14
Analyzing Queries
2.1 Different Types of Queries & Joins
2.2 Review
Module 15
Managing Transactions & Locks
3.1 Introduction to Transactions & Locks
3.2 Examples of Transactions
3.3 Locks
3.4 Basic Trips
3.5 Review |
