Видео

Problem statement source: leetcode.com/problems/consecutive-numbers/ Concepts used: 1. Nested query 2. Self Join - OUTER APPLY: www.sqlshack.com/the-difference-between-cross-apply-and-outer-apply-in-sql-server/

Problem statement source: leetcode.com/problems/rising-temperature/ Concepts used: 1. Nested Query 2. Self Joins

In this video I talk about how I've seen analytics solutions evolve from inception to implementation, as well as provide a quick insight into the tasks of a few commonly encountered job roles in Big Data - Data Analyst, Insights Analyst, BI Reporting Analyst, Data Scientist and Data Engineers.

WATCH TILL THE END FOR TIPS TO OPTIMIZE QUERY!! Problem statement source: leetcode.com/problems/trips-and-users/ Write a SQL query to find the cancellation rate of requests with unbanned users (both client and driver must not be banned) each day between "2013-10-01" and "2013-10-03". Round Cancellation Rate to two decimal points. Concepts used: 1. SQL Aggregate Functions and Logical Operators 2...

Part of a series of modules designed as to Introduce Relational Database Management Systems (RDBMS) and SQL for data analytics aspirants with little or no prior coding experience. Link to Supplementary Notes: krithisudhir.com/2022/01/17/beginners-guide-to-data-analysis/ Link to MySQL Server Installation Guide (Windows): medium.com/@idatawiz/how-to-install-mysql-server-application-windows-11-eas...

Problem statement source: leetcode.com/problems/department-top-three-salaries/ A company's executives are interested in seeing who earns the most money in each of the company's departments. A high earner in a department is an employee who has a salary in the top three unique salaries for that department. Write an SQL query to find the employees who are high earners in each of the departments. C...

Part of a series of modules designed as to Introduce Relational Database Management Systems (RDBMS) and SQL for data analytics aspirants with little or no prior coding experience. Link to Supplementary Notes: krithisudhir.com/2022/01/17/beginners-guide-to-data-analysis/ Link to MySQL Server Installation Guide (Windows): medium.com/@idatawiz/how-to-install-mysql-server-application-windows-11-eas...

Part of a series of modules designed as to Introduce Relational Database Management Systems (RDBMS) and SQL for data analytics aspirants with little or no prior coding experience. Link to notes: krithisudhir.com/2022/01/17/beginners-guide-to-data-analysis/ Link to MySQL Server Installation Guide (Windows): medium.com/@idatawiz/how-to-install-mysql-server-application-windows-11-easy-installation...

Part of a series of modules designed as to Introduce Relational Database Management Systems (RDBMS) and SQL for data analytics aspirants with little or no prior coding experience. Link to notes: krithisudhir.com/2022/01/17/beginners-guide-to-data-analysis/ Link to MySQL Server Installation Guide (Windows): medium.com/@idatawiz/how-to-install-mysql-server-application-windows-11-easy-installation...

MySQL server is a popular and open-source database application, and is suitable for beginners to get acquainted with the concepts of Relational Database Systems such as: creating database schemas and tables, inserting and querying data using Structured Query Language (SQL). In this video I will walk you through the steps I used to install MySQL Server and its corresponding Workbench application...