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

Requirements

Just a PC with any web browser

Description

6 Reasons why you should choose this SQL courseSolve complete 20 questions of 'Weather Observation Station' case study of HackerRankOther HackerRank SQL case studies we will be solvingThe Pads Binary Tree Nodes New Companies The Report Top Companies Ollivander's Inventory Challenges Contest Leaderboard Placements Symmetric Pairs SQL Project PlanningCarefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businessesComprehensive - covers basic and advanced SQL statements in both, PostgreSQL and MySQLDownloadable resources covering important topics on SQLYour queries on SQL and anything covered in the Masterclass will be responded by the Instructor himselfA Verifiable Certificate of Completion is presented to all students who undertake this SQL course.Why should you choose this course?This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. PostgreSQL and MySQL are highly desired skills for database management and data analysis roles. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.What makes us qualified to teach you?The course is taught by Abhishek, Pukhraj and Nadeem. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced SQL, PostgreSQL, MySQL, database management, and various data analysis tools available in the market.Our PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.By the end of this course, your confidence in using SQL will soar. You'll have a thorough understanding of how to use SQL for Data analytics as a career opportunity.Go ahead and click the enroll button, and I'll see you in lesson 1!CheersStart-Tech AcademyFAQ'sWhy learn SQL?SQL is the most universal and commonly used database language. It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put, If you want to access databases then yes, you need to know SQL.It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people to get interesting data from the database. It is also an English-like language so anyone who can use English at a basic level can write SQL queries easily.SQL is one of the most sought-after skills by hiring employers.You can earn good moneyHow much time does it take to learn SQL?SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.What's the difference between SQL and PostgreSQL?SQL is a language. Specifically, the "Structured Query Language"PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.Which is better, PostgreSQL or MySQL?Both are excellent products with unique strengths, and the choice is often a matter of personal preference.PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.Open source development will bring more features to subsequent releases of both databases.Who uses these databases?Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.Companies that use MySQL: Uber, Airbnb, Netflix, Udemy, Pinterest etc.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Course Resources

Lecture 2 Course Resources

Lecture 3 This is a milestone!

Section 3: HackerRank - Weather Observation Station 20 questions

Lecture 4 Weather Observation Station 1 - 15 points - EASY level

Lecture 5 Weather Observation Station 2 - 15 points - EASY level

Lecture 6 Weather Observation Station 3 - 10 points - EASY level

Lecture 7 Weather Observation Station 4 - 10 points - EASY level

Lecture 8 Weather Observation Station 5 - 30 points - EASY level

Lecture 9 Weather Observation Station 6 - 10 points - EASY level

Lecture 10 Weather Observation Station 7 - 10 points - EASY level

Lecture 11 Weather Observation Station 8 - 15 points - EASY level

Lecture 12 Weather Observation Station 9 - 10 points - EASY level

Lecture 13 Weather Observation Station 10 - 10 points - EASY level

Lecture 14 Weather Observation Station 11 - 15 points - EASY level

Lecture 15 Weather Observation Station 12 - 15 points - EASY level

Lecture 16 Weather Observation Station 13 - 10 points - EASY level

Lecture 17 Weather Observation Station 14 - 10 points - EASY level

Lecture 18 Weather Observation Station 15 - 15 points - EASY level

Lecture 19 Weather Observation Station 16 - 10 points - EASY level

Lecture 20 Weather Observation Station 17 - 15 points - EASY level

Lecture 21 Weather Observation Station 18 - 25 points - MEDIUM level

Lecture 22 Weather Observation Station 19 - 30 points - MEDIUM level

Lecture 23 Weather Observation Station 20 - 40 points - MEDIUM level

Section 4: HackerRank - Medium & Hard questions

Lecture 24 The Pads - 30 points - MEDIUM level

Lecture 25 Binary Tree Nodes - 30 points - MEDIUM level

Lecture 26 New Companies - 30 points - MEDIUM level

Lecture 27 The Report - 20 points - MEDIUM level

Lecture 28 Top Companiess - 30 points - MEDIUM level

Lecture 29 Ollivander's Inventory - 30 points - MEDIUM level

Lecture 30 Challenges - 30 points - MEDIUM level

Lecture 31 Contest Leaderboard - 30 points - MEDIUM level

Lecture 32 Placements - 40 points - MEDIUM level

Lecture 33 Symmetric Pairs - 40 points - MEDIUM level

Lecture 34 SQL Project Planning - 40 points - MEDIUM level

Section 5: Setting up PostgreSQL and PGAdmin

Lecture 35 Installing PostgreSQL and pgAdmin in your PC

Lecture 36 If pgAdmin is not opening…

Section 6: Installing MySQL

Lecture 37 Installing and Setting up MySQL

Section 7: Fundamental SQL statements

Lecture 38 CREATE in PostgreSQL

Lecture 39 CREATE in MySQL

Lecture 40 INSERT in PostgreSQL

Lecture 41 INSERT in MySQL

Lecture 42 Import data from File in PostgreSQL

Lecture 43 Import data from File in MySQL

Lecture 44 SELECT statement in PostgreSQL

Lecture 45 SELECT statement in MySQL

Lecture 46 SELECT DISTINCT in PostgreSQL

Lecture 47 SELECT DISTINCT in MySQL

Lecture 48 WHERE in PostgreSQL

Lecture 49 WHERE in MySQL

Lecture 50 Logical Operators in PostgreSQL

Lecture 51 Logical Operators in MySQL

Lecture 52 UPDATE in PostgreSQL

Lecture 53 UPDATE in MySQL

Lecture 54 DELETE in PostgreSQL

