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

icon
What you will learn

  • Creating SELECT queries
  • Data types and NULL
  • JOIN
  • Set operators
  • Functions and aggregate data

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 0 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Geoff Allix's Querying Data with Transact-SQL? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course Description

icon
sql Awards Best Free Course

Transact-SQL is an essential skill for data professionals and developers working with SQL databases. With this combination of expert instruction, demonstrations, and practical labs, step from your first SELECT statement through to implementing transactional programmatic logic.Work through multiple modules, each of which explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database. The labs in this course use a sample database that can be deployed easily in Azure SQL Database, so you get hands-on experience with Transact-SQL without installing or configuring a database server.

icon
Pros

icon
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.

icon
Instructor Details

MSlogo.jpg

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.

icon
Reviews

0.0

0 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

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 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 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 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 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 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 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 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 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 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 Charles Chowa on 10/06/2016

The instructors were great in providing the logic behind using any of these concepts in the real world. I loved the crisp pace of the course, and like others, I wish we had more labs to practice on. Overall, this is a good and helpful course.