• Post category:StudyBullet-4
  • Reading time:10 mins read


Master SQL queries and Become an In-demand SQL Professional. Also included – Data Analysis of Big Data with BigQuery

What you will learn

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.

Learn about Constraints and how to use in SQL.

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.

Become a Master SQL Developer.

Use SQL to perform data analysis.

Learn Advanced Querying Techniques.

Knowledge of all the essential SQL commands.

Become competent in using sorting and filtering commands in SQL.

Solid understanding of SQL.

Hands on Real-World examples.

Description

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.


Get Instant Notification of New Courses on our Telegram channel.


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.

English
language

Content

SQL Fundamentals

Introduction to SQL
Build your first SQL query
Basic SQL queries Part – 1
Basic SQL queries Part – 2
Brain Buster Exercise
Brain Buster Solution
Quiz on Introduction to SQL
Quiz Solution

Installation and Set up

Installation
Interface walkthrough
Creating Required Databases
Quiz on Installation and set up
Quiz Solution

Introduction to DQL

Type of SQL Commands
The SELECT Command
Numerical Functions
String Functions
Exercises on String Functions
The Having Clause
Filtering using the Like Operator
Quiz on DQL
Quiz Solution

Introduction to DDL and DML

Numerical Datatypes
String Datatypes
Constraints
Quiz on DDL
Quiz Solution
Creating Databases and Tables
Alter, Drop, and Truncate
Insert, Update, and Delete
Quiz on DML
Quiz Solution

Joins, Sub Queries, & Set Operations

Foreign Key
Joins
Left, Right, and Outer Join
Compound Joins, and Multiple Joins
Star Schema
Sub Queries Part 1
Sub Queries Part 2
Quiz on Joins, Sub Queries, & Set Operations
Quiz Solution

Accessing Databases using Python

Connecting MySQL through Python
Loading Tables into a Pandas DataFrame
Quiz on Accessing Databases using Python
Quiz Solution

Big Query

What is Big query
How Big query works
Getting started with GCP and Big query
Importing Dataset and Executing your first Big query
Visualizing using Data Studio
BI Engine
SQL exercise on Big query
Quiz on Introduction to Big Query
Quiz Solution
Use of Big query in Data Analysis
Exploring Big query dataset on kaggle kernel
Connecting Big query to Tableau Desktop for Visualizations
Data Analysis project – Part 1 (Introduction and Setting up Problem statement)
Data Analysis project – Part 2 (Exercises and Solutions)
Quiz on Big Query for Data Analysis
Quiz Solution
What is Data warehouse
Properties of modern Data warehouse
Alternatives to Big query
Quiz on Data warehouse
Quiz Solution

Outro Section

Conclusion
How to Get Your Certificate of Completion

Bonus Section

Bonus Lecture