watching now
3 Students

79 Lessons

Beginner

What You Will Learn?

  • Write, Read, Analyze SQL queries easily
  • Understanding Database Terminology
  • Get Any Data from the Database
  • Learn How to Use SQL functions Confidently
  • Restricting, Filtering, Grouping, Joining the Data

Curriculum

6h 28m
Section 1: Course Introduction
02:04
Section 2: Database Concepts
42:31
Why Oracle Database?
07:00
What is a Table?
03:40
What is a Relational Database?
08:01
Entity Relationship Logic in Databases
03:46
What is SQL?
05:03
The Sample Schema Used in This Course
07:23
Section 3: Preparation for SQL Development
41:13
About the Installation
03:02
Which Way to Have a Database?
09:19
How to Unlock HR Schema in Oracle?
Option 1 : Having The Database with Oracle VirtualBox Software
16:29
How to Install VirtualBox on Mac OSX?
Option 2 : Downloading And Installing Oracle Database
08:58
Section 4: Entering the Database!
32:33
Basic SQL Statements
02:05
SQL Coding Tips
03:11
Let's Describe Tables
01:19
How to Get Data - (SELECT Statement)
05:32
Aliasing The Columns
04:40
Getting Different Rows - DISTINCT Keyword
04:41
Concatenating The Returning Rows
03:43
Arithmetic Expressions
03:20
What is the NULL Value? Is it Dangerous?
04:02
Section 5: Conditional Retrieval
32:21
Getting Data Just We Want - WHERE Clause
04:15
BETWEEN AND Operator
02:20
Comparison Operators
03:13
IN Operator
04:49
Get Me Something LIKE this
07:29
What If Looking For Something NULL
03:33
Logical Operators - AND, OR, NOT Operators
06:42
Section 6: Converting Data & Conversion Functions
36:47
What is a Function?
02:16
Why To Convert Data?
04:54
Conversion Functions
02:34
Converting to a Character - TO_CHAR Function
14:26
Converting to a Date - TO_DATE Function
06:51
NULL Value Conversion - NVL Function
05:46
Section 7: Ordering the Results
11:54
ORDER BY Clause
06:17
ASC and DESC Operators
05:37
Section 8: Single Row Functions
34:38
About Single Row Functions
01:47
Character Functions
11:25
Number Functions
04:53
Nesting Functions
03:38
Date Functions
06:57
DECODE Function
05:58
Section 9: Group Functions
15:07
What are the Group Functions?
01:42
MAX Function
02:04
MIN Function
03:23
Count Function
04:18
AVG Function
01:55
SUM Function
01:45
Section 10: Grouping the Data
15:11
GROUP BY Clause
12:19
HAVING Clause
02:52
Section 11: Selecting From Multiple Tables (Joins)
48:32
What is JOIN?
02:44
Types of Joins
01:00
Let's Join Tables! (Natural Joins)
06:41
Join with USING Clause
07:10
Join with ON Clause
03:25
Join the table with itself! (Self Join)
04:03
Joining Multiple Tables
05:05
What Are Outer Joins?
06:15
What are the left joins? (Left Outer Joins)
03:39
What are the right joins? (Right Outer Joins)
03:27
FULL Outer Joins
02:25
Cross Joins (Cartesian Product)
02:38
Section 12: Subqueries (Query inside a Query)
26:04
What is a subquery?
04:56
Single Row Subqueries
07:20
Multiple Row Subqueries
08:29
Multiple Column Subqueries
05:19
Section 13: SET Operators
12:47
What are SET Operators?
03:59
UNION and UNION ALL Operators
02:54
Intersecting and Extracting the Queries
02:40
More in SET Operations
03:14
Section 14: Manipulating and Playing with the Data (DML Statements)
24:19
What is DML and Why to Use?
01:24
INSERTing New Record!
09:21
Updating the Existing Record
05:23
COMMIT and ROLLBACK Statements
03:34
DELETE Records!
04:37
Section 15: Manipulating Tables - DDL Statements
12:04
How to DROP an Existing Table
02:25
How to Create a Table With Many Ways and Rename it
09:39

Description

Requirements

  • Using ability an operating system

About the Instructor

100% of students rated this instructor as excellent!
Reviews 0
Students 15
Courses 1

I have been working for more than 15+ years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 10+ years on SQL&PL/SQL programming and Oracle Technologies. And also I'm a Software Development Manager for more than "10" years.

For now, I am working on a huge database which has more than 15M (million) active-users as a Project Manager, and teaching SQL&PL/SQL and many programming language courses like C, Java, Python, PHP, etc.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo