Querying with Transact-SQL

Provided by:
8/10 stars
based on  51 reviews
Provided by:
Cost FREE , Add a Verified Certificate for $99
Start Date In Session

Course Details

Cost

FREE,
Add a Verified Certificate for $99

Upcoming Schedule

  • In Session

Course Provider

edX online courses
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be tau...
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

Provider Subject Specialization
Sciences & Technology
Business & Management
22043 reviews

Course Description

This course is part of the Microsoft Professional Program Certificate in Big Data and the Microsoft Professional Program Certificate in Data Science.

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.

Reviews 8/10 stars
51 Reviews for Querying with Transact-SQL

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
Ryan Armstrong profile image
Ryan Armstrong profile image

Ryan Armstrong

8/10 starsCompleted
1 year, 10 months ago
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. The labs were helpful, but there was no chance to write queries from scratch (I followed along with the demos). Of course, with the Adventure Works database everything is in place to experiment on your own. Perhaps some optional assignments could be added? Overall very satisfied with the course.
Was this review helpful? Yes0
 Flag
Shubham Avasthi profile image
Shubham Avasthi profile image

Shubham Avasthi

10/10 starsCompleted
1 year, 10 months ago
The content was great and useful. Overall I learned a lot from the course. However, there is still room for improvement in the quality and the count of assignment questions.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsTaking Now
1 year, 10 months ago
If you have never worked with SQL or have zero experience in T SQL, it will be better to spend a few days learning from Microsoft TechNet and MSDN.
Was this review helpful? Yes0
 Flag
Divyesh Parmar profile image
Divyesh Parmar profile image

Divyesh Parmar

10/10 starsCompleted
1 year, 11 months ago
Good and easy to understand all practical session are really good and clear.lab assignment also superb but its require more complex then current one
Was this review helpful? Yes0
 Flag
Gagandeep Singh Gill profile image
Gagandeep Singh Gill profile image

Gagandeep Singh Gill

8/10 starsTaking Now
1 year, 11 months ago
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). It will be great help if they will deliver handout of summary of all the commands used in particular module for all module, this would also be really helpful while doing the test labs.
Was this review helpful? Yes0
 Flag
Ruslan Emelyanchenko profile image
Ruslan Emelyanchenko profile image
10/10 starsCompleted
  • 2 reviews
  • 2 completed
1 year, 11 months ago
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. Nice course to refresh knowledges that I had from my college classes on SQL.
Was this review helpful? Yes0
 Flag
Andre Campbell profile image
Andre Campbell profile image

Andre Campbell

10/10 starsTaking Now
1 year, 11 months ago
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, so it gets 5 stars.
Was this review helpful? Yes0
 Flag
Yaseen S. profile image
Yaseen S. profile image

Yaseen S.

1/10 starsTaking Now
1 year, 12 months ago
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 I think this course should be replaced by a fun, modern, convincing and easy to understand course I can not believe that a big company like Microsoft is offering this a failure course Courses in the eighties and nineties better than this course Any simple person can offer course and content on Youtube better of this course.
Was this review helpful? Yes0
 Flag
Gregory Taketa profile image
Gregory Taketa profile image

Gregory Taketa

8/10 starsCompleted
2 years ago
Too video intensive for a long period of time (about 6 videos before getting to the labs). -Providing slide downloads could shorten the learning time -Having the labs after each DEMO video instead of at the end of each module could make the course more engaging.
Was this review helpful? Yes0
 Flag
Vu Hua Hoang profile image
Vu Hua Hoang profile image

Vu Hua Hoang

8/10 starsCompleted
2 years ago
A well - oranized content course but it will be better if you have more exercise for the course. Thank you a lot.
Was this review helpful? Yes0
 Flag
Keith Safford profile image
Keith Safford profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
2 years, 2 months ago
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?). I would definitely recommend anyone taking this course with little or no T-SQL knowledge to have any of the books by Itzik Ben-Gan on hand to reinforce the concepts and to have alternative exercises to practice on.
Was this review helpful? Yes1
 Flag
 profile image
 profile image

