Training

Information Technology

SQL Server Database Developer

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

COURSE DESCRIPTION:
This course will teach Microsoft SQL Server development. Students will get practical skills in Transact-SQL coding, debugging, and performance tuning. Knowledge of SQL Server is required for Software Developers, Business Intelligence Analysts, SQL Server Administrators, Cyber Security Analysts etc. Also, it benefits many IT professions such as QA Analyst, Systems Analyst etc.
 
COURSE OBJECTIVES:
- 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
 
TOPICS:
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
 
 
Prerequisites: 
Computer user skills.
 

Related Courses