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

  • FileMaker Pro 12: Advanced

    FileMaker Pro 12: Advanced

    SGD $63.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how queries can be implemented to run the data better - Understand an effective solution to optimize your database's productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft SharePoint Server: 2007 & 2010

    Microsoft SharePoint Server: 2007 & 2010

    SGD $99.00

    Course Description

    Microsoft Office SharePoint Server 2007 is an integrated suite of server capabilities that can help improve organizational effectiveness by providing comprehensive content management including sharing of documents, photos and calendar events. This tutorial series covers the end user basics of this collaborative content management server. SharePoint “unleashes a suite of capabilities that dramatically improves the way people work”. Help improve organizational effectiveness by providing comprehensive content management including sharing of documents, photos and calendar events. Know how to collaborate with SharePoint!- Learn about the features and functions offered in Microsoft SharePoint - Find out how to improve your productivity using Microsoft SharePoint - Understand the functionality of the tools in Microsoft SharePoint - Know how you can adopt SharePoint into your daily work This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Project 2013

    Microsoft Project 2013

    SGD $45.00

    Course Description

    Microsoft Project is the standard-bearing tool to help project managers track all the vitals of their projects: tasks, resources, schedule, and cost. With the 2013 version of Project, Microsoft introduces several new features and improves existing ones. In this VTC course, author Brian Culp will guide users through techniques that allow project managers to quickly get up to speed on this powerful toolkit. Users will learn how to start projects, create and edit tasks, assign resources to tasks, share project information, and much more. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This 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.