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.阅读更多.
此资源由附属合作伙伴提供。 如果您支付培训费用,我们可能会赚取佣金来支持该网站。
Database Design and Basic SQL in PostgreSQL 中涵盖的技术和工具与 数据分析师 招聘广告中的要求最为相似。
Database Design and Basic SQL in PostgreSQL is a part of 一 structured learning path.
4 Courses
4 Months
PostgreSQL for Everybody