SQL for Beginners : The Easiest Way to Learn SQL - Step by Step
4.4 (747 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,038 students enrolled

SQL for Beginners : The Easiest Way to Learn SQL - Step by Step

Learn SQL by Coding! A Course that You Will Actually Learn SQL Easily with Hundreds of Examples!
4.4 (747 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,038 students enrolled
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 8 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Write, Read, Analyze SQL queries easily
  • Creating solutions on any SQL problems
  • Understanding database terminology
  • Download & install the related softwares
  • Get any data from the database
  • Restricting and Filtering the Data
  • Using SQL functions
  • Ordering the results
  • Grouping the data
  • Select from Multiple Tables
  • Use queries inside of queries
  • Combine the results
  • Playing with the Data
  • Create and modify their own tables.
  • Lifetime Author Support
  • Weekly Quizzes / Assessments
Course content
Expand all 91 lectures 07:38:12
+ Database Concepts
9 lectures 46:10
Why Oracle Database?
07:00
Special Gifts for Our Students
00:37
What is a Relational Database?
07:52
Entity Relationship Logic in Databases
03:46

In this lecture, you're going to learn what the pluggable database (multitenant architecture) is in Oracle Database.

What is Pluggable Database?
03:13
The Sample (HR) Schema Used in This Course
07:23
What is SQL?
05:02
+ Preparation for SQL Development
9 lectures 01:26:32
Which Option to Have a Database?
09:18

This lecture shows how to get Oracle database without installing, downloading and much more efforts.

We've prepared a virtual machine that contains a completely running Oracle database in it for you.

So you don't need to install Oracle database at all.

All you have to do is just to install the Oracle Virtual Box image.

Then, you'll get your database easily.

Preview 16:29
Option 1: How to Install VirtualBox on Mac OS X?
01:36

In this lecture, students are going to learn the oracle database 19c installation.

Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".

Preview 18:18

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

Option 2: Unlocking the HR Schema
07:34

This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.

Option 2: Configuring and Using Oracle SQL Developer
22:14
Option 3: Using Oracle Live SQL
07:40
Option 3: About Oracle Live SQL Restrictions
00:20
+ Entering the Database!
9 lectures 32:25

You will learn the sql statements in basic way.. 

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database", "sql statements", "basic sql statements".

Basic SQL Statements
02:04

You will find some tips for SQL Coding! 

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database", "sql coding", "coding tips", "sql coding tips".

 


SQL Coding Tips!
03:10

Tables are the main elements of SQL programming. So you will find the description of these tables.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database", "oracle tables", "describing tables".


Let's describe the tables!
01:18

You will find how to SELECT data with using SQL.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","select statement".


How to Get Data? (Select Statement)
05:31

How to rename the columns in SQL Select statements


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","aliasing the columns".


Aliasing The Columns
04:40

Using SQL select statements for retrieving the values for one time.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","distinct", "distinct operator".


Getting Different Rows - DISTINCT Operator!
04:40

Using SQL concatenation operators to unite more than one rows.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","concatenation".


Concatenating The Returning Rows
03:42

Learn arithmetic operations in SQL programming..


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","arithmetic functions".


Arithmetic Expressions
03:18

In this lesson we're going to learn what is the null values and is it dangerous?


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","null","null values".

What is the NULL Value? Is it dangerous?
04:02
+ Conditional Retrieval
7 lectures 32:15

Restricting the returning rows with using SQL Where clause.



Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","where","where clause".


Getting Data Just We Want - WHERE Clause!
04:13

Learn the comparison opreators in SQL.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","where","comparison operators".


Comparison Operators
03:12

Learn Between and AND operators in SQL where clause.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","between", "between and operators".


Between...AND Operators
02:19

In this lesson we're going to learn what is the IN operator?

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","in","in operator".

IN Operator
04:48

In this lesson we're going to learn what is the LIKE and how it is used?

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","like","get me something like this".

Get Me Something LIKE this
07:29

In this lesson we're going to learn what if we looking for something NULL?

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","null","what if we looking for null values".

What If Looking For Something NULL
03:32

Learn how to use logical operators which are AND operator, OR operator, NOT operator in SQL programming.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database","logical operators","and","or","not","and operator","or operator","not operator".


Preview 06:42
+ Converting Data & Conversion Functions
6 lectures 36:43

SQL pre-defined functions in Oracle.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "functions", "oracle functions".

What is a Function?
02:15

Learn how to convert data.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "converting data", "conversion data".

Why to Convert Data?
04:54

In this lesson, we're going to explain "Conversion Functions".

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "conversion", "conversion functions".

Conversion Functions
02:33

In this lesson, we're going to learn how to convert any data type to a character with TO_CHAR function.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "conversion", "conversion functions", "to_char", "to_char function".

Converting to a Character - TO_CHAR Function
14:25

In this lesson, we're going to learn how to convert data to a date with TO_DATE function.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "conversion", "conversion functions", "to_date", "to_date function".

Converting to a Date - TO_DATE Function
06:50

Handling the NULL values in SQL

NULL Value Conversion - NVL Function
05:46
+ Ordering The Results
2 lectures 11:51

Ordering the returning rows in SQL Select statements..

ORDER BY Clause
06:15

Changing the direction of the returning rows in sql select statement

ASC and DESC Operators
05:36
+ Single Row Functions
6 lectures 34:35

What are the single row functions in SQL

About Single Row Functions
01:46

In this lesson, we're going to learn "Character Functions" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "single row functions", "character functions".

Character Functions
11:25

In this lesson, we're going to learn "Number Functions" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "single row functions", "number functions".


Number Functions
04:52

In this lesson, we're going to learn "Nesting Functions" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "single row functions", "nesting functions".


Nesting Functions
03:38

In this lesson, we're going to learn "Date Functions" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "single row functions", "date functions".


Date Functions
06:57

Learn how to use Oracle's specific Decode function in SQL.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "single row functions", "decode function".



DECODE Function
05:57
+ Grouping the data (Group Functions)
6 lectures 15:04

What are group functions and how to use them in SQL

What are group functions?
01:41

In this lesson, we're going to explain "MAX Function" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "grouping the data", "group functions", "max function".

MAX Function
02:04

In this lesson, we're going to learn "MIN Function" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "grouping the data", "group functions", "min function".

MIN Function
03:23

Getting the number of the returning rows in SQL.

In this lesson, we're going to explain "Count Function" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "grouping the data", "group functions", "count function".

Count() Function
04:17

In this lesson, we're going to explain "AVG Function" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "grouping the data", "group functions", "average function", "avg function".

AVG Function
01:54

In this lesson, we're going to explain "SUM Function" in SQL.

Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training",  "sql course", "oracle database", "grouping the data", "group functions", "sum function".

SUM Function
01:45
+ Grouping the Data
2 lectures 15:10

This lecture teaches you how to group the data and return one value with using more than one data by these groups

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " installing oracle ", " group by "

GROUP BY Clause
12:19

This lecture teaches you how to use HAVING Clause.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " group by " , "having clause".

HAVING Clause
02:51
+ Selecting From Multiple Tables (Joins)
12 lectures 48:28

This lecture teaches you introducing Joins and what does join means in SQL.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , "oracle joins", "what is join?".

What is join?
02:44

This lecture teaches you types of joins in SQL programming language.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , "oracle joins", "types of joins".

Types of Joins!
00:59

This lecture teaches you joining tables with using natural join keyword.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , "joining tables", "natural join".

Let's Join Tables!
06:41

This lecture teaches you joining tables with using USING clause.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins " , " joining tables ", " join with using clause ".

Join With USING Clause
07:10

This lecture teaches you joining tables with using ON keyword.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins " , " joining tables ", " join with on clause ".

Join with ON Clause
03:24

This lecture teaches you joining tables with itself, which is called as self join.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins " , " joining tables ", " self join ".

Join the table with itself!
04:03

This lecture teaches you joining tables with more than two tables

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins " , " joining tables ", " multiple tables ".

Joining Multiple Tables
05:05

This lecture teaches you what are the Outer joins in SQL.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , "oracle joins", "outer joins".

What are the Outer Joins?
06:15

This lecture teaches you what are the left joins in SQL.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , "oracle joins", "left joins", " left outer joins ".

What are the Left Joins? (Left Outer Joins)
03:39

This lecture teaches you what are the right joins in SQL.

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , " oracle joins ", " right joins ", " right outer joins ".

What are the Right Joins? (Right Outer Joins)
03:26

This lecture teaches you what are the full outer joins in SQL.

Lesson Keywords: " sql ", " oracle sql ", "learn sql ", " sql training ", " sql course ", " oracle database ", " joins" , "oracle joins", "full outer joins".

Full Outer Joins
02:24

This lecture teaches you what are the cross joins in SQL programming language (Cartesian Product).

Lesson Keywords: " sql ", " oracle sql ", " learn sql ", " sql training ", " sql course ", " oracle database ", " joins " , " oracle joins ", " cross joins ", " cartesian product ".

Preview 02:38
Requirements
  • Using ability an operating system
Description

★★★★★ (Always Up to Date Course) ★★★★★

►Course Updates:

  • 21-Nov-2017: COMMIT & ROLLBACK Statements Lecture is added!

=============================================================

☛ Now you are looking at a course, that you will really Learn SQL by Coding Easily and Quickly.

☛ This course is not just easily explained, but also explained in detail, and many examples. 

☛ Forget about all the trivial courses, articles, or youtube videos.

☛ You are looking at a course that you will buy to thousands dollars ($$$,$$$) at somewhere else.

☛ I tried to explain the subjects with all the details, and with maximum number of examples.

☛ What is different in this course? "Proffessionality".

If you get this course, please try to write and run all the examples with me.

  • You can ask any questions about this course from discussion board.
  • Your questions will be answered immediately.

=============================================================

Benefits of Taking This SQL Course

Knowing SQL can get you a better job or improve the one you have and it provides to earn you $80k+ in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, that's why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts how to write SQL codes easily and thinking analytically against the problem in your company.

No Risk – Money-Back Guarantee

Finally, there is no risk. You can preview 10% of the course for free. Once you purchase the course, if for some reason you are not happy with the course, Udemy offers a 30-day money back guarantee.

So you have nothing to lose, sign up for this course and learn how to write SQL code easily from scratch to master level!

Who this course is for:
  • University or college students
  • Graduates or workers
  • Intermediates on SQL
  • Software developers (like java/.net/python/...) interacting with the Oracle Database
  • Anyone who wants to learn SQL