SQL Challenges: Learn SQL by solving challenging problems

SQL Challenges: Learn SQL by solving challenging problems, available at $44.99, has an average rating of 4.2, with 16 lectures, based on 12 reviews, and has 129 subscribers.

You will learn about Build SQL queries for challenging real world problems Understand usage of JOINS Understand usage of aggregate functions Build SQL queries that group data Build SQL queries to retrieve specific records from table Develop advanced SQL querying skills This course is ideal for individuals who are SQL Beginners and Intermediate or Beginner and Intermediate Data Analyst or Beginner and Intermediate Data Scientist or Beginner and Intermediate Software Developer or Beginner and Intermediate Database Administrator or Beginner and Intermediate to Data Warehouse It is particularly useful for SQL Beginners and Intermediate or Beginner and Intermediate Data Analyst or Beginner and Intermediate Data Scientist or Beginner and Intermediate Software Developer or Beginner and Intermediate Database Administrator or Beginner and Intermediate to Data Warehouse.

Enroll now: SQL Challenges: Learn SQL by solving challenging problems

Summary

Title: SQL Challenges: Learn SQL by solving challenging problems

Price: $44.99

Average Rating: 4.2

Number of Lectures: 16

Number of Published Lectures: 16

Number of Curriculum Items: 16

Number of Published Curriculum Objects: 16

Original Price: ₹999

Quality Status: approved

Status: Live

What You Will Learn

Build SQL queries for challenging real world problems
Understand usage of JOINS
Understand usage of aggregate functions
Build SQL queries that group data
Build SQL queries to retrieve specific records from table
Develop advanced SQL querying skills

Who Should Attend

SQL Beginners and Intermediate
Beginner and Intermediate Data Analyst
Beginner and Intermediate Data Scientist
Beginner and Intermediate Software Developer
Beginner and Intermediate Database Administrator
Beginner and Intermediate to Data Warehouse

Target Audiences

SQL Beginners and Intermediate
Beginner and Intermediate Data Analyst
Beginner and Intermediate Data Scientist
Beginner and Intermediate Software Developer
Beginner and Intermediate Database Administrator
Beginner and Intermediate to Data Warehouse

SQL is most popular RDBMS programming language. It is a domain specific language used in programming and designed for managing data stored in RDBMS.

In this course you will solve 120 challenging SQL problems varying from beginner, intermediate to advanced levels. This course is very practical and hands-on, it will hone your SQL skills to the next level and also help you in your daily work. So whether you are a Data Analyst, Data Scientist, DBA or Backend Developer this course will be super beneficial for you.

In this course we will be solving problems on the Northwind and AdventureWorks2012 database, and also along with that we will also solve some HackerRank SQL challenges.

This course is meant for all levels, so whether you are a beginner, intermediate or advanced you can still take this course.

The topics covered in this course are :

– SELECT, WHERE, GROUP BY, ORDER BY

– Understanding JOINS – FULL JOIN, LEFT JOIN, RIGHT JOIN, INNER JOIN

– Using CTE (Common Table Expression)

– Using Subqueries in SQL

By the end of this course you will have improved SQL skills and have a better understanding of SQL concepts like JOINS, aggregate functions, WHERE clause, GROUP BY, ORDER BY, UNION, Subquery expression, CTE (Common Table Expression) etc.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: SQL Server 2019 Express Edition and SSMS Installation

Chapter 2: SQL Refresher

Lecture 1: SQL Refresher

Chapter 3: Northwind Database Challenges

Lecture 1: Importing Northwind Database into SQL Server 2019

Lecture 2: Beginner Level Problems – Part 1

Lecture 3: Beginner Level Problems – Part 2

Lecture 4: Intermediate Level Problems – Part 1

Lecture 5: Intermediate Level Problems – Part 2

Lecture 6: Advanced Level Problems – Part 1

Lecture 7: Advanced Level Problems – Part 2

Chapter 4: AdventureWorks2012 Challenges

Lecture 1: Importing AdventureWorks2012 Database into SQL Server 2019

Lecture 2: Beginner Level Problems – Part 1

Lecture 3: Beginner Level Problems – Part 2

Chapter 5: HackerRank SQL Challenges

Lecture 1: Beginner Level Problems – Part 1

Lecture 2: Beginner Level Problems – Part 2

Lecture 3: Intermediate Level Problems

Instructors

Clone Factory
Learn coding the right way.

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 6 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu