In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Students will do hands-on assignments creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.
Completion of the first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python
- 5 stars84.76%
- 4 stars11.58%
- 3 stars1.90%
- 2 stars0.95%
- 1 star0.79%
来自DATABASE DESIGN AND BASIC SQL IN POSTGRESQL的热门评论
I am already familliar with PostgreSQL so it was great to review the basics. Its a great course for that.
Amazing course...learned alot from this course. The instructor explained well how the internal things are working.
It's just great.. great way of teaching.. After big time I felt that I learnt the way I wanted. Thanks!
Excelent! I'd say the best introductory course on SQL in general. It has those important SQL basics that you really don't find elsewhere.