SQL Roadmap For Data Science

If you are looking for an end to end roadmap of SQL for Data Science then this blog is for you.

This blog consist of the resources to learn SQL, reading material, practice sites, SQL projects, code challenges , interview preparation resources , cheat sheets. Are you excited then let’s get started.

SQL( Structured Query Language) is the standard language for relational databases. It is a domain specific language which focus on what you want without saying how to do it. It helps to communicate with the database. To communicate with the database we utilize SQL queries to access a collection of records that are stored in our database tables.

SQL topics to focus on are listed below:

• Basics of relational databases, schemas, tables, different database types, SQL data types.
• SQL commands: DDL(Create, Alter, Drop, Truncate), DML(Insert, Update, Delete), DCL(Grant, revoke), TCL( Commit, Rollback, SavePoint), DQL(Select).
• Basic Queries: Select, Limit, Where, Operators, Distinct, Aliasing, Comments, Aggregate functions (Avg, Count, Count(Distinct), Sum, Min, Max), Group by, Having, Order by, Joins (Left, Right Full Outer join, Self join, Cross join, Natural join), Union, Union All.
• Functions: String functions (concat, ucase, lcase, trim, ltrim, rtrim, reverse, replace, substr, instr, length), Date functions(curdate, curtime, date_add,date_sub, datediff, day, week, quarter, month, year), Numeric functions(sqrt, exp, greatest, least, round, power, mod, ceil, floor, abs), Advanced functions(case, cast, coalesce, if, ifnull, isnull)
• Advanced Queries: Advanced filtering( Like, wildcard operators, between, IN), cte ,views, temporary tables, window functions( over and partition by, row_number(), rank(), dense_rank(), lead(), lag()), subqueries, stored procedures and functions.

Resources to learn SQL:

freeCodeCamp: https://www.youtube.com/watch?v=HXV3zeQKqGY

Full Course: https://www.youtube.com/watch?v=en6YPAgc6WM&t=270s

Edurekha: https://www.youtube.com/watch?v=BPHAr4QGGVE

Krish Naik: https://www.youtube.com/playlist?list=PLZoTAELRMXVNMRWlVf0bDDSxNEn38u9Cl

Simplilearn: https://www.youtube.com/watch?v=AA7i2GcTGwU&t=5s

Socratica: https://www.youtube.com/playlist?list=PLi01XoE8jYojRqM4qGBF1U90Ee1Ecb5tt

Programming with Mosh: https://www.youtube.com/watch?v=7S_tz1z_5bA

SQL course on Kaggle: https://www.kaggle.com/learn

Reading material:

W3schools:

· https://www.w3schools.com/sql/

· https://www.w3schools.com/mysql/default.asp

Javatpoint:

· https://www.javatpoint.com/dbms-tutorial

· https://www.javatpoint.com/mysql-tutorial

SQL Quick Guide: https://www.kdnuggets.com/2019/10/last-sql-guide-data-analysis-ever-need.html

Functions: https://indieseducation.com/what-are-the-functions-in-mysql-some-built-in-functions/

Practice Resources:

Hackerrank: https://www.hackerrank.com/domains/sql

Leetcode: https://leetcode.com/problemset/database/

DataLemur: https://datalemur.com/

SQLZoo: https://sqlzoo.net/wiki/SELECT_basics

SQL Practice: https://www.sql-practice.com/

Teachbeamers: https://www.techbeamers.com/sql-query-questions-answers-for-practice/

W3resource: https://www.w3resource.com/sql-exercises/movie-database-exercise/basic-exercises-on-movie-database.php

GeeksforGeeks: https://www.youtube.com/playlist?list=PLqM7alHXFySGweLxxAdBDK1CcDEgF-Kwx

SQL Projects & Challenges:

Alex the Analyst: There are 2 guided projects they are SQL data exploration and data cleaning in SQL.
https://www.youtube.com/watch?v=qfyynHBFOsM&feature=youtu.be
https://www.youtube.com/watch?v=8rO7ztF4NtU&feature=youtu.be

Adam Finer: This project helps you from creating a SQL database, to querying and exploring the data, to visualize the data.

https://www.youtube.com/watch?v=0rB_memC-dA

PayPal / Braintree Take-Home Project: SQL interview challenge to test your skills! https://github.com/AlexanderConnelly/BrainTree_SQL_Coding_Challenge_Data_Analyst

Data with Danny’s 8-Week SQL Challenge: There are case-studies to solve. https://8weeksqlchallenge.com/case-study-1/

Interview Preparation resources:

techTFQ: https://techtfq.com/blog/top-20-sql-interview-questions

GreatLearning: https://www.mygreatlearning.com/blog/sql-interview-questions/

Edurekha: https://www.edureka.co/blog/interview-questions/sql-interview-questions

Intellipaat: https://intellipaat.com/blog/interview-question/sql-interview-questions/

Coding Glitz: https://www.youtube.com/playlist?list=PLKVxK2jv1oA_t7KqNfdUgNC9x54vymFbb

Cheat Sheets:

If you want cheat sheets for SQL then do checkout my blog Cheat sheets for Data Analyst there I have included all the materials for SQL too.

Cheat Sheets for Data Analyst: https://harshakumavat.medium.com/cheat-sheets-for-data-analyst-4645af153d0b

Connect with me on LinkedIn if you have any questions. I’m delighted to assist!!! LinkedIn: www.linkedin.com/in/harshakumavat2000

Please leave a comment and a clap to show your support for my blog. Follow me for more blogs like this.