Learn SQL : The Best Way to Learn SQL (From IT Experts)
Learn SQL from Scratch! A Comprehensive SQL Course that You Will Learn SQL Easily with Hundreds of Examples!
Created by Omer Faruk Ince • 40,000+ Students Worldwide, Last Updated 19-Nov-2019, Language:English
Description
☛ 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 for thousands of dollars ($$$,$$$) in somewhere else.
☛ I tried to explain the subjects with all the details, and with the maximum number of examples.
☛ What is different in this course? "Professionality".
If you get this course, please try to write and run all the examples with me.
✅ 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-120k 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 of how to write SQL codes easily and thinking analytically against the problem in your company.
✔ So you have nothing to lose, sign up now for this course and learn how to write SQL code easily from scratch to master level!
So what are you waiting for then?
Enroll Now and take the first step into Becoming a Qualified SQL Developer!
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
Requirements
- A Computer Installed with Windows/Linux /OS X
- Using Ability an Operating System
What Will I Get ?
- Write, Read, Analyze SQL queries easily
- Understanding Database Terminology
- Get Any Data from the Database
- Using SQL Functions
- Grouping the Data
- Learn How to use the Subqueries
- Manipulating Data
- Create analytical solutions on any SQL problems
- Restricting and Filtering the Data
- Sorting/Ordering the Results
- Learn How to Join Multiple Tables
- Learn How to Combine the Results using Oracle SET Operators
- Create, Alter, Modify, Drop Your Own Tables
Course Content
-
Course Introduction + Welcome
1 Lectures
00:02:04
-
Course Introduction
Preview00:02:04
-
-
Database Concepts
6 Lectures
00:38:48
-
What is a Database?
00:07:37 -
Why Oracle Database?
00:07:00 -
What is a Relational Database (RDBMS)?
00:08:00 -
Entity Relationship Logic in Databases
00:03:46 -
The Sample Schema Used in This Course
00:07:23 -
What is SQL?
00:05:02
-
-
Preparation for SQL Development
9 Lectures
00:55:17
-
About the Database Installation
00:03:02 -
Which Way to Have a Database?
00:09:18 -
Option 1: Having The Database with the Oracle Virtual Box
00:16:29 -
Option 1: How to Install Virtual Box on Mac OS X
-
Option 2: Downloading and Installing Oracle Database into Your Computer
00:08:58 -
Option 2: How to Unlock the HR Schema?
-
Option 2: Configuring and Using the Oracle SQL Developer
00:09:53 -
Option 3: Using Oracle Live SQL
00:07:37 -
Option 3: About Oracle Live SQL Restrictions
-
-
Entering the Database
9 Lectures
00:32:26
-
Basic SQL Statements
00:02:04 -
SQL Coding Tips
00:03:10 -
Let's Describe The Tables
00:01:18 -
How to Retrieve Data from the Database - (SELECT Statement)
00:05:31 -
Aliasing The Columns
00:04:40 -
Getting Unique/Different Rows - (The DISTINCT Keyword)
00:04:40 -
Concatenating The Returning Rows
00:03:42 -
Arithmetic Expressions
00:03:19 -
What is the NULL Value? Is it Dangerous?
00:04:02
-
-
Conditional Retrieval
7 Lectures
00:32:18
-
Getting Data Just You Want - Using the WHERE Clause
00:04:14 -
Comparison Operators
00:03:13 -
BETWEEN AND Operator
00:02:19 -
IN Operator
00:04:49 -
Get Me Something LIKE this
00:07:29 -
What If Looking For Something NULL?
00:03:32 -
Logical Operators (AND, OR, NOT Operators)
00:06:42
-
-
Converting Data & Conversion Functions
6 Lectures
00:36:46
-
What is a function?
00:02:15 -
Why to Convert Data?
00:04:54 -
Conversion Functions
00:02:34 -
TO_CHAR() Function - Converting To A Character
00:14:26 -
TO_DATE() Function - Converting To A Date
00:06:51 -
NVL() Function - Handling NULL Values
00:05:46
-
-
Ordering the Results
2 Lectures
00:11:52
-
ORDER BY Clause
00:06:16 -
ASC and DESC Operators
00:05:36
-
-
Single-Row Functions
6 Lectures
00:34:35
-
Date Functions
00:06:57 -
Nesting Functions
00:03:38 -
DECODE Function
00:05:57 -
Single-Row Functions
00:01:46 -
Character Functions
00:11:25 -
Number Functions
00:04:52
-
-
Group Functions (Grouping the Data)
6 Lectures
00:15:04
-
What are Group Functions?
00:01:41 -
MAX Function
00:02:04 -
MIN Function
00:03:23 -
COUNT Function
00:04:17 -
AVG Function
00:01:54 -
SUM Function
00:01:45
-
-
Grouping the Data (Grouping Multiple Records)
2 Lectures
00:15:10
-
GROUP BY Clause
00:12:19 -
HAVING Clause
00:02:51
-
-
Joins (Combining Data from Multiple Tables)
12 Lectures
00:48:28
-
What is a Join?
00:02:44 -
Types of Joins
00:00:59 -
Let's Join Tables - Natural Join
00:06:41 -
Join with the USING Clause
00:07:10 -
Join with the ON Clause
00:03:24 -
Join Table With ITSELF - Self Join
00:04:03 -
Joining Multiple Tables
00:05:05 -
What are the OUTER Joins?
00:06:15 -
LEFT OUTER JOINS
00:03:39 -
RIGHT OUTER JOINS
00:03:26 -
FULL OUTER JOINS
00:02:24 -
CROSS Joins (Cartesian Product)
00:02:38
-
-
Query inside a Query (Subqueries)
4 Lectures
00:26:01
-
What is a Subquery?
00:04:55 -
Single Row Subqueries
00:07:20 -
Multiple Row Subqueries
00:08:28 -
Multiple Column Subqueries
00:05:18
-
-
Combining Query Results (Using SET Operators)
4 Lectures
00:12:47
-
What are the SET Operators and Why to Use?
00:03:59 -
UNION and UNION ALL Operators
00:02:54 -
INTERSECTing and EXTRACTing the Queries
00:02:40 -
More In SET Operations
00:03:14
-
-
Manipulating and Playing with the Data (DML - Data Manipulation Language)
4 Lectures
00:22:51
-
Inserting a New Record (INSERT Statement)
00:09:20 -
Updating the Existing Record (UPDATE Statement)
00:05:22 -
Deleting the Existing Record (DELETE Statement)
00:04:36 -
COMMIT and ROLLBACK Statement
00:03:33
-
-
Manipulating Tables (DDL - Data Definition Language)
2 Lectures
00:12:04
-
How to DROP an Existing Table
00:02:25 -
How to Create a Table With Many Ways and Rename it
00:09:39
-
