Penn Health Institute > Business > Business Analytics & Intelligence > SQL for Data Analyst, Business Analyst and BI Developer

3 out of 5

1 review on Udemy

SQL for Data Analyst, Business Analyst and BI Developer

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

Instructor:

Shishir Kumar

2 students enrolled

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

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.

Introduction

Introduction of SQL Server

SQL Server Installation

Dataset and Power Point

SQL Server Interface

Server and Database

Table, Record, Field

Database

Create Database

Delete Database

Activate Database

Full Database Backup

Table

Create Table

Delete Table

Alter Table

Data Insert, Import and Export

Insert Data with Graphical User Interface

Insert Data into Table

Bulk Insert Data into Table

Import Data into Table

Export Data from Table

Delete and Truncate

Delete Data on Condition

Delete Entire Data from Table

Update Data

Update Entire Field Data in Table

Update Data on Condition

Update Single Column Data from Another Table

Update Multiple Columns Data from Another Table

Begin Transaction

Select Statement to View Data (Where Clause)

View Data

View Distinct Data

View Filtered Data

Filter Data with Where Clause (And, Or, IN, Between, LIKE Operators)

View Filtered Data with AND Operator

View Filtered Data with OR Operator

View Filtered Data with IN Operator

View Filtered Data with BETWEEN Operator

View Filtered Data with LIKE Operator

Order By

Sort Data in Ascending or Descending Orders

Sort Data In Ascending Orders

Sort Data in Descending Orders

Sort Data on Two Fields

Like Operator with Wild Card

Filter Data with Pattern Match

Filter Data with Single Character Match

Group By and Having

Extract Distinct Data

Aggregate Data with Group By

Apply Condition with Having Clause

Sub Query

Extract Data of Max Value

Extract Data of Min Value

Extract Data more than Average Value

Extract 3rd Largest Value

Extract 3rd Smallest Value

Joins in SQL

Join Introduction

Inner Join

Left Join

Right Join

Full Join

Cross Join

Self Join

SQL Append

Union

Union ALL

Intersect

Except

Case Statement

Use Case Statement to Add Virtual Column

CTE(Common Table Expression)

Row_Number Function

Rank Function

Dense_Rank Function

Extract Product Name of 3rd Largest Sales

Remove Duplicate Data from Table

Two Smallest Sales Based on Category

Two Largest Sales Based on Category

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!