SQL Deep Dive

This course provides an understanding of the basic relational database concepts and query formulation, an important skill in application development.

What You Will Learn:

  1. You will be able to use SQL to retrieve, filter, analyze, format and present information from Oracle databases.
  2. You will understand SQL code written by other people and feel confident to modify it.
  3. You will be able to use SQL to insert, modify and delete information from Oracle databases.
  4. You will be able to write the SQL code needed to solve the most common problems found in real work situations and academic tests.
  5. How to create reports of sorted and restricted data.
  6. How to run data manipulation statements (DML).
  7. How to control database access to specific objects and manage schema objects.
  8. How to write sub-queries, combine multiple queries into a single query using set operators and report aggregated data using group functions.
  9. You will also learn advanced Features of SQL to enable you to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.
  10. You will also learn the use of development tools such as SQL*Plus and SQL Developer to query and manipulate data.

    Requirements

  • A PC (Windows or Linux) or Mac is required
  • No prior knowledge of Databases or SQL is required.

Overview

  About Author

Start

  Course Objectives

Start

  Relational Database Concept

Start

Course Environment Set Up

  Access LiveSQL (Runs on oracle19c)

Start

  Oracle Client 12c/18c/19c Set Up

Start

  Microsoft Azure Set Up

Start

  Visual Studio Code Set Up

Start

  Install and configure SQL Developer

Start

  Provision a MS SQL Database Instance in MS Azure

Start

Introduction To SQL

  Objectives

Start

  Introduction To SQL

Start

  Users And Schemas

Start

  The HR Schema, Tables Description And ERD

Start

  The Fusion Schema, Tables Description And ERD

Start

Query Formulation with SQL

  Objectives

Start

  Retrieving Data Using SELECT Statements

Start

  Practice Lab

Start

  Restricting and Sorting Data

Start

  Using Single-Row Functions To Customize Output

Start

  Using Set Operators

Start

  Using Join Operations in SQL SELECT Statements

Start

  Using Group Functions To Report Aggregated Data

Start

  Using Joins To Display Data From Multiple Tables

Start

  Write Simple Sub-Queries

Start

SQL Modification Statements

  Objectives

Start

  Insert Data into a Table

Start

  Delete Data From a Tabke

Start

  Update Data on a Table

Start

  Truncate Data From a Table

Start

  Merge Data on Tables

Start

SQL Data Definition statements

  Objectives

Start

  Creating Tables

Start

  Creating Sequences, Synonyms, and Indexes

Start

  Creating Views

Start

  Managing Schema Objects

Start

SQL Data Control statements

  Objectives

Start

  Controlling User Access

Start

  Creating Users

Start

  Creating, Granting and Revoking System Privileges

Start

  Creating, Granting and Revoking Object Privileges

Start

  Creating,Granting and Revoking Privileges To A Role

Start

  Changing Your Password

Start