SQL Server Programming

SQL Server

SQL Enterprises Manager, Clint Configuration Utility, View and Index, Data Modeling, Data Integrity, Triggers, Stored Procedures.

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

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>