Learn SQL Didactic Course in Online with Scratch Examples

About the Course:

 SQL Full Course video will cover all the topics of Structured Query Language (SQL) starting from scratch. This video is great for beginners who want to learn SQL and for professionals who want to brush up their SQL skills


Learn SQL Didactic Course in Online with Scratch Examples



Course Timings:

  • 2:00 What is RDBMS?
  • 2:54 Normalization in DBMS
  • 3:44 Normalization Types in DBMS
  • 10:00 Data Types in SQL

***Database Commands***

  • 17:03 Create Database Objects
  • 25:04 Alter Table Statements
  • 30:47 Drop Table Statements
  • 32:05 Various Constraints
  • 57:54 Creating Views

***Table Commands***

  • 1:02:18 Insert Statements
  • 1:07:47 Insert – As- Select Statement
  • 1:13:58 Update Statements
  • 1:20:05 Delete Statements
  • 1:22:47 Select Statement
  • 1:28:01 Select Statement: Alias
  • 1:31:39 Select Statement: Distinct Values
  • 1:32:49 Sorting
  • 1:36:20 Filtering

***Comparison Operators***

  • 1:45:29 NOT IN
  • 1:45:58 IN
  • 1:48:10 Symbols
  • 1:49:21 Example
  • 1:29:29 LIKE
  • 1:52:37 CASE Expression

***Joins***

  • 1:56:23 Joins
  • 1:57:15 Self-Join
  • 1:58:36 Inner Join
  • 2:14:24 Left outer Join
  • 2:19:46 Right outer Join
  • 2:24:32 Full outer join
  • 2:28:12 Cross Join

***Functions***

  • 2:34:17 SQL Built-in Functions
  • 2:37:20 Conversion Function
  • 2:42:16 Logical Functions
  • 2:48:44 Math Function
  • 2:54:45 Aggregate Functions
  • 3:02:28 String Functions
  • 3:09:00 Date & Time Functions
  • 3:11:55 Custom Functions
  • 3:19:01 Stored Procedure
  • 3:43:44 User Defined Functions
  • 4:02:57 Triggers
Copyrights: Edureka





Post a Comment

Previous Post Next Post