SQL (Full Course)
4.0
(3)
40 learners
What you'll learn
This course includes
- 30 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 111 lessons • 30 hours of video
SQL (Full Course)
111 lessons
• 30 hours
SQL (Full Course)
111 lessons
• 30 hours
- SQL - Part 1 - Database Concepts (Database, DBMS, Data Models, RDBMS and SQL) 33:29
- SQL - Part 2 - Practice SQL without installing any Software 11:43
- SQL - Part 3 - Select Command 06:26
- SQL - Part 4 - distinct keyword 06:44
- SQL - Part 5 - SQL is not case sensitive 03:10
- SQL - Part 6 - Semicolon 08:41
- SQL - Part 7 - Where Clause 14:01
- SQL - Part 8 - Using Relational Operators in Where Clause Condition 07:42
- SQL - Part 9 - Using Logical Operators (AND, OR, NOT) 15:11
- SQL - Part 10 - Between Operator 09:28
- SQL - Part 11 - Order By Clause (ASC, DESC) 11:48
- SQL - Part 12 - Using Between Operator with Text 11:26
- SQL - Part 13 - In Operator 07:18
- SQL - Part 14 - Like Operator and Wildcard Characters 19:21
- SQL - Part 15 - Aliases for Table Column Names AS Keyword 11:16
- SQL - Part 16 - Limit Keyword 09:19
- SQL - Part 17 - Breaking the Lengthy SQL Statement into multiple lines 05:27
- SQL - Part 18 - MySQL Built in Functions 10:26
- SQL - Part 19 - upper() MySQL String Function 08:51
- SQL - Part 20 - lower() MySQL String Function 10:27
- SQL - Part 21 - length() MySQL String Function 10:38
- SQL - Part 22 - instr() MySQL String Function 12:04
- SQL - Part 23 - substr() MySQL String Function 14:14
- SQL - Part 24 - concat() MySQL String Function 12:24
- SQL - Part 25 - trim() MySQL String Function 16:43
- SQL - Part 26 - abs() MySQL Numeric Function 10:53
- SQL - Part 27 - mod() MySQL Numeric Function 09:20
- SQL - Part 28 - greatest() and least() MySQL Numeric Functions 05:24
- SQL - Part 29 - truncate() MySQL Numeric Function 08:45
- SQL - Part 30 - power() and sqrt() MySQL Numeric Functions 03:47
- SQL - Part 31 - current_date(), curdate(), current_time(), curtime(), now() & sysdate() 11:25
- SQL - Part 32 - year(),month(),day(),monthname(),dayname() MySQL Date Time Functions 08:25
- SQL - Part 33 - avg(), max(), min(), count() and sum() MySQL Aggregate Functions 06:38
- SQL - Part 34 - Arithmetic Operators 05:15
- SQL for Beginners - Installing MySQL Server and Workbench Client for Practicing SQL (Latest Way) 14:19
- SQL - Part 35 - Installing MySQL Server and Workbench Client for Practising SQL 34:46
- SQL - Part 36 - Creating, Deleting, viewing and using Databases 18:13
- SQL - Part 37 - Creating, Viewing, Describing and Deleting Tables 19:17
- SQL - Part 38 - Insert Into Statements (For inserting data into Tables) 14:15
- SQL - Part 39 - Data Types 35:46
- SQL - Part 40 - Null Value, Is Null Operator and Is Not Null Operator 11:19
- SQL - Part 41 - Delete Statement (For Deleting the Records from Table) 06:59
- SQL - Part 42 - Update Statement and Set Keyword (For Updating the Table Records) 10:52
- SQL - Part 43 - Rename statement and To Keyword (For Renaming Table Name) 03:40
- SQL - Part 44 - Alter Statement, Add, Modify Column, Rename Column, and Drop Column 09:58
- SQL - Part 45 - Set Autocommit 11:47
- SQL - Part 46 - Commit Statement 09:10
- SQL - Part 47 - Rollback Statement 08:23
- SQL - Part 48 - Truncate Statement 08:46
- SQL - Part 49 - Single Line and Multi Line Comments 12:47
- SQL - Part 50 - Group By Clause 10:18
- SQL - Part 51 - Having Clause 12:42
- SQL - Part 52 - Sequence of using where, group by, having and order by clauses 08:29
- SQL - Part 53 - Set Operators 14:15
- SQL - Part 54 - Union Operator 49:28
- SQL - Part 55 - Union All Operator 13:29
- SQL - Part 56 - Intersect Operator 16:19
- SQL - Part 57 - Minus Operator 13:38
- SQL - Part 58 - Tables and Aliases 17:26
- SQL - Part 59 - Joins (Inner Join, Left Join, Right Join, Full Join and Self Join) 47:42
- SQL - Part 60 - Sub Query (Single Row Sub Query explained by solving different problems) 18:57
- SQL - Part 61 - In Operator 08:41
- SQL - Part 62 - Using In Operator with Multi Row Sub Query 12:23
- SQL - Part 63 - Using Any Operator in Multi Row Sub Query 13:19
- SQL - Part 64 - Using All Operator in Multi Row Sub Query 06:43
- SQL - Part 65 - Exists Operator 06:53
- SQL - Part 66 - Using Sub Queries for retrieving the records from multiple tables 14:07
- SQL - Part 67 - Using Multiple Sub Queries in a single SQL statement 10:14
- SQL - Part 68 - Integrity Constraints 09:27
- SQL - Part 69 - Not Null Integrity Constraint 08:38
- SQL - Part 70 - Unique Integrity Constraint 12:45
- SQL - Part 71- Primary Key Integrity Constraint 16:46
- SQL - Part 72 - Foreign Key Integrity Constraint 34:51
- SQL - Part 73 - Check Integrity Constraint 09:58
- SQL - Part 74 - Default Integrity Constraint 10:25
- SQL - Part 75 - auto_increment 12:37
- SQL - Part 76 - Insert Into 16:10
- SQL - Part 77 - AS Keyword 08:15
- SQL - Part 78 - IfNull() function 07:42
- SQL - Part 79 - Case, When, Then and End Keywords 22:38
- SQL - Part 80 - Delimiter 07:27
- SQL - Part 81 - Delimiter usage in Stored Procedures 15:09
- SQL - Part 82 - Views 39:48
- SQL - part 83 - Indexes 30:04
- SQL - Part 84 - JDBC (MySQL Database connection from Java Programs) 01:02:06
- SQL - Part 85 - ODBC (Object Database Connectivity) using SQL ODBC Query Client Tool 37:58
- SQL - Part 86 - MySQL Shell Command Line Tool 12:14
- SQL - Part 87 - MySQL Command Line Client 08:13
- SQL - Part 88 - Using default Windows Command Prompt for connecting to MySQL Server 08:23
- SQL - Part 89 - Types of SQL Statements 05:22
- SQL - Part 90 - Grant and Revoke SQL Statements 18:57
- SQL - Part 91 - Temporary Tables 08:17
- SQL - Part 92 - Show Columns,Show Indexes,Show Privileges and Show Grants Statements 11:32
- SQL - Part 93 - Inserting Null 05:06
- SQL - Part 94 - Using trim() for trimming the corner characters of the Table Values 12:20
- SQL - Part 95 - Using wild cards as normal characters 08:05
- SQL - Part 96 - Database Objects 08:33
- SQL - Part 97 - Creating Linux Virtual Machine 29:14
- SQL - Part 98 - Installing MySQL Server in Linux Ubuntu Machine 21:42
- SQL - Part 99 - Putty for Connecting to a Remote Machine having MySQL Server 37:42
- SQL - Part 100 - Oracle 11g Software, SQL Plus, SQL Developer and Executing SQL Queries 44:17
- SQL - Part 101 - Oracle SQL Queries 59:33
- SQL - Part 102 - Oracle SQL Built in functions 48:28
- SQL - Part 103 - Oracle SQL Queries (Part 2) 39:31
- SQL - Part 104 - Oracle SQL Queries (Part 3) 22:09
- SQL - Part 105 - Oracle SQL Queries (Part 4) 37:49
- SQL - Part 106 - Oracle SQL Queries (Part 5) 01:07:36
- SQL - Part 107 - DBeaver Universal DB Client Tool 16:24
- SQL - Part 108 - XAMPP for Practicing SQL 17:08
- SQL for Beginners - Part 109 - Savepoint 07:26
- SQL for Beginners - Uninstalling MySQL Server completely from Windows Machine 06:08
Take this course with you
Download the app to continue lessons from your phone anytime.
