Course Introduction

The delegates will get the skills to write basic T-SQL queries for Microsoft SQL Server 2014. This course acts as a Foundation for all Microsoft SQL Server courses such as Database Administration, Database Development, and Business Intelligence. This course helps delegates to prepare for the exam and get certified. Microsoft SQL Server 2014 is among the next generation of Microsoft’s information platform that has new features with more cloud capabilities, faster performance, and powerful business insights. SQL Server 2014 incorporates in-memory technology to boost performance in online transaction processing (OLTP) and data warehouse solutions. It eases the transition from on-premises solutions to the cloud. SQL Server 2014 continues to include components that support analysis

  • Be an expert in Cloud Technologies

  • Learn To Store Data on the Cloud

  • Get Certified From Microsoft Certified Trainers

  • Learn to Integrate Cloud and On-Premises Databases

  • Learn from Maven, Known Training Providers Globally

  • Earn Hikes in Potential Salaries in the Database Field

What's included

exam

Key Learning Points

exam

Exam Prepration Tips

exam

Tutor Support

exam

Certificate

Prerequisites

  • The delegates must have knowledge of working with the Microsoft Windows Operating System and its applications
  • The delegates are also expected to be familiar with the basics of a Relational Database Management System (RDBMS) in order to Understand Microsoft SQL Server 2014 easily

What Will You Learn

By undergoing this course, the delegates  will be familiar with the following concepts:

  • Writing SELECT Queries and query multiple tables
  • Sorting and Filtering Data retrieved from the database
  • Use SQL Server2014 Data Types
  • Make changes to the SQL Server 2014 data using T-SQL
  • Use built-in functions
  • Use aggregate functions and sub-queries
  • Understand table expressions and set operators, window ranking
  • Implement pivoting and grouping sets
  • Execute stored procedures and program with the help of T-SQL
  • Use error handling and transactions

Who should take this course

The persons who want to learn about the SQL Server query concepts should attend this course.

Overview

SQL Server 2014, brings in the new era of Microsoft’s Cloud OS, which provides organizations and customers with one consistent platform spanning customer datacenters, hosting service provider datacenters, and the Microsoft public cloud. The benefits that customers get from such a platform are common development, management, data, identity, and virtualization, irrespective of where the application may be executing. SQL Server 2014 also protects, unlocks, and scales the organization’s data across all devices, the cloud and data centers. Furthermore, SQL Server 2014 makes a strong impact on organizations worldwide with its new capabilities for transforming the IT industry. SQL Server provides mission-critical performance for the most demanding database applications and also while delivers the highest forms of security, scalability, high availability, and support. SQL Server 2014 has also enabled new unique hybrid-cloud solutions based on the Cloud OS.

These solutions are able to affect an organization’s bottom line and create innovative solutions for its database applications. SQL Server 2014’s main mission is to deliver faster insights into data of all kinds be it small or big and, most importantly, deliver business intelligence in a consumable manner through familiar tools such as Microsoft Excel.

 

Course Content

  • Introducing Microsoft SQL Server 2014
    • SQL Server Architecture
    • SQL Server Editions and Versions
    • Introducing the SQL Server Management Studio
  • Transact-SQL Querying
    • Learning to use the Transact-SQL
    • Using The SET Operators
    • Predicate Logic
    • Logical Order of Operations in SELECT Statements
  • Learning to Write SELECT Queries
    • Writing Simple SELECT Statements
    • Using DISTINCT to Eliminate Duplicate Result Sets
    • Understand Column and Table Aliases
    • Writing and Understanding CASE Expressions
  • Querying Multiple Tables
    • Joins and their types
    • Query with Inner Joins and Outer Joins
    • Differentiating between Cross Joins and Self Joins
  • Sorting and Filtering Data
    • Sort Data
    • Filter Data with a WHERE Clause
    • Filter with the TOP and OFFSET-FETCH Options
    • Work with Unknown and Missing Values
  • SQL Server 2014 Data Types
    • Data Types in SQL Server 2014 
    • Work with Character Data
    • Work with Date and Time Data
  • Data Manipulation Language (DML) to Modify Data
    • Insert Data
    • Modify Data 
    • Delete Data
  • Using Built-In Functions
    • Write Queries with Built-In Functions
    • Conversion Functions
    • Logical Functions
    • Handle NULL values using in-built functions.
  • Grouping and Aggregating Data
    • Use Aggregate Functions
    • Use the GROUP BY Clause
    • Applying conditions on a Group with HAVING clause
  • Sub-queries
    • Write Self-Contained Sub-queries
    • Write Correlated Subqueries
    • Use the EXISTS Predicate with Sub-queries
  • Table Expressions
    • Use Derived Tables
    • Use Common Table Expressions
    • Use Views
    • Use Inline Table-Valued Functions
  • Working with Set Operators
    • Write Queries with the UNION Operator
    • Use EXCEPT and INTERSECT
    • Use APPLY
  • Window Ranking, Offset, and Aggregate Functions
    • Create Windows with OVER
    • Explore Window Functions including Ranking, Aggregate and Offset Functions
  • Pivoting and Grouping Sets
    • Write Queries with PIVOT and UNPIVOT
    • Work with Grouping Sets
  • Query Data with Stored Procedures
    • Understanding Stored Procedures
    • Query Data with Stored Procedures
    • Pass Parameters to Store Procedures
    • Create Simple Stored Procedures
    • Work with Dynamic SQL
  • Implement Error Handling
    • Use TRY/CATCH Blocks
    • Work with Error Information
  • Implement Transactions
    • Understanding Transactions
    • Transactions and the Database Engine
    • Control Transactions
    • Isolation Levels
  • Improve Query Performance
    • Factors in Query Performance
    • Display Query Performance Data
  • Query SQL Server Metadata
    • Query System Catalog Views and Functions
    • Execute System Stored Procedures
    • Query Dynamic Management Objects

 

Querying Microsoft SQL Server 2014 (M20461) Enquiry

 

Enquire Now


----- OR -------

Reach us at 02077817982 or info@maventraining.co.uk for more information.

Training Venues

Maven Training provides top-notch training at different venues across the world. We offer nearly 200 courses at 1000+ locations. Our learning programs are the blend of thorough understanding and application of skills.

View All Locations