Tag: sql server

Introduction to SQL Server 2012 Integration Services (SSIS) Training Course

Posted on by admin

Duration

28 hours (usually 4 days including breaks)

Requirements

Prior experience with SQL Server 2012

Course Outline

  • ETL and SSIS
  • Packages
  • Control Flow
  • Workflow
  • Constraints
  • Data Flows
  • Variables
  • Containers
  • Transactions
  • Errors and Debugging
  • Logging
  • Slowly Changing Dimensions
  • Deploying a Package
  • Security
  • Scripting
  • Best Practices

Developing in SQL Server Business Intelligence Training Course

Posted on by admin

Duration

35 hours (usually 5 days including breaks)

Requirements

Before attending this course, students must have:

  • Understanding of relational database concepts
  • Experience of querying a relational database
  • Fundamental understanding of reporting and analysis

Overview

Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects.

The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself.

4 Top Takeaways from the Course

  1. Make your existing data work harder for you
  2. Integrate diverse data stores to a single repository
  3. Transform raw data to business intelligence
  4. Create eloquent reports from raw data

Course Outline

Module 1: Introduction to SQL Server Reporting Services – SSRS

  • Overview of SSRS
  • Installing Reporting Services
  • The Reporting Lifecycle
  • Highlights of Reporting Services
  • Reporting Services Scenarios
  • Reporting Services Developer Tools

Module 2: Authoring Basic Reports

  • Creating a Basic Table Report
  • Report Definition Language
  • Accessing Data
  • Formatting Report Pages
  • Headers and Footers
  • Calculating Values
  • Common Aggregate Functions

Module 3: Enhancing Reports

  • Interactive Navigation
  • Use Show/Hide to Provide Drill-Down Interactivity
  • Navigate From Report To Report Using Links
  • Working with Data Regions
  • Using Report Manager
  • Distribute and Manage Published Reports

Module 4: Introduction to SQL Server Integration Services – SSIS

  • What Is SSIS?
  • When to Use SSIS?
  • SSIS Architecture
  • Integration Services Scenarios
  • Integration Services Developer Tools
  • Control Flow and Design Flow Design Surfaces
  • Migrating data across Excel, Flat Files, XML and database providers
  • Adding Tasks to a Package

Module 5: SSIS Going Further

  • Building a Package
  • Troubleshooting a Package
  • Deploying a Package to the SSIS Server
  • Scheduling a Package with SQL Server Agent
  • Securing a Package in Management Studio
  • Using Variables, Event Handlers and Configurations

Module 6: Introduction to SQL Server Analysis Services – SSAS

  •   What Is SSAS?
  •   When to Use SSAS
  •    SSAS Architecture
  •    Analysis Services Tools
  •    Understanding Fact and Dimension tables

Module 7: SSAS Going Further

  • Creating an Analysis Services Project in Visual Studio
  • Fact and Dimension Tables
  • Creating a Data Source
  • Creating a Data Source View
  • Creating a Cube Object Definition
  • Deploy Definitions to OLAP Server and Load in Data
  • Browse a Cube to Query Data
  • Creating Key Performance Indicators (KPI’s) to Give Meaning to Data

Learning SQL with Microsoft SQL Server Training Course

Posted on by admin

Duration

21 hours (usually 3 days including breaks)

Requirements

  • NO previous SQL or database experience is required.

Overview

Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.

In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.

By the end of this training, participants will be able to:

  • Install and configure Microsoft SQL Server
  • Query a Microsoft SQL Server database using Microsoft’s Transact-SQL (T-SQL) language
  • Understand the essentials of database design
  • Optimize a database through normalization
  • Use aggregate functions to generate results similar to those of “pivot-tables”
  • Access Microsoft SQL Server through Excel

Audience

  • Data analysts
  • Business Intelligence professionals
  • Business managers
  • Excel experts who wish to expand their analysis skill set

Format of the Course

  • Interactive lecture and discussion
  • Lots of exercises and practice
  • Hands-on implementation in a live-lab environment

Course Customization Options

  • This training is based on the latest version of Microsoft SQL Server
  • To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

Installing and Configuring Microsoft SQL Server

Overview of Microsoft SQL Server Features

Overview of Transact-SQL Concepts

Querying a Database using SELECT

Filtering the Data with WHERE

Sorting the Data with ORDER BY