6/10 starsCompleted
  • 1 review
  • 1 completed
2 years, 1 month ago
This course gives you a solid knowledge of SQL. The course cover a lot about SQL with clearly instruction videos thanks to the great instructors. However, the exercises are not that great in my opinion. Also, I want to see more, smaller exercises to gain practical experience. To conclude, I think this is a decent course to learn SQL.
Was this review helpful? Yes0
 Flag
Joe Schmutzler profile image
Joe Schmutzler profile image

Joe Schmutzler

5/10 starsTaking Now
2 years, 1 month ago
I learned more about actual SQL coding taking the free Codeacademy course. The one advantage of this course is having them walk through the examples and the text explanations that accompany the videos.
Was this review helpful? Yes0
 Flag
William Adomako profile image
William Adomako profile image

William Adomako

8/10 starsCompleted
2 years, 1 month ago
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. My one questions is; where it says "which of these two options completes the querry" do you always have to choose 2 of the multiple options or sometimes only just one will do? I have a feeling at one question only option was correct, but i felt compelled to an additional option. Any comments please ?
Was this review helpful? Yes0
 Flag
chris davies profile image
chris davies profile image

chris davies

5/10 starsTaking Now
2 years, 1 month ago
I'm currently studying the following: Microsoft: DAT201x Querying with Transact-SQ I have now noticed on a number of occasions during the course, that the demo videos are using examples of queries on tables and data that don't don't exist in the adventure works database. I find this very frustrating and is hindering my progress immensely. How am I meant to try out these demo queries, when the data is not available to me?
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsTaking Now
2 years, 2 months ago
I have to say that the beginning part does not require knowledge. However, I found that the courses later are kind of frustrating. It seems that you have to have prior knowledge about SQL to finish the course.
Was this review helpful? Yes0
 Flag
Rajesh Sampathkumar profile image
Rajesh Sampathkumar profile image

Rajesh Sampathkumar

8/10 starsCompleted
2 years, 3 months ago
Good course! Covers all salient aspects of the T-SQL language with good, relevant examples and exercises of a moderate difficulty. 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.
Was this review helpful? Yes0
 Flag
B G profile image
B G profile image

B G

9/10 starsCompleted
2 years, 3 months ago
The course delivered on what it promised, unlike some of these other reviews, I agree no prior SQL experience was needed. I feel some of the programming topics at the end could have been left out to focus on more Selects, Joins, Unions, etc. Or some additional query problems. My success at second/third attempts at questions was due more to memorizing the answer provided after initial trial and error than using my problem solving skills. While I do enjoy the relaxed discussion of the instructors, I think after a year of having made these videos they could polish up some of their 'chats'. At times they sounded a bit amateur.
Was this review helpful? Yes0
 Flag
Muhammad Amil Busthon profile image
Muhammad Amil Busthon profile image

Muhammad Amil Busthon

10/10 starsCompleted
2 years, 3 months ago
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. I think the purpose of course is to give you some idea that the data has relationship - one another and give you hand-on skill for data handling to make a good database schema, so the data can be provided correctly and systematically.
Was this review helpful? Yes0
 Flag
Matt McMichael profile image
Matt McMichael profile image

Matt McMichael

6/10 starsCompleted
2 years, 4 months ago
I also have had no prior experience with SQL, and I barely passed with a 72%. I think my primary complaint is the scoring/grading of this course. There are 11 modules, and each module has exactly 3 questions with 2 attempts each. So, if you miss one question (fail both attempts), you fail that entire module because it requires 70% to pass. The one's where I had to pick two or more out of many were the most typical fails. The final exam is also worth 50% of your grade. 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.
Was this review helpful? Yes1
 Flag
Charles Chowa profile image
Charles Chowa profile image

Charles Chowa

10/10 starsCompleted
2 years, 6 months ago
I came in with T-SQL knowledge from 2007. Not much has changed but there are some parts that are quite challenging and that I still have to work through in practice. 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.
Was this review helpful? Yes0
 Flag
Dean Hu profile image
Dean Hu profile image

Dean Hu

