Gain insights into SQL by exploring database creation, data manipulation, and advanced queries. Learn about practical applications and practice for SQL interviews to build confidence and readiness.

sql.tar.gz

The ability to work SQL is becoming an increasingly in-demand skill, both for software developers and people in less technical roles. If you’re interested in learning SQL and have no prior experience with it, then this course will be your light in a dark tunnel.

You’ll start by covering the basics of SQL such as how to create a database, how to insert, query, and update data. You’ll also learn fundamental concepts that developers and data scientists use everyday such as multi-table operations, nested queries, and how to set up views. 

Throughout, you’ll get to execute SQL queries in your browser and see results in real-time - you won’t need to worry about set-up.

At the end of this course, you’ll also get some hands-on practice with common SQL interview questions, so when the time comes, you’ll be ready and confident to answer any question that comes your way. Let’s get started!

An Introductory Guide to SQL

Let's view the cheat sheet of simple to complex tasks and an example for the demonstration.

Introduction

Basic SQL

Joins

Nested Queries

Multi Table Operations

Views

Stored Procedures

Triggers

Miscellaneous

Practice & Prep

Epilogue

Cheat Sheet

Task	Example
What does SQL stand for?	Structured Query Language
Default Port on which MySQL runs?	3306 TCP
Hello World example?	`SELECT "Hello World";`
How to list all databases?	`SHOW DATABASES;`
How to select a database to query against?	`USE DatabaseName`
How to list storage engines?	`SHOW ENGINES;`
How to display the structure of a table?	`DESCRIBE TableName` or `Explain TableName`
How to list all tables in a database?	`SHOW TABLES;`
How to list all views in a database?	`SHOW FULL TABLES IN <SUBSTITUTE_DATABASE_NAME> WHERE TABLE_TYPE LIKE 'VIEW';`
How to display create database statement?	`SHOW CREATE DATABASE DBName;`
How to display create table statement?	`DESCRIBE TableName;` or, `EXPLAIN TableName;`
How to list available character sets?	`SHOW CHARACTER SET;`
How to list available collations?	`SHOW COLLATION;`
How to list variables and their values set for the running MySQL server?	`SHOW VARIABLES;`
How to get rows from a table?	`SELECT * FROM TableName`
How to create a table?	`CREATE TABLE MyTable (id INT, name VARCHAR(30));`
How to create an index on a table?	`CREATE INDEX indexOnId ON MyTable(id);`
How to create a table with a primary key?	`CREATE TABLE MyTable (id INT, name VARCHAR(30), PRIMARY KEY (id));`
How to alter a name of a table?	`ALTER TABLE MyTable RENAME NotMyTable;`
How to inner join two tables?	`SELECT * FROM TableA INNER JOIN TableB ON TableA.id = TableB.id;`
How to left join two tables?	`SELECT * FROM TableA LEFT JOIN TableB ON TableA.id = TableB.id;`
How to right join two tables?	`SELECT * FROM TableA RIGHT JOIN TableB ON TableA.id = TableB.id;`
How to find a full outer join?	`SELECT * FROM TableA LEFT JOIN TableB ON TableA.id = TableB.id UNION ALL SELECT * FROM TableA RIGHT JOIN TableB ON TableA.id = TableB.id WHERE TableA.id IS NULL;`