Database Design and Basic SQL in PostgreSQL

Database Design and Basic SQL in PostgreSQL in University of Michigan

Beginner 0(0 Ratings) 0 Students enrolled
Created by University of Michigan Staff Last updated Mon, 28-Feb-2022 English


Database Design and Basic SQL in PostgreSQL free videos and free material uploaded by University of Michigan Staff .

Syllabus / What will i learn?

  • Introduction to SQL
  • Single Table SQL
  • One-to-Many Data Models
  • Many-To-Many Data Models



Curriculum for this course
0 Lessons 00:00:00 Hours
+ View more
Description

Understand and practice important PostgreSQL concepts

This four-week course from the University of Michigan is the first in the PostgreSQL and Python series, and delivers a solid foundation to PostgreSQL.

You’ll learn SQL fundamentals, basic CRUD (Create, Read, Update, Delete) operations in PostgreSQL, and the specifics of aggregation, transactions, reading, and parsing CSV files, and entering data into a database.

Finally, a look at how PostgreSQL handles and indexes data will complete your introduction to this relational database management system (RDBMS).

Learn all you need to know about SQL programming

You’ll start by exploring basic SQL commands to implement CRUD operations in PostgreSQL, and the functions of primary, logical, and foreign keys within a database.

From there you’ll build and differentiate between one-to-many and many-to-many relationships within PostgreSQL, giving you important insights into using this RDBMS for your own database design and creation.

Get hands-on practice in PostgreSQL

Throughout the course, you’ll practice the programming concepts as they are introduced to you, by completing different assignments.

By the end, you’ll be able to alter table schemas, create stored procedures, construct advanced queries, and work with text in databases using various techniques.

Study this RDBMS with leading experts

The University of Michigan is a highly-respected institution, with a long history of providing exceptional courses as well as academic support.

This course continues the University’s high standards, and is also convened by programming experts who understand the historical significance of PostgreSQL.

Not only will you learn and practice important aspects of the SQL, but you’ll also gain insights into the key players and innovations that brought about the game-changing SQL standard.

This course is designed for anyone with a background and working knowledge of Python or programming, who would like to upskill by learning PostgreSQL.

You need online training / explanation for this course?

1 to 1 Online Training contact instructor for demo :


+ View more

Other related courses
About the instructor
  • 0 Reviews
  • 1 Students
  • 313 Courses
Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews

Material price :

Free

1:1 Online Training Fee: 1 /-
Contact instructor for demo :