SQL INDEPTH PRACTICAL GUIDE FOR BEGINNERS & POWER USERS: The Concise SQL A-Z Mastery Guide for All Users for Data Management, Analysis, and Manipulation with Practice Exercises and Solutions

INTRODUCTION
CHAPTER ONE
GETTING TO KNOW SQL CONCEPT
    What is SQL?
    Who Uses SQL?
    SQL Concept
    Components of a Table
    Types of SQL commands
    Understanding Relational Databases
CHAPTER TWO
INTRODUCTION TO THE GUIDE AND ITS SET-UP
    Getting Set up on Oracle Apex
    Setup procedure
    Installing the Country’s dataset
    About Sample Datasets
    Manually installing the country’s dataset
    Oracle APEX Overview
    Exploring Oracle Apex
    Object browser
    SQL commands
    SQL scripts
    Utilities
    Restful services
    Log out
    Sign In
    Reset Password
    Exploring the Countries Sample Dataset
    Fact table
    Dimension table
    Important information relating to Oracle APEX Sample Datasets
    What is SQL?
    Tables
    Basic Database Terminology
    Your First SQL Query
CHAPTER THREE
DATA TYPES
    Section Overview
    String Data Types
    Numerical Data Types
    Note On String and Numerical Values
    Date Data Types
    The describe statement
    Simple Mathematical Operators
    Guidance and Documentation on Data Types
CHAPTER FOUR
SQL COMMANDS
    Section Overview
    Types of SQL Commands
    Data Query Language
    Select Distinct
    Data Definition Language
    Creating a table
    Adding of data
    Creating additional tables
    Alter command
    Drop command
    Renaming a table
    Truncating command
    Data Manipulation Language
    Insert command
    Data Control Language
    Transaction Control Language
        Exercise
        Solution
CHAPTER FIVE
QUALIFYING COLUMNS AND ALIASING TABLE NAMES
    Section Overview
    Qualifying Columns
    Qualified vs Unqualified objects
    Aliasing Table Names
    Inserting comments into your code
CHAPTER SIX
OPERATORS AND THE WHERE CLAUSE
    Section overview
    Operators
    WHERE Clause
    Examples using the where clause
        Important notes about case sensitivity in SQL
    Introduction to the case statement
    Examples with the case statement
    Revisiting the DML update command
        Exercises
        Solution to Exercises
CHAPTER SEVEN
DATE, STRING, AND MATHEMATICAL FUNCTIONS
    Section Overview
    Overview of the Employees (EMP/DEPT) Data Model
    Installing the Employees (EMP/DEPT) Dataset
    Manually installing the Employees (EMP/DEPT) Dataset
    The Cast Function
        Date values and formatting
    Date functions
    String functions
        Mathematical functions
    Useful external links on functions
    Date Formatting
    Date Functions
        Exercises
        Solution to Exercises
CHAPTER EIGHT
AGGREGATE FUNCTIONS AND THE GROUP BY, HAVING  ORDER BY CLAUSES
    Section Overview
    Aggregate functions
    Count(*)
        Aggregate functions and the Where clause
    Aggregate functions and group by
    Single column group by
    Multi-column group by
    Non-Aggregated Columns
    Group By and The Having Clause
    Group by on Numerical fields
    Order by
    Order of Execution
        Exercise
        Solution to Excercises
CHAPTER NINE
JOINING TABLES
    Section Overview
    Introduction to the join operation
    Type of Joins
    Syntax
    Simple Join
    Joining Multiple Tables
    Joining on Multiple Columns
        Exercises
        Solution to Exercises
CHAPTER TEN
SET OPERATORS
    Section Overview
    Union and Union All
    Intersect
    Minus
CHAPTER ELEVEN
QUERY ORDER OF EXECUTION AND SUBQUERIES
    Section Overview
        SQL Query Order of Execution
    Fetch, Limit and Top
    Subqueries
    Subqueries and Joins
        Exercise
        Solution to Exercises
CHAPTER TWELVE
RELATIONAL DATA MODEL BASICS AND DATABASE CONSTRAINTS
    Section Overview
        Relational Databases
    Fact and Dimension tables revisited
    Star and Snowflake Schemas
    Types of Relationships
    Primary Key and Foreign Key Constraints
    Other Important Constraints
CHAPTER THIRTEEN
VIEWS
    Section Overview
    What are Views?
    Creating, Replacing, and Dropping Views
    Simple and Complex Views
    Performing DML Operations on Simple Views
CHAPTER FOURTEEN
BRINGING IT ALL TOGETHER
    Section Overview
        Overview of the Customer Orders Data Model
    Installing the Customer Orders Dataset
    Manually Installing the Customer Orders Dataset
    Customers dataset
    Orders dataset
    Order items dataset
    Product dataset
    Stores dataset
        Exercises
        Solution to Exercises
Conclusion
INDEX