Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Programming

/

Database

Practical SQL with HackerRank for SQL Beginners

The goal of this course is for you to efficiently learn SQL, apply it directly to practical work, and quickly develop data analysis skills. Let's grasp essential SQL fundamental concepts through solving Hackerrank problems, immediately apply them to real-world tasks, and truly enhance your skills.

(5.0) 4 reviews

56 learners

  • growglobally
sql
mysql
dbms/rdbms
코딩테스트
SQL
MySQL
DBMS/RDBMS
Coding Test

Reviews from Early Learners

What you will learn!

  • I can understand the essential basic concepts of SQL.

  • You can learn it today and immediately apply it to your work tomorrow.

  • Practice SQL with HackerRank and add stars and badges to your resume.

Learn SQL basics while solving problems!

I want to learn data analysis
Do you feel like it's too difficult?

Learn SQL today, use it tomorrow
Essential concepts organized into 6 types!

  • Quickly learn essential SQL basic concepts with problem solving!
  • HackerRank Easy Difficulty: About 40 questions are divided into 6 types, and the concepts are organized and solved.

Hello, this is Yangyang! 🙋‍♀️

When I was a junior working as a data analyst in the consumer goods industry of a foreign company, I was obsessed with learning various data analysis languages and tools and obtaining certifications. However, although the certifications were recognized as specifications and helpful when I was hired, they were not of much help when I was actually applying them to work or changing jobs. As I gained experience and moved to a new company, what helped me the most was whether I had the ability to apply them immediately to work, rather than the certifications.

Learn SQL for data analysis quickly and use it well!

The goal of this course is for SQL beginners to learn efficiently and apply SQL to their work, reduce trial and error, and quickly acquire data analysis capabilities. Solve HackerRank problems to understand the essential basic concepts of SQL, apply them to work right away, and improve your real data analysis skills.


6 types at once
You can learn SQL concepts.

1. SQL query writing order
Total 9 problem solving questions

  • SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT queries

2. Functions and Operators
Problem solving: 14 questions in total

  • Numeric functions, character functions, data type conversion functions
  • Understand comparison, arithmetic, logical, special, and set operators

3. CASE WHEN statement
Problem solving: 1 question total

  • How to create new columns based on conditions

4. Simple wildcards
Problem solving: 7 questions in total

  • Simple Wildcards (SQL Wildcards)

5. Subquery
Problem solving: 4 questions in total

  • Using subqueries in the FROM and WHERE clauses

6. JOIN
Problem solving: 3 questions total

  • INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

I recommend this to these people 🙆‍♀️

  • For those who are new to SQL
  • For those who want to quickly learn the essential basic concepts of SQL
  • Anyone who wants to go from being a complete beginner to a complete beginner in SQL
  • Anyone who wants to learn SQL today and use it tomorrow
  • For those who want to learn SQL concepts and solve practical problems
  • Job seekers, new hires, and juniors interested in data analysis
  • Non-majors who want to be recognized for their data analysis skills at work
  • For those who want to quickly review basic concepts before moving on to HackerRank Medium and Hard

I don't recommend these people 🙅‍♀️

  • For those who are intermediate to advanced level in SQL
  • Anyone who wants to solve HackerRank Medium, Hard difficulty level
  • Anyone who wants to learn SQL beyond what is stated in the curriculum
  • Data Analysis Major
  • For those who want to learn about date functions and window functions (HackerRank Medium, Hard difficulty)

After taking this course, you will be able to do things like this!

  • You can learn essential SQL concepts by solving practical problems.
  • About 40 questions are categorized into 6 types and concepts and problem solving are conducted together.
  • Even after class, you can solve Hacker Rank Easy problems on your own.
  • Practice SQL with Hacker Rank and add stars and badges to your resume.

From real data analysis
Let me tell you about my experience.

  • (Current) Data Analytics Bootcamp Instructor
  • (Former) Analytics & Insights Manager at a foreign consumer goods company
  • Graduated from the Department of Statistics
  • SQL (Get SQLD)
  • Tableau (obtained Tableau Desktop Specialist)
  • Python (Big Data Analysis Engineer, ADP Written Exam Passed)
  • R (ADsP Acquisition)
  • SPSS (Level 2 Social Survey Analyst)
  • In addition, extensive experience using Excel, Power BI, etc.

Q&A 💬

Q. Do I need to download a specific program to take the course?

No, but I encourage you to sign up for HackerRank (www.hackerrank.com), which will be used in the course, and take a look around.

Q. Which SQL is it based on?

This course uses SQL based on MySQL from the HackerRank site.

📢 Please check before taking the class.

  • Please prepare a laptop PC and an environment with good Wi-Fi for the practice environment. The class will be conducted based on SQL questions corresponding to the Easy level of HackerRank (www.hackerrank.com).
  • This is not a lecture that uses MySQL tools directly. Problems based on MySQL are solved using HackerRank.

Recommended for
these people

Who is this course right for?

  • Beginners to SQL

  • People who have no experience with SQL

  • For those who want to quickly learn essential SQL basic concepts.

  • For those who want to evolve from a complete SQL beginner to a beginner.

  • Someone who is learning SQL for the first time but wants to learn it today and use it tomorrow.

  • For those who want to learn SQL concepts and experience solving real-world problems.

  • Job seekers, new hires, and junior-level professionals interested in data analysis, anyone is welcome.

Need to know before starting?

  • Those who have experience using Excel will understand this more easily.

Hello
This is

56

Learners

4

Reviews

1

Answers

5.0

Rating

1

Course

Curriculum

All

46 lectures ∙ (3hr 30min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

5.0

4 reviews

  • 이종운님의 프로필 이미지
    이종운

    Reviews 34

    Average Rating 5.0

    5

    100% enrolled

    훌륭한 강의 감사합니다

    • 김남주님의 프로필 이미지
      김남주

      Reviews 2

      Average Rating 5.0

      5

      96% enrolled

      ......

      • chlgnfka님의 프로필 이미지
        chlgnfka

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        기초를 다지기에 좋았습니다.

        • Yongje Jang님의 프로필 이미지
          Yongje Jang

          Reviews 3

          Average Rating 5.0

          5

          76% enrolled

          선생님께서 설명을 잘해주십니다. hackerrank에서 문제를 풀어보면서 분석해주시는데 하기 링크의 사이트에서 내가 생각하는것과 비교하면... 얻어가는것이 많을것이다.

          Limited time deal ends in 23:25:38

          $24,750.00

          25%

          $26.40

          Similar courses

          Explore other courses in the same field!