SQL Essentials For Beginners | P Ch Vidya Sagar Uppuluri | Skillshare
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. 

6

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

P Ch Vidya Sagar Uppuluri

Trainer and 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
Report class