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

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?

• 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

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