Beginners SQL for Analysts

SQL for Beginners

Interested in learning SQL &becoming an analyst? In this course, you will learn everything from basic database concepts to simple joins. Along the way, you'll practice with real-world examples of when each SQL function would be used.

Buy $40.00 Free Preview

Course curriculum

1. Welcome from SQL Pal!
1. Basic Database Concepts
1. Databases in Excel Terms
1. MySQL Software Overview
2. Downloading MySQL
3. MySQL Workbench Overview
1. Basics of SELECT Statements
  FREE PREVIEW
2. SELECT DISTINCT
  FREE PREVIEW
3. LIMIT Clause
4. Practice Questions
5. Practice Questions - Answers
1. WHERE Clause Introduction
2. >, < Operators
3. Strings in WHERE Clause
4. <> and != Operators
5. Practice Questions
6. Practice Questions - Answers
1. AND Operator
2. OR Operator
3. Using AND and OR Together
4. Using AND and OR Together - BEST PRACTICES
5. Practice Questions
6. Practice Questions - Answers
1. LIKE Operator Explanation
2. Position of % in LIKE Operator
3. Practice Questions
4. Practice Questions - Answers
1. MIN() and MAX() Functions
2. COUNT() Function
3. COUNT() Function Using DISTINCT
4. AVG() Function
5. SUM() Function
6. Practice Questions
7. Practice Questions - Answers
1. GROUP BY Clause
2. GROUP BY Clause - Visual Explanation
3. Practice Questions
4. Practice Questions - Answers
1. HAVING Clause Explanation
2. HAVING Clause - Visual Explantion
3. HAVING Clause & WHERE Clause
4. Practice Questions
5. Practice Questions - Answers
1. ORDER BY Overview
2. Practice Questions
3. Practice Questions - Answers
1. Setting the Stage for Joins
2. Fully Qualifying Tables
3. INNER JOIN
4. LEFT JOIN
5. A note on RIGHT JOINS and FULL OUTER JOINS
6. Practice Questions
7. Practice Questions - Answers
1. Congratulations! You finished Beginners SQL for Analysts!
2. Course Feedback

About this course

$40.00
55 lessons
1.5 hours of video content

Discover your potential, starting today

Enroll today