SQL Training : The Easiest Way to Learn SQL
4.3 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,022 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Training : The Easiest Way to Learn SQL to your Wishlist.

Add to Wishlist

SQL Training : The Easiest Way to Learn SQL

Learn SQL by Coding! A Course that You Will Actually Learn SQL Easily with Hundreds of Examples!
4.3 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,022 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $150 Discount: 93% off
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 4 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
What Will I Learn?
  • Write 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 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
View Curriculum
Requirements
  • Using ability an operating system
Description

★★★★★ (High-rated Five-Star Course) ★★★★★

►Course Release Date : (15 November, 2016)

►Course Updates:

  • 21-Nov-2016: COMMIT & ROLLBACK Statements Lecture was 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
71 Lectures
05:27:40
+
Preparation for SQL Development
2 Lectures 25:46

Having The Database with Oracle VirtualBox Lecture:

Download virtual image link (Copy & Paste into your browser):

https://drive.google.com/uc?id=0B7rEng2gKzHUSS1PTng2aXlYOWs&export=download 

----------------------------------------------------------------------------------------------------------------------

Oracle Virtual Box

https://drive.google.com/file/d/0B7rEng2gKzHUU1pSaEU5WWVub3c/view?usp=sharing

Preview 16:29

In this lesson, you are going to learn how to download and install the Oracle database software for running SQL codes.


Lesson Keywords: "sql", "oracle sql", "learn sql", "sql training", "sql course", "oracle database", "installing oracle", "installing and downloading oracle database" , " oracle database download ".

Preview 09:17
+
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 Quter 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
+
Query inside a Query - Subqueries
4 Lectures 26:01

This lecture teaches you what is a subquery in SQL programming language.

Lesson Keywords: " sql ", " oracle sql ", "learn sql ", " sql training ", " sql course ", " oracle database ", " subquery" , " subqueries ", "oracle subqueries ", " what is a subquery ".

What is a subquery?
04:55

This lecture teaches you Single Row Subqueries in SQL programming language.

Lesson Keywords: " sql ", " oracle sql ", "learn sql ", " sql training ", " sql course ", " oracle database ", " subquery" , " subqueries ", "oracle subqueries ", " single row subqueries ".

Single Row Subqueries
07:20

This lecture teaches you Multiple Row Subqueries in SQL programming language.

Lesson Keywords: " sql ", " oracle sql ", "learn sql ", " sql training ", " sql course ", " oracle database ", " subquery" , " subqueries ", "oracle subqueries ", " multiple row subqueries ".

Multiple Row Subqueries
08:28

This lecture teaches you Multiple Column Subqueries in SQL programming language.

Lesson Keywords: " sql ", " oracle sql ", "learn sql ", " sql training ", " sql course ", " oracle database ", " subquery" , " subqueries ", "oracle subqueries ", " multiple column subqueries ".

Multiple Columns Subqueries
05:18
4 More Sections
About the Instructor
Omer Faruk Ince
4.4 Average rating
235 Reviews
5,112 Students
3 Courses
Senior Software Engineer & Trainer

My name is Omer Faruk Ince. I have been working for more than 10 years in Software Projects. Also I have a Masters Degree in computer science with around 15 years of experience in the IT industry.

Also I've worked in many freelance software project in IT industry.

My areas of interests are mainly Database and Web Development and besides of these: 

 Big Data

Cloud Computing

Data Mining

Data Visualisation

 Data Security

Computer Security

Omer Dagasan
4.4 Average rating
739 Reviews
9,188 Students
4 Courses
Oracle Architect & Software Engineer

I have been working for more than 10 years on software development on many programming languages (like JAVA, C#, PHP, etc) and about 10 years on SQL- PL/SQL programming. And software project manager for more than 5 years.. For now, I am working on a database which has more than 15M active user as a project manager, and teaching SQL-PL/SQL courses...