Register on our Website or Android Mobile App and get 500/- in your Wallet.
Sales Closes in
D
H
M
S

WHY THIS COURSE?

-SQL from Basics to the Advanced Level

-Learning SQL on both popular MySQL and Oracle RDBMS Software
Learning SQL on both popular MySQL and Oracle RDBMS Software

DESCRIPTION

This course will teach you how to use the SQL language with MySQL and Oracle, by covering all the topics of SQL from scratch to advanced level in a detailed, step by step, practical, solution oriented and easiest manner.

Check the course contents to see the number of topics I covered int this video course to make you an SQL expert by teaching the SQL from basics and scratch to the advanced level.

COURSE CONTENT

127 Lessons 31:50:21

  Lesson- 1: Course Overview 00:03:17

  Lesson- 2: Database Concepts (Database, DBMS, Data Models, RDBMS and SQL) 00:33:28

  Lesson- 1: How to Practice SQL without installing any Software? 00:11:43

  Lesson- 2: Select Command 00:06:25

  Lesson- 3: distinct keyword 00:06:44

  Lesson- 4: SQL is not case sensitive 00:03:09

  Lesson- 5: Semicolon 00:08:40

  Lesson- 6: Where Clause 00:14:01

  Lesson- 7: Using Relational Operators in Where Clause Condition 00:07:41

  Lesson- 8: Using Logical Operators (AND, OR, NOT) 00:15:11

  Lesson- 9: Between Operator 00:09:28

  Lesson- 10: Order By Clause (ASC, DESC) 00:11:47

  Lesson- 11: Using Between Operator with Text 00:11:26

  Lesson- 12: In Operator 00:07:17

  Lesson- 13: Like Operator and Wildcard Characters 00:19:21

  Lesson- 14: Aliases for Table Column Names (AS Keyword) 00:11:16

  Lesson- 15: Limit Keyword 00:09:19

  Lesson- 16: Breaking the Lengthy SQL Statement into multiple lines 00:05:27

  Lesson- 1: MySQL Built-in Functions 00:10:26

  Lesson- 2: upper() MySQL String Function 00:08:51

  Lesson- 3: lower() MySQL String Function 00:10:26

  Lesson- 4: length() MySQL String Function 00:10:37

  Lesson- 5: instr() MySQL String Function 00:12:04

  Lesson- 6: substr() MySQL String Function 00:14:13

  Lesson- 7: concat() MySQL String Function 00:12:23

  Lesson- 8: trim() MySQL String Function 00:16:42

  Lesson- 9: abs() MySQL Numeric Function 00:10:53

  Lesson- 10: mod() MySQL Numeric Function 00:09:19

  Lesson- 11: greatest() and least() MySQL Numeric Functions 00:05:23

  Lesson- 12: truncate() MySQL Numeric Function 00:08:45

  Lesson- 13: power() and sqrt() MySQL Numeric Functions 00:03:46

  Lesson- 14: current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL 00:11:24

  Lesson- 15: year(),month(),day,monthname(),dayname() MySQL Date Time Functions 00:08:25

  Lesson- 16: avg(), max(), min(), count() and sum() MySQL Aggregate Functions 00:06:38

  Lesson- 17: Arithmetic Operators 00:05:14

  Lesson- 1: Installing MySQL Server and Workbench Client for Practising SQL 00:34:46

  Lesson- 2: Creating, Deleting, viewing and using Databases 00:18:13

  Lesson- 3: Creating,Viewing, Describing and Deleting Tables 00:19:16

  Lesson- 4: Insert Into Statements (For inserting data into Tables) 00:14:15

  Lesson- 5: Data Types 00:35:45

  Lesson- 6: Null Value, Is Null Operator and Is Not Null Operator 00:11:18

  Lesson- 7: Delete Statement (For Deleting the Records from Table) 00:06:58

  Lesson- 8: Update Statement and Set Keyword (For Updating the Table Records) 00:10:52

  Lesson- 9: Rename statement and To Keyword (For Renaming Table Name) 00:03:39

  Lesson- 10: Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords 00:09:57

  Lesson- 11: Set Autocommit 00:11:47

  Lesson- 12: Commit Statement 00:09:09

  Lesson- 13: Rollback Statement 00:08:23

  Lesson- 14: Truncate Statement 00:08:45

  Lesson- 15: Single Line and Multi-Line Comments 00:12:47

  Lesson- 16: Group By Clause 00:10:18

  Lesson- 17: Having Clause 00:12:42

  Lesson- 18: Sequence of using where, group by, having and order by clauses 00:08:29

  Lesson- 1: Set Operators 00:14:15

  Lesson- 2: Union Operator 00:49:28

  Lesson- 3: Union All Operator 00:13:29

  Lesson- 4: Intersect Operator 00:16:19

  Lesson- 5: Minus Operator 00:13:37

  Lesson- 1: Tables and Aliases 00:17:25

  Lesson- 2: Joins (Inner Join, Left Join, Right Join, Full Join and Self Join) 00:47:42

  Lesson- 3: Sub Query (Explaining Single Row Sub Query by solving different SQL problems) 00:18:56

  Lesson- 4: In Operator 00:08:41

  Lesson- 5: Using In Operator with Multi Row Sub Query 00:12:23

  Lesson- 6: Using Any Operator in Multi Row Sub Query 00:13:19

  Lesson- 7: Using All Operator in Multi Row Sub Query 00:06:42

  Lesson- 8: Exists Operator 00:06:52

  Lesson- 9: Using Sub Queries for retrieving the records from multiple tables 00:14:07

  Lesson- 10: Using Multiple Sub Queries in a single SQL statement 00:10:14

  Lesson- 1: Integrity Constraints 00:09:27

  Lesson- 2: Not Null (Integrity Constraint) 00:08:38

  Lesson- 3: Unique (Integrity Constraint) 00:12:44

  Lesson- 4: Primary Key (Integrity Constraint) 00:16:46

  Lesson- 5: Foreign Key (Integrity Constraint) 00:34:50

  Lesson- 6: Check (Integrity Constraint) 00:09:58

  Lesson- 7: Default (Integrity Constraint) 00:10:24

  Lesson- 8: auto_increment 00:12:37

  Lesson- 9: Insert Into 00:16:10

  Lesson- 10: AS Keyword 00:08:14

  Lesson- 11: If Null() function 00:07:41

  Lesson- 12: Case, When,Then and End Keywords 00:22:37

  Lesson- 13: Delimiter 00:07:26

  Lesson- 14: Delimiter usage in Stored Procedures 00:15:08

  Lesson- 15: Views 00:39:47

  Lesson- 16: Indexes 00:30:04

  Lesson- 1: JDBC (Conneting to MySQL Database from Java Programs) 01:02:05

  Lesson- 2: ODBC 00:37:58

  Lesson- 1: MySQL Shell Command Line Tool 00:12:14

  Lesson- 2: MySQL Command Line Client 00:08:13

  Lesson- 3: Using default Windows Command Prompt for connecting to MySQL Server 00:08:22

  Lesson- 4: Types of SQL Statements 00:05:21

  Lesson- 5: Grant and Revoke SQL Statements 00:18:56

  Lesson- 6: Temporary Tables 00:08:17

  Lesson- 7: Show Columns,Show Indexes,Show Privileges and Show Grants Statements 00:11:32

  Lesson- 8: Inserting Null 00:05:05

  Lesson- 9: Using trim() for trimming the corner characters of the specified Table values 00:12:19

  Lesson- 10: Using wild-cards as normal characters 00:08:05

  Lesson- 11: Database Objects 00:08:32

  Lesson- 1: Creating Linux Virtual Machine 00:29:13

  Lesson- 2: Installing MySQL Server in Linux Ubuntu Machine 00:21:42

  Lesson- 3: Using Putty for Connecting to a Remote Machine having MySQL and performing SQL 00:37:42

  Lesson- 1: Oracle Database, SQL Plus, SQL Developer and Executing SQL Queries 00:44:16

  Lesson- 2: Oracle SQL Queries 00:59:33

  Lesson- 3: Oracle SQL Built-in functions 00:48:28

  Lesson- 4: Oracle SQL Queries (Part 2) 00:39:31

  Lesson- 5: Oracle SQL Queries (Part 3) 00:22:09

  Lesson- 6: Oracle SQL Queries (Part 4) 00:37:49

  Lesson- 7: Oracle SQL Queries (Part 5) 01:07:36

  Lesson- 1: DBeaver Universal DB Client Tool 00:16:23

  Lesson- 2: XAMPP for Practicing SQL 00:17:07

  Lesson- 1: Question 1 00:05:55

  Lesson- 2: Question 2 00:04:13

  Lesson- 3: Question 3 00:04:43

  Lesson- 4: Question 4 00:05:08

  Lesson- 5: Question 5 00:04:46

  Lesson- 6: Question 6 00:11:53

  Lesson- 7: Question 7 00:01:12

  Lesson- 8: Question 8 00:01:55

  Lesson- 9: Question 9 00:05:20

  Lesson- 10: Question 10 00:04:49

  Lesson- 11: Question 11 00:18:28

  Lesson- 12: Question 12 00:08:49

  Lesson- 13: Question 13 00:12:18

  Lesson- 14: Question 14 00:13:19

  Lesson- 15: Question 15 00:04:45

  Lesson- 16: Question 16 00:05:17

  Lesson- 17: Question 17 00:08:28

  Lesson- 18: Question 18 00:06:07

SIMILAR COURSES

COURSE FEATURES
  127 Lessons
  Full Lifetime Access
  Access on Mobile
  Access on Web
  Certificate of Completion
M.R.P.: 1280.00
ISC Price: 99.00
You Save: 1181 (92.27% off)
DON'T HAVE TIME?

We can send you everything you need to know about this course through email.

We respect your privacy. your information is safe and will never be shared.