SQL for Data Analyst, Business Analyst and BI Developer

Focused View

Shishir Kumar

6:35:14

9 View

1 - Introduction

1 - Introduction of SQL Server.mp4

02:19

2 - SQL Server Installation.mp4

04:39

3 - SQL Server Interface.mp4

06:26

4 - Server and Database.mp4

08:15

5 - Table Record Field.mp4

05:35

2 - Database

6 - Create Database.mp4

02:17

7 - Delete Database.mp4

02:05

8 - Activate Database.mp4

01:29

9 - Full Database Backup.mp4

07:08

3 - Table

10 - Create Table.mp4

05:16

11 - Delete Table.mp4

01:27

12 - Alter Table.mp4

08:30

4 - Data Insert Import and Export

13 - Insert Data with Graphical User Interface.mp4

06:03

14 - Insert Data into Table.mp4

08:29

15 - Bulk Insert Data into Table.mp4

07:58

16 - Import Data into Table.mp4

05:30

17 - Export Data from Table.mp4

02:46

5 - Delete and Truncate

18 - Delete Data on Condition.mp4

11:07

19 - Delete Entire Data from Table.mp4

11:07

6 - Update Data

20 - Update Entire Field Data in Table.mp4

06:04

21 - Update Data on Condition.mp4

04:39

22 - Update Single Column Data from Another Table.mp4

07:45

23 - Update Multiple Columns Data from Another Table.mp4

06:38

7 - Select Statement to View Data Where Clause

24 - View Data.mp4

05:45

25 - View Distinct Data.mp4

04:09

26 - View Filtered Data.mp4

02:59

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

27 - View Filtered Data with AND Operator.mp4

06:01

28 - View Filtered Data with OR Operator.mp4

05:42

29 - View Filtered Data with IN Operator.mp4

07:29

30 - View Filtered Data with BETWEEN Operator.mp4

08:15

31 - View Filtered Data with LIKE Operator.mp4

10:36

9 - Order By

32 - Sort Data in Ascending or Descending Orders.mp4

06:58

33 - Sort Data In Ascending Orders.mp4

03:38

34 - Sort Data in Descending Orders.mp4

02:55

35 - Sort Data on Two Fields.mp4

06:58

10 - Like Operator with Wild Card

36 - Filter Data with Pattern Match.mp4

10:36

37 - Filter Data with Single Character Match.mp4

04:32

11 - Group By and Having

38 - Extract Distinct Data.mp4

02:16

39 - Aggregate Data with Group By.mp4

06:01

40 - Apply Condition with Having Clause.mp4

13:54

12 - Sub Query

41 - Extract Data of Max Value.mp4

05:05

42 - Extract Data of Min Value.mp4

02:07

43 - Extract Data more than Average Value.mp4

01:51

44 - Extract 3rd Largest Value.mp4

06:13

45 - Extract 3rd Smallest Value.mp4

04:19

13 - Joins in SQL

46 - Join Introduction.mp4

01:35

47 - Inner Join.mp4

07:50

48 - Left Join.mp4

05:36

49 - Right Join.mp4

05:25

50 - Full Join.mp4

04:08

51 - Cross Join.mp4

04:14

52 - Self Join.mp4

16:13

14 - SQL Append

53 - Union.mp4

08:05

54 - Union ALL.mp4

04:00

55 - Intersect.mp4

03:12

56 - Except.mp4

03:06

15 - Case Statement

57 - Use Case Statement to Add Virtual Column.mp4

13:48

16 - CTECommon Table Expression

58 - RowNumber Function.mp4

05:37

59 - Rank Function.mp4

07:06

60 - DenseRank Function.mp4

09:04

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

06:44

62 - Remove Duplicate Data from Table.mp4

12:46

63 - Two Smallest Sales Based on Category.mp4

06:10

64 - Two Largest Sales Based on Category.mp4

08:44

Description

Unlock the Power of SQL Server for Data Management, Data Analysis, Business Analyst and BI Developer with Live Practical

What You'll Learn?

Introduction of SQL Server
How to create Table in SQL Server
How to Insert Data into Table
Select Statement with Join
Use of Common Table Expression
Use of Case in Select and Update Statements

Who is this for?

This course is for them who want to mark career as a Data Analyst, Business Analyst, BI Developer

What You Need to Know?

No Programming experience needed for this course.

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 as a Data Analyst, Business Analyst, BI Developer

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.