SQL Server Developer Course
Duration 4 days
Objectives
An 4-day intensive on SQL Server Database Development. This course is unique in that it is aimed at the practical, real world usage of SQL server, rather than the more academic approach offered by other trainer suppliers.
The overall goal is to provide the developers both with key knowledge and expertise based on commercial usage of SQL Server and an understanding of industry best practice in SQL Server Development and Administration.
Our trainer comes with excellent credentials, since he is an MS Certified developer, but crucially he posseses in-depth commercial experience that ensures your training is highly relevant to industry needs. This means that the skills you obtain will provide the right foundation for you to develop effective solutions based on tried-and-tested SQLServer techniques and practices.
This course can be customised to me meet private client learning requirements. Requirements
Previous developer knowledge is helpful but not essential. Good working knowledge of Windows XP, and Windows Server 2003. Ideally, delegates will have completed our SQLServer Developer & Administrator Foundation.
Course Outline
SQL Server Overview
• Database Architecture Essentials
• Database Design Essentials
Data Definition Language (DDL)
• Creating tables
• Defining table constraints
T-SQL
• Retrieving data
• Using Joins
• Aggregate functions
• GROUP BY clause
• UNION operator
• Manipulating data
• Advanced T-SQL topics
Transactions
• Transaction basics
• Implicit vs Explicit transactions
• Starting a transaction
• Ending a transaction
• Error trapping
• Rolling back transactions
Locking and Blocking
• Overview of SQL Server locking
• Transaction Isolation levels
• Identifying blocked processes
• Deadlocks and how to avoid them
Stored Procedures
• What are stored procedures and how are they useful
• Creating and altering stored procedures
• Using parameters and variables
• Security and stored procedures
• Inserting results of stored procedures into tables
Triggers
• Creating triggers
• Using the inserted and deleted tables in triggers
DTS
• DTS Designer
• Creating connections
• Executing packages
• Error handling and logging
Indexes
• Basic concepts
• Creating indexes
• Managing indexes
Security
• Managing server level security
• Managing database level security
• Managing object level permissions
Performance and Maintenance
• Allocating memory to SQL Server
• Notes on best practices
• Managing database files
• Managing database consistency
• Query Tuning
Wrap-up
• QandA
• Further reading and resources
• Recommended next steps
| 
