Database Design and Basic SQL in PostgreSQL
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Course Summary
Learn how to design and implement a database using PostgreSQL. This course covers database modeling, normalization, schema creation, SQL statements, and more.Key Learning Points
- Understand the principles of database design and normalization
- Learn how to create and manage schemas using PostgreSQL
- Write complex SQL statements to query and manipulate data
Job Positions & Salaries of people who have taken this course might have
- USA: $77,080
- India: ₹5,00,000
- Spain: €32,000
- USA: $77,080
- India: ₹5,00,000
- Spain: €32,000
- USA: $62,453
- India: ₹4,00,000
- Spain: €28,000
- USA: $77,080
- India: ₹5,00,000
- Spain: €32,000
- USA: $62,453
- India: ₹4,00,000
- Spain: €28,000
- USA: $73,760
- India: ₹6,00,000
- Spain: €35,000
Related Topics for further study
Learning Outcomes
- Understand the fundamental principles of database design
- Implement a database schema using PostgreSQL
- Write complex SQL statements to query and manipulate data
Prerequisites or good to have knowledge before taking this course
- Basic understanding of SQL
- Familiarity with relational databases
Course Difficulty Level
IntermediateCourse Format
- Online
- Self-paced
Similar Courses
- SQL for Data Analysis
- Database Management Essentials
Related Education Paths
Related Books
Description
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.
Knowledge
- 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
Outline
- Introduction to SQL
- Welcome to PostgreSQL!
- History of Relational Databases
- Bonus Video: Elizabeth Fong and SQL Standards
- SQL Architecture
- Using PythonAnywhere to Run SQL
- Using the DBeaver Client to Run SQL Commands
- Dr. Chuck Goes Racing - Joliet, Illinois, USA
- Office Hours - London (Very close to PythonAnywhere)
- Help Us Learn More About You
- Elizabeth Fong and SQL Standards
- Assessment Philosophy
- How Assignments Work
- Connecting to Your Database Server
- Introductory SQL
- Single Table SQL
- Working with Tables and PostgreSQL
- Data Types in PostgreSQL
- Database Keys and Indexes in PostgreSQL
- Musical Track Database (CSV)
- Dr. Chuck Sings the Blues in Geneva, Switzerland (Near CERN)
- Office Hours - Kyoto, Japan
- Single Table SQL
- One-To-Many Data Models
- Relational Database Design Part 1
- Relational Database Design Part 2
- Keys
- Database Normalization
- Building Tables
- Inserting Data
- Using JOIN Across Tables
- Office Hours at Bletchley Park, Milton Keynes, England
- Office Hours, Philadelphia, Pennsylvania, USA
- One to Many Data Models
- Many-To-Many Data Models
- Many-to-Many Relationships
- Demonstration: Database Design and Many to Many
- Up Next - Beyond CRUD (Create, Read, Update, Delete) and JOIN
- Office Hours - Capetown, South Africa
- Office Hours - Raleigh, North Carolina, USA
- Post-Course Survey
- Many-to-Many Data Models
Summary of User Reviews
This course on database design using PostgreSQL has received high praise from users for its comprehensive content and practical approach. Many users found the instructor to be engaging and knowledgeable, making the course both informative and enjoyable.Key Aspect Users Liked About This Course
The course content is comprehensive and practicalPros from User Reviews
- The instructor is engaging and knowledgeable
- The course covers a wide range of topics related to database design
- The course includes practical exercises and assignments that help reinforce the concepts learned
- The course is suitable for both beginners and advanced learners
- The course is well-structured and easy to follow
Cons from User Reviews
- Some users found the course to be too basic and lacking in depth
- Some users had technical issues with the platform or software used in the course
- Some users found the pacing of the course to be too slow or too fast
- Some users felt that the course could benefit from more interactive elements or live sessions
- Some users found the course to be too theoretical and lacking in real-world examples
Charles Russell Severance
4.8 Raiting
The Complete Python Masterclass: Learn Python From Scratch
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Python course for beginners, Learn Python Programming , Python Web Framework Django, Flask, Web scraping and a lot more. The Complete Python Masterclass: Learn Python From Scratch...
WAMP + MySql = Awesome
- 4.3
-
![]()
![]()
![]()
![]()
![]()
I teach you how to install WAMP and MySQL and I show you how to use these 2 tools together to create a Really cool DB....
Data Science and Machine Learning For Beginners with Python
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Learn to Analyse , Make Predictions, Explore data Frames,Clean and Visualize Data Data science is the study of data. Python is what is referred to as a high level language....
Oracle 1Z0-931 1Z0-1072 1Z0-1085 1Z0-1067 & 1Z0-997
- 0.0
-
![]()
![]()
![]()
![]()
![]()
100 % passing guarantee for Oracle Cloud Infrastructure (OCI) program. Practice Dumps ( attend all 5 Sections ) 100 % passing guarantee for Oracle Cloud Infrastructure (OCI) program....
