PDP Url

Introduction to Transact SQL

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.

Self-Paced

Learning Style

Beginner

Difficulty

2 Hours

Course Duration

Course Info

Download PDF

Certificate

See Sample

About Individual Course:
  • Individual course plan gives you access to this course
On Sale!
Now Only $0.00 Regular Price $49.00
Now Only $0.00 Regular Price $49.00
/ Each
When you subscribe, you get:
Learn Subscription plan gives you access to this course and over 836 other popular courses
On Sale!
Now Only $39.99 Regular Price $44.99
Now Only $39.99 Regular Price $44.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 68% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 72% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 78% ($8.99 monthly.)
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.

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

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

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here