SQL Made Easy for Beginners

Step by Step, Easy, In Detailed, Well Organized Videos along with Interview Questions (Includes MySQL and Oracle)

Created by Arun Motoori, Last Updated 05-Jun-2020, Language:English

What Will I Get ?

SQL from Basics to the Advanced Level
Learning SQL on both popular MySQL and Oracle RDBMS Software

Requirements

All the pre-requisites are covered in this course itself. Having some basic computer knowledge will be enough.

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

Introduction

2 Lectures 00:36:45
- Course Overview
  
  Preview
  
  00:03:17
- Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
  
  Preview
  
  00:33:28
Practice different SQL Statements, Clauses, Keywords and Operators

16 Lectures 02:38:45
- How to Practice SQL without installing any Software?
  
  Preview
  
  00:11:42
- Select Command
  
  Preview
  
  00:06:25
- distinct keyword
  
  Preview
  
  00:06:43
- SQL is not case sensitive
  
  00:03:09
- Semicolon
  
  00:08:40
- Where Clause
  
  00:14:00
- Using Relational Operators in Where Clause Condition
  
  00:07:41
- Using Logical Operators (AND, OR, NOT)
  
  00:15:10
- Between Operator
  
  00:09:27
- Order By Clause (ASC, DESC)
  
  00:11:47
- Using Between Operator with Text
  
  00:11:25
- In Operator
  
  00:07:17
- Like Operator and Wildcard Characters
  
  00:19:20
- Aliases for Table Column Names (AS Keyword)
  
  00:11:15
- Limit Keyword
  
  00:09:18
- Breaking the Lengthy SQL Statement into multiple lines
  
  00:05:26
MySQL Built-in Functions

17 Lectures 02:45:22
- MySQL Built-in Functions
  
  00:10:25
- upper() MySQL String Function
  
  00:08:50
- lower() MySQL String Function
  
  00:10:26
- length() MySQL String Function
  
  00:10:37
- instr() MySQL String Function
  
  00:12:03
- substr() MySQL String Function
  
  00:14:13
- concat() MySQL String Function
  
  00:12:23
- trim() MySQL String Function
  
  00:16:42
- abs() MySQL Numeric Function
  
  00:10:52
- mod() MySQL Numeric Function
  
  00:09:19
- greatest() and least() MySQL Numeric Functions
  
  00:05:23
- truncate() MySQL Numeric Function
  
  00:08:44
- power() and sqrt() MySQL Numeric Functions
  
  00:03:46
- current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL
  
  00:11:24
- year(),month(),day,monthname(),dayname() MySQL Date Time Functions
  
  00:08:24
- avg(), max(), min(), count() and sum() MySQL Aggregate Functions
  
  00:06:37
- Arithmetic Operators
  
  00:05:14
Practicing SQL on MySQL

18 Lectures 04:07:11
- Installing MySQL Server and Workbench Client for Practising SQL
  
  00:34:45
- Creating, Deleting, viewing and using Databases
  
  00:18:12
- Creating,Viewing, Describing and Deleting Tables
  
  00:19:16
- Insert Into Statements (For inserting data into Tables)
  
  00:14:15
- Data Types
  
  00:35:45
- Null Value, Is Null Operator and Is Not Null Operator
  
  00:11:18
- Delete Statement (For Deleting the Records from Table)
  
  00:06:58
- Update Statement and Set Keyword (For Updating the Table Records)
  
  00:10:51
- Rename statement and To Keyword (For Renaming Table Name)
  
  00:03:39
- Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords
  
  00:09:57
- Set Autocommit
  
  00:11:46
- Commit Statement
  
  00:09:09
- Rollback Statement
  
  00:08:22
- Truncate Statement
  
  00:08:45
- Single Line and Multi-Line Comments
  
  00:12:46
- Group By Clause
  
  00:10:17
- Having Clause
  
  00:12:42
- Sequence of using where, group by, having and order by clauses
  
  00:08:28
Set Operators

5 Lectures 01:47:05
- Set Operators
  
  00:14:15
- Union Operator
  
  00:49:27
- Union All Operator
  
  00:13:28
- Intersect Operator
  
  00:16:18
- Minus Operator
  
  00:13:37
Sub Queries and Other Advanced Concepts

10 Lectures 02:36:15
- Tables and Aliases
  
  00:17:25
- Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
  
  00:47:41
