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

  • Produce Dynamic Presentation Slides with Microsoft PowerPoint 2013

    Produce Dynamic Presentation Slides with Microsoft PowerPoint 2013

    SGD $45.00

    Course Description

    This VTC course provides students with the knowledge and skills to use Microsoft PowerPoint 2013 for creating and making presentations. The course moves from a study of the PowerPoint interface through creating presentations with an eye towards reusing already created content whenever possible. You will learn how to add smart art objects, images, drawings, charts, and a/v content to slides. You will also learn about SkyDrive and the PowerPoint WebApp. There is a focus on using those PowerPoint features that are appropriate to the audience and presentation location. Helen Bradley teaches this course from a business perspective, introducing tools that can be used to ensure that PowerPoint presentations are consistently formatted and easy to update. She covers formatting data in tables, using the photo album tool, working with multimedia objects, and preparing a slide show for presentation. 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 

    Read more...

  • EXIN Cloud Computing

    EXIN Cloud Computing

    SGD $299.00

    Course Description

    Exin's Cloud Computing Foundation is not only a technical cloud course, but focuses on the business and management side of cloud computing as well. This course also examines the auditing and service response within cloud computing, as well the delegation of IT responsibilities within an eviroment focused on cloud technology. This course covers how cloud technology deals with a variety of different areas, including: Hardware, Software, Processes, OS and Application Licenses, People, Power and Backups. Understand how Cloud Computing works! - Know what exactly is Cloud Computing - Understand the concept of Cloud Computing  - Understand how Cloud is applied in today's IT  - Catch onto the advantages of Cloud 

    Read more...

  • 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...


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.