Learning Microsoft Transact - SQL (Udemy.com)

Creating, querying, and programming with SQL databases using the Microsoft of Sybase extension language.

( 146 Reviews )

Created by: Infinite Skills

Produced in 2017

What you will learn

create new databases and tables using Transact SQL.
query and modify data within a T-SQL database.
perform basic programming and optimization tasks within an SQL database.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Course Description

If you're eager to learn how to create SQL databases or more specifically work with Microsoft's T-SQL extension language, this course is for you. The tutorials are designed for the absolute beginner, meaning no previous experience with Transact is required. You will start by learning about databases, then jump into learning about the Microsoft SQL server. From there, Mark will teach you about the T-SQL foundations, how to create a database with T-SQL, and querying with T-SQL. This video tutorial also covers how to modify data with T-SQL, as well as T-SQL programming basics, such as comments, set and select, and batches. You will also learn how to program objects and create and drop indexes. Finally, you will learn to understand normalization and transactions. Once you have completed this computer based training course, you will be fully capable of using Transact-SQL to create your own databases and tables to select, insert, and manage data. Who this course is for:

anyone wanting to learn more about SQL database design and Microsoft's extension language
developers and IT professionals interested in Microsoft certification

Time: 7h

Instructor Details

Infinite Skills

4.3 Rating
146 Reviews

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.3

146 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Jahanvi Shah on 9/24/2020

Concepts were clearly explained. But exercises are missing.

By Valerie Candelaria on 9/21/2020

Exactly what I was looking for to get started building from the ground up!

By Doug Mason on 9/8/2020

Very Good Class - The instructor communicated in a way a beginner can understand!! I would like to take the advanced TSQL class. Is there one available?

By Jaimie Amaya on 5/25/2020

This course is much more informational than I was expecting. Also, with such a pleasing voice, makes it so easy to listen to.
Wish I would have started sooner.

By Reynaldo Esparza on 4/27/2020

Excellent course!

By Shaik John Saida on 4/7/2020

In this training he try to cover all topics. But, this all topics on basic level only. It is useful for beginners not for experienced persons. I am expecting more and deep T-SQL. Your need to add more real time examples.
Than you:)

By Tammi Saffold on 4/1/2020

Clear, easy to understand, interesting facts.

By Scott McGoldrick on 3/23/2020

This is a great course for an introduction to T-SQL. I enjoyed the general theory around databases which this course provides but would have preferred some more examples and information on the execute commands and perhaps some regulary testing to check understanding.

By Alan Chiwaridzo on 3/7/2020

Great Content; Great confidence from Tutor; Relevant Information; I recommend to anyone best choice; The Instructor was just very good and Voice projection so clear. Examples short, precise and informative. Keep it up

By Stephen Fraser on 2/22/2020

The course is only really about rudimentary Select, Insert, Update and Delete. Whenever you need to do anything more complex the trainer says find a book or read the documentation.

By Jeffrey Robinson on 9/26/2019

Very Good!!!

By Michal Jankowski on 9/24/2019

I did this course as a refresher of the information I learned during my university IT major and as a refresher it is superb. I forgot how much I forgot :) A lot of knowledge here, but as a starter - a very good choice to learn about T-SQL. Recommended wholeheartily!