SQL

Udemy - Course on PostgreSQL published under my RPubs repository and GitHub repository

Includes lecture notes and exercises using SQL commands.

Lecture Notes

• SQL: Statement Fundamentals
  • SELECT
  • SELECT DISTINCT
  • SELECT WHERE
  • COUNT
  • LIMIT
  • ORDER BY
  • BETWEEN
  • IN
  • LIKE
• SQL: GROUP BY Statements
  • MIN MAX SUM and AVG
  • GROUP BY
  • HAVING
• SQL: JOINS
  • AS
  • INNER JOIN
  • OUTER JOIN
  • UNION
• SQL: Advanced SQL Commands
  • Timestamps and Extract
  • Mathematical Functions
  • String Function and Operators
  • SubQuery
  • Self-Join
• SQL: Creating Database and Tables
  • Data Types
  • Primary Keys and Foreign Keys
  • Create Table
  • Insert
  • Update
  • Delete
  • Alter Table
  • Drop Table
  • CHECK Constraint
  • NOT NULL Constraint
  • UNIQUE Constraint
• SQL: Bonus Lectures
  • Views
  • PostGreSQL with Python

UDEMY: Exercises

• SQL: Statement Fundamentals - General Challenges
• SQL: Assessment Test 1 - GROUP BY Statements
• SQL: Assessment Test 2 - JOINS and Advanced SQL Commands
• SQL: Assessment Test 3 - Creating Databases and Tables

Stanford Lagunita: Exercises

• SQL: Stanford Exercises - Movie Rating - PART I
• SQL: Stanford Exercises - Movie Rating - PART II
• SQL: Stanford Exercises - Movie Rating - PART III
• SQL: Stanford Exercises - Social Network - PART I
• SQL: Stanford Exercises - Social Network - PART II
• SQL: Stanford Exercises - Social Network - PART III

-Sulman Khan