Sql Made Easy For Beginners

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

What you'll learn

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.

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.

Overview

Section 1: Introduction

Lecture 1 Course Overview

Lecture 2 Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)

Section 2: Practice different SQL Statements, Clauses, Keywords and Operators

Lecture 3 How to Practice SQL without installing any Software?

Lecture 4 Select Command

Lecture 5 distinct keyword

Lecture 6 SQL is not case sensitive

Lecture 7 Semicolon

Lecture 8 Where Clause

Lecture 9 Using Relational Operators in Where Clause Condition

Lecture 10 Using Logical Operators (AND, OR, NOT)

Lecture 11 Between Operator

Lecture 12 Order By Clause (ASC, DESC)

Lecture 13 Using Between Operator with Text

Lecture 14 In Operator

Lecture 15 Like Operator and Wildcard Characters

Lecture 16 Aliases for Table Column Names (AS Keyword)

Lecture 17 Limit Keyword

Lecture 18 Breaking the Lengthy SQL Statement into multiple lines

Section 3: MySQL Built-in Functions

Lecture 19 MySQL Built-in Functions

Lecture 20 upper() MySQL String Function

Lecture 21 lower() MySQL String Function

Lecture 22 length() MySQL String Function

Lecture 23 instr() MySQL String Function

Lecture 24 substr() MySQL String Function

Lecture 25 concat() MySQL String Function

Lecture 26 trim() MySQL String Function

Lecture 27 abs() MySQL Numeric Function

Lecture 28 mod() MySQL Numeric Function

Lecture 29 greatest() and least() MySQL Numeric Functions

Lecture 30 truncate() MySQL Numeric Function

Lecture 31 power() and sqrt() MySQL Numeric Functions

Lecture 32 current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL

Lecture 33 year(),month(),day,monthname(),dayname() MySQL Date Time Functions

Lecture 34 avg(), max(), min(), count() and sum() MySQL Aggregate Functions

Lecture 35 Arithmetic Operators

Section 4: Practicing SQL on MySQL

Lecture 36 Installing MySQL Server and Workbench Client for Practising SQL

Lecture 37 Creating, Deleting, viewing and using Databases

Lecture 38 Creating,Viewing, Describing and Deleting Tables

Lecture 39 Insert Into Statements (For inserting data into Tables)

Lecture 40 Data Types

Lecture 41 Null Value, Is Null Operator and Is Not Null Operator

Lecture 42 Delete Statement (For Deleting the Records from Table)

Lecture 43 Update Statement and Set Keyword (For Updating the Table Records)

Lecture 44 Rename statement and To Keyword (For Renaming Table Name)

Lecture 45 Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords

Lecture 46 Set Autocommit

Lecture 47 Commit Statement

Lecture 48 Rollback Statement

Lecture 49 Truncate Statement

Lecture 50 Single Line and Multi-Line Comments

Lecture 51 Group By Clause

Lecture 52 Having Clause

Lecture 53 Sequence of using where, group by, having and order by clauses

Section 5: Set Operators

Lecture 54 Set Operators

Lecture 55 Union Operator

Lecture 56 Union All Operator

Lecture 57 Intersect Operator

Lecture 58 Minus Operator

Section 6: Sub Queries and Other Advanced Concepts

Lecture 59 Tables and Aliases

Lecture 60 Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)

Lecture 61 Sub Query (Explaining Single Row Sub Query by solving different SQL problems)

Lecture 62 In Operator

Lecture 63 Using In Operator with Multi Row Sub Query

Lecture 64 Using Any Operator in Multi Row Sub Query

Lecture 65 Using All Operator in Multi Row Sub Query

Lecture 66 Exists Operator

Lecture 67 Using Sub Queries for retrieving the records from multiple tables

Lecture 68 Using Multiple Sub Queries in a single SQL statement

Section 7: Integrity Constraints and other advanced concepts

Lecture 69 Integrity Constraints

Lecture 70 Not Null (Integrity Constraint)

Lecture 71 Unique (Integrity Constraint)

Lecture 72 Primary Key (Integrity Constraint)

Lecture 73 Foreign Key (Integrity Constraint)

Lecture 74 Check (Integrity Constraint)

Lecture 75 Default (Integrity Constraint)

Lecture 76 auto_increment

Lecture 77 Insert Into

Lecture 78 AS Keyword

Lecture 79 IfNull() function

Lecture 80 Case, When,Then and End Keywords

Lecture 81 Delimiter

Lecture 82 Delimiter usage in Stored Procedures

Lecture 83 Views

Lecture 84 Indexes

Section 8: JDBC and ODBC

Lecture 85 JDBC (Connecting to MySQL Database from Java Programs)

Lecture 86 ODBC

Section 9: Client Tools and other topics

Lecture 87 MySQL Shell Command Line Tool

Lecture 88 MySQL Command Line Client

Lecture 89 Using default Windows Command Prompt for connecting to MySQL Server

Lecture 90 Types of SQL Statements

Lecture 91 Grant and Revoke SQL Statements

Lecture 92 Temporary Tables

Lecture 93 Show Columns,Show Indexes,Show Privileges and Show Grants Statements

Lecture 94 Inserting Null

Lecture 95 Using trim() for trimming the corner characters of the specified Table values

Lecture 96 Using wild-cards as normal characters

Lecture 97 Database Objects

Section 10: Using MySQL In Linux Machine and Putty Software

Lecture 98 Creating Linux Virtual Machine

Lecture 99 Installing MySQL Server in Linux Ubuntu Machine

Lecture 100 Using Putty for Connecting to a Remote Machine having MySQL and performing SQL

Section 11: Oracle SQL

Lecture 101 Oracle Database, SQL Plus, SQL Developer and Executing SQL Queries

Lecture 102 Oracle SQL Queries

Lecture 103 Oracle SQL Built-in functions

Lecture 104 Oracle SQL Queries (Part 2)

Lecture 105 Oracle SQL Queries (Part 3)

Lecture 106 Oracle SQL Queries (Part 4)

Lecture 107 Oracle SQL Queries (Part 5)

Section 12: Other Tools for SQL

Lecture 108 DBeaver Universal DB Client Tool

Lecture 109 XAMPP for Practicing SQL

Section 13: Interview Questions

Lecture 110 Question 1

Lecture 111 Question 2

Lecture 112 Question 3

Lecture 113 Question 4

Lecture 114 Question 5

Lecture 115 Question 6

Lecture 116 Question 7

Lecture 117 Question 8

Lecture 118 Question 9

Lecture 119 Question 10

Lecture 120 Question 11

Lecture 121 Question 12

Lecture 122 Question 13

Lecture 123 Question 14

Lecture 124 Question 15

Lecture 125 Question 16

Lecture 126 Question 17

Lecture 127 Question 18

Beginners who want to learn SQL from scratch to the advanced level