Description
PostgreSQL for Everybody Specialization is an SQL training package and PostgreSQL database management system published by Coursera Specialized Academy. The skills and techniques taught in this course are quite practical and you will use them in real projects. Some of the most important topics covered in this course include database design and architecture and the implementation of various databases depending on the project requirements and goals. After learning the basic skills, you will become familiar with the differences and advantages of SQL and NoSQL approaches in the database design process and learn valuable points. The skills acquired in this training will be useful to people working in the extraction and processing of information and the development of web and mobile applications.
What you will learn in the PostgreSQL for All specialization
- Creating and editing tables in various databases
- Design of different data models
- Structured queries and complex queries to retrieve and modify information
- Work with different types of data such as texts and texts in the database
- Use psql and SQL statements to perform CRUD operations
- Differences between one-to-many and many-to-many information models
- Different database management systems and differences between each
Course specifications
Editor: Coursera
Instructors: Charles Russell severance pay
French language
Intermediate level
institution/university: University of Michigan
Number of Courses: 4
Duration: Approximately 4 months to complete – Suggested pace of 4 hours/week
Course included:
Course 1
Database design and basic SQL in PostgreSQL
Course 2
Intermediate PostgreSQL
Course 3
JSON and natural language processing in PostgreSQL
Course 4
Database Architecture, Scaling, and NoSQL with Elasticsearch
PostgreSQL Specialization Prerequisites for All
What prior knowledge is needed?
You must have taken the first two courses of the Python for Everybody specialization or have an equivalent basic understanding of Python.
Pictures
PostgreSQL specialization video sample for everyone
Installation guide
After ripping, watch with your favorite player.
english subtitle
Quality: 720p
This specialization contains 4 courses.
Download links
Database design and basic SQL in PostgreSQL
Intermediate PostgreSQL
JSON and natural language processing in PostgreSQL
Database Architecture, Scaling, and NoSQL with Elasticsearch
File password(s): ngaur.com
Cut
In total, about 4.7 GB