Querying Data with Transact-SQL
Microsoft created this course through edX to provide a certification path to working with Transact-SQL. It takes developers who are new to SQL databases and leads them to proficiency with the concept.
Created by: Geoff Allix
Produced in 2015
What you will learn
- Creating SELECT queries
- Data types and NULL
- JOIN
- Set operators
- Functions and aggregate data
Quality Score
Overall Score : 86 / 100
Course Description
SQL Awards Best Free Course
Pros
Cons
-
- Course is part of two certified programs: Data Analysis: Essential Skills and Data Science Core.
- Course does a great job of encouraging experimentation, expanding the depth of understanding of the topics covered.
- Course support is robust and outperforms many of its peers.
-
- Course is for beginners with SQL, but not beginners with programming in general. It is geared towards an intermediate audience, and inexperienced coders may struggle.
- Course does not involve writing queries from scratch, which leaves certified graduates feeling unprepared for real-world applications.
- Course success rates are much higher for students with at least a peripheral background in SQL.
Instructor Details
- 4.3 Rating
15 Reviews
Geoff Allix
Geoff Allix is a Microsoft SQL Server subject matter expert and professional content developer at Content Master a division of CM Group Ltd. Geoff is a Microsoft Certified IT Professional for SQL Server with extensive experience in designing and implementing database and BI solutions on SQL Server technologies. He has provided consultancy services to organizations seeking to implement and optimize database solutions, and contributed as a writer and subject matter expert to many SQL Server courses including the SQL Server 2014 Microsoft Official Curriculum courses.
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Ryan Armstrong on 07/15/2017
Generally, it seemed like this course covers what I have needed as an analyst professionally. The video lectures contain lots of useful information and the professors have a good dynamic. I work with databases every day, but there was plenty of new material as well---maybe things I should have known already---that will no doubt be useful in my day-to-day. I would have liked to have had more opportunity for practical application.
By Shubham Avasthi on 07/03/2017
The content was great and useful. Overall I learned a lot from the course.
By Andre Campbell on 06/26/2017
Learning transact sql for my job - this course has been a huge help, there is definitely room for improvement on how the content is presented, but this has been the best sql resource I've found so far
By Ruslan Emelyanchenko on 06/01/2017
Good involving lab assignments that covers all the content that you might see in the videos. Graeme and Geoff are enjoyable teachers, it was a pleasure to learn from them.
By Gagandeep Singh Gill on 05/26/2017
I am really enjoying it, it is time consuming however I can't have words to thank microsoft and edx for providing it to needfulls for free. labs are there , test is there and lecturers are there, full support is there if you have any question( my only 2 question upto know were answered in less then 24 hours).
By Yaseen S. on 04/16/2017
I am very disappointed I have previous experience in SQL BUT this course is The worst course I have ever seen Videos are very long and very boring there is a lot of talk and little information The professor progresses in the material and has no persuasive style I hated databases because of this course Videos must be short for less than 3 minutes and there should be interesting content such as slide shows, teaching aids, illustrations, and graphics. In addition, the professor is a professional in databases but not a professional in teaching
By William Adomako on 03/25/2017
Very interesting course, I have no prior knowledge of SQL and very minimal knowledge of programming, i failed passing for the certificate by 2 points at my first attempt, I will attempt one more time and hopefully pass.
By Muhammad Amil Busthon on 02/06/2017
Don't worry if you have no experience with SQL. I can complete this course, it is not that difficult if you read the detail statements and try to guess/predict the results when necessary.
By Keith Safford on 02/02/2017
The course was an excellent course on T-SQL. I have worked with SQL Server since v6.5 so I did have familiarity with the subject matter and have utilized numerous topics covered in the lessons. I did find the course challenging as there were a number of the items I had NOT used before (GROUP BY ROLLUP, GROUP BY GROUPING SETS, GROUPING_ID, etc.) which I found very challenging, but very useful and will benefit me in the future. Even though I have been working with SQL Server, the labs were quite challenging and I did learn a lot from the course (after all, isn't that the objective of the course?).
By Matt McMichael on 01/23/2017
This is a little too intense and hardcore in terms of grading and weight, in my opinion. There were some definite gaps and a little too much assumed programming-wise which is where I failed to understand content the most. I've had some online learning experiences with Python and Java which helped to understand some of the syntax, yet SQL is definitely its own animal.
By Rajesh Sampathkumar on 01/15/2017
Good for those who seek to refresh their skills in SQL or gain a credential that showcases their knowledge. The content doesn't involve graded labs, which is unusual given the number of examples they have included in the labs. However, the questions and content are definitely good.
By Dean Hu on 11/23/2016
This course is quite nice although is not designed for full beginners. You have to have some ideas of querying with T-SQL. But when you do have used T-SQL before, it's a very nice experience to refresh your skills using this course. The videos are of good quality.
Showing 12 of 15 reviews
Could not load more reviews.






