SQL Server 2008

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

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

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.

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

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

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.

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

SSAS Training

Coming soon.......

  • Fee : RS 25,000
  • Duration : 40 Hours

Apply Here

If you’d like to know more about our services please use the contact form below.

DATA SCIENCE

Click Here To view
Detail Information for this course

STATISTICAL SOFTWARE CERTIFICATION

Click Here To view
Detail Information for this course

TABLEAU

Click Here To view
Detail Information for this course

BIG DATA HADOOP

Click Here To view
Detail Information for this course