SQL Made Easy for Beginners

Udemy

Gain a practical understanding of the core concepts and methodologies associated with SQL and learn about MySQL and Oracle SQL.

Beginner

Online

₹ 2299

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

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

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

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 (Connecting 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

Popular Courses

Popular Platforms

Popular Searches

SQL Made Easy for Beginners

Beginner

Online

₹ 2299

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

Who it is for

What you will learn

The syllabus

Introduction

Practice different SQL Statements, Clauses, Keywords and Operators

MySQL Built-in Functions

Practicing SQL on MySQL

Set Operators

Sub Queries and Other Advanced Concepts

Integrity Constraints and other advanced concepts

JDBC and ODBC

Client Tools and other topics

Using MySQL In Linux Machine and Putty Software

Oracle SQL

Other Tools for SQL

Interview Questions

Instructors

Articles

Popular Articles

Latest Articles

Similar Courses

Courses of your Interest

More Courses by Udemy

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone