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

Beginner's Guide to PostgreSQL

Course Summary

PostgreSQL Tutorial: What you need to know to get started with relational databases in PostgreSQL


  • +

    Course Syllabus

    • Introduction
      • An Introduction to the Course
      • Database Overview
      • Identities in database tables
      • Normalization
      • Relationships
      • Relationship Types
      • Database Management Systems
      • PostgreSQL features
      • PostgreSQL Windows Installation
    • Database Usage Basics
      • Connecting to Database Server with pgAdmin III
      • Configuring PostgreSQL to Accept External Connections
      • Creating Databases
      • Creating Tables
      • Inserting and viewing data in pgAdmin III
      • DataTypes Intro
      • Numeric DataTypes in PostgreSQL
      • Serial Datatypes For Row Ids
      • Character Types
      • The Date Datatype
      • The time datatype
      • Timestamps
      • The boolean datatype
      • NULL Values
      • Requirements
      • Car Repair Shop DB Requirements
      • Designing the repair shop database Pt1
      • Designing the repair shop database Pt2
      • Designing the repair shop database Pt3 - choosing datatypes
      • Car Repair Shop DB Table and Column Definitions
      • Building the Database - Part 1
      • Applying constraints to table columns
      • Creating relationships between tables in pgAdmin III
      • Creating the remaining tables
      • Users and Privileges
      • Backup and Restore in PostgreSQL with pgAdmin III
    • SQL in PostgreSQL
      • Introduction to SQL
      • The CREATE TABLE command
      • The CREATE TABLE command with constraints PT 1
      • The CREATE TABLE command with constraints pt.2
      • The CREATE TABLE command with foreign keys PT 1
      • The CREATE TABLE command with foreign keys PT 2
      • Drop Table
      • The Alter Table command
      • Insert Into SQL Command
      • Insert scripts used in the previous video
      • The Update Statement
      • Update Script file
      • The DELETE FROM Statement
      • Deletes with cascades
      • Script: Delete from commands for the previous videos
      • The TRUNCATE command
      • Truncate Script
      • Filling the database with data
      • Full Db Script
      • The SELECT command
      • pgAdmin III's Graphical Query Builder
      • The WHERE clause (PT I)
      • The WHERE clause (PT 2) - BETWEEN and IN
      • The WHERE clause (PT 3) - IS [NOT] NULL
      • The WHERE clause (PT 4) - LIKE and ILIKE
      • The WHERE clause - using the graphical query builder
      • The WHERE Clause Command Script
      • The LIMIT and OFFSET clauses
      • The ORDER BY clause
      • Order By commands
      • Joins tables in a query through relationships
      • SQL functions - group clause


Course Fee:
USD 49

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Open Source and 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