SQL for Data Analytics and Business Analytics

Focused View

Shishir Kumar

4:56:33

16 View

1 - Introduction

1 - Course Introduction.mp4

05:48

2 - Introduction of SQL Server.mp4

02:19

3 - SQL Server Interface.mp4

06:26

4 - Server and Database.mp4

08:15

5 - SQL Table Record Field.mp4

05:35

5 - SQL-Data.xlsx

2 - SQL Table

6 - Create Table.mp4

05:16

7 - Create Table without Create Statement.mp4

08:36

8 - Delete Table.mp4

01:27

9 - Alter Table.mp4

08:30

3 - Data Insert Import and Export

10 - Insert Data with Graphical User Interface.mp4

06:03

11 - Insert Data into Table.mp4

08:29

12 - Bulk Insert Data into Table.mp4

07:58

13 - Import Data into Table.mp4

05:30

14 - Export Data from Table.mp4

02:46

4 - Delete and Truncate

15 - Delete Data on Condition.mp4

11:07

16 - Delete Entire Data from Table.mp4

03:34

5 - Update Data

17 - Update Entire Field Data in Table.mp4

06:04

18 - Update Data on Condition.mp4

04:39

6 - Select Statement to View Data Where Clause

19 - View Data.mp4

05:45

20 - View Distinct Data.mp4

04:09

21 - View Filtered Data.mp4

02:59

7 - Filter Data with Where Clause And Or IN Between LIKE TOP Operators

22 - View Filtered Data with AND Operator.mp4

06:01

23 - View Filtered Data with OR Operator.mp4

05:42

24 - View Filtered Data with IN Operator.mp4

07:29

25 - View Filtered Data with BETWEEN Operator.mp4

08:15

26 - View Filtered Data with LIKE Operator.mp4

10:36

27 - View Top and Bottom Records with TOP Clause.mp4

07:45

8 - SQL Order By

28 - Sort Data in Ascending or Descending Orders.mp4

06:58

29 - Sort Data In Ascending Orders.mp4

03:38

30 - Sort Data in Descending Orders.mp4

02:55

9 - Group By and Having

31 - Extract Distinct Data.mp4

02:16

32 - Aggregate Data with Group By.mp4

06:01

33 - Apply Condition with Having Clause.mp4

13:54

10 - SQL Sub Query

34 - Extract Data of Max Value.mp4

05:05

35 - Extract Data of Min Value.mp4

02:07

36 - Extract Data more than Average Value.mp4

01:51

11 - SQL Joins

37 - Introduction of Join.mp4

01:35

38 - Inner Join.mp4

07:50

39 - Left Join.mp4

05:36

40 - Right Join.mp4

05:25

41 - Full Join.mp4

04:08

42 - Cross Join.mp4

04:14

43 - Self Join.mp4

16:13

12 - SQL Union

44 - Union.mp4

08:05

45 - Union ALL.mp4

04:00

46 - Intersect.mp4

03:12

47 - Except.mp4

03:06

13 - SQL Case Statement

48 - Create a Conditional Field.mp4

13:48

14 - Common Table Expression CTE

49 - Extract Product Name of 3rd Largest Sales.mp4

07:33

Description

Mastering SQL Server: A Comprehensive Guide to Database Management and Optimization

What You'll Learn?

Introduction of SQL Server
Select Statement with Multiple Scenarios
All Types of JOINS
Sub Queries with Multiple Business Scenarios

Who is this for?

This course is for them who want to mark career in Data Analytics, Business Analytics, Reporting

What You Need to Know?

No specific requirement to learn this course. This course will guide you step by step

More details

Description
Embark on a journey to become a proficient SQL user with our comprehensive course designed for beginners and advanced learners alike. Whether you are a database novice or looking to enhance your SQL skills, this course covers everything you need to know about Structured Query Language (SQL) and its application in database management.
1 Foundation of SQL:-
Â Â Â Â Â Understanding the fundamentals of relational databases.
Â Â Â Â Â Mastering the basics of SQL syntax and structure.
Â Â Â Â Â Creating and manipulating database tables.
2 Querying Data:-
Â Â Â Â Â Â Writing powerful SQL queries to retrieve and filter data.
Â Â Â Â Â Â Employing advanced querying techniques for complex data extraction.
3. Data Modification:-
Â Â Â Â Â Inserting, updating and deleting records in a table.
Â Â Â Â Â Ensuring data integrity through constraints.
4. Joins and Relationships:-
Â Â Â Â Â Exploring relationship between tables
Â Â Â Â Â Utilizing different types of joins for comprehensive data retrieval.
5 Data Aggregation and Grouping:-
Â Â Â Â Â Understanding aggregate functions for summarizing data
Â Â Â Â Â Grouping and transforming data for insightful analysis
By the end of this course, you will have the knowledge and hands-on experience to confidently work with SQL databases, manage data effectively, and optimize database performance.
Whether you are pursuing a career in database administration, data analysis BI developer.
This course equips you with the skills needed to excel in the world of databases.
Who this course is for:
This course is for them who want to mark career in Data Analytics, Business Analytics, Reporting

User Reviews

Rating

average 0

Total votes0

Focused display

Having good experience as an instructor from last 15 years. Having skillset to train in Advance Excel, VBA Macro Development, SQL Server, Ms Access, Power BI, Tableau, Python. Overall 15 years of industry experience in BI Development, Automation, Data Analytics and Data Science. Working on big data set to create report and dashboard and handling stakeholders.

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.