SQL

SQL

• CREATE TABLE statement (Complete)

• CREATE TABLE statement (Broken)

• ALTER TABLE statement

• SELECT Statement

• SET Operators

• Oracle Datatypes

• Generic steps involved in execution of SQL query (What happen during query execution?)

SQL Exercises

• Exercise 1 - Table creation, record insertion, and SELECT queries
• Exercise 2 - Table creation, record insertion, and SELECT queries with JOINs.
• Exercise 3 - Table creation, record insertion, and SELECT queries with simple conditions, joins, order by clauses and projection.
• Exercise 4 - Table Creation / Table Alteration
• Exercise 5 - SQL queries with GROUP BY clause and sub-queries - solved example.  
• Exercise 6 - SQL exercises with subqueries
• Exercise 7 - CREATE TABLE 
• Exercise 8 - Simple queries on Amusement Park database