Inara Technologies | SQL Online Training
16816
page,page-id-16816,page-template-default,ajax_fade,page_not_loaded,, vertical_menu_transparency vertical_menu_transparency_on,qode-theme-ver-7.2,wpb-js-composer js-comp-ver-4.5.1,vc_responsive
SQL baner

Microsoft SQL Server is a database server, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users

Course Benefits:

    • Syllabus: We came up with a unique list of topics that will help you gradually work your way into the testing world.
    • Practice sessions: Assignments in a way that you will get to apply the theory you learnt immediately.
    • Video sessions of Instructor led live training sessions.
    • Practical learning experiencee with live project work and examples.
    • Support: Our Team is going to be available to you via email or the website for you to reach out to us.
    • Learn SQL Server basics from a professional trainer from your own desk.
    • Information packed practical training starting from basics to advanced testing techniques.
    • Best suitable for beginners to advanced level users and who learn faster when demonstrated.

 

What are the requirements?

  • Anyone with basic computer knowledge can take this course.

What am I going to get from this course?

  • LIVE SQL Server Installation Included in Training.
  • Information packed practical training starting from TSQL to SSIS, SSRS, SSAS .
  • Best suitable for beginners to advanced level users and who learn faster when demonstrated.
  • Course content designed by considering current Business needs and the job market.
  • Practical assignments at the end of every session.
  • Practical learning experience with live project work and examples.
  • Lifetime enrollment – Pay one time fee and access video training sessions as many times as you want.
  • Resume Preparation Guidance for analyst is included.
  • SQL Server Interview Questions and Preparation Tips Included.

SQL SERVER TRAINING SYLLABUS

 

An overview of DBMS technology

 

  • How data is accessed, organized and stored
  • The database development process

 

DBMS and related user tools

  • Query and application development tools

 

Introduction to Microsoft SQL Server

 

  • Databases – Relational and Others
  • The Database as Part of the System Architecture
  • SQL Server Versions and Editions
  • SQL Server Services and Components
  • SQL Server Client Tools
  • Practice

 

All about Databases

 

  • Overview of System Databases
  • Filegroups and Files
  • Introducing the Transaction Log
  • Database Configuration Options
  • Creating a Database
  • Database Snapshots
  • Schemas and Database Objects
  • Practice

 

 All about Tables & Data Types

 

  • System Tables and System Views
  • System Data Types
  • The Use of NULL
  • Creating a Table
  • Special Data Types
  • User-Defined Data Types
  • Table @Variables vs. #Temporary Tables
  • Table Types
  • Sparse Columns
  • Using FILESTREAM and FileTables
  • Practice

 

All about Indexes and Statistics

 

  • Introduction to Indexes
  • Physical Structures
  • Special Types of Indexes
  • Creating an Index
  • Guidelines for Planning Indexes
  • The Database Engine Tuning Advisor-Do not use blind folded
  • Introducing Statistics
  • Understanding Execution Plans
  • Guidelines for Writing Efficient Queries
  • Indexes and Statistics Maintenance
  • Practice

 

 All about Constraints

 

  • Data Integrity Overview
  • Primary Key and Unique Constraint
  • Foreign Key
  • Check and Default Constraints
  • Creating Constraints
  • Disabling Constraints
  • Practice

 

Partitioning

 

  • Introduction to Partitioning
  • Partitioning Setup
  • Operations on a Partitioned Table
  • Partitioned Indexes
  • Special Guidelines
  • Practice

 

Transactions and Locks

 

  • Transactions Overview
  • Lock Types
  • Concurrency Issues
  • Transaction Isolation Levels
  • Locking Hints
  • Deadlocks

 

 Views

 

  • Introduction to Views
  • Creating a View
  • Modifying Data through a View
  • Indexed Views
  • Partitioned Views
  • Practice

 

User-Defined Functions

 

  • Introduction to User-Defined Functions
  • Scalar Functions
  • Table-Valued Functions
  • Practice

 

Stored Procedures

 

  • Introduction to Stored Procedures
  • Stored Procedure Interfaces
  • Creating and Executing Stored Procedures
  • Compilation Sequence
  • Practice

 

Triggers

 

  • Introduction to Triggers
  • The INSERTED and DELETED Tables
  • Creating a Trigger
  • Nested and Recursive Triggers
  • Triggers Pros and Cons
  • Scenarios for Using Triggers
  • Practice

 

XML

 

  • Introduction to XML
  • XPath and XQuery
  • The XML System Data Type
  • XML Schema Collections
  • XML Indexes
  • Converting Relational Data to XML
  • Converting XML to Relational Data
  • Practice

 

