Product Description
OVERVIEW
Our SQL Fast Course is a 24 hours classroom course. Structured Query Language (SQL) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language.
AUDIENCE PROFILE: Meant for anyone who wants to have a solid understanding of a Relational Data Base System
PRE-REQUISITE: No Pre-requisite required
COURSE TYPE: Classroom
DURATION: 24 Hours
COURSE DESCRIPTION
Techno Canada Centre of Excellence’s 24 hour SQL Fast Track course has a hands-on approach where students learn SQL using Microsoft’s flagship database product, MS SQL Server. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.
On course completion you will receive a “Certificate of Completion” from Techno Canada Centre of Excellence.
Some of the features of SQL to be taught in class include:
- Establish relationship among tables using business rules
- Use Update and Delete commands
- Query on Databases
- Retrieving Result Sets
- Functions & Joins
- Subqueries
- Creating Tables & Enforcing Data Integrity
- Maintaining Databases
- Implementing Indexes
- Implementing Views & Batches
- Implementing Stored Procedures
- Implementing Triggers & Transactions
- Implementing Transactions & Cursors.
