 |
Courses Offered
|
|
|
Essential SQL Server 2005 for Developers
This course is designed to provide knowledge and skills required to install, configure, administer and troubleshoot the client-server database management system of Microsoft SQL Server 2005.This course will cover everything you need to know about SQL Server, with emphasis on SQL Server 2005: how to utilize its features for maximum performance, code re-usability, and application modularity. The latest version of SQL Server, SQL Server 2005 uses .NET 2.0 to introduce changes that make the database a truly integrated part of the .NET Framework, and this course give the developers a thorough look at these exciting features.
Highlight: This course covers all of these topics at both a low level and a functional level, enabling developers to determine not only how they work, but when to use them.
| Duration: | Six Weekends (Sat & Sun)Approx. 80 hrs |
| Skill Level: | Intermediate |
| Price: | USD 1295.00 |
Detailed Course Outline
Introduction to SQL Server 2005
- Module 1 - Basic RDMS concepts, Database Modeling and writing T-SQL Queries. The goal is to provide the technical and logical skills required to write and understand queries in Transact-SQL.
- Module 2 - Product knowledge and skills needed to implement Microsoft SQL Server 2005 database. The primary objective is to teach how to use SQL Server 2005 product tools related to implementing a database.
- Module 3 - Features of MS SQL Server 2005 i.e. SSIS, SSAS, SSRS, Notification Services and other relevant technologies.
Beginning to Program with the SQL Server 2005
- Module 1 (Day 1) - RDBMS Concepts
- RDBMS Basics
- Normalization
- SELECT Clause
- FROM Clause and Joining Tables INNER JOIN Statement
- WHERE Clause
- Subqueries
- Subqueries
- Correlated Subqueries
Using Aggregation
- Aggregate Functions
- GROUP BY
- HAVING
- Advanced Query Topics
- Writing Scripts
- Using Variables
- Temporary Objects
- Introduction to Database Objects
- Tables, Views
- Stored Procedures, User Defined Functions and Triggers.
- Constraints, Defaults and Views
- Module 2 (Day 2) - MS SQL Server 2005
- Creating Databases and Database Files
- Creating Databases.
- Creating Filegroups.
- Creating Schemas.
- Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
- Using XML
- Retrieving XML by Using FOR XML.
- Shredding XML by Using OPENXML.
- Using the xml Data Type.
- Module 2 (Day 3) - MS SQL Server 2005 (cont.)
- Creating and Tuning Indexes
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
- Implementing Data Integrity
- Data Integrity Overview
- Implementing Constraints
- Implementing Triggers
- Implementing Views
- Introduction to Views
- Creating and Managing Views
- Creating Partitioned Views.
- Implementing Stored Procedures and Functions
- Implementing Stored Procedures.
- Creating Parameterized Stored Procedures.
- Creating Functions
- Handling Errors
- Module 2 (Day 4) - Internals of MS SQL Server (cont.)
- Understanding SQL Server Internals
- Batch and Transactions
- SQL Server LOG
- Checkpoints
- LOCKS
- Isolation Levels
- Indexes
- Distributed Transactions
- Performance Tuning
- Module 2 (Day 5) - Implementing Managed Code in the Database (cont.)
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
- Migration from MS SQL Server 2000 to 2005
- Overview of BRD implementation
- Revisions
- Module 3 (Day 6) - Features of MS SQL Server 2005
- Introduction to SSIS / DTS
- Introduction to SSRS
- Introduction to SSAS
- Introduction to Notification Services
|
|
Employees Portal