Learn concepts & compare syntax of 4 popular SQL dialects- PostgreSQL, MySQL, Microsoft SQL & Oracle SQL | SQL Bundle
What you will learn
Noteβ Make sure your ππππ¦π² cart has only this course you're going to enroll it now, Remove all other courses from the ππππ¦π² cart before Enrolling!
How to write SELECT queries to fetch relevant data in 4 SQL dialects – PostgreSQl, MySQL, Oracle SQL and Microsoft SQL
How to filter and sort the data using WHEN, logical operators and ORDER BY
How to group and aggregate data in PostgreSQl, MySQL, Oracle SQL and Microsoft SQL
How to apply joins and combining queries in 4 SQL dialects – PostgreSQl, MySQL, Oracle SQL and Microsoft SQL
String, mathematical, date-time functions and pattern matching in 4 SQL dialects – PostgreSQl, MySQL, Oracle SQL and Microsoft SQL
Understanding of VIEWS and INDEXES in 4 SQL dialects – PostgreSQl, MySQL, Oracle SQL and Microsoft SQL
How to write subqueries in SQL
English
language