SQL Tutorial: Learn SQL with MySQL Database - Beginners to Expert

Pradnyankur Nikam, Freelancer PHP & WordPress developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
115 Videos (8h 50m)
    • Course Introduction

      1:13
    • What is SQL

      2:23
    • Who should learn SQL

      2:17
    • Install MySQL on Windows Operating System

      13:31
    • Install MySQL on Mac Operating System

      12:49
    • Install MySQL on Linux Operating System

      6:58
    • Add New Database User and Set Privileges

      10:04
    • MySQL shortcut for Windows users

      6:40
    • What is DBMS and RDBMS

      3:02
    • Database Engine Database Server and Database Software

      2:31
    • What is database How to create database

      5:53
    • What is database table How to create database table

      8:44
    • How to add the data rows to database table

      7:19
    • Understand Keywords Identifiers Constants and Clauses

      2:56
    • Learn about SQL Statements

      1:30
    • Data Definition Language and Data Manipulation Language

      2:34
    • Create example databases tables and data rows

      10:50
    • Learn about SQL SELECT Clause

      5:33
    • SQL SELECT DISTINCT Statement

      5:16
    • Learn about SQL FROM Clause

      3:10
    • Learn about SQL WHERE Clause

      4:56
    • SQL True Condition

      4:18
    • SQL False Condition

      4:42
    • SQL AND Operator

      5:59
    • SQL OR Operator

      6:58
    • SQL IN Operator

      5:09
    • SQL EXISTS Condition

      7:49
    • SQL NOT IN or NOT EXISTS Conditions

      4:48
    • SQL Comparison Operators

      4:17
    • SQL LIKE Operator

      5:40
    • SQL BETWEEN Operator

      4:35
    • SQL Numeric Operators

      4:14
    • SQL Concatenation Operator

      2:22
    • SQL Temporal Operator

      1:59
    • Learn about SQL GROUP BY Clause

      7:34
    • Learn about SQL HAVING Clause

      5:45
    • Learn about SQL ORDER BY Clause

      4:53
    • SQL LIMIT or TOP Clause

      2:55
    • SQL Wildcards

      4:56
    • SQL Aliases

      6:05
    • SQL Dates

      4:07
    • Add the data rows in a table using INSERT INTO Statement

      6:04
    • SQL INSERT INTO SELECT Statement

      6:10
    • Update data rows using UPDATE Statement

      7:10
    • Delete data rows using DELETE Statement

      3:38
    • What is SQL Injection and How to secure a database

      5:49
    • What are JOINS in SQL Types of SQL JOINS

      5:01
    • Learn about INNER JOIN in SQL

      10:32
    • Learn about LEFT OUTER JOIN in SQL

      7:31
    • Learn about RIGHT OUTER JOIN in SQL

      7:32
    • Learn about FULL OUTER JOIN in SQL

      3:52
    • Learn about CROSS JOIN in SQL

      4:29
    • SQL UNION Operator

      4:31
    • SQL VIEWS

      8:12
    • Derived Tables or Inline Views

      5:22
    • Functions in SQL and Types of SQL functions

      1:17
    • SQL COUNT Function

      5:44
    • SQL FIRST Function

      2:26
    • SQL LAST Function

      2:47
    • SQL SUM Function

      2:52
    • SQL MIN Function

      3:27
    • SQL MAX Function

      3:14
    • SQL AVG Function

      3:12
    • SQL UCASE Function

      2:27
    • SQL LCASE Function

      2:13
    • SQL MID Function

      2:51
    • SQL LEN Function

      2:25
    • SQL ROUND Function

      3:23
    • SQL FORMAT Function

      2:48
    • SQL SUBSTRING Function

      3:05
    • SQL COALESCE Function

      2:43
    • SQL CHAR LENGTH Function

      2:45
    • SQL CAST Function

      3:41
    • SQL CASE Function

      6:25
    • SQL NULLIF Function

      6:12
    • What is data type in SQL

      2:04
    • Integer Numbers in SQL Exact Values

      3:01
    • Fixed Point Numbers in SQL Exact Values

      3:30
    • Floating Point Numbers in SQL Approximate Values

      3:12
    • CHAR and VARCHAR in SQL String Values

      2:47
    • NCHAR and NVARCHAR in SQL String Values

      1:12
    • CLOB and BLOB in SQL String Values

      0:57
    • DATE TIME and TIMESTAMP in SQL Temporal Values

      1:33
    • Learn how to create and display databases

      4:11
    • Select and use existing database

      2:45
    • Remove or delete database from database management system

      2:57
    • Learn how to create the database table using right method

      3:41
    • Modify or update the database table details

      6:10
    • Remove or delete an existing table

      2:16
    • Understand Constraints in SQL

      1:00
    • NOT NULL Constraint in SQL

      8:05
    • UNIQUE Constraint in SQL

      6:45
    • PRIMARY KEY Constraint in SQL

      3:23
    • FOREIGN KEY Constraint in SQL

      10:32
    • CHECK Constraint in SQL

      0:55
    • DEFAULT Constraint in SQL

      4:19
    • AUTO INCREMENT or SEQUENCE in SQL

      4:03
    • Understand Database Relationship in SQL

      1:43
    • One to One 1 1 Relationship in SQL

      8:45
    • One to Many 1 M Relationship in SQL

      5:27
    • Many to Many M M Relationship in SQL

      7:08
    • What is Database Normalization in SQL

      2:32
    • First Normal Form 1NF in database normalization

      1:14
    • Second Normal Form 2NF in database normalization

      1:30
    • Third Normal Form 3NF in database normalization

      1:19
    • What is SQL Export and Import

      1:17
    • How to Export the database using SQL statement

      8:32
    • How to Import the database using SQL statement

      5:16
    • What is MySQL Workbench

      5:14
    • Create a new user and connect to database using MySQL Workbench

      4:20
    • Create Alter Drop database using MySQL Workbench

      3:38
    • Create Alter Drop table using MySQL Workbench

      7:34
    • Insert Read Update Delete data rows using MySQL Workbench

      4:19
    • Database Export and Import using MySQL Workbench

      8:07
    • SQL Tutorial Thank You

      1:20