- Introduction to SQL and Databases
- Various SELECT statements with examples
Assignents and Solutions
- DISTINCTS, JOINS, GROUP BY, SUBQUERY, IN-LINE QUERY etc
- TABLE CREATION, DATA TYPES etc
- TABLE CONSTRAINTS, CHECK STATEMENTS, DEFAULT VALUES etc
- DATABASE CREATION etc
- INSERTS, DELETE, UPDATES etc
- ALTER TABLES
- VIEWS
Assignents and Solutions
Course include: resources and steps to install PostGreSQL Database with pgAdmin tool.