SQL Made Easy for Beginners

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

4.50 (35 reviews)

Udemy

platform

English

language

Other

What you will learn

SQL from Basics to the Advanced Level

Learning SQL on both popular MySQL and Oracle RDBMS Software

Why take this course?

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.

Content

Introduction

Course Overview

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

Practice different SQL Statements, Clauses, Keywords and Operators

How to Practice SQL without installing any Software?

Select Command

distinct keyword

SQL is not case sensitive

Semicolon

Where Clause

Using Relational Operators in Where Clause Condition

Using Logical Operators (AND, OR, NOT)

Between Operator

Order By Clause (ASC, DESC)

Using Between Operator with Text

In Operator

Like Operator and Wildcard Characters

Aliases for Table Column Names (AS Keyword)

Limit Keyword

Breaking the Lengthy SQL Statement into multiple lines

MySQL Built-in Functions

upper() MySQL String Function

lower() MySQL String Function

length() MySQL String Function

instr() MySQL String Function

substr() MySQL String Function

concat() MySQL String Function

trim() MySQL String Function

abs() MySQL Numeric Function

mod() MySQL Numeric Function

greatest() and least() MySQL Numeric Functions

truncate() MySQL Numeric Function

power() and sqrt() MySQL Numeric Functions

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

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

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

Arithmetic Operators

Practicing SQL on MySQL

Installing MySQL Server and Workbench Client for Practising SQL

Creating, Deleting, viewing and using Databases

Creating,Viewing, Describing and Deleting Tables

Insert Into Statements (For inserting data into Tables)

Data Types

Null Value, Is Null Operator and Is Not Null Operator

Delete Statement (For Deleting the Records from Table)

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

Rename statement and To Keyword (For Renaming Table Name)

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

Set Autocommit

Commit Statement

Rollback Statement

Truncate Statement

Single Line and Multi-Line Comments

Group By Clause

Having Clause

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

Set Operators

Union Operator

Union All Operator

Intersect Operator

Minus Operator

Sub Queries and Other Advanced Concepts

Tables and Aliases

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

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

In Operator

Using In Operator with Multi Row Sub Query

Using Any Operator in Multi Row Sub Query

Using All Operator in Multi Row Sub Query

Exists Operator

Using Sub Queries for retrieving the records from multiple tables

Using Multiple Sub Queries in a single SQL statement

Integrity Constraints and other advanced concepts

Integrity Constraints

Not Null (Integrity Constraint)

Unique (Integrity Constraint)

Primary Key (Integrity Constraint)

Foreign Key (Integrity Constraint)

Check (Integrity Constraint)

Default (Integrity Constraint)

auto_increment

Insert Into

AS Keyword

IfNull() function

Case, When,Then and End Keywords

Delimiter

Delimiter usage in Stored Procedures

Views

Indexes

JDBC and ODBC

JDBC (Conneting to MySQL Database from Java Programs)

ODBC

Client Tools and other topics

MySQL Shell Command Line Tool

MySQL Command Line Client

Using default Windows Command Prompt for connecting to MySQL Server

Types of SQL Statements

Grant and Revoke SQL Statements

Temporary Tables

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

Inserting Null

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

Using wild-cards as normal characters

Database Objects

Using MySQL In Linux Machine and Putty Software

Creating Linux Virtual Machine

Installing MySQL Server in Linux Ubuntu Machine

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

Oracle SQL

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

Oracle SQL Queries

Oracle SQL Built-in functions

Oracle SQL Queries (Part 2)

Oracle SQL Queries (Part 3)

Oracle SQL Queries (Part 4)

Oracle SQL Queries (Part 5)

Other Tools for SQL

DBeaver Universal DB Client Tool

XAMPP for Practicing SQL

Interview Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Screenshots

SQL Made Easy for Beginners - Screenshot_01

SQL Made Easy for Beginners - Screenshot_02

SQL Made Easy for Beginners - Screenshot_03

SQL Made Easy for Beginners - Screenshot_04

Charts

Price

Rating

Enrollment distribution

SQL Made Easy for Beginners - Distribution chart