Training

Information Technology

SQL Server Database Developer

Start: TBA       Type: Evening / Weekend Classes       Duration (hr): 63

 

COURSE DESCRIPTION:
This course will introduce Microsoft SQL Server development to students. Students will get theoretical knowledge and practical skills in Transact-SQL coding, debugging, and performance tuning.
 
COURSE OBJECTIVES:
Upon completing this course students will have skills in:
  •  - Developing robust, efficient server-side code for SQL Server
  •  - Retrieving and Maintain data using Transact SQL
  •  - Managing local and distributed transactions and locks
  •  - Writing store procedures and user defined functions
  •  - Utilizing of server-side cursors
  •  - Developing triggers for data validation and audit trails
  •  - Tuning queries for optimization
 
The Following topics will be covered:
 

SQL Server Overview
SQL Server Installation and Configuration
Overview of Database Concepts
Normalization
T-SQL
Cursor and Transactions
ADO Technology
SQL Programming Across Multiple Servers
XML Integration

 

(*) Contact us about current Discounts and Promotions

Related Courses