Course Introduction

This five-day course provides delegates with the required technical skills to write basic transact SQL queries for Microsoft SQL Server 2014. It is the foundation course for all Microsoft SQL Server courses namely Database Administration, Database Development and Business Intelligence. This course helps delegates to prepare for the exam and get certified.

Querying Microsoft SQL Server

This training helps a delegate to write basic SQL queries for Microsoft SQL Server 2014.This training gives the knowledge of SQL Server Management Studio, T-SQL, SELECT statements , data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server.

 

Course Content

Introduction to Microsoft SQL Server 2014

  • Basic architecture of SQL Server
  • SQL Server editions and versions
  • Get started with SQL Server Management Studio

Introduction to T-SQL Querying

  • Introducing T-SQL
  • Understanding Sets
  • Predicate Logic
  • Understanding Logical order of operations In SELECTstatements

Write SELECT queries

  • Write simple SELECT statement
  • Eliminate Duplicate records with the help of DISTINCT
  • Use Column and Table Aliases
  • Writing SIMPLE CASE Expressions

Querying Multiple Tables

  • Understand Joins
  • Query with Inner Joins, Outer Joins, Cross joins, and Self- joins

Sorting and Filtering data

  • Sorting data
  • Filtering data using WHERE clause
  • Filter with TOP and OFFSET-FETCH options
  • Work with Missing and Unknown values

Work with SQL Server 2014 Data types

  • Introducing SQL Server 2014 Data Types
  • Work with Character Data, Date and Time data

Using DML to modify data

  • Insert data
  • Modify and Delete data

Using Built-in Functions

  • Write queries with built-in functions
  • Using Conversion as well as Logical functions
  • Using Functions to work with NULL

Grouping and Aggregating Data

  • Use aggregate functions
  • Use GROUP by clause
  • Filtering Groups with HAVING

Using Subqueries

  • Writing Self-contained subqueries
  • Write Correlated subqueries
  • Using EXISTS predicate along with Subqueries

Using Table Expressions

  • Use Derived Tables
  • Use Common Table Expressions
  • Use Views
  • Using Inline Table-Valued Functions

Using SET operators

  • Writing Queries using UNION Operator
  • Use EXCEPT, INTERSECT and APPLY

Using Window Ranking, Offset and Aggregate Functions

  • Creating Windows using OVER
  • Exploring Window Functions

Pivoting and Grouping Sets

  • Write Queries using PIVOT and UNPIVOT
  • Work with Grouping Sets

Executing stored procedures

  • Query Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Create Simple Stored Procedures
  • Work with Dynamic SQL

Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Flow of Program

Implementing error handling

  • Use TRY / CATCH Blocks
  • Work with Error Information

Perform Transactions

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels

Improve Query Performance

  • Query Performance Factors
  • Displaying Query Performance Data

Querying SQL Server Metadata

  • Querying System Catalog Views and Functions
  • Execute System Stored Procedures
  • Querying Dynamic Management Objects

Note: Lab is provided in this course for hands-on practice and practical learning.

Prerequisites

The delegate must have a working knowledge of relational database. Also, possess some basic understanding of Microsoft Windows operating the system and other Microsoft programs.

Target Audience

This course is intended for below-mentioned delegates:

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals
  • SQL power users such as report writers

Delegates Will Learn How To

  • Learn to write SELECT queries and Query multiple tables.
  • Effectively sort and filter data.
  • Describe use of data types in SQL Server
  • Modify data using Transact-SQL and make use of built-in functions.
  • Learn to use subqueries, table expressions, set operators, window ranking, offset and other aggregate functions.
  • Implement pivoting and grouping sets.
  • Execute stored procedures and program with the help of T-SQL
  • Implement error handling wherever required and transactions.

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Querying Microsoft SQL Server Training Calender

Filters

arrow

Querying Microsoft SQL Server

Contact Us for Date and Price

Enquire Nowup-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Querying Microsoft SQL Server

Contact us for Date and Price

Enquire up-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Querying Microsoft SQL Server

hours

40 Hours (on average)

days

90 Days Access

administration

40 Hours (on average)

  • Course Price

    £1535

  • add-ons Price

    £0

  • Sub-Total

    £1535

foundation-call Enquire Now

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 from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

name name-red
email email-red
phone-call phonecall-red
house house-red
book book-red
position position-red
house house-red
comment comment-red
conference

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

whiteboard

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

messaging

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

control

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

future

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

search}

Select the Course

Choose the course you want to attend to fulfil your desired goals.

details}

Attend the Course

Attend the training with your prefered method at your convenience.

book}

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Querying Microsoft SQL Server

£ 1535 £ 1485

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

skilled

Get Tailored Programmes

affordable

Quick Delivery

flexible

Scalability and Consistency

access

90 Days Access

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

name

name name-red
phone-call phonecall-red
email email-red
email email-red
comment comment-red
up-arrow
LOADING