What you'll learn:
- SQL Dialects
- ASCII vs Unicode
- Data Types
- Case-Sensitive Collation
- Filtering Records with the Where Clause
- Sorting Result Sets
This free course is only an introduction of Transact SQL, to give you an idea about how Transact SQL database queries are performed in Visual Studio. This course is not intended to make you an expert in Transact-SQL, instead the course is designed to give you a basic idea to help you plan your future learning and project.
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.