SQL for Beginners
Learn the fundamentals SQL: how to write SQL code, how to communicate with the database, how import data, and how to access data. You'll gain the skills you need to become a world-class data analyst and take the first step toward a rewarding career.
About the SQL for Beginners Course
SQL for Beginners is THE MOST IMPORTANT course for individuals who want to break into the world of data analytics or want to understand how to write SQL code. Many analysts do not obtain sufficient SQL skills, which causes them to fail the coding part of their interview!
Through our course, you'll learn the fundamentals of SQL code, how to write SQL code, how to use a database, and more. With SQL for Beginners, you'll gain the skills you need to become a world-class data analyst and take the first step toward a rewarding career in this exciting field.
Our on-demand SQL for beginners course is the most comprehensive on the market. Unlike competitors who offer a bunch of slides, our course provides live-coding examples and homework questions to ensure that you gain a strong understanding of the subject matter. With approximately 50 in-depth lessons, you'll be able to learn at your own pace through self-paced video content.
Skill Level
Beginner
Video Length
5.25 hrs
Pre-requisites
Basic computer skills
Certificate of Completion
SQL for Beginners: Course Content
01. Course Overview
- 1.01: Course Introduction
- 1.02: About Your Instructor
- 1.03: How to Use this Course
02. Course Learning Content
- 2.01: Installing PostgreSQL
- 2.02: Datatypes
- 2.03: Creating Tables
- 2.04: Dropping Tables
- 2.05: Adding Columns to Tables
- 2.06: Dropping Columns from Tables
- 2.07: Altering Column Datatypes
- 2.08: Renaming Column
- 2.09: Inserting Individual Records
- 2.10: Deleting and Updating Records
- 2.11: Adding Unique ID Fields
- 2.12: Working with Multiple Tables
- 2.13: Importing CSV Data
- 2.14: Inner and Left Joins
- 2.15: Right Joins
- 2.16: Full Outer Joins
- 2.17: Why Use Outer Joins
- 2.18: Self Joins
- 2.19: Chaning Output Field Name
- 2.20: Cross Joins
- 2.21: Primary and Foreign Keys
- 2.22: Introduction to Conditional Filters
- 2.23: 'ILike' Condition
- 2.24: 'IN' Statement
- 2.25: 'Distinct' values
- 2.26: 'Upper' and 'Lower' Conversions
- 2.27: Special Column Output Options
- 2.28: Aggregating Data Using 'Having' and 'Group by'
- 2.29: Aggregate Functions 'Min', 'Max', 'Sum', 'Avg'
- 2.30: 'Coalesce' Function
- 2.31: 'Concatenate' Function
- 2.32: Understanding and Handling Null Values
- 2.33: Casting Datatypes
- 2.34: 'Case' Statements
- 2.35: Sub-Queries
- 2.36: 'Union' and 'Union All' Statements
- 2.37: Learning Wrap-up
03. Additional Homework and Practice
- 3.01: Homework Introduction
- 3.02: Creating Table Mocks
- 3.03: Creating and ERD & Importing Data
- 3.04: Inspecting Table Import
- 3.05: Writing SQL - Part 1
- 3.06: Writing SQL - Part 2
- 3.07: Writing SQL - Part 3
- 3.08: Writing SQL - Part 4
- 3.09: Writing SQL - Part 5
- 3.10: Homework Wrap-up
04. Course Wrap-up
- 4.01: Content Wrap-up
- 4.02: Course Wrap-up
"I feel like I found a goldmine!"
"I remember my tutor trying to teach me C++. Nightmare. Brandon explaining SQL. Crystal clear."
Your Instructor:
Brandon Southern
Sr. Leader - Head of Analytics: US Prime & North America Stores Marketing at Amazon
Meet Brandon Southern (Sr. Leader at Amazon). Brandon is an expert data analytics and engineering, with over 20 years of experience in software engineering, quality assurance engineering, software release management, data engineering, and analytics. With more than 12 years of leadership experience across these domains, he has interviewed, hired, coached, and elevated professionals like you!
As a Senior Leader of Business Intelligence at Amazon, he leads business analysts and business intelligence engineers. He has a passion for helping others grow and developing world-class analytics solutions and teams, which led him to create Analytics Mentor. In his courses and coaching sessions, he will teach you how to develop the necessary skills to become one of the best professionals in the field of data and analytics. He will also show you how to incorporate the best practices that he has developed after working across multiple engineering roles. With his coaching, you'll develop your resume, prepare for interviews, negotiate for higher salaries, and grow your career. By the end of it, you'll become a world-class analyst and engineer and learn the best practices and skills that almost no other analytics team (even in the top tech companies) are using today!
Frequently Asked Questions
Who is this course designed for?
This course is designed for anyone that is interested in becoming a data analyst, business analyst, data engineer, data scientist, or even a program manager. It's also a prerequisite for becoming a data scientist or data engineer. It's designed for individuals with little or no knowledge of SQL and databases. Also, if you're a little rusty or don't feel that you received a good foundational understanding, this is a recommended course to ensure that you can effectively understand more advanced concepts.
How long is this course and can I complete it at my own pace
This is a self-paced course so you can start and stop as needed and take the course all at once or in small increments. This course will take 6-30 hrs to complete.
Will I need any prior knowledge or experience in data analytics?
No. Prior knowledge is not required for this course. You should have basic computer skills such as installing software and a basic understanding of a spreadsheet such as Google Sheets or Microsoft Excel.
What kind of support is available to me while taking this course?
You can get support in the Free Discord group.
What certification will I receive upon completion of this course?
You will receive a certificate of completion for the SQL for Beginners course from Analytics Mentor. This is an educational item that you can add to your resume to improve your chances of obtaining a job in the field of analytics.
