Welcome to the best online course on SQL.
SQL stands for Structured Query Language.
It is designed for managing data in a relational database management system (RDBMS). SQL is a database language, it is used for database creation, deletion, fetching rows, and modifying rows, etc.
SQL is needed for Data Scientists to get data and to work with that data.
Without databases, data science is meaningless.
A Data Analyst can use SQL to access, read, manipulate and analyze the data stored in a database and generate useful insights to drive an informed decision making process.
This course is best for you to learn SQL.
It covers basic to advanced level SQL concepts.
In this course, you will cover:-
- Learn about creating databases and tables in SQL
- Learn about building basic SQL queries
- Learn about Numerical, string functions in SQL
- Learn about HAVING clause
- Learn about filtering using LIKE operator in SQL
- Learn about different DDL and DML commands
- Learn about the different datatypes in SQL
- Lear about Constraints
- Learn about primary key and foreign key
- Learn about the different Joins in SQL- LEFT, RIGHT, INNER, COMPOUND, MULTIPLE.
- Learn about subqueries in SQL
- Learn connecting Python and MySQL
- Get tips and knowledge that is usually only learned through years of SQL experience.
- And much more…
Not only this, you will get to practice lots and lots of exercises from the world famous coding platform “HackerRank”.
After finishing this course, you will become an expert in SQL.
We are also providing quizzes.
You will also have access to all the resources used in this course.
Instructor Support – Quick Instructor Support for any queries.
Enroll now and make the best use of this course.
Installation and Set up
Introduction to DQL
Introduction to DDL and DML
Joins, Sub Queries, & Set Operations
Accessing Databases using Python
Big Query
Outro Section
-
46What is Big query
-
47How Big query works
-
48Getting started with GCP and Big query
-
49Importing Dataset and Executing your first Big query
-
50Visualizing using Data Studio
-
51BI Engine
-
52SQL exercise on Big query
-
53Quiz on Introduction to Big Query
-
54Quiz Solution
-
55Use of Big query in Data Analysis
-
56Exploring Big query dataset on kaggle kernel
-
57Connecting Big query to Tableau Desktop for Visualizations
-
58Data Analysis project - Part 1 (Introduction and Setting up Problem statement)
-
59Data Analysis project - Part 2 (Exercises and Solutions)
-
60Quiz on Big Query for Data Analysis
-
61Quiz Solution
-
62What is Data warehouse
-
63Properties of modern Data warehouse
-
64Alternatives to Big query
-
65Quiz on Data warehouse
-
66Quiz Solution