- Sub Query (Explaining Single Row Sub Query by solving different SQL problems)
  
  00:18:56
- In Operator
  
  00:08:40
- Using In Operator with Multi Row Sub Query
  
  00:12:22
- Using Any Operator in Multi Row Sub Query
  
  00:13:18
- Using All Operator in Multi Row Sub Query
  
  00:06:42
- Exists Operator
  
  00:06:52
- Using Sub Queries for retrieving the records from multiple tables
  
  00:14:06
- Using Multiple Sub Queries in a single SQL statement
  
  00:10:13
Integrity Constraints and other advanced concepts

16 Lectures 04:22:24
- Integrity Constraints
  
  00:09:26
- Not Null (Integrity Constraint)
  
  00:08:37
- Unique (Integrity Constraint)
  
  00:12:44
- Primary Key (Integrity Constraint)
  
  00:16:45
- Foreign Key (Integrity Constraint)
  
  00:34:50
- Check (Integrity Constraint)
  
  00:09:57
- Default (Integrity Constraint)
  
  00:10:24
- auto_increment
  
  00:12:36
- Insert Into
  
  00:16:09
- AS Keyword
  
  00:08:14
- IfNull() function
  
  00:07:41
- Case, When,Then and End Keywords
  
  00:22:37
- Delimiter
  
  00:07:26
- Delimiter usage in Stored Procedures
  
  00:15:08
- Views
  
  00:39:47
- Indexes
  
  00:30:03
JDBC and ODBC

2 Lectures 01:40:02
- JDBC (Conneting to MySQL Database from Java Programs)
  
  01:02:05
- ODBC
  
  00:37:57
Client Tools and other topics

11 Lectures 01:46:51
- MySQL Shell Command Line Tool
  
  00:12:13
- MySQL Command Line Client
  
  00:08:12
- Using default Windows Command Prompt for connecting to MySQL Server
  
  00:08:22
- Types of SQL Statements
  
  00:05:21
- Grant and Revoke SQL Statements
  
  00:18:56
- Temporary Tables
  
  00:08:16
- Show Columns,Show Indexes,Show Privileges and Show Grants Statements
  
  00:11:31
- Inserting Null
  
  00:05:05
- Using trim() for trimming the corner characters of the specified Table values
  
  00:12:19
- Using wild-cards as normal characters
  
  00:08:04
- Database Objects
  
  00:08:32
Using MySQL In Linux Machine and Putty Software

3 Lectures 01:28:35
- Creating Linux Virtual Machine
  
  00:29:13
- Installing MySQL Server in Linux Ubuntu Machine
  
  00:21:41
- Using Putty for Connecting to a Remote Machine having MySQL and performing SQL
  
  00:37:41
Oracle SQL

7 Lectures 05:19:16
- Oracle Database, SQL Plus, SQL Developer and Executing SQL Queries
  
  00:44:16
- Oracle SQL Queries
  
  00:59:32
- Oracle SQL Built-in functions
  
  00:48:27
- Oracle SQL Queries (Part 2)
  
  00:39:30
- Oracle SQL Queries (Part 3)
  
  00:22:08
- Oracle SQL Queries (Part 4)
  
  00:37:48
- Oracle SQL Queries (Part 5)
  
  01:07:35
Other Tools for SQL

2 Lectures 00:33:30
- DBeaver Universal DB Client Tool
  
  00:16:23
- XAMPP for Practicing SQL
  
  00:17:07
Interview Questions

18 Lectures 02:07:17
- Question 1
  
  00:05:55
- Question 2
  
  00:04:12
- Question 3
  
  00:04:42
- Question 4
  
  00:05:08
- Question 5
  
  00:04:45
- Question 6
  
  00:11:52
- Question 7
  
  00:01:12
- Question 8
  
  00:01:55
- Question 9
  
  00:05:19
- Question 10
  
  00:04:49
- Question 11
  
  00:18:28
- Question 12
  
  00:08:49
- Question 13
  
  00:12:17
- Question 14
  
  00:13:18
- Question 15
  
  00:04:45
- Question 16
  
  00:05:17
- Question 17
  
  00:08:27
- Question 18
  
  00:06:07

Arun Motoori

Selenium Expert and Training Specialist having 12 plus QA Experience

I am a software testing professional since 2007 (12 years of experience). I am a Selenium Training Expert since 2013. I love training in an organized, easy, practical and solution oriented manner. Subscribe to my course and feel the difference.