About This Course
Need additional practice to improve your SQL skills? Our course takes you through 10 SQL queries step by step. This is a basic level tutorial for people who already have a general understanding of how SQL works. It covers 10 different SQL challenges in depth, showing you the thinking that goes into finding the right answers, as well as common mistakes and how to avoid them. There are two parts of this course - the videos, and the actual hands-on practice. You will learn how to use SELECT, FROM, and WHERE clauses to perform queries, how to analyze database schemas to find the right tables and columns for any query, how to use "less than" and "greater than" signs (< and >) to filter their data, how to apply the DISTINCT keyword to eliminate duplicates, how to use the GROUP BY and HAVING statements to filter data by groups. The clear and thorough presentation of information makes this course easy to understand. Check it by yourself now!