Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Learn SQL in 6 days

Learn SQL and handle databases confidently

Created byJohn Anthony

Last updated 4/2023

English

What you'll learn

The primary objective is to make the individual utilizing this tutorial an expert in writing data retrieval statements.

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

8 sections • 56 lectures • 4h 17m total length

Database3:44
This lecture will give a basic understanding of database concepts.
Tables1:15
Tables are taught with a real time example in this lecture
Set of Tables3:20
This lecture talks about how real time data can be split in multiple tables.
Primary and Foreign Key2:10
In relational database world, tables are connected and data is referred by using primary keys and foreign keys. This lecture explains these concepts with examples
Data Types3:11
This lecture talks about the basic data types which are commonly used in real-time databases.
Schema8:01
Defines how data can be represented in database with an example.
Quiz

Database Creation1:35
Database creation is explained in this lecture with examples.
Show Database0:40
This lecture explains the participant on how to find all the databases that exists in the RDMS,
Drop Database1:53
This lecture explains the user on how to delete a database which already exists.
Data Types3:15
This lecture talks about the data types that are commonly used in MySQL.
Create Table4:23
This lectures explains how to create a table.
Describe Table1:35
This lecture explains how to see the structure of a table.
Alter Table2:14
This lecture explains how to modify the table structure and its fields.
Delete Table1:35
This lecture explains how to delete a table which already exists.
Create Foreign Key2:53
This lecture explains how to create a primary key with an example.
Create Primary Key0:53
This lecture explains how to create a foreign key with examples.

Setting up Database and Tables6:30
This lecture explains how to create a database and tables in it with the help of MySQL
Add Data to table10:50
This lecture explains how to insert data into a table.
WHERE Clause1:49
This lecture explains the purpose and how to include WHERE clause in an SQL statement.
WHERE Clause examples1:21
This lecture gives examples of WHERE clause statements to make the user understand how to write conditional statements.
Arithmetic Operators and Expressions2:08
This lecture explains arithmatic operators and expressions using MySQL
Comparison Operators and Simple Condition1:24
This lecture explains the user on how to write simple conditional statements.
Logical Operators and Operator Precedence1:22
This lecture talks about Logical Operators and operator preceidence.
Update Table Data8:17
This lecture explains how to update table data using SQL Statements.
Delete Data from Table4:39
This lecture explains how to delete data from a table.

Simple Select2:41
This lecture explains how to write a simple SQL retrival query.
Change Column Header2:21
This lecture explains how to change the column header in the output created by an SQL statement.
Select Specific Columns1:19
This lecture explains how to retrieve only selected fields from table and display the result using SQL.
Select Distinct Columns3:09
This lecture explains how to select unique rows from the table data.
Sorting the Data3:38
This lecture explains how to sort the output of an SQL query as per the user requirement.
Retrieve Data from Multiple Tables5:06
This lecture explains how to retrieve data from multiple tables as per the user requirement.

String Functions22:54
This lecture explains the application of string functions with the help of MySQL functions.
Mathematical Functions13:02
This lecture explains some of the mathematical functions which are commonly used in writting SQL statements.
Date Functions8:01
This lecture explains some of the commonly used date functions using MySQL Date Functions.
Logical Operators7:09
This lecture explains some commonly used logical operators and how those operators can be used in SQL statements.
NULL Data2:07
NULL is a special data type and it works in a specified manner. The concept of NULL and its usage is explained in this lecture.
GROUP BY clause4:12
This lecture explains how to group the output data retrieved by an SQL query.
GROUP Functions8:48
This lecture explains the functions that are used in SQLs with GROUP BY Cluase.
HAVING clause4:35
Data retreived by GROUP BY Clause can further be filtered using the HAVING Clause. The HAVING clause is explained in this lecture.

Sub-Queries in SELECT11:09
Some times the data retrieved by an SQL statement can be filtered using one more query. Query within a query is a sub-query. The Sub-queries are usually used in WHERE clauses, This lecture aims at explaining the concept of Sub-queries.
Sub-Queries in WHERE10:07
This lecture aims at explaining how to use a sub-queries within WHERE clause.
Sub-Queries in WHERE - ANY Operator4:31
This lecture aims at explaining the usage of ANY operator in Sub-queries.
Sub-Queries in WHERE - ALL Operator4:53
This lecture aims at explaining the usage of ALL operator in Sub-queries.
Sub-Queries using EXISTS Operator4:42
EXISTS is a special operator. This lecture aims at explaining the user on how to use the EXISTS operator in Sub-queries.
Sub-Queries in INSERT1:59
This lecture aims at explaining the user on how to used Sub-queries in INSERT statements.

Exercise 13:45
Display all the Publisher Names from Publisher list.
Exercise 23:59
List all the Customers first name along with their Address
Exercise 33:10
List all the Publisher IDs from the books table
Exercise 43:46
List all the unique Publisher IDs from the books table
Exercise 54:19
List all the state names in the descending order
Exercise 64:45
List all the Customers first name along with their Address sorted by Customer Name
Exercise 74:06
Exercise 87:00
Exercise 99:08
Exercise 105:28
List unique City Names of the Publishers

Requirements

No prior SQL knowledge is required

Description

"Learn SQL in 6 days" Video Course provides a basic understanding of databases, tables, as well as how to manipulate data with functions like add, edit or delete data from tables and databases. Data retrieval concepts, which includes sorting, filtering, multi-table join, sub-queries and using functions in retrieval statements are discussed in detail.

This course covers the following topics:

· Database Basics

· Schema

· Managing Database and Tables

· Populating Data

· Retrieving Data

· Functions

· Creating Sub-totals

· Sub-queries

· Bonus exercises (on Simple Select)

This course requires approximately 4.5 hours to complete. But we would recommend you to split it into 6 days to have a complete understanding of the concepts.

Each section is well structured and is designed in such a way that the concept is explained first, then I have taken example and explained how to write the SQL for the problem statement. This might help you to understand the concepts better. To make it easier for the learner, all the examples are based on the schema explained in the Schema section.

This course is structured in such a way that one can start writing SQL in hours with confidence.

The bonus exercises section is an add-on, where I made some simple and lighter exercises to give some more input on Simple Select statements. The bonus section has around 10 exercises only on simple select statement.

Who this course is for:

"Learn SQL in 6 days" can be used by any and every technology professional as well as individuals pursuing their graduation / post-graduation in the Computer Science or Information Technology sector.

Learn SQL in 6 days

What you'll learn

Explore related topics

Coding Exercises

Course content

DAY 1: Database Basics and Schema6 lectures • 22min

DAY 2 : Managing Database and Tables10 lectures • 21min

DAY 3: Populating Data9 lectures • 38min

DAY 4: Retrieving Data6 lectures • 18min

DAY 5: Functions and Creating Sub-totals8 lectures • 1hr 11min

DAY 6: Sub-Queries6 lectures • 37min

Conclusion1 lecture • 1min

Practice Sessions10 lectures • 49min

Requirements

Description

Who this course is for: