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

  • Multi-Node Cluster Access - 6 weeks
  • Reference Material
  • Practice Tasks & Exercises
  • Expert Live Sessions
  • Study Groups
  • Guided Support

Pre-requisites

  • No technical prerequisites are required, however Knowledge or experience with databases is highly desired
  • Decent configuration Computer with a quality internet connection (At least 4 GB RAM and Dual Core, 8 GB RAM and Quad Core is highly desired)

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
Founder & Chief Instructor, ITVersity, Inc

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.