Introduction to Transact SQL

About this course:

This course is a free version of Transact SQL, and contains initial 2 modules of the main Transact SQL course to give you an idea about how Transact SQL database queries are performed in Visual Studio. Transact SQL or T-SQL is a standardized computer language for querying, altering and defining relational databases, using declarative statements. While this course is specifically focused on Microsoft product, most of what you learn will be applicable to any SQL based database including Oracle, DB2, MySQL etc. This course does not assume that you have any prior knowledge of T-SQL. If you understand relational database concepts it will be a benefit, however it is not a prerequisite.

The average salary for SQL Database Administrator is $77,428 per year.

Course Objective:

After completing this course, students will have a working understanding of:

• SQL Dialects
• ASCII vs Unicode
• Data Types
• Case-Sensitive Collation
• Filtering Records with the Where Clause
• Sorting Result Sets

Audience: 

This course is intended for:

• Database Administrators
• Database Developers

Prerequisites:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of relational databases.

Suggested prerequisites courses:

• SQL Database for Beginners
• SQL Basics