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

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

Requirements

No Programming experience needed for this course.

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 analysisBy 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.

Overview

Section 1: Introduction

Lecture 1 Introduction of SQL Server

Lecture 2 SQL Server Installation

Lecture 3 SQL Server Interface

Lecture 4 Server and Database

Lecture 5 Table, Record, Field

Section 2: Database

Lecture 6 Create Database

Lecture 7 Delete Database

Lecture 8 Activate Database

Lecture 9 Full Database Backup

Section 3: Table

Lecture 10 Create Table

Lecture 11 Delete Table

Lecture 12 Alter Table

Section 4: Data Insert, Import and Export

Lecture 13 Insert Data with Graphical User Interface

Lecture 14 Insert Data into Table

Lecture 15 Bulk Insert Data into Table

Lecture 16 Import Data into Table

Lecture 17 Export Data from Table

Section 5: Delete and Truncate

Lecture 18 Delete Data on Condition

Lecture 19 Delete Entire Data from Table

Section 6: Update Data

Lecture 20 Update Entire Field Data in Table

Lecture 21 Update Data on Condition

Lecture 22 Update Single Column Data from Another Table

Lecture 23 Update Multiple Columns Data from Another Table

Section 7: Select Statement to View Data (Where Clause)

Lecture 24 View Data

Lecture 25 View Distinct Data

Lecture 26 View Filtered Data

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

Lecture 27 View Filtered Data with AND Operator

Lecture 28 View Filtered Data with OR Operator

Lecture 29 View Filtered Data with IN Operator

Lecture 30 View Filtered Data with BETWEEN Operator

Lecture 31 View Filtered Data with LIKE Operator

Section 9: Order By

Lecture 32 Sort Data in Ascending or Descending Orders

Lecture 33 Sort Data In Ascending Orders

Lecture 34 Sort Data in Descending Orders

Lecture 35 Sort Data on Two Fields

Section 10: Like Operator with Wild Card

Lecture 36 Filter Data with Pattern Match

Lecture 37 Filter Data with Single Character Match

Section 11: Group By and Having

Lecture 38 Extract Distinct Data

Lecture 39 Aggregate Data with Group By

Lecture 40 Apply Condition with Having Clause

Section 12: Sub Query

Lecture 41 Extract Data of Max Value

Lecture 42 Extract Data of Min Value

Lecture 43 Extract Data more than Average Value

Lecture 44 Extract 3rd Largest Value

Lecture 45 Extract 3rd Smallest Value

Section 13: Joins in SQL

Lecture 46 Join Introduction

Lecture 47 Inner Join

Lecture 48 Left Join

Lecture 49 Right Join

Lecture 50 Full Join

Lecture 51 Cross Join

Lecture 52 Self Join

Section 14: SQL Append

Lecture 53 Union

Lecture 54 Union ALL

Lecture 55 Intersect

Lecture 56 Except

Section 15: Case Statement

Lecture 57 Use Case Statement to Add Virtual Column

Section 16: CTE(Common Table Expression)

Lecture 58 Row_Number Function

Lecture 59 Rank Function

Lecture 60 Dense_Rank Function

Lecture 61 Extract Product Name of 3rd Largest Sales

Lecture 62 Remove Duplicate Data from Table

Lecture 63 Two Smallest Sales Based on Category

Lecture 64 Two Largest Sales Based on Category

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