Web Content Display Web Content Display

Breadcrumb Breadcrumb

Schedule

Training Schedule Training Schedule

(6552) Querying Microsoft SQL Server 2014
Code: 6552 v0420
Type: null
Tuition (USD): $3095
Length: 5 Days
Have a question?

Get In Touch

Have an idea for your next great application development or analytics project?
Let us know so we can make it happen!

Tell Us Your Name

Enter Your Company Information

Write Us a Message

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 08/24/2020
Live Virtual, US 09/14/2020
Live Virtual, US 11/16/2020

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

Skills Gained:
SELECT query writing Query multiple tables Sort and filter data Data types in SQL Server Data modification using T-SQL Built-in functions Group and aggregate data Set operators Window functions: ranking, offset, and aggregate Pivot and group sets T-SQL programming Error handling and transaction implementation
Who Should Attend?
Database administrators Database developers Business intelligence professionals SQL power-users such as: Report writers Business analysts Client application developers
Prerequisites:
  • Working knowledge of relational databases
  • Basic knowledge of Microsoft Windows operation system and its core functionality
What You Will Learn:
  • Classroom Live Outline
  • 1. Microsoft SQL Server 2014
  • SQL Server Architecture
  • SQL Server Editions and Versions
  • SQL Server Management Studio
  • 2. Transact-SQL Querying
  • Transact-SQL
  • Sets
  • Predicate Logic
  • Logical Order of Operations in SELECT Statements
  • 3. Write SELECT Queries
  • Write Simple SELECT Statements
  • Eliminate Duplicates with DISTINCT
  • Column and Table Aliases
  • Write Simple CASE Expressions
  • 4. Querying Multiple Tables
  • Joins
  • Query with Inner Joins and Outer Joins
  • Query with Cross Joins and Self Joins
  • 5. 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
  • 6. SQL Server 2014 Data Types
  • SQL Server 2014 Data Types
  • Work with Character Data
  • Work with Date and Time Data
  • 7. DML to Modify Data
  • Insert Data
  • Modify and Delete Data
  • 8. Built-In Functions
  • Write Queries with Built-In Functions
  • Conversion Functions
  • Logical Functions
  • Use Functions to Work with NULL
  • 9. Grouping and Aggregating Data
  • Use Aggregate Functions
  • Use the GROUP BY Clause
  • Filter Groups with HAVING
  • 10. Sub-queries
  • Write Self-Contained Sub-queries
  • Write Correlated Sub-queries
  • Use the EXISTS Predicate with Sub-queries
  • 11. Table Expressions
  • Use Derived Tables
  • Use Common Table Expressions
  • Use Views
  • Use Inline Table-Valued Functions
  • 12. Set Operators
  • Write Queries with the UNION Operator
  • Use EXCEPT and INTERSECT
  • Use APPLY
  • 13. Window Ranking, Offset, and Aggregate Functions
  • Create Windows with OVER
  • Explore Window Functions including Ranking, Aggregate and Offset Functions
  • 14. Pivoting and Grouping Sets
  • Write Queries with PIVOT and UNPIVOT
  • Work with Grouping Sets
  • 15. Query Data with Stored Procedures
  • Query Data with Stored Procedures
  • Pass Parameters to Store Procedures
  • Create Simple Stored Procedures
  • Work with Dynamic SQL
  • 16. Programming with T-SQL
  • 17. Implement Error Handling
  • Use TRY/CATCH Blocks
  • Work with Error Information
  • 18. Implement Transactions
  • Transactions and the Database Engine
  • Control Transactions
  • Isolation Levels
  • 19. Appendix 1: Improve Query Performance
  • Factors in Query Performance
  • Display Query Performance Data
  • 20. Appendix 2: Query SQL Server Metadata
  • Query System Catalog Views and Functions
  • Execute System Stored Procedures
  • Query Dynamic Management Objects
Course Info:
In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, 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.

This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20461: Querying Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-461 and along with on-the-job experience, helps you prepare for the exam.

RELATED CERTIFICATIONS:
MCSA: SQL Server 2012/2014

FOLLOW-ON COURSES:
Administering Microsoft SQL Server 2014 Databases (M20462)
Implementing a Data Warehouse with Microsoft SQL Server 2014 (M20463)
Developing Microsoft SQL Server 2014 Databases (M20464)
Designing a Data Solution with Microsoft SQL Server 2014 (M20465)

Training Exclusives

This course comes with 12 months access to the following benefits:

Practice Labs
24x7 Mentoring
Indexed Class Recordings
Unlimited Retakes
Digital Courseware

* Terms and conditions may apply. Learn more about our Microsoft training exclusives by contacting training@dunnsolutions.com

Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.

Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.

Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.

Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.
Learn basic Transact- SQL queries for SQL Server 2012 and 2014.