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

  • FileMaker Pro 12: Intermediate

    FileMaker Pro 12: Intermediate

    SGD $80.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 intermediate level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys, deleting duplicate records and new FileMaker Pro 11 features. 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...

  • Database Optimization

    Database Optimization

    SGD $45.00

    Course Description

    This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Work files are included. Learn how you can manage your database from becoming redundant. - Find out how you can mange your database- Learn ways to fully utlize your data's potential - Know how to analyze reports from your data - Learn how to apply formula, queries and commands into your database This course is SkillsFuture Credit Eligible.

    Read more...

  • Cakewalk SONAR X1 Producer Edition: Know how to work with audio

    Cakewalk SONAR X1 Producer Edition: Know how to work with audio

    SGD $54.00

    Course Description

    Cakewalk SONAR X1 is the most recent update in a long line of full-featured Digital Audio Workstations on the cutting edge of audio production. Packaged with one of the largest set of features and tools in any audio application, it can be overwhelming to master. Sam McGuire, audio engineer, author, and educator, explains Sonar using a variety of examples and real world work flows. Follow along using the provided work files and explore the multifaceted features of Sonar with Sam as your guide. Both first-time Sonar users who are trying to figure out basic tasks and experienced veterans who are looking to explore the latest features will find just what they are looking for in this VTC course. Create your own original works with Cakewalk SONAR!- Learn the tools and techniques of Cakewalk SONAR- Know how to enhance audio files with Cakewalk SONAR- Discover the secrets of producing a quality audio files- Learn the ropes of creating your own master piece with 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.