-
Introduction to SQL - Deleting Rows from a Table
After watching this video; you will be able to remove rows from a table using the DELETE SQL statement.
-
Adding Data to Tables
After watching this video; you will be able to add data to a table.
-
Administrating PostgreSQL and Using SELECT
After watching this video; you will be able to working with PostgreSQL tables and managing the PostgreSQL RDBMS.
-
Constraints
After watching this video; you will be able to describe constraints in PostgreSQL.
-
Constraints - CHECK
After watching this video; you will be able to work with check constraints.
-
Constraints - NOT NULL
After watching this video; you will be able to work with the NOT NULL constraint.
-
Constraints - UNIQUE
After watching this video; you will be able to work with the unique constraint.
-
Creating Database Objects
After watching this video; you will be able to create database objects.
-
Creating Schema Objects
After watching this video; you will be able to create schema objects.
-
Data Definition/Manipulation Language
After watching this video; you will be able to work with SQL DML commands.
-
Data Types and the PRIMARY KEY Constraint
After watching this video; you will be able to define the various data types and understand the PRIMARY KEY constraint.
-
Deploying PostgreSQL
After watching this video; you will be able to working with PostgreSQL installation and database operation.
-
Downloading and Installing
After watching this video; you will be able to download and install PostgreSQL.
-
Foreign Key Constraint
After watching this video; you will be able to describe the FOREIGN KEY - REFERENCES constraint.
-
Managing PostgreSQL Objects
After watching this video; you will be able to remove database objects.
-
Object Backup
After watching this video; you will be able to back up PostgreSQL objects.
-
Object Restore
After watching this video; you will be able to restore PostgreSQL object.
-
PostgreSQL Architecture
After watching this video; you will be able to work with the components of the PostgreSQL architecture.
-
PostgreSQL Data Files
After watching this video; you will be able to work with the PostgreSQL data and configuration files.
-
PostgreSQL Privilege in Action
After watching this video; you will be able to work with Privilege configuration.
-
PostgreSQL Security
After watching this video; you will be able to outline security fundamentals for PostgreSQL objects.
-
Privileges in PostgreSQL
After watching this video; you will be able to describe the various object-sensitive privileges within PostgreSQL.
-
Retrieving Data #1
After watching this video; you will be able to retrieve data from tables.
-
Retrieving Data #2
After watching this video; you will be able to retrieve data using the Query builder tool.
-
Roles and Users
After watching this video; you will be able to work with object security in PostgreSQL.
-
SELECT Item Functions
After watching this video; you will be able to work with aggregate functions; operators and column labels.
-
The DISTINCT Option
After watching this video; you will be able to Use the DISTINCT option.
-
The GROUP BY Clause
After watching this video; you will be able to work with the GROUP BY clause.
-
The ORDER BY Clause
After watching this video; you will be able to utilize the ORDER BY clause.
-
The SELECT Command
After watching this video; you will be able to describe the more advance options of the SELECT command.
-
The WHERE Clause #1
After watching this video; you will be able to work with the WHERE clause.
-
The WHERE Clause #2
After watching this video; you will be able to work with the WHERE clause.
-
Using FOREIGN KEYS
After watching this video; you will be able to work with the FOREIGN KEY - REFERENCES constraint.
-
Using the Command Line Prompt
After watching this video; you will be able to work with the command line option (psql).
-
Using the SERIAL Data Type
After watching this video; you will be able to work with the SERIAL data type.
-
Using the VACUUM Options
After watching this video; you will be able to work with the VACUUM command.
-
What Is PostgreSQL?
After watching this video; you will be able to outline the PostgreSQL product.
-
Working with Default Values
After watching this video; you will be able to work with default values for defined columns.
-
Working with Indexes
After watching this video; you will be able to create and work with table Indexes.
-
Working with PostgreSQL Admin Console
After watching this video; you will be able to login to the Administration Console and connect to the default database.
-
Working with SQL DDL - ALTER TABLE
After watching this video; you will be able to work with the ALTER TABLE command in PostgreSQL.
-
Working with SQL DDL - CREATE
After watching this video; you will be able to work with SQL DML commands in PostgreSQL.
-
Working with SQL DDL - DROP; DELETE; and TRUNCATE
After watching this video; you will be able to work with SQL DML commands in PostgreSQL.
-
Working with SQL DML - INSERT INTO
After watching this video; you will be able to work with SQL DML commands in PostgreSQL.
-
Working with SQL DML - SELECT
After watching this video; you will be able to work with SQL DML commands in PostgreSQL.
-
Working with SQL DML – UPDATE and DELETE
After watching this video; you will be able to work with SQL DML commands in PostgreSQL.
-
Working with Views
After watching this video; you will be able to create and work with PostgreSQL Views.
-
Scripts
After watching this video; you will be able to work with scripts.
-
Groups
After watching this video; you will be able to work with PostgreSQL Groups.
-
Reports
After watching this video; you will be able to work with reports.
-
Creating Tables
After watching this video; you will be able to create a table.