Description
In this course, you will learn:-
- You'll learn how to construct basic SQL queries to view data, insert data, update existing data, and delete data in a database in this course.
Syllabus:-
-
Introduction
-
Oracle Express 18c Download and Setup
-
How To Install Oracle On A Mac
-
How to Resolve Oracle Connection Issues
-
SQL Developer Download
-
Create a New User
-
Our Sample Database
-
Setting Up Our Sample Data
-
How to View Data With the SELECT Statement
-
Selecting Individual Columns
-
Filtering Data with WHERE
-
Comparison Operators
-
Filtering on Partial Values with LIKE
-
Filtering on Date Values
-
Using Two Filters
-
More Than Two Filters
-
What is NULL?
-
Getting Unique Records with DISTINCT
-
SELECT Quiz
-
IN and NOT IN
-
BETWEEN and NOT BETWEEN
-
ALL Keyword
-
ANY Keyword
-
Operators Quiz
-
Sorting Results with the ORDER BY Clause
-
Ordering By Multiple Columns
-
Set Operators and UNION
-
UNION ALL Operator
-
INTERSECT Operator
-
MINUS Operator
-
Three or More Sets At Once
-
What are Functions?
-
Counting Data
-
Using COUNT in Other Ways
-
Counting Data Within Groups with GROUP BY
-
GROUP BY with WHERE and ORDER BY
-
GROUP BY with Multiple Columns
-
GROUP BY with HAVING
-
The SUM Function
-
Using the MAX and MIN functions
-
Using the AVG function
-
What are Table Aliases?
-
What Are Column Aliases?
-
What Are Joins?
-
Inner Join
-
Left Outer Join
-
Right Outer Join
-
Full Outer Join
-
Natural Join
-
Cartesian or Cross Join
-
Self Join
-
Joining Many Tables
-
Alternative Join Syntax
-
String Functions
-
Nesting Functions Within Functions
-
Number Functions
-
Date Functions
-
Data Types and Conversion Functions
-
The CASE Statement