Lecture 55 DELETE in MySQL

Lecture 56 ALTER Part 1 in PostgreSQL

Lecture 57 ALTER Part 2 in PostgreSQL

Lecture 58 ALTER in MySQL

Section 8: Restore and Back-up in PostgreSQL

Lecture 59 Restore and Back-up

Lecture 60 Debugging restoration issues

Lecture 61 Creating DB using CSV files

Lecture 62 Debugging summary and Code for CSV files

Section 9: Restore and Back-up in MySQL

Lecture 63 Restoring and Back-up in MySQL

Lecture 64 Restore and Back-up in MySQL

Section 10: Selection commands: Filtering

Lecture 65 IN in PostgreSQL

Lecture 66 IN in MySQL

Lecture 67 BETWEEN in PostgreSQL

Lecture 68 BETWEEN in MySQL

Lecture 69 LIKE in PostgreSQL

Lecture 70 LIKE in MySQL

Section 11: Selection commands: Ordering

Lecture 71 Side Lecture: Commenting in SQL

Lecture 72 ORDER BY in PostgreSQL

Lecture 73 ORDER BY in MySQL

Lecture 74 LIMIT in PostgreSQL

Lecture 75 LIMIT in MySQL

Section 12: Aliases

Lecture 76 AS in PostgreSQL

Lecture 77 AS in MySQL

Section 13: Aggregate Commands

Lecture 78 COUNT in PostgreSQL

Lecture 79 COUNT in MySQL

Lecture 80 SUM in PostgreSQL

Lecture 81 SUM in MySQL

Lecture 82 AVERAGE in PostgreSQL

Lecture 83 AVERAGE in MySQL

Lecture 84 MIN & MAX in PostgreSQL

Lecture 85 MIN & MAX in MySQL

Section 14: Group By Commands

Lecture 86 GROUP BY in PostgreSQL

Lecture 87 GROUP BY in MySQL

Lecture 88 HAVING in PostgreSQL

Lecture 89 HAVING in MySQL

Section 15: Conditional Statement

Lecture 90 CASE WHEN in PostgreSQL

Lecture 91 CASE WHEN in MySQL

Section 16: JOINS

Lecture 92 Introduction to Joins

Lecture 93 Concepts of Joining and Combining Data

Lecture 94 Preparing the data

Lecture 95 Inner Join in PostgreSQL

Lecture 96 Inner Join in MySQL

Lecture 97 Left Join in PostgreSQL

Lecture 98 Left Join in MySQL

Lecture 99 Right Join in PostgreSQL

Lecture 100 Right Join in MySQL

Lecture 101 Full Outer Join in PostgreSQL

Lecture 102 Full Outer Join in MySQL

Lecture 103 Cross Join in PostgreSQL

Lecture 104 Cross Join in MySQL

Lecture 105 Intersect and Intersect ALL in PostgreSQL

Lecture 106 Intersect in MySQL

Lecture 107 Except in PostgreSQL

Lecture 108 Except in MySQL

Lecture 109 Union in PostgreSQL

Lecture 110 Union in MySQL

Section 17: Subqueries

Lecture 111 Subqueries: Subquery in WHERE clause in PostgreSQL

Lecture 112 Subqueries: Subquery in FROM clause in PostgreSQL

Lecture 113 Subqueries: Subquery in SELECT in PostgreSQL

Lecture 114 Subqueries in MySQL

Section 18: Views and Indexes

Lecture 115 VIEWS in PostgreSQL

Lecture 116 VIEWS in MySQL

Lecture 117 INDEX in PostgreSQL

Lecture 118 INDEX in MySQL

Section 19: String Functions

Lecture 119 LENGTH in PostgreSQL

Lecture 120 UPPER LOWER in PostgreSQL

Lecture 121 REPLACE in PostgreSQL

Lecture 122 TRIM, LTRIM, RTRIM in PostgreSQL

Lecture 123 CONCATENATION in PostgreSQL

Lecture 124 SUBSTRING in PostgreSQL

Lecture 125 LIST AGGREGATION in PostgreSQL

Lecture 126 String Functions Part 1 in MySQL

Lecture 127 String Functions Part 2 in MySQL

Section 20: Mathematical Functions

Lecture 128 CEIL & FLOOR in PostgreSQL

Lecture 129 RANDOM in PostgreSQL

Lecture 130 SETSEED in PostgreSQL

Lecture 131 ROUND in PostgreSQL

Lecture 132 POWER in PostgreSQL

Lecture 133 Mathematical Functions in MySQL

Section 21: Date-Time Functions

Lecture 134 CURRENT DATE & TIME in PostgreSQL

Lecture 135 AGE in PostgreSQL

Lecture 136 EXTRACT in PostgreSQL

Lecture 137 Date-Time Functions in MySQL

Section 22: Data type Conversion

Lecture 138 Data Type conversion to string in PostgreSQL

Lecture 139 Data Type conversion to Number and Date in PostgreSQL

Lecture 140 Data Type conversion in MySQL

Section 23: PATTERN (STRING) MATCHING

Lecture 141 PATTERN MATCHING BASICS

Lecture 142 Advanced pattern matching Part 1 (REGULAR EXPRESSIONS)

Lecture 143 Advanced pattern matching Part 2 (REGULAR EXPRESSIONS)

Lecture 144 Pattern matching in MySQL

Section 24: Congratulations

Lecture 145 The final milestone!

Lecture 146 Bonus Lecture

Working Professionals beginning their Data journey,Anyone curious to learn and compare both PostgreSQL and MySQL,Students about to join their first corporate job