This video is a tutorial on how to use the PostgreSQL database. It covers how to connect to the database, work with data, and use various command-line tools. It also demonstrates how to create a table and add constraints to it.
This video provides a tutorial on how to use PostgreSQL for data management. It explains how to create a new table and insert data, how to select data from a table and how to drop a table. It also teaches how to use SQL to manage data, how to limit the results of a SELECT query, and how to use the like operator to compare values against a pattern.
This video is a tutorial on how to use PostgreSQL operators for arithmetic. The video starts with a data set and demonstrates how to sum, aggregate, and perform basic calculations with the PostgreSQL operators. It then goes on to explain how to use dates with PostgreSQL, and how to add a primary key to a table. Finally, it covers how to use indexes and constraints to improve table performance.
This video tutorial explains how to use the PostgreSQL update command to update a table's data. The command requires a where clause to avoid updating or modifying the entire table. The presenter also teaches how to use the on conflict keyword to perform updates on a row that has a conflict.
This video is a tutorial on how to use PostgreSQL. It covers topics such as changing IDs, generating keys, and creating and inserting data into tables. It also goes over more advanced topics such as joins. Upon completion of the video, students should be ready to take one of the instructor's other courses.