USA: +1-515-337-8778
India: +91-8008527566
info@sryitsolutions.com

SQL SERVER

What is SQL SERVER ?

SQL Server Pro is a trade digital publication and website owned by Penton serving the information needs of IT Professionals in various fields including data processing, database administration, database development, computer-related consulting, and many other areas.

SQL SERVER Online Training Content

SQL SERVER Online Training Details

Blog

SQL Server Overview

  • Understanding Client Server Architecture
  • SQL SERVER Basic Concepts
  • Introducing the Tools
  • Selecting an Edition
  • Creating Sample Databases

UsingManagement Studio

  • Arranging the Workspace
  • Registering Servers
  • Explaining Items in the Object Explorer
  • Explaining the Database Properties Dialog
  • Explaining the Columns Properties Dialog
  • Continuing with Object Explorer Items
  • Using the Query Editor

Designing Relational Databases

  • Understanding Normalization
  • Discovering Patterns
  • Avoiding Over Complexity
  • Managing Optional Data
  • Creating Physical Keys
  • Using the Database Diagrammer Tool
  • Final Comments

Selecting Data

Working With Single Table Queries

  • Understanding Query Flow
  • Filtering Data with the Where Clause
  • Columns, Expressions & Scalar Functions
  • Using Case Expressions
  • Working with Nulls & Coalesce
  • Selecting Environment Functions
  • Working with Dates & Times
  • Parsing Strings
  • Converting Data
  • 10. Sorting Data
  • 11. Topping Off the Query with Predicates

Merging Data With JOINS & UNIONS

  • Working with Inner Joins
  • Using Left Outer Joins
  • Multiplying Data with Cross Joins
  • Referencing Self-Joins
  • Working with Complex Joins
  • Finding the Set Difference
  • Stacking Data with Unions

Working With Sub-queries 

  • Using Subqueries as Expressions
  • Including Subqueries as Lists
  • Adding Subqueries as Derived Tables
  • Working with Correlated Subqueries
  • Solving for X with Relations Division

Aggregating Data

  • Using the New Windowing Functions
  • Using Aggregate Functions
  • Grouping a Data Set
  • Nesting Aggregations
  • Filtering Groups & Adding Grand Totals
  • Generating Cross Tab Tables (Pivot)
  • Calculating Cumulative Sums

Using Full-Text Search

  • Creating a Full-Text Index
  • Searching for Words
  • Using a Fuzzy Search to Search for Phrases

Selecting Data Through Views

  • Creating Views
  • Preventing Disappearing Rows
  • Protecting from Schema Changes
  • Nesting Views

Distributed Queries

  • Linking to External Data Sources
  • Executing Distributed Queries
  • Looking at Where the Work Takes Place
  • Using Pass Through Queries
  • Controlling Distributed Transactions

Modifying Data (29 min)

  • Inserting Data
  • Updating Data
  • Deleting Data
  • Using the Output Clause
  • Final Comments & Credits

T-SQL & Stored Procedures

  • Introducing T-SQL
  • Working with Variables
  • Controlling Procedural Flow
  • Examining SQL Server with Code
  • Using Temp Tables
  • Developing Dynamic SQL
  • Introducing Stored Procedures
  • Passing Parameters
  • Returning Parameters
  •  Working with a Cursor
  •  Handling Errors
  •  Explaining the Raise Error
  •  Controlling Transactions

 Triggers & Audit Trails

  • Introducing After Triggers
  • Using “Instead of” Trigger
  • Disabling Triggers
  • Using the Update ( ) Function
  • Selecting Transaction Data
  • Nesting & Recursion
  • Enforcing Complex RI
  • Auditing Data Changes

User-Defined Functions

  • Creating Scalar Functions
  • Working with Inline Table-Valued Functions
  • Using Multi-Statement Table-Valued UDFs
  • Navigating a Hierarchy
  • Having Fun with Apply
  • Exploring Functions in Nordic

Indexing For Performance

  • Introducing Indexes
  • Creating Indexes
  • Examinging Query Execution Plans, Pt. 1
  • Examinging Query Execution Plans, Pt. 2

Transactions, Locking & Blocking

  • Introducing ACID
  • Understanding Transactional Faults
  • Stepping through a Transaction
  • Exploring Locks
  • Working with Locks
  • Viewing Deadlocks
  • Using Snapshot Isolation

Introduction to Optimization Theory

  • Deconstructing the Database System
  • Walking through Optimization Theory
  • Optimization Theory Continued
  • Final Comments & Credits

 

Course Details:

Duration: 30-35 hours (Daily 1 hr to 1 hr 30 minutes)
System Access: 60 days
Session Timings: As per participant convenience
Payment Options: Paypal

Why SRY IT:

We are having ample of experience in SQL SERVER Online Training . After every session recordings will be provided and soft copy of SQL SERVER Online Training  material will be provided. After the sessions SQL SERVER  project support will be provided. CV preparation will be done with the ongoing clients. We are maintaining the Blogs for every course which will have the blogs related to new concepts.

About the Trainer:

SQL SERVER Online Training  will be provided by real time certified consultant. Overall experience of trainer is 8 years. Trainer is having good experience in corporate training. Trainer is an expert in implementation projects and support projects. In the training real time scenarios will be covered which helps the job seeker to handle the projects easily.

 Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn SQL SERVER Online Training .

To know more details about SQL SERVER visit our blog

Open Popup
  • Book Your Demo.