Share Description
In this course, you will 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:-
- 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
