Free SQL Server Tutorial – Introduction to Transact SQL
Introduction to Transact SQL – Free Course
What you’ll learn
- SQL Dialects
- ASCII vs Unicode
- Data Types
- Case-Sensitive Collation
- Filtering Records with the Where Clause
- Sorting Result Sets
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
This course is an introductory 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.