MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

PostgreSQL: Introduction to SQL Queries

Course Summary

In this course, we will go over various table and data operations. We will learn to retrieve and modify data efficiently.


  • +

    Course Syllabus

    Introduction
    - 4m 30s

    —Introduction 4m 30s
    Introduction to Various Data Types
    - 50m 4s

    —Introduction 1m 12s
    —Example of Data Types 1m 31s
    —Advantages of Proper Data Types 3m 55s
    —Different Data Types 3m 6s
    —Real World Scenarios 1m 14s
    —Scenario 1: Create Table with Different Data Type 1m 11s
    —Demo 1: Create Table with Different Data Type 4m 51s
    —Scenario 2: Create New Column Accepting Yes/No 1m 5s
    —Demo 2: Create New Column Accepting Yes/No 3m 34s
    —Scenario 3: Data Type and Default Values 0m 58s
    —Demo 3: Data Type and Default Values 8m 3s
    —Scenario 4: Incorrect Data Type and Problems 1m 17s
    —Demo 4: Incorrect Data Type and Problems 5m 46s
    —Scenario 5: Data Type and Integrity 1m 8s
    —Demo 5: Data Type and Integrity 4m 24s
    —Scenario 6: Data Type and Mac Address 0m 47s
    —Demo 7: Data Type and Mac Address 4m 20s
    —Summary 1m 33s
    Table Operations: Schemas, Constraints, and Keys
    - 44m 8s
    Data Operations: Insert, Update, and Delete
    - 38m 26s
    Summary
    - 2m 13s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top