ZMedia Purwodadi

SQL HackerRank Challenge: Get Gold star & 670 points

Table of Contents
SQL HackerRank Challenge: Get Gold star & 670 points

SQL HackerRank Challenge: Get Gold star & 670 points - 
Learn complete MySQL & PostgreSQL. Solve HackerRank problems to get Gold star and 670 points in SQL HackerRank


What you'll learn
  • Get silver and gold rank with 600+ points
  • Solve 30+ questions of HackerRank SQL section
  • 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