Querying Data With Transact-SQL Server 2016

by Vinsys

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Vinsys Logo

img Duration

Enquire Now

Course Details

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum

 

Querying Data With Transact-SQL Server 2016 Course

  • Describe key capabilities and components of SQL Server 2016.

  • Describe T-SQL, sets, and predicate logic.

  • Write a single table SELECT statement.

  • Write a multi-table SELECT statement.

  • Write SELECT statements with filtering and sorting.

  • Describe how SQL Server uses data types.

  • Write DML statements.

  • Write queries that use built-in functions.

  • Write queries that aggregate data.

  • Write subqueries.

  • Create and implement views and table-valued functions.

  • Use set operators to combine query results.

  • Write queries that use window ranking, offset, and aggregate functions.

  • Transform data by implementing pivot, unpivot, rollup and cube.

  • Create and implement stored procedures.

  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

Audience

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.

 

Eligibility Criteria

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

  • Working knowledge of relational databases.

  • Manhattan Branch

    132 West 31st Street, First Floor, Manhattan, New York
  • Mid-town Brandywine Branch

    1209 Orange St, Mid-town Brandywine, Wilmington
  • Loma Verde Branch

    3163 Loma Verde Drive, Unit 10, Loma Verde, San Jose

Check out more SQL Server courses in USA

Yes-M Systems Logo

Oracle DB (Introduction To SQL Training)

Learn how to design, implement, support, and maintain databases with our Oracle Database SQL course. Learn about data security, high availability, and integrity. Oracle is one of the highly used databases in the world today.

by Yes-M Systems [Claim Listing ]
Business Computer Skills Logo

MySQL Querying Fundamentals

The MySQL Querying Fundamentals class teaches students the fundamentals of how to write MySQL statements and perform simple queries of a database. Students will learn the core skills needed to access and manipulate data from MySQL databases. This course covers MySQL version 8.0.

by Business Computer Skills [Claim Listing ]
Fun Coderz Logo

Learn SQL

Learn about databases, move from basic understanding to advance level SQL Query

by Fun Coderz [Claim Listing ]
  • Price
  • Start Date
  • Duration
Austin Community College Continuing Education Logo

Oracle Certification

Oracle is a world's largest enterprise software company and the Oracle certification carries significant weight throughout the software industry.

by Austin Community College Continuing Education [Claim Listing ]
Netcom Learning Logo

Microsoft SQL Server

This course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages and to use SSIS to extract, transform, and load data to and from SQL Server.

by Netcom Learning

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy