PostgreSQL and MySQL for Beginners - Learn most popular SQL dialects, PostgreSQL & MySQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MySQL
New, Created by Start-Tech Trainings, Start-Tech Academy
What you'll 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
Preview this Course