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.
- Multi-Node Cluster Access - 6 weeks
- Reference Material
- Practice Tasks & Exercises
- Expert Live Sessions
- Study Groups
- Guided Support
- 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
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.