What Will You Learn?
Utilize psql and SQL commands to implement CRUD (Create, Read, Update, and Delete) operations for tables in a PostgreSQL database.
Identify and utilize the functions of primary, logical, and foreign keys within a database.
Build and differentiate between one-to-many and many-to-many relationships within PostgreSQL.
Recall key people, organizations, and innovations that were instrumental to building the SQL standard
About This Course
Provider: Coursera
Format: Online
Duration: 13 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: By the end of this course, you will master the historical design of databases and proficiently utilize SQL in the PostgreSQL environment.Course Prerequisites: NA
Assessment and Certification: NA
Instructor: University of Michigan
Key Topics: Database (DB) Design, SQL, Database (DBSM)
Topic Covered:
- - Welcome to PostgreSQL!
- - History of Relational Databases
- - SQL Architecture
- - Using PythonAnywhere to Run SQL
- - Using the DBeaver Client to Run SQL Commands
- - Working with Tables and PostgreSQL
- - Data Types in PostgreSQL
- - Database Keys and Indexes in PostgreSQL
- - Musical Track Database (CSV)
- - Relational Database Design
- - Keys
- - Database Normalization
- - Building Tables
- - Inserting Data
- - Using JOIN Across Tables
- - Many-to-Many Relationships
- - Demonstration: Database Design and Many to Many
- - Up Next - Beyond CRUD (Create, Read, Update, Delete) and JOIN
0 Comments