+91 989 971 4317

SQL Server Training

Online Sas Training

Learn Through Case Studies and Get a Project Completion Certificate.

Microsoft SQL Server is a relational database management system developed by Microsoft Corporation. Its primary function is to store and retrieve data as requested by other software applications, on the same computer or other computers across the network. There are several editions of MS SQL Server for different kind of uses.


Excel Training in Delhi
SQL Server 2008

SQL Server 2008

Analytic Square has achieved the noteworthy position as India's best training institute for SAS certification. In the last few years, there has been an extensive increase in collecting data by structure enterprise .

More

Developing SSIS Packages
Module-1:
Chapter 1. Overview of Microsoft® SQL Server™
Chapter 2. General database concepts
Chapter 3. Evolution of Database (DBMS, RDBMS, OODBMS)
Chapter 4. Database Objects (Table, View, Stored Procedure, User defined Functions)

Module-2:
Chapter 1. GUI of SQL Server
Chapter 2. System Databases
Chapter 3. Inside the SQL Server database (.LDF and .MDF files)
Chapter 4. How to create database
Module-3:
Chapter 1. Data types in SQL Server (General overview)
Chapter 2. Create Table- Basic
Chapter 3. Adding data into Table (INSERT INTO command)
Chapter 4. DML, DDL, DCL, DQL command
Chapter 5. Create Table- Advance (Referential Integrity, Constraints-Check, Default, Unique, Primary Key, Foreign Key)
Chapter 6. Cascade data

Module-4
Chapter 1. Select data
Chapter 2. Joining data
Chapter 3. Union Data
Chapter 4. Select with Crete
Chapter 5. Questions
Module -5
Chapter 1. Indexes- Structure and types of
Chapter 2. Creating Indexes
Chapter 3. Index working
Chapter 4. Optimization –Basic
Module-6
Chapter 1. Views in SQL Server
Chapter 2. Stored Procedures
Chapter 3. User Defined Functions
Chapter 4.Triggers
Module-7
Chapter 1. SQL Server Agent
Chapter 2. SQL Profiler

Less...
VBA Training in Delhi
SSIS Training

SSIS Training

The Beginners courses are designed for those looking to develop skills in data science and analytics. No prior experience or knowledge of analytics is required for these courses. Knowledge of Statistics is helpful but not essential.

More

Developing SSIS Packages
Topic 1: Creating SSIS Packages and Data Sources.
1. Creating SSIS Packages
2. Developing Project Data Sources and Package Connections
Topic 2: Creating and Editing Control Flow Objects
1. Creating Control Flow Tasks
2. Using Control Flow Containers
3. Working with Package Variables
4. Using the Script Task
5. Testing Package Execution in BIDS
Topic 3: Using Data Flow Adapters and Transformations
1. Defining Data Flow Source Adapters
2. Creating Data Flow Destinations
3. Working with Data Flow Transformations
4. Practice: Creating Simple and Complex Data Flows

Debugging and Error Handling in SSIS
Topic 1: Configuring Package Transactions and Checkpoints
1. Defining Package and Task Transaction Settings
2. Implementing Restartability Checkpoints
Topic 2: Identifying Package Status, Enabling Logging, and Handling Task Errors
1. Viewing Package Status
2. Configuring Execution Logging
3. Connecting Control Flow Objects with Precedence
Topic 3: Handling Data Flow Errors and Debugging
1. Using Error Paths to Handle Data Flow Errors
2. Using Data Viewers to Identify Data Flow Issues
3. Handling Package Errors with Event Handlers
4. Debugging the Control Flow with Breakpoints
5. Deploying and Configuring SSIS Packages
Topic 1: Using Package Configurations and Expressions
1. Understanding Package Configurations
2. Using SSIS Expressions and Property Expressions
Topic 2: Deploying SSIS Packages
1. Understanding Package Deployment
2. Creating an Installer Kit by Using the
3. Package Deployment Utility
4. Deploying Package

Executing SSIS Packages
Topic 1: Executing and Scheduling Packages
1. Executing Packages in SSMS with the SSIS Service
2. Creating SQL Server Agent Jobs to Execute SSIS Packages

Less...
Online Sas Training
SSRS Training

SSRS Training

Get trained in SQL Server and gain the skills needed to unite the power of the cloud with the demand for deeper insight into customer data. These courses also prepare you for certification on Microsoft SQL Server.

More

Developing SSRS Reports
Topic 1: Creating SSRS Projects and Reports in BIDS
1. Understanding the SSRS Report Templates
2. Using the Report Wizard
3. Modifying Project Properties
4. Modifying Report-Level Properties
5. Developing Report Objects with the Report Designer
6. Adding Report Objects to a Report
Topic 2: Creating a Dataset from a Data Source
1. Creating a New Report Dataset
2. Working with an SSAS-Based Dataset
3. Practice: Creating Report Datasets
Topic 3: Working with Advanced Report Object Properties
1. Toggling Object Visibility
2. Defining Report Actions
Topic 4: Applying Dataset Filters and Groups
1. Assigning Datasets to Data Regions
2. Applying Filters, Groups, and Sorts to Data Regions
3. Applying Aggregates to Data Regions
4. Practice: Creating Advanced Data Regions

Extending and Deploying SSRS Reports
Topic 1: Assigning Parameters Within Reports
1. Creating Parameters in Report Datasets
2. Exposing Parameters to Users
3. Binding Datasets to Parameters
4. Using Multivalued Parameters
5. Working with Parameter Defaults
6. Working with Parameters in URLs
Topic 2: Using Expressions to Perform Advanced Report Item Formatting
1. Extending Report Properties by Using Expressions
2. Using the Element in a Report
3. Extending SSRS with Custom Assemblies
4. Creating a Custom Assembly
Topic 3: Deploying New Reports and Changes
1. Configuring Report Deployment Properties in BIDS
2. Deploying and Redeploying Reports in BIDS
3. Uploading a Report File in Report Manager
4. Deploying Report Builder Models and Reports

Scheduling and Securing Deployed Reports and Data Sources
Topic 1: Creating Report Schedules and Subscriptions
1. Creating Shared Schedules
2. Defining a Report-Specific Schedule
3. Applying a Subscription to a Report
4. Defining Data-Driven Subscriptions and Rendering Formats
5. Creating Data-Driven Subscriptions
6. Specifying the Subscription Delivery Format and Location

Less...

Apply now

Back to Top