Analytics Gurukul

Data Analytics

Embrace tailored coaching that aligns with your leadership style

SQL Server

data

SQL Server Course Contents :

 

SQL Overview

  • RDBMS Concepts

The Foundation Statements of T-SQL

  • Started with SELECT Statement

Adding Data with the INSERT Statement

  • SQL Commands
    • DDL
    • DML
    • DCL
    • DQL

 

SQL Data Types

 

  • Basic Commands
    • Create Statement
    • Create Database
    • Create Table
    • Alter Statement
    • Alter Database
    • Alter Table
    • Drop Statement
    • Delete Statement
    • Update Statement

 

SQL Operators

  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators

 

 NORMALIZATION

  • 1NF
  • 2NF
  • 3NF

 

 

 

JOINS

  • INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL Join
  • SELF Join
  • CARTESIAN Join

 

SQL Constraints

  • PRIMARY KEY Constraints
  • FOREIGN KEY Constraints
  • UNIQUE Constraints
  • CHECK Constraints
  • DEFAULT Constraints
  • NULL Constraints

 

SQL Clauses

  • WHERE Clause
  • ORDER BY Clause
  • GROUP BY Clause
  • HAVING Clause
  • TOP Clause
  • LIKE Clause
  • UNION Clause
  • UNION ALL Clause

 

Adding More to Our Queries

  • What Is a Sub-Query?
  • Building a Nested Sub-Query
  • Correlated Sub-Queries
  • How Correlated Sub-Queries Work Correlated Sub-Queries in the WHERE Clause

 

The EXISTS Operator

 

  • Using EXISTS in Other Ways

System Defined Functions:

  • AVERAGE
  • COUNT
  • MAX

                                               MIN                                                                                                                        

 

 

 

  • SUM
  • SQRT
  • RAND
  • CONCAT
  • GROUP BY
  • HAVING
  • TRIM
  • LENGTH
  • UPPER
  • LOWER
  • REPLACE
  • REVERSE
  • SUBSTRING
  • STUFF
  • DATEADD(day,10,@date)
  • DATEDIFF (day,exp1,exp2)
  • DATEPART(day,exp)
  • GETDATE
  • CONVERT
  • FORMAT
  • ISNULL
  • Top

 

UDF (USER DEFINED FUNCTIONS)

  • Scalar Functions
  • Table-valued Functions

 

 UNDERSTANDING INDEXES

  • How Data Is Accessed in SQL Server
  • Creating, Altering, and Dropping Indexes
  • The CREATE INDEX Statement

 

VIEWS

  • Simple Views
  • Views as Filters
  • More Complex Views
  • Dropping Views

 

STORED PROCEDURES

  • Basic Syntax
  • Changing Stored Procedures with ALTER

                                              Dropping Stored Procedures                        

 

 
  

 

 

 

  • Handling Errors

 

Window Function

  • Row Over
  • Dense rank
  • Partition by

 

USING Sequences

  • Auto Increment (Identity Field)

 

Triggers

  • Auto Generated Tables (INSERTED / DELETED)

 

 

End to End case Study

Duration 24 Hours

Master the Art of SQL Server

Effective communication is at the core of leadership

Leading with Vision and Purpose

Our coaching focuses on developing a clear vision and purpose

We are making our students masters in every aspects Whether it is communication skills, Data Visualization or so on.

Effective Data Collection and Statistical Analysis is the core strength of Data Analytics

Data Visualization

Creating visual representations of data to communicate complex findings effectively. Scientists use tools like charts, graphs

Communication Skills:

Effectively communicating findings and insights to non-technical stakeholders, such as business leaders or decision-makers.

Continuous Learning

Staying updated on the latest developments in data science, machine learning, and related fields.

Optimization and Tuning

Fine-tuning machine learning models to improve their performance, often through hyperparameter tuning