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

  • Microsoft Word 2013

    Microsoft Word 2013

    SGD $49.00

    Course Description

    In this VTC course, students will learn how to work with basic to advanced functions of Microsoft Word 2013. This efficient word processing program allows you to edit text, graphics, tables, page layouts, styles, and more. Intermediate to advanced users will learn how to complete a mail merge, use screenshots or clippings, implement hyperlinks, set up collaboration, create a table of contents, and utilize macros. Microsoft Word even provides connected services so users can utilize social media networks within files. Word is part of the cloud, SkyDrive, which allows everyone to utilize remote access anywhere, anytime. 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...

  • Data Structures and Algorithms in C++

    Data Structures and Algorithms in C++

    SGD $40.00

    Course Description

    This is an introductory course about algorithms and data structures. C++ is the programming language used in the course. The basics of this language will be reviewed before more difficult concepts are explored. VTC author and expert Dima Kassab will examine many topics, including: data design and implementation, primitive data structures (such as arrays and records), classes, templates, sorted and unsorted array-based lists, linked lists, doubly linked lists, stacks, queues, and binary search trees. Pick up a new programming language into the mix of new skills!- Pick up a new programming language - Increase your employability with an extra language under your belt - Learn how the different languages work to develop web site and applications - Be able to optimize your database using the structure and search features

    Read more...

  • Microsoft Visual Basic for Applications (VBA)

    Microsoft Visual Basic for Applications (VBA)

    SGD $45.00

    Course Description

    The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. 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.