Skip to content

Resource

SQL Basics and Beyond

Build a robust SQL foundation, from basic querying to advanced data manipulation, with lectures, a practice dataset and a real-world assignment.

Muhammad Usama HameedData SeekhoGitHub repository

SQL is the backbone of data handling in databases, essential for retrieving, manipulating and managing data in any analytics or data science role.

That's why we published SQL Basics and Beyond at Data Seekho: an open repository that takes you from your first query to advanced SQL, at your own pace.

It is designed for:

→ Beginners with no prior database knowledge

→ Intermediate learners who want to solidify their SQL skills

→ Professionals applying SQL in data-centric roles

What's inside ⬇️

1) Session 1 notebook: Basics & Intermediate SQL

2) Session 2 notebook: Advanced SQL

3) A practice dataset with customers, orders, products and sales tables

4) The ShopEase E-Commerce Sales Analysis assignment, to apply everything on a business scenario

Clone the repository, load the dataset into the SQL database of your choice, and work through the sessions in order.

Open the Repository on GitHub

Resources

Similar Resources

Free Insights for Aspiring Data Professionals

Python

Python Beyond Basics

Python lectures, assignments and a final project covering core concepts and real-world applications for beginner and intermediate learners.

Muhammad Usama Hameed

Data SeekhoGitHub repository

Access now
Pandas

Pandas Beyond Basics

A complete guide to data analysis and manipulation with Pandas, from basic operations to more advanced techniques.

Muhammad Usama Hameed

Data SeekhoGitHub repository

Access now
Machine Learning

ML Beyond Basics

Hands-on Machine Learning notebooks that take you from fundamental concepts towards applied, real-world modelling.

Muhammad Usama Hameed

Data SeekhoGitHub repository

Access now