Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
27 Videos (1h 35m)
    • Introduction

      3:08
    • Basics

      5:43
    • Projections (Query)

      4:25
    • Insert Command

      4:55
    • Bulk Insert

      2:09
    • Constraints - Part 1

      5:16
    • Constraints - Part 2 - Foreign Key

      6:05
    • Identity Column

      2:27
    • Cardinality and Establishing Many-to-Many relation between tables

      4:23
    • Composite Constraints

      2:40
    • Key Columns

      3:20
    • Data Filtering

      6:44
    • Ordering Results

      1:50
    • Memorizing Queries - Part 1

      2:06
    • Updating Data

      2:19
    • Delete Data

      1:38
    • Aggregate Functions

      1:44
    • Grouping Data

      2:11
    • Filtering Data Groups

      2:04
    • Memorizing Queries Part 2

      1:20
    • Introduction to Joins

      5:29
    • Inner and Outer Joins

      5:17
    • Sub Queries

      4:31
    • Views

      3:05
    • Indexing Tables

      3:31
    • Transaction Control Commands

      4:34
    • Altering the table definition

      2:28

About This Class

This course is all about creating the tables, applying the constraints and establishing the relationship among the tables, it also covers basics related to keys, indexes, views along with other essential topics. Most critical of the lot includes designing queries for information retrieval and joins. 

You can learn it at your own pace, if you are determined you can complete this in a Day as well.

This course is apt for you if you are an absolute beginner to SQL or you may want to fine tune your SQL foundations. It is structured in a step by step manner which will help you understand even the tough topics through simplified examples. 

--

Students

--

Projects

0

Reviews (0)

P Ch Vidya Sagar Uppuluri

Software Architect

Hello, I'm P Ch Vidya Sagar, Software Architect and a passionate trainer with over 15+ years of experience in training and software development.

See full profile

Technology Web Development MySQL Database DBMS