Transact SQL Development Certificate

Recommended Pre-requisites

  • Use Microsoft Windows - one year minimum general experience
  • Program in a computer programming language
  • Apply structured programming concepts
  • Express a strong interest in computer programming

Overview
The Transact SQL certificate series teaches students fundamental relational database design as well as the Transact SQL, the programming language of Microsoft SQL Server. Students will learn to analyze data requirements and then, working within the Microsoft SQL Server Management Studio, build databases, tables and other SQL Server objects to support those requirements. Once database objects are created, students will use Transact SQL to mine data, add, edit and delete data and use programming objects such as stored procedures and triggers to build business logic into the database design. Upon completion of the series of classes, students will have skills necessary to use SQL Server as the back-end database to develop client-server applications using the front-end programming tool of their choice.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below. Courses should be completed in the order shown below.
  2. A final project during which the participant will demonstrate knowledge of Transact SQL.

Relational Database Modeling
This course is designed to assist participants in developing a systematic approach to developing a relational database. The student will learn how to define user requirements, develop an entity-relationship diagram and map a logical database model to a physical database design. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain hands-on practical experience. This course will conclude with a hands-on modeling workshop. This workshop provides the opportunity to model a real world database application. All materials for the class are provided. This course is intended for individuals who currently work with databases such as Access, Oracle or Microsoft SQL Server OR who anticipate working with them in the future. Individuals who are interested in database design.

Introduction to Transact SQL
This course is designed to introduce participants to the SELECT statement using Transact SQL and Microsoft SQL Server 2005. Transact-SQL is the language used by the SQL Server Database Engine, to create and manage database objects, and to insert, retrieve, modify, and delete data. Transact-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI). Participants will use the Query Editor to create and execute SELECT statements from single and multiple tables.

Intermediate Transact SQL
This course is a continuation of the Introduction to Transact SQL course. The following SQL statements will be covered in detail: CREATE DATABASE, CREATE TABLE, INSERT, SELECT INTO, UPDATE, DELETE, ALTER TABLE, CREATE VIEW. Other topics include data integrity, types of constraints, defining constraints using SQL and creating and using views.

Advanced Transact SQL
This course is a continuation of the Intermediate to Transact SQL course. The following SQL statements and concepts will be covered in detail: Built-in functions, user defined programming objects, set based queries. Other topics include: indexes.

Project in Modeling and SQL
This course is a comprehensive exercise that incorporates all topics covered from Data Modeling through Advanced Transact SQL. Students are given a series of related objectives that require utilization of their skills and knowledge of Transact SQL to complete. During the course of the project, students will: create a database, create tables, insert, update and delete data, create views, write numerous queries, create views, rite several user defined functions, stored procedures and triggers. After completing all of the objectives, students take an online exam that tests their knowledge of concepts presented in the series of SQL courses.

 

Register for a class