Path title:

SQL for Beginners (Data Analytics and Data Science)

Created 2 years ago and Updated 2 years ago

Objectives:

This path helps you learn SQL and understand Databases. Don't worry if you are a total beginner as this path covers everything needed for a beginner and learning up to intermediate-level SQL. This path includes exercises, quiz, and interview questions to practice SQL. SQL is one such language in which you learn more by practicing more so don't leave any chance to practice the queries!

15h

11 Steps

for all

Free

4 watching

7 reading

+ 128

		#	Type	Title	Creator	Platform	Duration
		1		What is SQL? [in 4 minutes for beginners]	Danielle Thé	youtube.com	4m
	What you'll learn in this step: Structured Query Language - or SQL, is a language that communicates with databases. Learn what SQL is, and why it is an important language to learn in the era of big data.
		2		How to install MySQL 8.0.30 Server and Workbench latest version on Windows 10	Amit Thinks	youtube.com	7m
	What you'll learn in this step: This videos helps you to download and install MySQL for windows 8 and 10. Highly recommended to practice the SQL scripts alonsige the upcoming tutorials.
		3		Introduction to SQL and Relational Databases	SqlBolt	sqlbolt.com	15m
	What you'll learn in this step: This reading resource is a good recap of Introduction to SQL and Databases. Just read the first page.
		4		SQL Basics for Beginners \| Learn SQL \| SQL Tutorial for Beginners \| Edureka	edureka!	youtube.com	27m
	What you'll learn in this step: This video lecture covers the basic statements in SQL. Highly recommended to pause at whichever part required and practice the scripts in MySQL in this video tutorial.
		5		SQL Tutorial	W3Schools	w3schools.com	3h
	What you'll learn in this step: This reading resource will help you recap all the topics and statements which was introduced in the previous video lecture. Use the mini menu on the left side to navigate through the several SQL topics. You can also use the SQL editor which is present in the bottom of the Menu on the left side.
		6		JOIN TO UNLOCK	********	********	********
	What you'll learn in this step: This reading resource takes you through the DDL (Data Defition Language) statements which helps you create and manage databases.
	7		JOIN TO UNLOCK	********	********	********
What you'll learn in this step: This quiz tests your knowledge on all the SQL statements which you learned in the previous sections. Try to get atleast 23 questions right before you move on further.
	8		JOIN TO UNLOCK	********	********	********
What you'll learn in this step: This free course by Udacity is very comprehensive and covers all the SQL statements and also provides hands on exercises and quiz. Depending on the level of expertise and knowledge you want to gain go through the course. Skip topis which are advanced if you are content with learning the basics.
	9		JOIN TO UNLOCK	********	********	********
What you'll learn in this step: This is a very important Intermediate level topic which is included in this curriculum. Sub-queries are bread and butter of SQL and even if you dont want to learn advanced statements I would suggest you to learn subqueries.
	10		JOIN TO UNLOCK	********	********	********
What you'll learn in this step: Become interview ready by reading the Inerview questions in this resource. These are fundamental questions as well as statements which test your SQL knowledge.
	11		JOIN TO UNLOCK	********	********	********
What you'll learn in this step: Practice Interview level exercises in this resource. The questions are divided into 3 levels based on dificulty. These are FAANG interview questions are great way to put the things you learned into practice. Remember that the you practice and write quesries, the more you become better at SQL. All the Best!

Access to 6 More Steps with free subscription

Curated by:

Sasisekaran B

Data Analytics Consultant

@sasi

Skills:

sql data analytics data science beginners database mysql

Curated from: