Description
PostgreSQL for Everybody Specialization is a 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-world projects. Some of the most important topics covered in this course include database design and architecture and implementation of various databases based on project prerequisites and objectives. After acquiring 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 during this training will be useful to people working in information extraction and processing and in the development of web and mobile applications.
What you will learn in the PostgreSQL for Everybody specialization
- Creating and editing tables in various databases
- Design of different data models
- Structured queries and complex queries to retrieve and modify information
- Working 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 the Differences Between Each
Course Specifications
Editor: Coursera
Instructors: Charles Russell Severance pay
French language
Intermediate level
institution/university: University of Michigan
Number of lessons: 4
Duration: Approximately 4 months to complete – Suggested pace of 4 hours/week
Courses 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, Scalability, and NoSQL with Elasticsearch
PostgreSQL Specialization Prerequisites for Everyone
What basic knowledge is needed?
You must have completed the first two courses in the Python for Everybody specialization or have an equivalent basic understanding of Python.
Pictures
PostgreSQL Specialization Video Example for Everyone
Installation guide
After the clip, watch with your favorite reader.
english subtitles
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, Scalability, and NoSQL with Elasticsearch
File password(s): free download software
size
In total, approximately 4.7 GB