SQL. 4. DDL & DML
All SQL queries are divided into two large subsections: DDL and DML. In the lesson, we will talk about which queries belong to which sections and start with basic operations for creating a database and schemas in them. We will also try to perform operations for deleting created structures.
Link to courses on the udemy platform:
https://taplink.cc/denis.dmdev
To subscribe to the channel, click the link:
/ dmdev
00:00 - Introduction
00:15 - DDL
01:43 - DML
03:05 - CREATE DATABASE
05:30 - 3 default database schemas in PostgreSQL
06:53 - pg_catalog and information_schema database schemas
08:20 - CREATE SCHEMA
11:08 - DROP SCHEMA/DATABASE