Querying Microsoft SQL Server 2014 (M20461)

  • Effectively manage database using T-SQL queries

  • Quickly perform data operations like sort, filter, group and aggregate

  • Course is designed by well experienced and certified trainers

Key Points About Querying Microsoft SQL Server 2014 (M20461)

237 Learners Recommended

Duration: 5 Days*

Accredited: Yes

Book Now

Querying Microsoft SQL Server 2014 (M20461)

Course Overview

The Querying Microsoft SQL Server 2014 course helps the delegates in acquiring the skills required to write T-SQL statements for managing SQL Server. This course is a foundation level course while Administering Microsoft SQL Server 2014 Databases course is an advanced level. The delegates during this course learn to use the SQL statements using SQL Server Management Studio (SSMS). Also, the delegates will understand how to sort, group and aggregate data. The course also teaches how to manage transactions in SQL Server. This course acts as a first step towards the certification and is a must for candidates who wish to obtain SQL Server skills.

Course Outline

Introduction to Microsoft SQL Server 2014

  • Basic Architecture of SQL Server
  • SQL Server versions and editions
  • SQL Server Management Studio

Introduction to T-SQL Querying

  • T-SQL overview
  • Understand sets
  • Understand base logic and logical order of operations in SELECT statements

Writing SELECT Queries

  • How to write simple SELECT statements
  • Remove duplicates with DISTINCT
  • Use table aliases and columns
  • Write simple CASE expressions

Querying Multiple Tables

  • Joins overview
  • Query with Inner and outer joins
  • Query with self-joins and cross joins

Sorting and Filtering Data

  • Sort data
  • Using WHERE clause filter data
  • With TOP and OFFSET-FETCH options filter data
  • Work with missing and unknown values

Working with SQL Server 2014 Data Types

  • SQL Server 2014 data types
  • Work with character data
  • Work with time and date data

Use DML to Change Data

  • Add data
  • Modify and delete data

Using Built-in Functions

  • With Built-in functions write queries
  • Use conversion and logical functions
  • Use functions to work with NULL

Grouping and Aggregating data

  • Use aggregate functions
  • Use GROUP BY clause
  • Filter groups with HAVING

Using Subqueries

  • Write Self-contained and correlated subqueries
  • Use EXISTS predicate with subqueries

Using Table Expressions

  • Use derived tables and common table expressions
  • Use views and Inline Table-Valued Functions

Using Set Operators

  • With UNION operator write queries
  • Use INTERSECT, EXCEPT and APPLY

Using Window Ranking, Offset, and Aggregate Functions

  • With OVER create windows
  • Explore Window Functions

Pivoting and Grouping Sets

  • Write queries with PIVOT and UNPIVOT
  • Work with grouping sets

Executing Stored Procedures

  • Query data with stored procedures
  • Pass parameters to stored procedures
  • Create simple stored procedures
  • Work with Dynamic SQL

Programming with T-SQL

  • Programming elements of T-SQL
  • Controlling program flow

Implementing Error Handling

  • Use TRY/CATCH block
  • Work with error information

Implementing Transactions

  • Transactions and Database engine
  • Control transactions
  • Isolation Levels

Before enrolling in to this course, the delegates must have a fundamental knowledge of Windows operating systems and the I/O devices used with the Windows O/S.

The Querying Microsoft SQL Server 2014 (M20461) course targets those delegates who want to go ahead into database administration, database development, and business intelligence.

The Querying Microsoft SQL Server 2014 (M20461) Cost in United Kingdom Starts from £13195.00

Please see our Microsoft SQL Server Training courses available in United Kingdom

  • Key Learning Points
  • Exam Preparation Tips
  • Tutor Support
  • Certification
telephone

Get More Information

Still have questions? We’re happy to help.

calendar

Dates & Prices

Choose a Location

Choose a Month

Learn from the comfort of your home or office

Join discussions via computer or mobile device

Interact with subject matter experts

40 Hours (on average)

90 Days Access

Certificate upon completion

Schedule and location of your choice

Save on travel costs

Monitor employee development

Key points about this course

237 Learners Recommended

Duration: 5 Days*

Accredited: Yes

Add additional features

Official Exam - £ 329.00

Personal career coach and career services

Your online (Querying Microsoft SQL Server 2014 (M20461)) package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Course Onsite Enquiry

Querying Microsoft SQL Server 2014 (M20461)

Complete the steps below to receive a quote or more information

Your details

How many employees need training test?

When would you like to take the course test?

How many employees need training?

Prev

Discover how we are doing

Our goal is to always provide training of the highest quality for your organisation.

We aim for customer satisfaction across all areas, including price, quality, and learning support. We always use the feedback from clients to continually improve and ensure we surpass expectation. Have a look at our customer reviews that showcase the standard we offer.

97% price

Response Rate

99% price

Positive Rating

Steps For Success

Leading Path To Success

works