+91 9879558787 , +91 9825306119 info@itsahmedabad.com

Technical course for Business Analyst

Excel

(24 hours)

Excel VBA

(24 hours)

Querying SQL Server - 40 hours

Introduction to Microsoft SQL Server 2012
Getting Started with SQL Azure
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2012 Data Types
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Using Window Ranking
Offset and Aggregate Functions
Pivoting and Grouping Sets
Querying SQL Server Metadata
Executing Stored Procedures
Programming with T-SQL
Implementing Error Handling
Implementing Transactions
Improving Query Performance

Download Brochure

SQL Server 2012 Reporting Services (SSRS) - 12 hours

Introduction to Reporting Services and SQL Server 2012
Installing Reporting Services
Reporting Services Internals and Post Installation Setup
Basic Report Building with Reporting Tools
Working with Report Builder and Report formatting
Working with Data Sources to Access data
Advance Report design considerations
Working with Chart Reports
Administrating SSRS and Managing Report projects
SQL Server Administration related to SSRS database

Download Brochure

Basic and Advance Excel - 24 hours

Basic: – Getting Started with Excel, Basic of Formatting a Worksheet
Modifying a Worksheet
Performing Calculations
Printing Workbook Contents
Creating and Modifying Charts
Sorting and Filtering Data
Advance:- Creating a PivotTable
Auditing Worksheets
Calculating with Advanced Formulas
Automated task with Macros
Importing and Exporting Data
Creating and Applying Templates

Download Brochure

Beginner and Advance Excel VBA - 24 hours

Beginner:- Start VBA & Security
Excel Objects, Conditions & Loops
Functions & Sub routine
Exceptions
Advance:- Forms
Controls
Validation
Array
Chart
Pivot
Database

Download Brochure

 Trainers profile

Years real time experience

Real time Business analyst

Students and professionals trained

Corporate Training Customers

Student Testimonials

Please follow and like us:
0