Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
47 Videos (3h 29m)
    • Introduction

      0:59
    • Database

      3:44
    • Data Types

      3:11
    • Set of Tables

      3:20
    • Schema

      8:01
    • Drop Database

      1:53
    • Primary and Foreign Key

      2:10
    • Database Creation

      1:35
    • Create Table

      4:23
    • Create Foreign Key

      2:53
    • Alter Table

      2:14
    • Data Types

      3:15
    • Tables

      1:15
    • Show Database

      0:40
    • Describe Table

      1:34
    • Delete Table

      1:35
    • Create Primary Key

      0:53
    • Add Data to table

      10:50
    • Setting up Database and Tables

      6:30
    • WHERE Clause examples

      1:21
    • WHERE Clause

      1:49
    • Arithmetic Operators and Expressions

      2:08
    • Comparison Operators and Simple Condition

      1:24
    • Delete Table Data

      4:39
    • Update Table Data

      8:17
    • Logical Operators and Operator Precedence

      1:22
    • Simple Select

      2:41
    • Change Column Header

      2:21
    • Select Specific Columns

      1:19
    • Select Distinct Columns

      3:09
    • Sorting the Data

      3:38
    • Retrieve Data from Multiple Tables

      5:06
    • String Functions

      22:54
    • Mathematical Functions

      13:02
    • Date Function

      8:01
    • More Logical Operator

      7:09
    • NULL Data

      2:07
    • GROUP BY clause

      4:11
    • GROUP Functions

      8:47
    • HAVING clause

      4:35
    • Sub-Queries in SELECT

      11:09
    • Sub-Queries in WHERE

      10:06
    • Sub-Queries in WHERE - ANY Operator

      4:31
    • Sub-Queries in WHERE - ALL Operator

      4:53
    • Sub-Queries using EXISTS Operator

      4:42
    • Sub-Queries in INSERT

      1:59
    • Conclusion

      0:37

About This Class

"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

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

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

1 of 2 students recommendSee All

Very well explained with examples in every video.

90

Students

--

Project

John A.

Architect, Analyst and Trainer

John Anthony has a Masters in Computer Application with around 20 years of experience in the industry. The instructor has worked on real time projects in India and USA and has successfully designed, developed projects for clients in India as well as Abroad. Also, he has life-time experience on small, medium as well as large size projects.

As an entrepreneur John Anthony has managed IT businesses for around two decades. During his tenure as an entrepreneur, he has worked with highly qualified finance professionals and made important financial decisions to foster business growth.