SQL: From Basic to Advanced. Learn SQL skills you can use in an actual, real-world environment
What you will learn

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

Skills you will gain

Json
Database (DBMS)
Natural Language Processing
SQL

About this Specialization

Across these four courses, you'll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You'll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.
Applied Learning Project

This course series utilizes a custom autograding environment for an authentic set of graded and practice assignments, including: creating and manipulating tables, designing data models, constructing advanced queries, techniques for working with text in databases, including regular expressions, and more.