SQL interview questions with business scenarios

Focused View

Compylo Ed-Tech Private Limited,S K

5:40:22

139 View

1. Introduction

1. Introduction.mp4

02:19

2. Thanks Lets get started!.mp4

00:52

2. SQL Questions

1.1 Business Scenario - The Maximum Value.pdf

1.2 maximum value.zip

1. The Maximum Value.mp4

13:06

2.1 a percentage problem.zip

2.2 Business Scenario - A Percentage Problem.pdf

2. A Percentage Problem.mp4

06:35

3.1 Business Scenario - The Low Salary Situation.pdf

3.2 the low salary situation.zip

3. The Low Salary Situation.mp4

11:26

4.1 Default Join in SQL Server.txt

4.2 top ctc guys.zip

4. Top CTC Guys.mp4

14:23

5.1 the early joiners.zip

5. The Early Joiners.mp4

05:30

6.1 the from and to.zip

6. The FROM and TO.mp4

03:03

7.1 glamorous question 1.zip

7. Glamorous Question 1.mp4

03:42

8.1 glamorous question 2.zip

8. Glamorous Question 2.mp4

04:51

9.1 glamorous question 3.zip

9. Glamorous Question 3.mp4

11:04

10.1 Default Databases.pdf

10. Glamorous Question 4.mp4

07:12

11.1 Business Scenario - The CTE - Part 1.pdf

11.2 the cte - part 1.zip

11. The CTE - Part 1.mp4

08:03

12.1 Business Scenario - The CTE - Part 2.pdf

12.2 the cte - part 2.zip

12. The CTE - Part 2.mp4

12:01

13.1 Business Scenario - Date Problem 1.pdf

13.2 date problem 1.zip

13. Date Problem 1.mp4

12:40

14.1 date problem 2.zip

14. Date Problem 2.mp4

04:46

15.1 Business Scenario - Date Problem 3.pdf

15.2 date problem 3.zip

15. Date Problem 3.mp4

24:51

16.1 who earns more.zip

16. Who Earns More.mp4

06:38

17.1 a scenario of joins with and.zip

17. A Scenario of JOINs with AND.mp4

07:47

18.1 Business Scenario - Limit Unlimited.pdf

18.2 limit unlimited.zip

18. Limit Unlimited.mp4

06:48

19.1 handle - data in csv format.zip

19. Handle - Data in CSV format.mp4

14:46

20.1 keep your basics strong 1.zip

20. Keep Your Basics Strong 1.mp4

04:54

21.1 Business Scenario - Keep Your Basics Strong 2.pdf

21.2 keep your basics strong 2.zip

21. Keep Your Basics Strong 2.mp4

08:32

22.1 keep your basics strong 3.zip

22. Keep Your Basics Strong 3.mp4

05:55

23.1 keep your basics strong 4.zip

23. Keep Your Basics Strong 4.mp4

04:34

24.1 add a column.zip

24.2 Business Scenario - Add A Column.pdf

24. Add a Column!.mp4

10:39

25. Whats Wrong.mp4

02:30

26.1 the cut-off.zip

26. The Cut-Off!.mp4

10:59

27.1 Business Scenario - Lets Deliver Something.pdf

27.2 lets deliver something.zip

27. Lets Deliver Something!.mp4

09:04

28.1 be prudent while answering.zip

28.2 Business Scenario - Be Prudent While Answering.pdf

28. Be Prudent While Answering.mp4

04:56

29.1 to check your thinking.zip

29. To Check Your Thinking.mp4

08:37

30.1 Business Scenario - Create With Existing.pdf

30.2 create with existing.zip

30. Create With Existing.mp4

09:32

31.1 Business Scenario - The Two Brothers.pdf

31.2 the two brothers.zip

31. The Two Brothers.mp4

08:51

32.1 a less common thing.zip

32.2 Business Scenario - A Less Common Thing.pdf

32. A Less Common Thing.mp4

07:44

33.1 old vs new way.zip

33. Old Vs New Way.mp4

09:51

34.1 when your manager can come home for evening tea.zip

34. When Your Manager Can Come Home For Evening Tea!.mp4

08:28

35.1 Business Scenario - The Stored Procedure.pdf

35.2 the stored procedure.zip

35. The Stored Procedure.mp4

11:10

36.1 Business Scenario - Lets Forget Old One.pdf

36.2 lets forget old one.zip

36. Lets Forget Old One.mp4

05:41

37.1 Best Practices for Writing SQL.pdf

37. Performance is Important.mp4

16:42

3. Lets finish it in style!

1. Lets learn additional things!.html

2.1 compylo sql interviewquestions.zip

2. Compylo SQL Interview Questions Database.mp4

03:07

3. How To Upload CSVExcel Data in SQL.mp4

05:13

4.1 What a SQL Developer does in office.pdf

4. What A SQL Developer Does in Office.mp4

01:00

Description

Crack SQL interview with confidence

What You'll Learn?

Most popular SQL interview questions along with their solutions
Business scenarios of SQL interview questions
Important SQL concepts to use while working in industry
Best practices to follow along with what a SQL developer does in office

Who is this for?

Beginner to intermediate level data analysts, data engineers and software developers

More details

Description
This course is based on SQL interview questions and answers for freshers as well as experienced professionals with examples of live SQL queries.
Though Structured query language or SQL is ~50 years old but Microsoft SQL Server came into existence in the late 80s. Nowadays, we use SQL Server Management Studio, i.e., SSMS to write SQL queries (also called T-SQL) and after the advent of its cloud computing offering called Microsoft Azure, role of SSMS has been extended as it can connect to Azure SQL and Azure Synapse servers and run SQL queries.
You can register for this course if you want to know the SQL Interview Questions based on popular concepts like Common Table Expressions (also known as CTEs), Joins (Like Inner Join, Left Join), Subquery, Distinct, Top, Pivot and Unpivot in SQL, Store Procedures etc. along with their possible business scenarios. Although SQL is quite common topic in data analyst courses and it is an important part of data engineering roadmap (as you can use SQL in Databricks too!), full stack developers and software testers are also required to know the concepts of relational database and SQL.
Let us start SQL practice with MSSQL to do well in interviews!
Who this course is for:
Beginner to intermediate level data analysts, data engineers and software developers

User Reviews

Rating

average 0

Total votes0

Focused display

Compylo aims to provide quality knowledge to all the prospective students with best possible examples which may enhance their ability to tackle real world problems. We are a registered company and work in the field of education, guiding students for their career, suggesting them on CVs and helping them in landing with best possible job for them.

S K

Instructor's Courses

Working as a BI consultant, having 8+ years of industry experience, having done multiple live projects in various domains like Manufacturing, Retail, Banking etc. utilizing various ETL and reporting tools such as Power BI(Certified), Tableau(Certified) , MSBI DWH and Alteryx. Looking forward to share my knowledge with other aspiring techies to get better understanding of technologies and gain practical exposure

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.