Course Overview

This course provides a quick start to analyze the data using SQL Server. It covers most of the topics required for data analysis along with suitable examples. In this course, you’ll learn how to organize data, uncover patterns and insights, draw meaningful conclusions, and clearly communicate critical findings. By completing this training, the candidate gets expertise in SQL queries and the ability to add analysis capabilities to visualize the data. Gain all the skills necessary to get a job as a data analyst.

Course Features

  • Live Instructor-Led online training.
  • Receive a comprehensive set of materials, including course notes and all the class examples.
  • Easy access to the trainer for any questions and follow-ups.
  • An ample number of practical assignments to test your skills.
  • Assignments evaluation, feedbacks, and encouragements to develop your skills in a better way.
  • Focus on hands-on training during sessions.

Data Analysis with SQL

Course Duration

50 hours of training

Course Contents

Training Description

This training course covers the training for Python Language.  This includes fundamentals, OOPS, File handling, Exception handling and multithreading using Python. After finishing this training you will be ready for develop advanced applications like Web based or Data Science or Machine learning.

Course Content

  • DML & DDL statements in SQL
  • SQL Data Types
  • Common function & Analytics functions in SQL
  • Selecting single column
  • Selecting multiple columns
  • Select Distinct
  • Select Top
  • Learning count
  • Arithmetic Operators
  • Aliasing
  • Arithmetic operations on data – Concatenation
  • Data manipulations using built in functions
  • Date Functions
  • Operators used for filtering
  • Filtering of numerical
  • Filtering of text values
  • Filtering of date values
  • Data cleanup by handling NULLs
  • Aggregate Functions
  • Combining aggregate functions with where clause
  • Elimination of duplicate records
  • Sorting the data- Order By
  • Groups records into summary rows – Group By
  • Filter data after aggregates – HAVING
  • Types of Joins
  • Sorting and grouping multiple tables
  • Aggregating data from multiple tables
  • Writing sub-queries in SQL
  • RANK
  • DENSE_RANK
  • NTILE
  • ROW_NUMBER
  • What is T-SQL?
  • Comparison between SQL and T-SQL?
  • T-SQL Keywords
  • Programming constructs
  • Variables and Data-types
  • Control statement- (if else)
  • Looping Statement-(While)
  • Introduction to Cursors
  • Cursors storing data from multiple columns
  • Cursors storing data from views
  • Introduction to Functions
  • Types of functions?
  • User defined Scalar function
  • Table valued functions
  • Introduction to Stored Procedures
  • Calling functions from procedures
  • Passing table parameter to stored procedures
  • For operation triggers (For-Insert, For Update, For Delete)
  • Instead of operation triggers (Instead of Insert, Instead of Update, Instead of Delete)
  • Using Exists function
  • Using RowCount variable
  • Using Merge function
  • What are Errors?
  • Error Types
  • Error Handling using Try-Catch
  • Introduction to MSBI
  • What is SSRS?
  • Why do we need SSRS?
  • How SSRS works?
  • Introduction to SQL Server Data Tools
  • Creating new project
  • Solution Explorer
  • What is Data source and Data set?
  • Creating new report
  • Report Data Window
  • Creating Data Source
  • Creating Data Set
  • List of Report Items
  • Create New Table Report
  • Add Text Box to Report
  • Rectangle in a Report
  • Create a List Report
  • Display Image in Report
  • Changing Font and Background Color of a Text Box
  • Format Numbers in a Text Box
  • Format Date and Time in a Report
  • Global references in SSRS
  • Repeat Column Headers on Each Page
  • Column Headers Visible While Scrolling
  • Add, or Remove Headers and Footers on Reports
  • Page number
  • Filtering at Tablix Level
  • Filtering at Dataset Level
  • Sorting Data at Tablix Level
  • Interactive Sorting
  • Simple Expressions
  • Complex Expressions
  • Add Row Numbers to Report
  • Add Alternative Row Color to Report
  • Conditional Formatting
  • CStr function
  • Add totals
  • Add calculated fields
  • Add Parent Groups
  • Add Child Groups
  • Add total and Subtotal in grouping
  • Create new Matrix Report
  • Add Row Groups and Column Groups
  • Add Total and Subtotal in Matrix Report
  • Simple drill down report
  • Drill down matrix report
  • Multiple drill down matrix report
  • Type in text Parameter
  • Drop Down List Parameter
  • Drop down List Parameter with user friendly labels
  • Drop down List Parameter with default value parameter
  • Multiple Parameters
  • Multi-value Parameters
  • Cascaded Parameters
  • Linked Report
  • Sub Report
  • Drill through Report
  • Go to URL Action
  • Dashboards
  • Two table two queries
  • Two table one query
  • Dynamic Conditional Formatting
  • Visibility Control
  • Report using Stored Procedure
  • Report using Parameterized Stored Procedure
  • Charts Introduction
  • Column Chart
  • Pie Chart
  • Data Bars
  • Indicators
  • Linear Gauges
  • Radial Gauges
  • Sparkline
  • SQL Server Reporting Services Configuration Manager
  • Report Deployment

Course Prerequisites

  • Students should have a very basic understanding of Microsoft Word and Excel.
  • Knowledge of any DBMS at a basic level along with any programming language knowledge will be added advantage.
  • ​A PC with a minimum Windows 7 Operating system with MS Office and an Internet connection.
  • Candidates should have basic skills in Office tools with some programming knowledge.

Course Outcome

  • Understand the importance of data analysis.
  • Understand how to analyze quantitative data.
  • Learn to manipulate data using SQL Server.
  • Learn to analyze and interpret data.
  • Learn basic formatting, sorting, and filtering.
  • Work with reporting expressions
  • Understand reporting services and their components.
  • Learn basic formatting, sorting, and filtering.
  • Work with reporting expressions
  • Learn basic formatting, sorting, and filtering.
  • Work with reporting expressions
  • Understand the importance of data visualization.
  • Learn to create a dashboard and analyze data.
  • Interpret data findings effectively to any audience visually.

Application Form