PostgreSQL and MySQL for Beginners

[carxproveteran]

PostgreSQL and MySQL for Beginners​

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

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

To view the content, you need to Sign In or Register.

Click to read more...