DDL, DML, & Constraints

PostgreSQL 9.4.5
  • 14 Videos | 1h 35m 12s
  • Includes Assessment
  • Earns a Badge
Likes 17 Likes 17
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

  • Playable
    1. 
    Data Definition/Manipulation Language
    3m 56s
    UP NEXT
  • Playable
    2. 
    Working with SQL DDL - CREATE
    9m 12s
  • Locked
    3. 
    Working with SQL DDL  - DROP, DELETE, TRUNCATE
    7m 3s
  • Locked
    4. 
    Working with default values
    7m 15s
  • Locked
    5. 
    Working with SQL DDL - ALTER TABLE
    5m 29s
  • Locked
    6. 
    Working with SQL DML - INSERT INTO
    7m 55s
  • Locked
    7. 
    Working with SQL DML - SELECT
    9m 50s
  • Locked
    8. 
    Working with SQL DML - UPDATE, DELETE
    5m 31s
  • Locked
    9. 
    Constraints
    4m 56s
  • Locked
    10. 
    Constraints - NOT NULL
    3m 42s
  • Locked
    11. 
    Constraints - UNIQUE
    4m 44s
  • Locked
    12. 
    Constraints - CHECK
    7m 11s
  • Locked
    13. 
    Using the SERIAL data type
    7m 10s
  • Locked
    14. 
    Exercise: Deploying PostgreSQL
    4m 51s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 72 Likes 72  
Likes 125 Likes 125  
CHANNEL PostgreSQL
Likes 36 Likes 36  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 172 Likes 172  
Likes 251 Likes 251