SECTION 1
- Introdution
- How to Use Resource Material
SECTION 2
- How to Create a Database
- How to Create Table in a Database
- How to Select records from a table.
- Playing with Tables using CREATE, INSERT & SELECT
- Playing with Tables using CREATE, INSERT & SELECT
- Select Statement problem
- Select Statement problem
- What is a String
- How to perform Calculation using arithmetic operators
SECTION 3
- Filter Out Records From a Table.
- Using Where Statement
- Using Where Statement : Solution
- Calculations with Where Statement
- Calculations with Where Statement : Solution
- Select Records Between a range
- Comparison Operators
- In Operator
- How to Update records in a table.
- Updating Records in a Table
- Updating Records in a Table : Solution
- How to Delete a record for a table.
- Deleting Rows from a table
- Deleting Rows from table : Solution
SECTION 4
- Database Design
- Create Primary Key
- Create Foreign Key
- Foreign Key
- Foreign Key : Solution
SECTION 5
- How to Select Records from Both the tables.
- Joining
- Joining : Solution
- How to select the common records from both the tables.
- Inner Joins
- Inner Joins : Solution
- Select all the records from left side table and the matching records Right table
- More on join
- More on join : Solution
- Select all the records from Right side table and the matching records Left table
- Select all the records from both the tables.
- Does order of Tables across Joins Matters.
- Filter Records Returned By Join
- Apply join on more than one table.
- Three way Join
- Three way Join : Solution
SECTION 6
- How to Group Records in a table.
- Aggregate Functions
- Grouping and Aggregating
- Grouping and Aggregating : Solution
- Grouping with Join
- Grouping with Join : Solution
- Filtering out the Groups returned by Group By
- Exercise on Having
- Exercise on Having : Solution
- Practicing with Group By
- Practicing with Group By : Solution
SECTION 7
- Sorting the Records in a Table
- More complex use of Where Statement
- More complex use of Where Statement
- Sorting Exercise
- Sorting Exercise : Solution
- Limit the records returned by Select Statement
SECTION 8
- UNION
- Merging with Unions
- Merging with Unions : Solution
- INTERSECT
SECTION 9
- Sub Query
- Embedding in Select
- Embedding in Select : Solution
- Subquery using Where
- Subquery using Where : Solution
- More on Subqueries
- More on Subqueries : Solution
- Subquery without From & Where
- Subquery without From & Where : Solution
- Correlated Query
SECTION 10
- Select Distinct Records
- Distinct Exercise
- Distinct Exercise : Solution