Querying Multiple Tables with Joins

Grouping Data with GROUP BY

Using Aggregate Functions to Perform Calculations on Resulting Data

Filtering Groups with HAVING

Creating a New Database

Understanding the Database Model

Optimizing the Database through Normalization

Enhancing your Queries with Procedures

Writing Functions and Sub-routines

Using Conditions to Control the Flow

Connecting to Microsoft SQL Server through Excel

Troubleshooting

Summary and Conclusion

T-SQL Fundamentals with SQL Server Training Course Training Course

Posted on by admin

Duration

14 hours (usually 2 days including breaks)

Requirements

Basic Computer Skills.

Overview

This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:

  • How to work with SQL Server and SQL Server Management Studio.
  • Meaning of Databases, SQL and RDBMS etc.
  • How to create tables, use DDL, DML and DAL.
  • Which are the various RDBMS Packages in the market and how they compare with each other.
  • An Introduction to NoSQL and how they are organizations are changing into hybrid databases.

Course Outline

Course Outline:

  • What is the meaning of Databases. Comparison of RDBMS and DBMS
  • Different RDBMS available in the market.
  • What is SQL Server? Working with SQL Server Management Studio
  • Working with sublanguages like DDL, DML, DAL.
  • Creation of Tables, data types, Constraints and their definition.
  • Using Insert, Delete and Update statements.
  • Using Select Query and its various operators.
  • Use of Null, Not Null, And, OR, Between, Exists, Order by, Group by, Having clause
  • What are inbuilt functions? Math, String and Datetime functions.
  • Working with Views. How they are used for data access.
  • Working with Joins. Joins types and getting data from multiple tables.
  • Working with Sub Queries. What is a correlated subquery. Difference between Sub Query and Joins.
  • What are Common Table Expressions. Using Recursive Common Table expressions.

SQL in SQL Server Training Course

Posted on by admin

Duration

14 hours (usually 2 days including breaks)

Requirements

Basic computer skills

Overview

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between T-SQL and other dialects
  • practical skills for writing queries

This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.

Course Outline

RDBMS (Relational DataBase Management System)

Relational Operators

SQL as Declarative Language

SQL Syntax

SQL Sublanguages DQL, DML, DDL, DCL

DQL (Data Query Language) in Detail

  • SELECT clause
  • Column aliases
  • Table aliases
  • Date types and Date functions
  • Group function
  • Table joins
  • JOIN clause
  • UNION operator
  • Nested queries
  • Correlated subqueries

DML (DataManipulationLanguage) Overview

  • Inserting rows (INSERT)
  • Inserting rows using subquery
  • Updating rows (UPDATE)
  • Deleting rows (DELETE)

DDL (Data Definition Language) Overview

  • Creating, altering and dropping objects (CREATE, ALTER, DROP)
  • Creating tables using subquery (CREATE TABLE …. AS SELECT…)

CONSTRAINTS Overview

  • NULL i NOT NULL
  • CONSTRAINT clause
  • ENUM type
  • SET type
  • PRIMARY KEY
  • UNIQUE
  • FOREIGN KEY
  • DEFAULT clause

Transactions Overview

  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • Implicit and explicit rollbacks and commits

T-SQL Dialects Overview

  • What is Transact-SQL
  • T-SQL and portability with other dialects (what to avoid)
  • Handling Date

Python Automation Series

Posted on by admin

Read and Write Data from Excel using Python

Read Specific Row and Columns Using Python

Read specific sheet using Python

Load data from excel to database using Python

Requirements

  • No programming experience needed.

Description

After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.

We have covered all the below things.

Read Data from Excel

Write Data from Excel

Read Specific sheet

Read specific cell

Write data

Sql Connectivity

Load Data in sql server

After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.

We have covered all the below things.

Read Data from Excel

Write Data from Excel

Read Specific sheet

Read specific cell

Write data

Sql Connectivity

Load Data in sql server

After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.

We have covered all the below things.

Read Data from Excel

Write Data from Excel

Read Specific sheet

Read specific cell

Write data

Sql Connectivity

Load Data in sql server

After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.

We have covered all the below things.

Read Data from Excel

Write Data from Excel

Read Specific sheet

Read specific cell

Write data

Sql Connectivity

Load Data in sql server

Who this course is for:

  • Beginners Python Course

Course content