Share this link via
Or copy link
Overview
Become an Expert in SQL and PostgreSQL: Master SQL Database Querying with PostgreSQL and PgAdmin 4 What you'll learn: Master Relational Database fundamentalsBuild a Relational Database from scratchUse SQL to perform data analysisPerform complex SQL queries using joins and subqueriesUnderstand database concepts such as database relationships and constraintsConfident putting SQL and PostgreSQL on your resumeUse Conditional Statements and Functions in SQL and PostgreSQLUnderstand and manipulate Window Functions in SQL and PostgreSQL for deeper data analysisPractice your skills with multiple...
Syllabus
- Course Introduction
- Introduction to Databases, SQL and PostgreSQL
- SQL & PostgreSQL : Data Definition Language - Creating Our Movie Database
- SQL & PostgreSQL: Data Manipulation Language
- SQL & PostgreSQL : Retrieving Data from a Table - Select Queries
- SQL & PostgreSQL : Aggregate Functions and Grouping Data
- Database Relationships
- SQL & PostgreSQL: Joining Tables
- SQL & PostgreSQL: Subqueries
- SQL & PostgreSQL: String Functions
Instructor
Jon Avis - SQL Instructor
Reviews
No reviews yet. Be the first to review!
Alternative Courses
Demystify complex big data technologies Compared to traditional data processing,...
Free
Organizations are pressured to become digital enterprises for good reason....
Free
You must be logged in to submit a review.