DDL, DML, & Constraints

PostgreSQL 9.4.5    |    Beginner
  • 14 videos | 1h 28m 42s
  • Includes Assessment
  • Earns a Badge
Data definition and data manipulation languages allow you to work with data in meaningful ways. Discover how to work with SQL DML commands, constraints, and datatypes in PostgreSQL.

WHAT YOU WILL LEARN

  • Work with sql dml commands
    Work with sql dml commands in postgresql
    Work with sql dml commands in postgresql
    Work with default values for defined columns
    Work with the alter table command in postgresql
    Work with sql dml commands in postgresql
    Work with sql dml commands in postgresql
  • Work with sql dml commands in postgresql
    Describe constraints in postgresql
    Work with the not null constraint
    Work with the unique constraint
    Work with check constraints
    Work with the serial data type
    Working with postgresql installation and database operation

IN THIS COURSE

  • 3m 56s
    During this video, you will learn how to work with SQL Data Manipulation Language (DML) commands. FREE ACCESS
  • 9m 12s
    In this video, you will work with SQL Data Manipulation Language (DML) commands in PostgreSQL. FREE ACCESS
  • Locked
    3.  Working with SQL DDL  - DROP, DELETE, TRUNCATE
    7m 3s
    During this video, you will learn how to work with SQL Data Manipulation Language (DML) commands in PostgreSQL. FREE ACCESS
  • Locked
    4.  Working with default values
    7m 15s
    In this video, you will learn how to work with default values for columns you have defined. FREE ACCESS
  • Locked
    5.  Working with SQL DDL - ALTER TABLE
    5m 29s
    During this video, you will learn how to use the ALTER TABLE command in PostgreSQL. FREE ACCESS
  • Locked
    6.  Working with SQL DML - INSERT INTO
    7m 55s
    In this video, you will work with SQL Data Manipulation Language (DML) commands in PostgreSQL. FREE ACCESS
  • Locked
    7.  Working with SQL DML - SELECT
    9m 50s
    In this video, you will work with SQL Data Manipulation Language (DML) commands in PostgreSQL. FREE ACCESS
  • Locked
    8.  Working with SQL DML - UPDATE, DELETE
    5m 31s
    During this video, you will learn how to work with SQL Data Manipulation Language (DML) commands in PostgreSQL. FREE ACCESS
  • Locked
    9.  Constraints
    4m 56s
    Upon completion of this video, you will be able to describe constraints in PostgreSQL. FREE ACCESS
  • Locked
    10.  Constraints - NOT NULL
    3m 42s
    In this video, learn how to work with the NOT NULL constraint. FREE ACCESS
  • Locked
    11.  Constraints - UNIQUE
    4m 44s
    In this video, find out how to work with the UNIQUE constraint in SQL. FREE ACCESS
  • Locked
    12.  Constraints - CHECK
    7m 11s
    In this video, you will work with check constraints. FREE ACCESS
  • Locked
    13.  Using the SERIAL data type
    7m 10s
    In this video, learn how to work with the SERIAL data type. FREE ACCESS
  • Locked
    14.  Exercise: Deploying PostgreSQL
    4m 51s
    Find out how to work with PostgreSQL installation and database operation. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.