Introduction to PostgreSQL

Price
$2,000.00 USD

Duration
2 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

Modern companies are generating more data every day, and key competitive advantages will stem from being able to query and understand this data. Data is often stored in relational databases, which are queried using a specific language: SQL. SQL, which stands for Structured Query Language, allows communication with relational databases and is one of the most demanded tech skills of the 21st century.

Private classes on this topic are available. We can address your organization’s issues, time constraints, and save you money, too. Contact us to find out how.

This course includes 6-months access to the full course content in on-demand format to support post-class reference and review.

Course Objectives

Get started with PostgreSQL and PgAdmin
two of the world's most popular SQL tools
Learn the basics of SQL syntax
Analyze data using aggregate functions with GROUP BY commands
Run advanced queries with string operations and comparison operations
Learn to use logical operators to add logic flow to your SQL queries
Learn common SQL JOIN commandsv
Learn to create tables and databases with constraints on data entries

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Course Prerequisites

There are no prerequisites for this course.

Agenda

SQL Syntax

Setup of PostgreSQL

Setup of PgAdmin – a powerful administration tool

Use SQL to query data:

Data Extraction from databases
GroupBy for data aggregation
Merging data via Joins
Advanced queries, such as comparisons
Using logical operators to add logical flow
Conditional expressions

Creation of databases and tables

Data Types
Primary and Foreign Keys
Data Insertion
Data Alteration
Data Deletion
Administration

Combination of PostgreSQL and Python

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

Do You Have Additional Questions? Please Contact Us Below.

Contact Us about Starting Your Business Training Strategy with New Horizons