PostgreSQL and MySQL for Beginners

Learn most popular SQL dialects, PostgreSQL & MySQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MySQL

Created by: Start-Tech Trainings
Analytics and ML academy

Created by: Start-Tech Academy
5,000,000+ Enrollments | 4.5 Rated | 160+ Countries

What Will I Learn?

• How to write SELECT queries to fetch relevant data in PostgreSQL and MySQL
• How to filter and sort the data using WHEN, logical operators and ORDER BY
• How to group and aggregate data in PostgreSQL and MySQL
• How to apply joins and combining queries in PostgreSQL and MySQL
• String, mathematical, date-time functions and pattern matching in PostgreSQL and MySQL
• Understanding of VIEWS and INDEXES in PostgreSQL and MySQL
• How to write subqueries in PostgreSQL and MySQL

Requirements

• Just a PC with any web browser

Target audience

• Working Professionals beginning their Data journey
• Anyone curious to learn and compare both PostgreSQL and MySQL
• Students about to join their first corporate job