Perform Database Operations¶
As part of this module we will perform basic database operations in Postgres. This is just to get started and advanced concepts will be covered as part of other courses.
Overview of SQL
Create Database and Users Table
DDL – Data Definition Language
DML – Data Manipulation Language
DQL – Data Query Language
CRUD Operations – DML and DQL
TCL – Transaction Control Language
Example - Data Engineering
Example - Web Application
Exercise - Database Operations