All about Joins

 

  • Introduction
  • Types of Joins
  • Explanation of Joins
  • Practice
  • Conditional Statements
  • Loops
  • SQL Query Types
  • SQL CLAUSES

 

SQL Developer Summary using Live Project

 

  • Introduction
  • Architecture Design
  • Modelling Requirement
  • Schema Design
  • Bulding Queries
  • Tuning the Queries
  • Compilation & Presentation

 

SQL Server Business Intelligence

 

  • Introduction to Business Intelligence
  • Introduction to SSIS
  • Introduction to SSRS
  • Introduction to SSAS

 

Introduction to SQL Server Integration Services

 

  • SSIS Historical Overview
  • SSIS Architecture
  • Creating aSimple Package
  • Practice

 

SSIS Tools

 

  • Import and Export Wizard
  • SQL Server Data Tools
  • SQL Server Management Studio
  • Command-Line Utilities
  • Practice

 

SSIS Tasks

 

  • Looping and Sequence Tasks
  • Data Flow Task
  • Data Preparation Tasks
  • Workflow Tasks
  • Administration Tasks
  • Execute Package Task
  • Practice

 

Working with Containers

 

  • Sequence Containers
  • Groups
  • For Loop Container
  • Foreach Loop Container
  • Practice

 

The Data Flow

 

  • Understanding the Data Flow
  • Sources & Destinations
  • Common Transformations
  • Practice

 

Using Variables, Parameters and Expressions

 

  • Dynamic Package Objects
  • Understanding Data Types
  • Using Variables and Parameters
  • Working with Expressions
  • Practice

 

Accessing Heterogeneous Data

 

  • The Connection Managers
  • Excel and Access
  • Oracle
  • Using XML and Web Services
  • Flat Files
  • Other Heterogeneous Sources
  • Practice

 

Error and Event Handling

 

  • Package Transactions
  • Using Precedence Constraints
  • Event Handling
  • Breakpoints
  • Logging
  • Practice

 

SSIS Administration

 

  • Deployment Models
  • Package Configuration
  • Security
  • Scheduling Packages
  • Monitoring Package Executions
  • Practice

 

Introducing SQL Server Reporting Services

 

  • Investigate what SQL Server Reporting Services can do
  • Explore the basic architecture of SQL Server Reporting Services
  • Gain a basic understanding of the components behind SQL Server Reporting Services
  • Learn how to create a basic report using the SQL Server Reporting Services Wizard

 

Creating Tabular and List Reports

 

  • Learn how to create a tabular report from scratch
  • Learn about datasets and data regions
  • Discover how to add textboxes and other controls to reports
  • Investigate the list data region

 

Calculation and Formatting

 

  • Explore how to create expressions in your reports
  • Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
  • Find out how you can use conditional formatting to make your reports more dynamic
  • Learn about report variables and when you might need to use them

 

Grouping and Sorting

 

  • Explore creating groups
  • Master the Reporting Services Grouping pane
  • Learn how to calculate group totals and percentages
  • Understand scope as it applies to aggregate functions
  • Discover interactive sorting
  • Find out how to create drill-down reports

 

Working with Parameters

 

  • Understanding how Reporting Services parameters work with stored procedure parameters
  • Learn how to create parameters in ad-hoc SQL
  • Find out how to display parameter values in report headers
  • Discover how to improve parameter prompts using drop-down list parameters
  • Dig into the use of unbound, multivalued, and cascading parameters

 

Creating Matrix Reports and Charts

 

  • Learn how to create matrix reports
  • Investigate Reporting Services charts
  • Explore the use of Reporting Services gauges

 

Report Types

 

  • Tabular Reports
  • Matrix Reports
  • Charts
  • Drill Down Reports
  • Drill Through Reports
  • Sub Reports

 

Managing Reporting Services

 

  • Understand how to plan and configure for deployment
  • Learn how to deploy Reporting Services projects and individual reports and data sources
  • Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
  • Investigate how to manage Reporting Services projects using Report Manager

 

Snapshots and Subscriptions

 

  • Learn how to enable and control report caching
  • Investigate the scheduling of report snapshots
  • Explore the maintenance of report history
  • Discover how to create standard report subscriptions
  • Learn how to create data-driven report subscriptions

 

SQL Analysis Service (SSAS)

 

  • Introduction to SSAS
  • OLTP and OLAP
  • Schema’s and Dimensions
  • Measures and Aggregates
  • Creating Cube and Browsing Cube
  • Working with Data Source

Resume Preparation Tips

        1. Resume Review
        2. Resume Preparation Tips
        3. Sample Resumes

Interview Preparation

        1. Interview Preparation Tips
        2. Sample Interview Questions
        3. Tips & Guidelines for Effective Interview