
Introduction to Transact SQL

Self-Paced
Learning Style

Beginner
Difficulty

2 Hours
Course Duration

Course Info

Certificate
About Individual Course:
On Sale!
Now Only
$30.00
Regular Price
$59.00
Now Only
$30.00
Regular Price
$59.00
/ Each |
||||
When you subscribe, you get:
Learn Subscription plan gives you access to this course and over 841 other popular courses
On Sale!
Now Only
$39.99
Regular Price
$44.99
Now Only
$39.99
Regular Price
$44.99
/ Month Team
Pricing
|
Course Information
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:
Outline
More Information
Brand | Microsoft |
---|---|
Subjects | IT Ops & Management |
Lab Access | No |
Technology | Microsoft |
Learning Style | Self-Paced Learning |
Difficulty | Beginner |
Course Duration | 2 Hours |
Language | English |
VPA Discount | VPA Discount |
Reviews