SQL Fundamental

Online | Self-paced | Start Anytime
Fundamental
Fully Ready

About the Course

Unlock the power of data with our SQL Fundamental course, a foundational step in your data science journey. Learn to set up databases, load data, and master SQL’s built-in and analytic functions. This hands-on course covers everything from the basics to advanced topics, with real-world industry examples guiding your learning. By the end, you’ll be confident in querying databases and solving business challenges using SQL.

Curriculum

  • Module 0: Getting Started

    Overview:

    This module provides participants with an overview of SQL and the installation instructions of necessary programs

    Topics to Cover:

    • Introduction to SQL
    • Software Installation
    • Additional Resources

  • Module 1: Fast Track

    Overview:

    This module provides an intensive overview of the usage of SQL. The module will cover everything from basics to advanced functions.

    Topics to Cover:

    • Introduction to SQL
    • Advanced Filtering and Functions
    • Aggregations
    • Join and Union
    • Window Functions

  • Module 2: Introduction to SQL and Databases

    Overview:

    This module covers the basic concepts of SQL and the importance of databases. Get a brief glimpse into the world of analytics with SQL.

    Topics to Cover:

    • What is SQL?
    • Key Operations and Concepts
    • Why use SQL?

  • Module 3: Working with Databases & Tables

    Overview:

    This module focuses on working with the essential elements of SQL, database and tables.

    Topics to Cover:

    • Create and select databases
    • Create tables
    • Load data into table

  • Module 4: Basic Queries

    Overview:

    This module provides insight into syntax and basic queries of SQL.

    Topics to Cover:

    • Extract particular columns from table
    • Filter depending on certain conditions
    • Sort the query results
    • List the unique values from selected columns

  • Module 5: Functions

    Overview:

    This module focuses on the built-in functions of common datatypes

    Topics to Cover:

    • String Functions
    • Datetime Functions

  • Module 6: Aggregations

    Overview:

    This module introduces aggregations to do simple calculation based on common groups.

    Topics to Cover:

    • Common Aggregation Function
    • Using Group By
    • Know the restrictions of aggregation functions

  • Module 7: Case When

    Overview:

    This module teaches the concept of case when, which is the if-else equivalent in SQL.

    Topics to Cover:

    • What is Case When?
    • Syntax of Case When
    • Applications of Case When

  • Module 8: Subquery

    Overview:

    This module introduces the concept of subquery to work on multi-step solutions in SQL.

    Topics to Cover:

    • What is subquery?
    • Two ways to apply subqueries
    • Restrictions of subqueries
    • Accessing more than one table with subqueries

  • Module 9: Joins and Unions

    Overview:

    This module introduces the concept of joins and unions which allows working with multiple tables to solve a single business question.

    Topics to Cover:

    • What are Joins?
    • What are the types of Joins?
    • How to work with multiple tables?
    • What is Union?
    • Restrictions of Union
    • Applications of Joins and Unions

  • Module 10: Window Functions

    Overview:

    This module focuses on working with more advanced analytics in SQL known as the Window Functions.

    Topics to Cover:

    • What are Window Functions?
    • Window Functions vs Group By
    • The common Window Functions
    • Real Case Application of Window Functions

  • Module 11: SQL Review + Other Topics

    Overview:

    This module provides a review of the materials and advanced topics in SQL.

    Topics to Cover:

    • Review of the key concepts in SQL
    • Learn about CRUD operations
    • Examine the impact of Keys

  • Module 12: Marketing Analysis

    Overview:

    This module applies the concepts of SQL in a marketing analysis scenario. Participants will learn how to analyze post campaign data, determine churn rate, and create a simple recommender system.

    Topics to Cover:

    • Utilize campaign data to provide insight
    • Analyzing customer behavior
    • Using collaborative and content filtering to recommend items to users

  • Module 13: Credit Risk Analysis

    Overview:

    This module applies the concepts of SQL in a financial scenario. Participants will use customer information to determine risk of lending.

    Topics to Cover:

    • Analyze customer information in the mindset of a credit lending company
    • Provide insight into the ability to pay back loans
    • Calculate and recommend probability of loan approval

  • Module 14: Mini-Projects

    Overview:

    This module offers participants mini-projects to apply their SQL skills. Participants will work on real-world datasets and write SQL scripts to solve business problems.

    Topics to Cover:

    • Case studies that showcases SQL in various industries
    • Practice SQL skills using dataset that mimics real-life situations

  • Module 15: LeetCode Practices

    Overview:

    This final module gives participants a chance to further hone their SQL skills.

    Topics to Cover:

    • Apply SQL skills in various scenarios
    • Answer possible real-life interview questions