8/10 starsCompleted
2 years, 6 months ago
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. The labs will help you memory the content without overwhelming you with a long list to assignment to finish. To sum up, I like this course, which is a good choice to refresh your skills
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

6/10 starsCompleted
2 years, 7 months ago
It is stated for those with no prior SQL experience, but what I can say is this - if you have no prior SQL experience you will have to do extensive outside work to supplement this material if you plan on either passing the class or having enough skill to do something useful with T-SQL.
Was this review helpful? Yes2
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
2 years, 8 months ago
With no prior knowledge of SQL or any type of data scripting, I barely failed getting a 68% out of the possible 70% to pass. The material given is sufficient enough, but a lot of the mid to later content is harder to understand, especially with the British accents, no offense. It just seems the other co-instructor doesn't really say much or do much to help analyze why we are doing something this way. You're best bet is to grab an outside source book on SQL and use that to guide you through what you're doing. I picked one up for about $20 that has the basic SQL lingo and why you do it this way. Taking it again for the 3rd run to get verified. Oh and for those that are new to SQL do the audited version first before getting the verified that way you know what you're up against. Im out $49 for failing and retaking will cost another $49.
Was this review helpful? Yes2
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
2 years, 8 months ago
MY BACKGROUND: Minor in Computer Engineering 7 years ago and working as a Data Analyst since (Mainly Excel). The only experience with SQL I have is completing sqlzoo.net. MY SUGGESTIONS FOR STUDENTS: Complete the highly interactive, easy-to-use, and addictive sqlzoo.net before coming to this course. It's the best intro to SQL ever. Then come back and take this course since sqlzoo.net covers only about half of this course. PROS: (1) It's a free (or $50) T-SQL course from Microsoft and that's awesome! (2) The course is pretty comprehensive and I learned a lot which the whole point. (3) They walk through how to download Microsoft SQL Server Management Studio and how to connect to Azure.(4) The instructors are from the UK so it's a little more entertaining to listen to them. CONS: The only con is that there are not a lot of practice problems. Only about 5 per module. OTHER: Microsoft PLEASE add a sequel to this SQL course!
Was this review helpful? Yes1
 Flag
Calvin He profile image
Calvin He profile image

Calvin He

9/10 starsCompleted
2 years, 6 months ago
I felt like I learned a lot from this course. I took notes on all of the commands mentioned in the videos as a quick reference, which were helpful when doing the labs, though I did also have to look at the official reference during the more difficult labs. The database used in the lab was big and resembled realistic business data. I took this course at a rate of about one module a day, and finished with a 94%. Prior to this course, I've had a small amount of exposure to SQL, having taken a short introductory course at Codecademy, and having self-learn how to set up MySQL as part of a LAMP stack for hosting a local Apache2 website.
Was this review helpful? Yes0
 Flag
David Marsh profile image
David Marsh profile image

David Marsh

10/10 starsCompleted
2 years, 7 months ago
Great course, I really enjoyed it. It is not an easy course, but I learnt a lot. The instruction is clear and the labs have been beautifully prepared. The discussion area was useful and the instructors replied quickly to any questions that needed their input.
Was this review helpful? Yes0
 Flag
Abdul Salam profile image
Abdul Salam profile image

Abdul Salam

10/10 starsCompleted
2 years, 7 months ago
Pretty good course content, however the presentation and switch between instructors and slide was not perfect. Also, I think the course verified certificate should be free, esp for students taking the Data Science Curriculum. One single certificate fee show cover the individual courses.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
2 years, 7 months ago
I had very little previous experience with SQL: I learned a lot of fundamental concepts from this course. I liked that it's organized around a sample dataset with multiple tables, so that you can practice writing queries (and learn the most-common mistakes) through the labs. I think this course would stand alone very well: no need to take it as part of the data science professional degree necessarily.
Was this review helpful? Yes0
 Flag
Ed X profile image
Ed X profile image

Ed X

2/10 starsTaking Now
2 years, 8 months ago
Not sure why a self-paced course requires me to wait until the 29th August 2016 (almost two weeks) to start it!? Guess I'll need to look elsewhere!
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.