The Complete Oracle SQL Bootcamp 2022
Welcome to the Complete Oracle SQL Bootcamp 2022.
If you want to get ready and become a professional Oracle SQL Developer and Prepare for an Oracle SQL Certification Exam 1Z0-071: Oracle Certified Associate (OCA), then this course is the best for you.
Do you want to get a better job?
Are you bored with watching a lot of stuff, but could not learn anything?
Are you looking for a really professional course?
Then this is best Oracle SQL course you are looking for.
You have come to the right place!
If you are new to Oracle SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve you skills, this course explains all the details including all of the subjects.
Get this course, and go get a better job!
In this course, all the subjects are explained in a professional way.
All practices and solutions are in the lessons. you can pause the video and complete the practice before resuming to watch the solution. Make sure you solve the practice on your own before moving on to the solution!
Topics covered in this course:
-
Downloading and installing Oracle database express 18c in details
-
Downloading and installing Oracle SQL Developer
-
Connecting to Oracle Database using SQL Developer and SQLPlus
-
Retrieving data using the select statement
-
Restricting / Filtering Data
-
Sorting Data
-
Using Substitution Variables
-
Using Single-Row Functions to Customize Output
-
Reporting Aggregated Data Using the Group Functions
-
Displaying Data from multiple tables using joins
-
Using Subqueries to Solve Queries Part I
-
Using the Set Operators
-
Manipulating tables using DML Statements ( Insert, Update, Delete )
-
Using Data Definition Language / Creating tables
-
Managing objects with data dictionary views
-
Creating Views in details
-
Creating sequences, synonyms, and indexes
-
Managing Schema Objects
-
Retrieving Data By Using Subqueries Part II
-
Manipulating Data By Using Subqueries
-
Controlling User Access in details
-
Manipulating Data using DML Part II
-
Managing Data in Different Time Zones
Using SELECT Statement to Retrieve Data
-
1
Download the Course Syllabus -
2
Data and Database Overview -
3
DBMS and SQL Overview
-
4
Downloading Oracle Database Express
-
5
Installing Oracle Database Express
-
6
Downloading Oracle SQL Developer
-
7
Installing Oracle SQL Developer
-
8
Connecting to Oracle Database using Oracle SQL Developer
-
9
View Table Structure and Data Practice
-
10
Connecting to Oracle Database using Oracle SQLPlus Practice
Filtering Data
-
11
Writing Basic SELECT Statement
-
12
Writing Basic SELECT Statement Practice
-
13
Arithmetic Operations and Null Values
-
14
Arithmetic Operations and Null Values Practice
-
15
Using Column Alias
-
16
Using Column Alias Practice
-
17
Concatenation Operator, Literal Character String and DISTINCT keyword
-
18
Describe Command
-
19
Concatenation Operator, Literal Character String, Distinct and Describe Practice
-
20
All Chapter Practices
Sorting Data
Single Row Functions
-
29
Sorting Data
-
30
Sorting Data Practice
-
31
Chapter 4 Quiz 1 -
32
Row Limiting Clause
-
33
Row Limiting Clause Practice
-
34
Chapter 4 Quiz 2
-
35
Substitution Variables
-
36
Difference between & and && Practice
-
37
Define and Verify Commands
-
38
Substitution Variables and Verify Practice
-
39
Chapter 4 Quiz 3
-
40
All Chapter Practices
Conversion and General Functions
-
41
SQL Functions
-
42
Character Functions – Case Conversion Functions
-
43
Case Conversion Functions Practice
-
44
Character Functions – Manipulation Functions
-
45
Character Manipulation Functions Practice
-
46
Chapter 5 Quiz 1
-
47
Numeric Functions
-
48
Numeric Functions Practice
-
49
Chapter 5 Quiz 2
-
50
Date Functions
-
51
Date Functions Practice
-
52
All Chapter Practices
Group Functions
-
53
Data Type Conversion
-
54
Conversion Functions – TO_CHARE
-
55
TO_CHARE Practice
-
56
Conversion Functions - TO_NUMBER and TO_DATE
-
57
TO_NUMBER and TO_DATE Practice
-
58
Chapter 6 Quiz 1
-
59
General Functions - NVL, NVL2, NULLIF and COALESCE
-
60
NVL and NVL2 Practice
-
61
Chapter 6 Quiz 2
-
62
General Functions - CASE and DECODE
-
63
CASE and DECODE Practice
-
64
All Chapter Practices
Joins
-
65
Using Group Functions
-
66
Using Group Functions Practice
-
67
Distinct and Null Values in Group Functions
-
68
Distinct and Null Values in Group Functions Practice
-
69
Using the GROUP BY clause
-
70
Using Group By Clause Pratice
-
71
Chapter 7 Quiz 1
-
72
Using the HAVING clause
-
73
Using the HAVING Clause Practice
-
74
Chapter 7 Quiz 2
-
75
All Chapter Practices