Learning Outcomes

By the end of this course, participants will be able to:

  • Grasp the core principles of relational databases and SQL syntax.
  • Effectively design, create, modify, and manage databases and tables.
  • Perform basic and advanced SQL queries for data retrieval and manipulation.
  • Utilize functions, aggregations, and conditional logic to conduct complex data analyses.
  • Master joins, unions, and subqueries to seamlessly work with multiple datasets.
  • Apply window functions to uncover data trends and patterns.
  • Implement SQL in real-world applications, such as marketing analytics and risk management.

Tools

MySQL Server
Early Access Available!

Get early access to this course at a special rate. Not all content is ready yet, but you can sign up today and unlock new materials as they are released!

SQL Fundamental
$99.00
what you will get
HOW IT WORKS

Upgrade your skills with our short courses

Ranked #1 Data Training Program

4.9/5
4.96/5
4.95/5
4.95/5
student success

What our graduates are saying

OUR ALUMNI ARE WORKING AT
Recommended if you're interested in SQL Fundamental
Learning Track

MLOps Engineer Track

Learning Track

Big Data Engineer Track

Learning Track

Cloud Engineer Track

Learning Track

Large Language Model (LLM) Engineer Track

Short Course

Data Streaming

Short Course

Data Migration

Short Course

Data Lake Architecture

Short Course

AI Autiomation and RPA

Career Track to Advance Your Career

Join our comprehensive career tracks designed to accelerate your professional growth and help you achieve your goals

Unlock Your Potential with Expert Guidance

Our mentorship services provide personalized support and insights from industry experts to help you navigate your career journey with confidence

Empower Your Workforce

Enhance your team’s skills and productivity with our tailored corporate training courses, designed to meet your organization’s unique needs

FAQ

Frequently asked questions about the bootcamp

The course is structured into weekly modules, each containing video lectures, reading materials, assignments, and quizzes. You can complete the modules at your own pace, but we recommend following the weekly schedule to stay on track.

You can get support in multiple ways:

  • TA Support on Slack: Our teaching assistants are available on Slack to answer your questions and provide guidance.
  • Peer Community on Discord: Join our Discord community to discuss course topics, share ideas, and collaborate with fellow students.

TAs are available on Slack from 9 AM to 6 PM (ET) Monday to Friday. Outside these hours, you can still post your questions, and TAs will respond as soon as they are back online.

After enrolling in the course, you will receive an invitation link to join the Discord community. Follow the link to create an account or log in to your existing account.

The Discord community offers peer-to-peer support, where you can discuss course topics, share resources, collaborate on projects, and network with fellow learners

The optional mentoring service includes one-on-one sessions with an experienced mentor who can provide personalized guidance, feedback on your progress, and help you set and achieve your learning goals.

Please talk to our Program Advisors to sign up for Mentorship services for an additional cost

Yes, you will have lifetime access to the course materials, including any updates made to the content in the future.

We accept all major credit cards, PayPal, and bank transfers. You can choose your preferred payment method at checkout

Ready to kick start your career

Contact our advisors now to learn more about our programs and courses. They are here to answer all your questions and help you embark on a successful journey.

Inquire about our programs
Speak to our advisors

"*" indicates required fields

Name*
This field is for validation purposes and should be left unchanged.
View our SQL Fundamental course package
This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.