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
-
1Download the Course Syllabus
-
2Data and Database Overview
-
3DBMS and SQL Overview
-
4Downloading Oracle Database Express
-
5Installing Oracle Database Express
-
6Downloading Oracle SQL Developer
-
7Installing Oracle SQL Developer
-
8Connecting to Oracle Database using Oracle SQL Developer
-
9View Table Structure and Data Practice
-
10Connecting to Oracle Database using Oracle SQLPlus Practice
Filtering Data
-
11Writing Basic SELECT Statement
-
12Writing Basic SELECT Statement Practice
-
13Arithmetic Operations and Null Values
-
14Arithmetic Operations and Null Values Practice
-
15Using Column Alias
-
16Using Column Alias Practice
-
17Concatenation Operator, Literal Character String and DISTINCT keyword
-
18Describe Command
-
19Concatenation Operator, Literal Character String, Distinct and Describe Practice
-
20All Chapter Practices
Sorting Data
Single Row Functions
-
29Sorting Data
-
30Sorting Data Practice
-
31Chapter 4 Quiz 1
-
32Row Limiting Clause
-
33Row Limiting Clause Practice
-
34Chapter 4 Quiz 2
-
35Substitution Variables
-
36Difference between & and && Practice
-
37Define and Verify Commands
-
38Substitution Variables and Verify Practice
-
39Chapter 4 Quiz 3
-
40All Chapter Practices
Conversion and General Functions
-
41SQL Functions
-
42Character Functions – Case Conversion Functions
-
43Case Conversion Functions Practice
-
44Character Functions – Manipulation Functions
-
45Character Manipulation Functions Practice
-
46Chapter 5 Quiz 1
-
47Numeric Functions
-
48Numeric Functions Practice
-
49Chapter 5 Quiz 2
-
50Date Functions
-
51Date Functions Practice
-
52All Chapter Practices
Group Functions
-
53Data Type Conversion
-
54Conversion Functions – TO_CHARE
-
55TO_CHARE Practice
-
56Conversion Functions - TO_NUMBER and TO_DATE
-
57TO_NUMBER and TO_DATE Practice
-
58Chapter 6 Quiz 1
-
59General Functions - NVL, NVL2, NULLIF and COALESCE
-
60NVL and NVL2 Practice
-
61Chapter 6 Quiz 2
-
62General Functions - CASE and DECODE
-
63CASE and DECODE Practice
-
64All Chapter Practices
Joins
-
65Using Group Functions
-
66Using Group Functions Practice
-
67Distinct and Null Values in Group Functions
-
68Distinct and Null Values in Group Functions Practice
-
69Using the GROUP BY clause
-
70Using Group By Clause Pratice
-
71Chapter 7 Quiz 1
-
72Using the HAVING clause
-
73Using the HAVING Clause Practice
-
74Chapter 7 Quiz 2
-
75All Chapter Practices