Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


PostgreSQL: Know how to handle database jobs


  • PostgreSQL: Know how to handle database jobs, Singapore SKillsFuture elarning online course
  • PostgreSQL: Know how to handle database jobs, Singapore SKillsFuture elarning online course
  • PostgreSQL: Know how to handle database jobs, Singapore SKillsFuture elarning online course
  • PostgreSQL: Know how to handle database jobs, Singapore SKillsFuture elarning online course
  • PostgreSQL: Know how to handle database jobs, Singapore SKillsFuture elarning online course
  • PostgreSQL: Know how to handle database jobs, Singapore SKillsFuture elarning online course

Course Description

This VTC course is an introduction to the popular open source and free database management system PostgreSQL. Author Dima Kassab covers the basics needed to create databases and database objects. The course assumes no prior knowledge of database concepts. It sets the groundwork for more advanced topics such as database administration and development. Topics covered include: installations, data types, main database operators/functions, and creating/modifying database objects such as tables, views, indexes, and sequences.

Take the first step in maintaining your database.

- Learn how to maintain your database
- Know about the features and functions of PostgreSQL.
- Learn about the different administrative tools available
- Be able to handle and monitor the activity in your database

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Understand about maintaining a database 
2. Able to install, configure and navigate the interface of PostgreSQL.
3. Understand how to create a database by applying different operations 
4. Know the types of schemas and privileges in PostgreSQL.
5. Able to apply different operations and commands in queries 


Related Courses

  • Access 2010 and Beyond

    Access 2010 and Beyond

    SGD $99.00

    Course Description

    Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft® Access® 2010 is an easy-to-use database software that helps you track and report information with ease. This training series will teach you how to use the results-oriented user interface that's context-sensitive and optimized for efficiency and flexibility. Become comfortable with the new look and feel and the many great features of Access 2010 in this online tutorial series.Maximize your skills in Microsoft Access 2010 and beyond now!- Use the results-oriented user interface and the many great features of Access 2010 to 2013- Maximize your database with Microsoft Access- Take your working knowledge of tables, queries, reports and forms to dress up your forms and reports- Know how to build your own database with personalized tables and queries This course is SkillsFuture Credit Eligible.

    Read more...

  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    SGD $49.60

    Course Description

    Microsoft Excel is an important and powerful program for many businesses. The PivotTable feature is one of the most useful, powerful and misunderstood features. PivotTables are absolutely not just about big data and large companies. Although PivotTables can work with very large data sets they are just as useful for micro businesses trying to understand where their sales opportunities lie or for individuals working on their household finances or even their fantasy football leagues. This PivotTable course from Skillsology teaches you how to draw these conclusions easily and present and manage your findings effectively. Using screenshots, video examples and exercises, you’ll soon be able to make the most out of your data, whether ‘Big’ or small, to further your business or personal life. Turn redundant data into useful analysis with PivotTable.  - Manage your data and information in a more intelligent system  - Realize your data's full potential to your advantage  - Discover ways to enhance your data output  - Learn about the advantages of PivotTable    This training is for PivotTable (PC version: 2013, 2007/10) This course is SkillsFuture Credit Eligible.

    Read more...

  • Avid Pro Tools 11: Know how to work with audio

    Avid Pro Tools 11: Know how to work with audio

    SGD $45.00

    Course Description

    Avid Pro Tools 11 is the standard when it comes to audio recording and mixing. Version 11 brings additional features and power to the audio production process. This VTC course explores these features along with the basics of operation. Author Sam McGuire demonstrates how to use this software in a variety of situations using provided work files. This course is an excellent resource for anyone who wants to learn how to use Pro Tools. Learn how to work with audio files using Avid Pro Tools. - Know how Avid Pro Tools handles audio - Learn how to edit your own audio files with Avid Pro Tools- Discover the potential of Avid Pro Tools with your audio files- Master audio editing with all the right tools and techniques in Avid Pro ToolsThis course is SkillsFuture Credit Eligible.

    Read more...


Content

Introduction

Preview Available

+

About the Course

About PostgreSQL

Resources

Installation

Preview Available

+

Installing Locally

Regarding Installation on a Server

Stop and Start the Service Locally

Create / Drop / Connect to a Database pt. 1

Create / Drop / Connect to a Database pt. 2

Psql Help

Keywords and Identifiers

Comments

Data Types

+

Numeric Types

Character Types

Date / Time Types pt. 1

Date / Time Types pt. 2

Boolean Types

Enumerated Types

Geometric Types

Arrays

Defining Tables

+

Create / Drop a Table Using Command Line

Primary Key Constraint

Foreign Key Constraint pt. 1

Foreign Key Constraint pt. 2

Foreign Key Constraint pt. 3

Check Constraints pt. 1

Check Constraints pt. 2

Not Null Constraint

Unique Constraint

Create a Table Using pgAdmin

Creating Constraints Using pgAdmin pt. 1

Creating Constraints Using pgAdmin pt. 2

Default Values

Drop Table Cascade

Working with Tables

+

Insert pt. 1

Insert pt. 2

Update

Delete

Cascade Option

Truncate

Working with Tables Using pgAdmin pt. 1

Working with Tables Using pgAdmin pt. 2

Queries

+

Simple Query

Retrieving a Portion of the Rows

Sorting Queries

Table and Column Aliases

Limit and Offset Options

Combining Queries

Aggregate Functions

Group By and Having pt. 1

Group By and Having pt. 2

Inner Joins Between Tables pt. 1

Inner Joins Between Tables pt. 2

Outer Joins Between Tables

Cross and Self Joins

Subquery Expressions pt. 1

Subquery Expressions pt. 2

Accessing Data Using pgadmin pt. 1

Accessing Data Using pgadmin pt. 2

Creating Views Using Command Line

Creating Views Using pgAdmin

Transactions

+

Starting and Ending a Transaction

Savepoints

DeadLocks

System Columns

Modifying Tables

+

Changing a Column Data Type and Default Value

Adding / Removing a Column

Adding / Removing a Constraint

Renaming a Column / Table

Modifying Tables Using pgAdmin

Main Operators and Functions

+

Logical Operators

Comparison Operators

Mathematical Operators

Mathematical Functions

String Functions pt. 1

String Functions pt. 2

String Functions pt. 3

Pattern Matching pt. 1

Pattern Matching pt. 2

Date and Time Operators

Date and Time Functions

Sequences

Conditional Expressions

Schemas / Privileges

+

Create / Drop Schemas

Grant / Revoke Privileges on Tables

Grant / Revoke Privileges on Columns

Grant / Revoke Privileges Using pgAdmin

Indexes

+

Index Usage and Benefits

Index Types

Create and Drop an Index

Multi-Column Index

Indexes on Expressions

Unique Index and Partial Index

Create and Drop Index Using pgAdmin

Conclusion

+
Resource File

Course Wrap Up

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.