Learn to Query Microsoft SQL Server 2014 Databases with Our Course

Download Course Contents

Querying Microsoft SQL Server 2014 Databases Course Overview

New version 20761C:Querying Data with Transact-SQL 2016 is now available.

The Querying Microsoft SQL Server 2014 Databases online course is designed to provide learners with the knowledge and skills required to extract and analyze data using Transact-SQL. The course will cover the basics of querying a database and then build on that knowledge to give students a deep understanding of the topics involved in data mining and analysis. Topics covered include understanding the relationships between tables, designing queries, manipulating data with built-in functions, and using the SELECT statement to obtain data. Students will also learn to create and modify tables, views, and stored procedures; manage transactions and locks; and secure databases. At the end of the course, learners will have the necessary skills to use Transact-SQL to work with databases more efficiently and effectively.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

home-icon

The 1-on-1 Advantage

Get 1-on-1 session with our expert trainers at a date & time of your convenience.
home-icon

Flexible Dates

Start your session at a date of your choice-weekend & evening slots included, and reschedule if necessary.
home-icon

4-Hour Sessions

Training never been so convenient- attend training sessions 4-hour long for easy learning.
home-icon

Destination Training

Attend trainings at some of the most loved cities such as Dubai, London, Delhi(India), Goa, Singapore, New York and Sydney.

You will learn:

Module 1: 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
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT Statements
  • Lab: Introduction to T-SQL Querying
  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Lab: Writing Basic SELECT Statements
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Lab: Querying Multiple Tables
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering Data with TOP and OFFSET-FETCH
  • Working with Unknown Values
  • Lab: Sorting and Filtering Data
  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Lab: Working with SQL Server 2014 Data Types
  • Adding Data to Tables
  • Modifying and Removing Data
  • Generating Numbers
  • Lab: Using DML to Modify Data
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Using Built-In Functions
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Lab: Grouping and Aggregating Data
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Using Subqueries
  • Using Views
  • Using Inline TVFs
  • Using Derived Tables
  • Using CTEs
  • Lab: Using Table Expressions
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Using Set Operators
  • Creating Windows with OVER
  • Exploring Window Functions
  • Lab: Using Window Ranking, Offset, and Aggregate Functions
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Lab: Pivoting and Grouping Sets
  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Lab: Executing Stored Procedures
  • T-SQL Programming Elements
  • Controlling Program Flow
  • Lab: Programming with T-SQL
  • Implementing T-SQL Error Handling
  • Implementing Structured Exception Handling
  • Lab: Implementing Error Handling
  • Transactions and the Database Engine
  • Controlling Transactions
  • Lab: Implementing Transactions
Live Online Training (Duration : 40 Hours) Fee On Request
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
Date On Request
Winner of the Microsoft’s Asia Superstar Campaign in FY 22
Winner of the Microsoft’s Asia Superstar Campaign in FY 22
Course Prerequisites

The Querying Microsoft SQL Server 2014 Databases Training does not usually have prerequisites, although having some basic knowledge of using computers and a general understanding of relational databases is beneficial. It is recommended that learners complete the Querying Microsoft SQL Server 2012/2014 Training and Core Concepts before taking this course. In particular, the following topics are recommended:
Basic Database Concepts
TSQL Fundamentals
Creating and Manipulating Database Objects
Creating and Manipulating Programmability Objects in SQL Server
Understanding and Apply RDBMS Concepts
Database Design
Basic Data Analysis
Setting up Database Backup and Restore Procedures
Monitoring Database Performance
Using Views and User Defined Functions
Managing Data Integrity with Constraints
Creating and Tuning Stored Procedures
Managing Security in SQL Server

Target Audience


This Querying Microsoft SQL Server 2014 Databases training is targeted towards IT professionals who have basic knowledge of managing relational databases, such as defining constraints, transactions and property enforcement
It is also suitable for developers who are looking to build their skills in querying MS SQL Server
The training also applies to system administrators and engineers, who want to understand and gain a hands-on practice experiance in writing complex and multi-table SQL queries

The training requires participants to have a basic understanding of key systems administration concepts and how to perform basic SQL operations such as SELECT, INSERT, UPDATE and DELETE
The course would be beneficial to those looking to specialize in Microsoft SQL Server 2014, developing more efficient queries and creating procedure-oriented databases

Learning Objectives of Querying Microsoft SQL Server 2014 Databases


1. Learn how to utilize MS SQL Server 2014 in a data-driven environment
2. Understand the relational database management system provided by MS SQL Server.
3. Become familiar with the Transact-SQL language used in creating and modifying databases.
4. Master the concepts of database querying and query optimization.
5. Understand the structure of SQL Server 2014 databases.
6. Learn the basics of creating tables and schemas.
7. Gain the knowledge of writing queries and stored procedures.
8. Get accustomed to server-side programming and the components of the SQL Server 2014 platform.
9. Learn to manage MS SQL Server 2014 databases with tasks such as backup and recovery.
10. Develop the ability to export, import and transform data.

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?
on Trust Pilot
Student Name Feedback
Abubaker Ahmed Soliman Mustafa
United States
A3. Yes

FAQ's


1-on-1 Public - Select your start date. Other students can be merged.
1-on-1 Private - Select your start date. You will be the only student in the class.
Yes, course requiring practical include hands-on labs.
You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
Yes, you can pay from the course page and flexi page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You can request a refund if you do not wish to enroll in the course.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
After you submit your payment, you will land on the payment confirmation screen.It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however,it takes 48 hours for the money to be moved.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, if we have an office in your city.
Yes, we do offer corporate training More details
Yes, we do.
Yes, we also offer weekend classes.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes.You can access courseware for most vendors.
Yes, this is our official email address which we use if a recipient is not able to receive emails from our @koenig-solutions.com email address.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
Yes you can.
Yes, we do. For details go to flexi
You can pay through debit/credit card or bank wire transfer.
Yes you can request your customer experience manager for the same.
Yes, fee excludes local taxes.
Yes, we do.
Yes, Koenig Solutions is a Microsoft Gold Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1 on 1 Public you can select your own schedule, other students can be merged. Choose 1-on-1 if published schedule doesn't meet your requirement. If you want a private session, opt for 1-on-1 Private.
Duration of Ultra-Fast Track is 50% of the duration of the Standard Track. Yes(course content is same).

Prices & Payments

Yes of course.
Yes, We are

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.