Master SQL in 4 weeks
Get started and learn SQL in 4 weeks…
What it all take is dedication and consistency.
SQL is the most important and key skill set for cracking interviews and job profiles like Data Analyst/ Data Engineering/ Data Scientist roles. There is a huge demand of SQL in data world. For learning a new skill set from scratch you always need to define what is your end goal and why you want to learn the technology.
At the end of this blog, you will be able write a query for: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.
What Is SQL
SQL is a standard language for storing, manipulating, and retrieving data in databases.
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
In this Blog we will see that how we can start learning SQL from scratch as a beginner and how we can play with the data in the databases.
Following are the downloadable links for tool to perform SQL queries:
https://www.mysql.com/downloads/
https://www.microsoft.com/en-in/sql-server/sql-server-downloads
https://www.postgresql.org/download/
Following is week wise Path to learn the SQL with resource links.
WEEK 1
Its week 1 always we must start from the basic let’s not rush and try to understand the basic syntax of SQL. If you take more than one week then too it’s alright, we are not in a war!
We will first understand what SQL Statement & TABLE is, and why we use it SQL.
A table is nothing but the combination of rows and columns which we use to store structured data.
We will see what is the Select statement how we can use it in our query.
https://www.w3schools.com/sql/sql_select.asp
https://www.tutorialspoint.com/sql/sql-syntax.htm
https://www.geeksforgeeks.org/sql-create/
WEEK 2
In week 2 we will be focusing more on hands-on practice. And some basic functions to perform crucial data activities.
We will see how to select and print the table values from database. And many more functions.
Select statement, Select Where, ORDER BY, LIMIT, BETWEEN, IN and Like keywords we will focus more here and will make a base for SQL.
These all things are the basics of SQL.
To learn about these you can check following links:
https://www.w3schools.com/sql/sql_where.asp
https://www.guru99.com/where-clause.html
https://www.javatpoint.com/sql-group-by
WEEK 3
In Week 3 we will focus on Joins and discuss further about it.
join is very important in SQL to merge or join the values from 2 or more columns.
for performing the same there are different types of JOINS available. Let’s dig into it…
Following are the type of JOINS:
1. Inner JOIN
2. Left JOIN
3. Right JOIN
4. Full JOIN
5. Self JOIN
Useful Links to Learn JOINS:
https://www.w3schools.com/sql/sql_join.asp
https://www.geeksforgeeks.org/sql-join-set-1-inner-left-right-and-full-joins/
Week 4:
Practice makes man perfect! Only reading these articles may not help you to be pro in SQL.
the only way is to learn from Practice, Practice and Practice…
For doing that one has to install MySQL or any SQL tool and start doing the challenges available.
Check following links for practicing the SQL.
https://www.hackerrank.com/domains/sql
https://leetcode.com/problemset/database/
https://leetcode.com/problemset/database/
Thank you for reading! Happy learning…
