SQL

 <<BACK TO VIDEO TUTORS 

01)     Introduction: SQL Why do you need SQL?

02)     Initial SQL commands create database, use show databases, show tables etc.

03)     Keys Primary Key, Candidate Key Alternate Key

04)     Primary Key Foreign Key Primary Key and Foreign Key w.r.t. SQL

05)     Create a Parent Table create the Parent Table

06)     Difference: char and varchar create the Parent Table

07)     Create Child Table create the Child Table on delete cascade

08)     Structure of a table the command "desc" or "describe"

09)     Insert a row into the table rows with and without missing entry

10)     alter table command insert column remove column rename a table

11)     source and select
import database: source select statement keyword distinct with select

12)     condition with select
where clause with select condition based on relational operators

13)     Logical Operators and List

Condition-based on Logical operators( or, and, not) Condition-based on List(in, not in)

14)     Condition based on range and NULL

Condition-based on range between and not between Condition-based on NULL

15)     Condition: Pattern Match

Condition-based on Pattern match ( %, Underscore _ )

16)     delete from, drop table, update

delete from, drop table, update...set

17)     sorting data and condition

order by, where ... order by

18)     SQL functions and nested SQL

functions in SQL Nested SQL statements

19)     grouping data

group by, having

20)     Multiple Tables

data from Multiple tables

21)     Views and Classification of SQL

Views in SQL Classification of SQL Statements DDL and DML

22)     SQL commands classified

SQL commands are classified.

23)     Joins in SQL 

3 types of joins are explained.