SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.

Created bySagar Uppuluri

Last updated 9/2019

English

What you'll learn

Understand how to the design the database schema.
Learn SQL commands along with key insights about the logic behind the command.
Design queries, apply aggregations and combine information from multiple tables.

Course content

8 sections • 59 lectures • 3h 12m total length

Course Overview1:12
High level introduction about the contents of the course.
MySQL Installation Guide0:02
Step by step Installation guide for MySQL (Windows).
Introduction & Terminology3:08
Explains the key terms like database, schema and key components of DBMS.
Getting started with basic commands5:43
Demonstrates how to get started with MySQL workbench, database creation along with sample table creation, insertion and query.
Script0:38
Quiz

Projecting required columns through Query4:25
Explains how to project the required columns using the query.
Script0:38
Insert data into the table4:55
Explains how to use the insert command to insert data into the table.
Script1:00
Inserting multiple records2:09
Explains how select command could be used in conjunction with insert to insert multiple records at one go.
Script0:55
Quiz
Arranging the data before display2:54
Explains how to use order by with the query.
Script0:47
Filtering Data6:11
Explains the usage of where clause in the query.
Script0:59
Quiz
Updating and Delete6:52
Explains about update and delete command usage.
Script1:10
Quiz

Primary Constraints6:18
Explains unique and not null constraints.
Script0:22
Identity Column4:48
Explains how to set auto increment for an identity column.
Script0:26
Primary Key10:05
Explains what is a key column and primary keys through an example.
Script0:55
Need for splitting data into multiple tables3:07
Explains the need for splitting tables to avoid redundancy, also called as normalization.
Referential Integrity6:05
Explains foreign key constraint and its usage.
Script0:57
Relationship and Cardinality4:23
Explains about designing tables for cardinality
One - to - One
One - to - Many
Many - to - Many
Script1:03
Constraints over multiple columns2:40
Explains how to apply constraints over multiple columns. It distinguishes column constraints and table constraints.
Script0:39
Quiz

Aggregate functions1:44
Explains about aggregate functions.
Script0:51
Grouping and applying aggregate functions2:11
Explains how to use group by clause in query.
Script1:06
Filtering groups2:04
Explains how to filter groups with having clause in the query.
Script0:36
Memorising queries 21:20
Fine tunes query oriented thinking.
Quiz
Joins Introduction5:29
Explains what is join.
Script0:57
Inner and Outer Joins5:17
Explains how to inner and outer joins.
Script1:33
Subqueries4:31
Explains the usage of sub queries.
Script1:19
Correlated Subqueries4:05
Explains about correlated sub queries and comparison between sub query and correlated sub query.
Script0:51
Quiz
Problem Set0:32

ALTER command2:28
Explains how to use Alter command to add, modify and drop a column for an existing table.
Views3:05
Explains the significance of views and teaches how to create view using CREATE VIEW command and query the view.
Index3:31
Explains what is an Index and demonstrates the following,
Index creation
Unique Index
Dropping Index
Transactions4:34
Explains how to begin a transaction and perform commit and rollback operations along with save points concept.
Quiz

Requirements

You need to download and install either MySQL or SQL Server and should have the environment setup in your machine. For general users community editions are available for both the products which are free.

Description

SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant.

This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema.

It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features. Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.

Who this course is for:

If you are a newbie to SQL and looking forward to understand it through step by step approach or you would like to finetune your SQL foundations, this course is apt for you.
It is NOT for you if you are familiar with SQL and looking for advanced topics.

SQL Foundations

What you'll learn

Explore related topics

Course content

Getting Started5 lectures • 11min

Basic DML12 lectures • 33min

Designing the Tables/Relations13 lectures • 42min

Query Design16 lectures • 34min

Example Social App Schema Design7 lectures • 58min

Other essential topics4 lectures • 14min

Source1 lecture • 1min

What's next?1 lecture • 1min

Requirements

Description

Who this course is for: