Requirements: No programming experience, at least 12 years old
Duration: 5 hours and 35 minutes
Standards: K-12 Computer Science Framework Core Concepts and Practices * Algorithms and Programming - Collaborating Around Computing - Recognizing and Defining Computational Problems - Developing and Using Abstractions - Creating Computational Artifacts - Testing and Refining Computational Artifacts
An Introduction to PostgreSQL
Querying and accessing data is one of the most essential skills that a developer should possess. This course is designed for beginning programmers who want to take their first steps in database interaction and for experienced programmers who need a refresher on the most essential concepts.
About this course
An Introduction to PostgreSQL is a series of interactive lessons that helps you learn the essential concepts about SQL in general and PostgreSQL in particular. You will be solving problems that challenge you to retrieve, group, filter, merge, and compare data. You will learn how to manipulate databases, tables, columns and rows. At the end of this course, you will be able to master the most essential SQL database manipulation skills and get a good sense of how PostgreSQL works.
A database is a set of structured data in a computer. PostgreSQL is a database system that is used to create, read, update, and delete databases.
An Introduction to PostgreSQL uses
psql as its command-line client. The command-line client is the interface between you and the database. It provides feedback for successfully executed queries and commands. It also provides feedback when there are errors in the query or command that you execute. There are other command-line client for PostgreSQL, aside from
psql. For consistency, all the lessons in this course uses