Querying Data with Transact-SQL (M20761)

What is Querying Data with Transact-SQL (M20761)?

This Microsoft training 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. Days 4 & 5 teach the remaining skills required to take exam 70-761. The main purpose of the training 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.

Who is Querying Data with Transact-SQL (M20761) intended for?

The primary target audience for this training course is: Database Administrators, Database Developers and BI professionals. 

Candidates will need:

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

What are the objectives of Querying Data with Transact-SQL (M20761)?

After completing this training course, students will be able to:

  • 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.

Keypoints

keypoints accredited

Starting Price:£2745

Duration:5 Days

Querying Data with Transact-SQL (M20761) Calendar

Filters

Select Your Course

Select Your Location

Select Delivery Method

Keypoints

keypoints accredited

Starting Price:£2745

Duration:5 Days

Querying Data with Transact-SQL (M20761)

Sorry! Our team is updating this schedule!


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

Please reach us at+44 20 4571 2395 or info@siliconbeachtraining.co.uk or for more information about the schedule

meeting

Upcoming Dates

There are no Upcoming Dates Available for - Querying Data with Transact-SQL (M20761)


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

Please reach us at+44 20 4571 2395 or info@siliconbeachtraining.co.uk or for more information about the schedule

Onsite Training

Our Onsite/In-house Training method is most selected by organisations, as it allows them to train their employees at their choice of place. We can also tailor the course content to focus on your needs.

Leading Path to Success

step-1

Find a course and let us know how you would like to learn.

Step 1

step-2

Select your preferred method of training for the course.

Step 2

step-3

Confirm your seats.

Step 3

step-4

Get an excellent experience with our qualified instructors.

Step 4

step-5

Acquire skills and achieve your career goals.

Step 5

460+

Courses

92+

Locations

126K+

Learners

Some Facts Worth Shouting About

To win in this competitive world, you need to be constantly moving forward, and Silicon Beach Training is the one that can help you. Our courses are highly engaging as we have high-quality and certified training courses for both individuals and organisations that are structured in easy to digest modules. We don't compromise on the quality of our trainers. We have:

Our Clients

With extensive experience working with large organisations, national and local government, universities, charities, SMBs and individuals we believe that no client is too big or too small. This creates a diverse atmosphere on our scheduled courses with the opportunity to discuss solutions for a wide range of problems. We excel at developing bespoke training solutions for prestigious clients including EDF Energy, Sport England and Tesco PLC.

Banco Central Do Brasil

Nationwide Building Society

EDF Energy

EDF Energy

Sport England

Sport England

Tesco PLC

Tesco PLC

Imperial College London

Imperial College London

Request info Get Free Advice Quick Enquiry
LOADING