SQL Made Easy for Beginners
Created by Arun Motoori, Last Updated 05-Jun-2020, Language:English
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
Preview00:03:17 -
Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
Preview00:33:28
-
-
Practice different SQL Statements, Clauses, Keywords and Operators
16 Lectures 02:38:45-
How to Practice SQL without installing any Software?
Preview00:11:42 -
Select Command
Preview00:06:25 -
distinct keyword
Preview00: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.