Share Description
In this course, you will learn :
- SQL queries for Oracle databases
- Data from a database can be created, read, updated, and deleted.
- TOAD can be used to connect to Oracle databases.
- SQL queries can be run in TOAD Editor.
- SQL is used to extract data from multiple tables.
Syllabus :
1. Introduction and Lab Setup
- Basic database concepts
- Tools the Professional use
- Oracle 11g Download and Installation
- Unlocking Sample HR Schema Account
- Download and install Oracle SQL Developer
- Connect SQL Developer to Oracle database
- Creating Account on Oracle Application Express
- Populating Sample HR Schema
- Running Sample Application
- Toad For Oracle Download and Installation
- Toad Database Connection Setup
- Notepad++ Download and Installation
- What is an ERD
- How to generate ERD with TOAD
- How to generate ERD with SQL Developer
2. SQL Sub Languages
- DDL CREATE
- DDL ALTER ,TRUNCATE ,DROP
- DML SELECT
- DML INSERT
- DML UPDATE , DELETE
3. Reading Data
- Data Types And Constraints
- Limiting And Sorting Data
- Operators
- Set Operators
- View And Dual Table
4. Table Joins
- Table Joins
- Aliases
- Equi Join
- Non Equi Join
- Cartesian Join
- Outer Join
- Self Join
5. Functions
- Functions
- Character Functions
- Conversions
- Date Functions
- Numeric Functions
- Group / Aggregate Functions
6. Analytic Functions
- What are Analytic Functions
- Syntax
- Partition By Clause
- ORDER BY Clause
- DENSE RANK Functions
- First and LAST Function
- LAG Function
- LISTAGG Function
- RANK Functions
- ROW Number Functions
