Upcoming
Sessions
Welcome!    Login | Checkout 0 Items | Checkout
ETI Performance Improvement

Technical Training

Creating Rock Stars since 1984


Querying SQL Server 2014

Microsoft Course Number: 10774A

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Prerequisites

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic understanding of virtualization technology (Classroom labs utilize virtual machines) 



More About This Session


Topics
Dates & Registration

Querying SQL Server 2014

5 Days

Your Price: $2995


Register!

Topic 1. Microsoft SQL Server 2014

  • SQL Server Architecture
  • SQL Server Editions and Versions
  • SQL Server Management Studio

Topic 2. Transact-SQL Querying

  • Transact-SQL
  • Sets
  • Predicate Logic
  • Logical Order of Operations in SELECT Statements

Topic 3. Write SELECT Queries

  • Write Simple SELECT Statements
  • Eliminate Duplicates with DISTINCT
  • Column and Table Aliases
  • Write Simple CASE Expressions

Topic 4. Querying Multiple Tables

  • Joins
  • Query with Inner Joins and Outer Joins
  • Query with Cross Joins and Self Joins

Topic 5. Sorting and Filtering Data

  • Topic Sort Data
  • Filter Data with a WHERE Clause
  • Filter with the TOP and OFFSET-FETCH Options
  • Work with Unknown and Missing Values

Topic 6. SQL Server 2014 Data Types

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

Topic 7. DML to Modify Data

  • Insert Data
  • Modify and Delete Data

Topic 8. Built-In Functions

  • Write Queries with Built-In Functions
  • Conversion Functions
  • Logical Functions
  • Use Functions to Work with NULL

Topic 9. Grouping and Aggregating Data

  • Use Aggregate Functions
  • Use the GROUP BY Clause
  • Filter Groups with HAVING

Topic 10. Sub-queries

  • Write Self-Contained Sub-queries
  • Write Correlated Sub-queries
  • Use the EXISTS Predicate with Sub-queries

Topic 11. Table Expressions

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

Topic 12. Set Operators

  • Write Queries with the UNION Operator
  • Use EXCEPT and INTERSECT
  • Use APPLY

Topic 13. Window Ranking, Offset, and Aggregate Functions

  • Create Windows with OVER
  • Explore Window Functions including Ranking, Aggregate and Offset Functions

Topic 14. Pivoting and Grouping Sets

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

Topic 15. Query Data with Stored Procedures

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

Topic 16. Programming with T-SQL

Topic 17. Implement Error Handling

  • Use TRY/CATCH Blocks
  • Work with Error Information

Topic 18. Implement Transactions

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

Querying SQL Server 2014

5 Days

Your Price: $2995

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

back to top

Customize Sessions

Need a customized session?


Did you know that all of our sessions can be customized?
Let us help create a private session your team will love!

Selected Sessions

No Sessions Selected

Add a session to begin registration.
  • Personalize This Session

    All of our sessions can be customized to meet your team's specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team's valuable time!

    Let us help customize your next:

    Lunch-n-Learn

    30-90 Minute Webinar

    Half or Full Day Training

    On-Demand Learning

    Team Learning Paths



    Contact us today!



Contact

ETI Performance Improvement
8500 Keystone Crossing Suite 550
Indianapolis, Indiana 46240

p. 317.475.6555
f. 317.475.6556
e. [email protected]

Hours:
8:00 am - 5:00 pm M-F EST

Educate. Equip. Empower.
ETI Performance Improvement

© 2018 ETI Performance Improvement        Illustrations ©2012 Nathaniel Charles