Querying Microsoft SQL server 2014

skyrocket

Querying Microsoft SQL server 2014

From AED1,850.00

Description

Course Duration:

30  hours

Contents:

Introduction to Microsoft SQL Server 2014

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Lab : Working with SQL Server 2014 Tools

Introduction to T-SQL Querying

  • Introducing T-SQL
  • Understanding Sets and Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Lab : Introduction to Transact-SQL Querying

Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Lab : Writing Basic SELECT Statements

Querying Multiple Tables

  • Understanding Joins
  • Querying with Inner Joins, Querying with Outer Joins, Querying with Cross Joins and Self Joins
  • Lab : Querying Multiple Tables

Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values
  • Lab : Sorting and Filtering Data

Working with SQL Server 2014 Data Types

  • Introducing SQL Server 2014 Data Types
  • Working with Character Data, Working with Date and Time Data
  • Lab : Working with SQL Server 2014 Data Types

Using DML to Modify Data

  • Inserting Data
  • Modifying and Deleting Data
  • Lab : Using DML to Modify Data

Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Using Conversion Functions, Using Logical Functions
  • Using Functions to Work with NULL
  • Lab : Using Built-In Functions

Grouping and Aggregating Data

  • Using Aggregate Functions, Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Lab : Grouping and Aggregating Data

Using Subqueries

  • Writing Self-Contained Subqueries, Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Lab : Using Subqueries

Using Table Expressions

  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views, Using Inline Table-Valued Functions
  • Lab : Using Table Expressions

Using Set Operators

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Lab : Using Set Operators

Using Window Ranking, Offset, and Aggregate Functions

  • Creating Windows with OVER
  • Exploring Window Functions
  • Lab : Using Window Ranking, Offset and Aggregate Functions

Pivoting and Grouping Sets

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Lab : Pivoting and Grouping Sets

Executing Stored Procedures

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Lab : Executing Stored Procedures

Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Program Flow
  • Lab : Programming with T-SQL

Implementing Error Handling

  • Using TRY / CATCH Blocksa
  • Working with Error Information
  • Lab : Implementing Error Handling

Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels
  • Lab : Implementing Transactions

Reviews

There are no reviews yet.

Be the first to review “Querying Microsoft SQL server 2014”

Book Now
Contact Us