Enquiry

  Submit

MSSQL

software development Applications,Production support and training

Courses

SQL Server Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth SQL Server Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and SQL Server Training Certificate

SQL Server Course Contents

Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browse.

Course Objectives:

Learn about SQL – Structured Query Language

Build database using Data Definition Language Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database. Write and manage database triggers, cursors and Index.

Pre-requisite / Target Audience:

This sql server course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.

  • Introduction to Basic Database Concepts
  • E-R Modeling and Diagram
  • Normalization
  • Introduction to SQL Server
  • Introduction to SQL
  • DDL and DML Statements
  • Working with Queries (DQL)
  • Aggregate Functions
  • Joins and Set Operations
  • Implementation of Data integrity
  • Working with Constraints
  • Data Control language (DCL)
  • Working with Indexes
  • Writing Transact-SQL (T-SQL)
  • Working with Stored Procedures and Functions
  • Implementing Triggers
  • Working with Cursors
  • Transaction Control Language (TCL)
  • Backup and Restore
  • Advance Features
Courses

SSAS Server Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth SSAS Server Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and SSAS Server Training Certificate

SSAS Server Course Contents

Analysis Services enables you to analyse large quantities of data. With it, you can design, create, and manage multidimensional structures that contain detail and aggregated data from multiple data sources. To manage and work with Online Analytical Processing (OLAP) cubes, you use SQL Server Management Studio. To create new OLAP cubes, you use Business Intelligence Development Studio.

Course Objectives:

Pre-requisite / Target Audience:

Basic working knowledge of SQL Server like working with tables, views, stored procedures etc is required.

  • OLAP Introduction
  • Introduction to SSAS
  • Data Source View and Cube Wizard
  • MDX (Multi - Dimensional expressions) and Cube Browser
  • Calculations
  • Working with Dimensions
  • Working with Cube Design
  • Translation, Perspective and Actions
  • KPI (Key Performance Indicator)
  • Deployment and Processing
  • Partitions
  • Aggregation
  • Security

At the end of the course participants will be able to:

  • Work with actual clients, technology architects, or team leads on a large scale SQL Server Analysis Services / MDX / Data Mining Project.
  • Upon completion of this course, successful participants will be able to use SSAS to deploy an Analysis Services database with multiple levels of security for data mining.


Courses

SSIS Server Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth SSIS Server Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and SSIS Server Training Certificate

SSIS Server Course Contents

SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server database software which can be used to perform a broad range of data migration, data integration and Data Consolidation tasks. It features fast and flexible data warehousing tool used for data extraction, transformation and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates multidimensional cube data. SSIS is the new data transformation standard for SQL Server 2005 onwards and has replaced the old SQL Server Data Transformation Services.

Course Objectives:

Pre-requisite / Target Audience:

Participants are need to be familiar with basic RDBMS concepts with skills to write queries. Working experience on any RDBMS would be an added advantage.

  • Introduction to MSBI
  • Introduction to SSIS
  • Data Flow Task
  • Transformations
  • Control Flow
  • Debugging
  • Logging and Event Handling
  • Robustness and Restartibility
  • Deployment and Execution

At the end of the course participants will be able to:

  • Perform basic ETL(Extract Transform Load) tasks at your work
  • Gateway to obtain Microsoft Business Intelligence Certifications
  • Analyze data and do marketing more effectively for a particular application
  • Simplifying Deployments
  • Perform Database Operations
  • Organize Package Workflow
  • Design Robust Packages


Courses

SSRS Server Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth SSRS Server Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and SSRS Server Training Certificate

SSRS Server Course Contents

Reporting Services is a server-based reporting platform that provides a full range of ready-to-use tools and services to help people throughout your organization create, deploy, manage, and use reports quickly and easily. With Reporting Services, you can retrieve data from relational, multidimensional, and XML-based data sources; publish reports that can be viewed in various formats; and centrally manage report security and subscriptions. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application

Course Objectives:

Pre-requisite / Target Audience:

Before opting this course the student should have general familiarity with relational database concepts and writing basic SQL SELECT statement.

  • SSRS Introduction
  • Creating Reports
  • Working with Tablix
  • Data Visualization
  • Other Features
  • DDL and DML Statements
  • Working with Queries (DQL)
  • Aggregate Functions
  • Joins and Set Operations
  • Implementation of Data integrity
  • Working with Constraints
  • Data Control language (DCL)
  • Working with Indexes
  • Writing Transact-SQL (T-SQL)
  • Working with Stored Procedures and Functions
  • Implementing Triggers
  • Working with Cursors
  • Transaction Control Language (TCL)
  • Backup and Restore
  • Advance Features

At the end of the course participants will be able to:

  • Create parameter reports.
  • Create list reports.
  • Format reports with complex expressions.
  • Add images and sub reports.
  • Add drilldown and drill through functionality.
  • Add spark lines, data bars, and indicators.


Courses

DBA (Database Administrator) Course Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth DBA (Database Administrator) Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and DBA (Database Administrator) Training Certificate

Courses

Performance Tuning Course Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Performance Tuning Course Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Performance Tuning Course Training Certificate

Categories

All Courses

Our Clients