SQL Server 2008 T-SQL Programming: Introduction to SQL Server 2008 for Developers and Query Writers training course teaches attendees the skills they need to successfully build, query, and interact with Microsoft SQL Server 2008.

Audience

This course is intended for IT Professionals who can write efficiently write the stored procures for business logic and can also generate the reports by using SQL Server 2008 databases.

Course fee - 250$

For any queries on how to pay, mail us to billing@sqlservermasters.com

Online Payment

Microsoft SQL Server 2008 T-SQL programming Outline :

Introducing SQL Server 2008

  • What's New in SQL Server?
  • SQL Server Editions
  • Installing SQL Server

Basics of Database Design

  • Normalization
  • Denormalization
  • Tools for Normalization in SQL Server
  • Introducing SQL Server Management Studio
  • Creating a Database
  • Adding Tables
  • Creating Indexes and Constraints
  • Building Relations

T-SQL Basics

  • What is T-SQL?
  • Syntax Conventions
  • Introducing AdventureWorks2008
  • Executing SQL Statements
  • Identifiers
  • Creating Data Types
  • Operators
  • Variables
  • Functions

SELECT queries

  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • Using GROUP BY and HAVING
  • Using TOP N and TOP N PERCENT
  • UNION Queries
  • Full-Text Search

Action queries

  • SELECT INTO queries
  • DELETE queries
  • TRUNCATE TABLE queries
  • INSERT queries
  • UPDATE queries
  • MERGE queries

Locking and Execution Plans

  • What is Locking?
  • Monitoring Locks
  • Tuning Locking
  • Deadlocks
  • Tuning Queries
  • Management Data Warehouse
  • Performance Studio

Views, Stored Procedures, and Functions

  • Using Views
  • Using Stored Procedures
  • Using Functions

Triggers

  • Creating DML Triggers
  • Altering DML Triggers
  • Using the Inserted and Deleted Tables
  • Checking Updated Columns
  • Recursive and Nested Triggers
  • Creating DDL Triggers

Data Protection/Tracking

  • Understanding Change Data Capture
  • Data Capture Schema and Tables
  • Transparent Data Encryption

Security and SQL Server

  • Choosing Service Accounts
  • Authentication Modes
  • Roles and Users
  • Permissions
  • Object Ownership

Conclusion

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture.

Software Needed on Each Student PC

  • Windows Server 2003 or 2008, Windows XP Professional, with at least 1GB RAM
  • SQL Server 2008

After completing this course, students will be able to:

  • Use the programming environment in SQL Server Management Studio and learn the Transact-SQL language
  • Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
  • Implement the SQL Server 2008 security model; and create logins, users and permissions to protect your data
  • Configure and tune SQL Server 2008 and monitor database activity