SQL and PostgreSQL for Beginners: Become an SQL Expert

Become an Expert in SQL and PostgreSQL: Master SQL with PostgreSQL and PgAdmin 4

Created by: Jon Avis - SQL Instructor
IT Systems Engineer and SQL Instructor

What Will I Learn?

• Master Relational Database fundamentals
• Build a Relational Database from scratch
• Use SQL to perform data analysis
• Perform complex SQL queries using joins and subqueries
• Understand database concepts such as database relationships and constraints
• Use Conditional Statements and Functions in SQL and PostgreSQL
• Understand and manipulate Window Functions in SQL and PostgreSQL for deeper data analysis
• Apply your SQL skills with multiple challenges throughout the course
• Feel confident putting SQL and PostgreSQL on your resume

Requirements

• No previous knowledge of SQL or PostgreSQL is needed for this course.
• A Mac, Windows or Linux-based Computer

Target audience

• Anyone interested in learning SQL or PostgreSQL
• Anyone that is interested in data analysis, data science and data analytics