Training Schedule Training Schedule

(4395e) Querying Data with Transact-SQL (eLearning)
Code: 4395e v12-08-18
Type: null
Tuition (USD): $895
Length: 90 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
eLearning, US 02/01/2019

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

Skills Gained:
1. Describe key capabilities and components of SQL Server. 2. Describe T-SQL, sets, and predicate logic. 3. Write a single table SELECT statement. 4. Write a multi-table SELECT statement. 5. Write SELECT statements with filtering and sorting. 6. Describe how SQL Server uses data types. 7. Write DML statements. 8. Write queries that use built-in functions. 9. Write queries that aggregate data. 10. Write subqueries. 11. Create and implement views and table-valued functions. 12. Use set operators to combine query results. 13. Write queries that use window ranking, offset, and aggregate functions. 14. Transform data by implementing pivot, unpivot, rollup and cube. 15. Create and implement stored procedures. 16. Add programming constructs such as variables, conditions, and loops to T-SQL code
Who Should Attend?
The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
Prerequisites:
  • Students should have a working knowledge of relational databases and a basic knowledge of the Microsoft Windows operating system and its core functionality.
What You Will Learn:
  • On-Demand Outline
  • View More View More
  • 1. Introduction to Microsoft SQL
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • 2. Introduction to T-SQL Querying
  • Introducing T-SQL
  • Sets
  • Predicate Logic
  • Logical Order of Operations in SELECT statements
  • 3. Writing SELECT Queries
  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • 4. Querying Multiple Tables
  • Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • 5. Sorting and Filtering Data
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values
  • 6. Working with SQL Server 2016 Data Types
  • Introducing SQL Server 2016 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • 7. Using DML to Modify Data
  • Inserting Data
  • Modifying and Deleting Data
  • 8. Using Built-In Functions
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • 9. Grouping and Aggregating Data
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • 10. Using Subqueries
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • 11. Using Set Operators
  • 12. Using Set
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • 13. Using Windows Ranking, Offset, and Aggregate
  • Creating Windows with OVER
  • Exploring Window Functions
  • 14. Pivoting and Grouping Sets
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • 15. Executing Stored
  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • 16. Programming with T-SQL
  • T-SQL Programming Elements
  • Controlling Program Flow
  • 17. Implementing Error Handling
  • Implementing T-SQL Error Handling
  • Implementing Structured Exception Handling
  • 18. Implementing Transactions
  • Transactions and the Database Engines
  • Controlling Transactions
  • On-Demand Labs
  • View More View More
  • Lab 1: Working with SQL Server 2016 Tools
  • Lab 2: Introduction to Transact-SQL Querying
  • Lab 3: Writing Basic SELECT Statements
  • Lab 4: Querying Multiple Tables
  • Lab 5: Sorting and Filtering Data
  • Lab 6: Working with SQL Server 2016 Data Types
  • Lab 7: Using DML to Modify Data
  • Lab 8: Using Built-In Functions
  • Lab 9: Grouping and Aggregating Data
  • Lab 10: Using Subqueries
  • Lab 11: Using Table Expressions
  • Lab 12: Using SET Operators
  • Lab 13: Using Windows Ranking, Offset, and Aggregate
  • Lab 14: Pivoting and Grouping Sets
  • Lab 15: Executing Stored
  • Lab 16: Programming with T-SQL
  • Lab 17: Implementing Error Handling
  • Lab 18: Implementing Transactions
Course Info:
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first part of the content can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. The remaining content focuses on the skills required to take exam 70-761.

This is MOC for course 20761.

This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC).

RELATED CERTIFICATIONS:
Earning an MCSA: SQL 2016 Database Development certification validates your skills in building and implementing databases across organizations and will qualify you for a position as a database developer.

MCSA: SQL 2016 Database Development

Follow-On Courses:
Administering a SQL Database Infrastructure (M20764)
Implementing a SQL Data Warehouse (M20767)
Developing SQL Databases (M20762)

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

eLearning:
This course provides the same superior content as the instructor-led training delivered via the Internet so you can learn at your own pace.

These Self-Paced delivery format includes hundreds of titles designed to support your learning initiatives by focusing on both interactivity and expert instruction. These courses combine the knowledge of our subject matter experts with sophisticated development tools and techniques to create interactive self-paced content that provides flexibility and stretches your training dollars.

These award-winning Self-Paced training effectively incorporates the latest instructional design methodologies and mirrors the content we have used to train millions of IT and business professionals. WThese elf-paced training use the same instructional design and content from the instructor-led courses in developing these Self-Paced courses.

Benefits:
Study topical, results-oriented course content.
Learn at your own pace.
Have convenient access to hands-on labs.
Enjoy flexibility and savings.
Support corporate green initiatives.