Join today
Mastering SQL using Postgres
Build key skills such as how to create database objects, write effective queries from basic to advance, and many more using Postgres with expert led online videos, tons of practice task and exercises, and multi-node cluster lab for hands on practice.
Write your awesome label here.
Beginner Level
14hrs Time
Flexible Schedule
What’s Included
Pre-requisites
About this course
This course is primarily designed to go through
basic and advanced SQL using Postgres Database. You will be learning all the aspects
from connecting database, loading and writing basic operations to writing
advanced operations of SQL as well as Postgres Database.
What you’ll learn in this Course
-
Ability to interpret data models
-
Using database IDEs to interact with databases.
-
Data loading strategies to load data into database tables
-
Write SQL queries from basic to advance
-
Ability to create tables, partition tables, indexes, etc.
-
Understand and use constraints effectively based upon the requirements.
-
Effective usage of functions provided by PostgreSQL
-
Ability to write queries using advanced features such as Analytic Functions.
-
Differences between RDBMS and Data Warehouse concepts by comparing PostgreSQL with Redshift
Durga Gadiraju
Technology Adviser and Evangelist with 20+ years of IT experience in
executing complex projects using a vast array of technologies including Big
Data and Cloud.