Learn SQL in 6 days

Learn SQL and handle databases confidently

“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.

What you’ll learn

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

Course Content

  • DAY 1: Database Basics and Schema –> 6 lectures • 22min.
  • DAY 2 : Managing Database and Tables –> 10 lectures • 21min.
  • DAY 3: Populating Data –> 9 lectures • 38min.
  • DAY 4: Retrieving Data –> 6 lectures • 18min.
  • DAY 5: Functions and Creating Sub-totals –> 8 lectures • 1hr 11min.
  • DAY 6: Sub-Queries –> 6 lectures • 37min.
  • Conclusion –> 1 lecture • 1min.
  • Bonus Exercises –> 10 lectures • 49min.

Learn SQL in 6 days

Requirements

  • No prior SQL knowledge is required.

“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.

Get Tutorial