Microsoft Querying Data with Transact-SQL

The highest quality teaching in the industry delivered through our unique accelerated learning methodology. Expert instructors allow students to receive and retain maximum knowledge in minimum time in a distraction-free environment.

You want new efficiencies, new opportunities and growth from technology, and you will need skills to get them. With Readynez Talent Services you will answer real and burning business challenges. No wonder we’ve been awarded the Microsoft Learning Partner of the year global finalist award for helping businesses transform and achieve remarkable results.

You'll use Official Course materials. You'll also use Readynez's unique Lecture | Lab | Review technique, which will immerse you in topics like:

Querying multiple tables

Working with SQL Server 2016 data types

At Readynez we know your time is valuable. That's why we give you the opportunity to gain your Microsoft Querying Data with Transact-SQL Training in just 3 days. We provide the best conditions for you to learn.

With us by your side, encouraging and guiding you along the way, you can enjoy 3 intense, focused days of quality learning in a distraction free environment. Your expert instructor will be working with Readynez's unique accelerated learning methods, which include our exclusive lecture/lab/review methodology with real life cases putting you in the best possible position to learn and retain knowledge.

Module 2: Introduction to T-SQL QueryingThis module introduces the elements of T-SQL and their role in writing queries, describes the use of sets in SQL Server, describes the use of predicate logic in SQL Server, and describes the logical order of operations in SELECT statements.

Describe the elements of T-SQL and their role in writing queriesDescribe the use of sets in SQL ServerDescribe the use of predicate logic in SQL ServerDescribe the logical order of operations in SELECT statements

Module 3: Writing SELECT QueriesThis module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.

Module 4: Querying Multiple TablesThis module explains how to write queries which combine data from multiple sources in SQL Server. The module introduces the use of JOINs in T-SQL queries as a mechanism for retrieving data from multiple tables.

Describe how multiple tables may be queried in a SELECT statement using joins.Write queries that use inner joins.Write queries that use outer joins.Write queries that use self-joins and cross joins.

Module 5: Sorting and Filtering DataThis module explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. The module also discusses how to resolve missing and unknown results.

Lessons

Sorting DataFiltering Data with PredicatesFiltering with the TOP and OFFSET-FETCH OptionsWorking with Unknown ValuesLab : Sorting and Filtering Data

After completing this module, you will be able to:

Filter data with predicates in the WHERE clause.Sort data using ORDER BY.Filter data in the SELECT clause with TOP.Filter data with OFFSET and FETCH.

Module 6: Working with SQL Server 2016 Data TypesThis module explains the data types SQL Server uses to store data. It introduces the many types of numeric and special-use data types. It also explains conversions between data types, and the importance of type precedence.

Lessons

Introducing SQL Server 2016 Data TypesWorking with Character DataWorking with Date and Time DataLab : Working with SQL Server 2016 Data Types

Insert new data into your tables.Update and delete existing records in your tables.

Module 8: Using Built-In FunctionsThis module introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion, testing for logical results and nullability.

Module 9: Grouping and Aggregating DataThis module introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. The module is designed to help the student grasp why a SELECT clause has restrictions placed upon column naming in the GROUP BY clause as well as which columns may be listed in the SELECT clause.

Lessons

Using Aggregate FunctionsUsing the GROUP BY ClauseFiltering Groups with HAVINGLab : Grouping and Aggregating Data

After completing this module, you will be able to:

Write queries which summarise data using built-in aggregate functions.Use the GROUP BY clause to arrange rows into groups.Use the HAVING clause to filter out groups based on a search condition.

Module 10: Using SubqueriesThis module will introduce the use of subqueries in various parts of a SELECT statement. It will include the use of scalar and multi-result subqueries, and the use of the IN and EXISTS operators.

Describe the uses of queries which are nested within other queries.Write self-contained subqueries which return scalar or multi-valued results.Write correlated subqueries which return scalar or multi-valued results.Use the EXISTS predicate to efficiently check for the existence of rows in a subquery.

Module 11: Using Set OperatorsThis module introduces the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.

Lessons

Writing Queries with the UNION OperatorUsing EXCEPT and INTERSECTUsing APPLYLab : Using SET Operators

You get 3 more hours of training with Readynez and save 2 days out of the office

You will get the best conditions to learn in minimum time. Your expert instructor will train you using Readynez's unique accelerated learning methods, in our distraction-free environment, putting you in the best possible position to learn and retain knowledge and pass your exams.

The course Microsoft Querying Data with Transact-SQL has been added to the basket.

It will take you just a moment to see how cheap our courses are...

Name*

Error

Work email*

Error

Phone*

Error

Company*

Error

Please fill in missing fields to complete form.

We´ve created your login

Thank you, we´ve created your login and sent your login details to your email. You will automatically be logged in now.

Convince your boss

Let’s give your boss a head’s up about the benefits of this course.

*Required fields

Boss’s name*

Error

Boss’s email*

Error

Your full name*

Error

Your work email*

Error

Comment*

Error

Please fill in missing fields to complete form.

Notification sent

All set! Your boss has been notified of your interest in this course.

YOUR BENEFITS!

Effective instruction must be highly varied and interactive to keep attention levels high, promote learning and teamwork between the students and instructor, and solidify knowledge through hands-on learning.
That's the Readynez way.

Your personal benefits

1

Your Readynez training programme will get you trained in fewer days with more training hours per day than any other provider

2

Maximum learning in a distraction free environment

3

Dedicated, onsite support at all hours

4

Improved knowledge and confidence with official certification

5

Instructors with real-world experience – you will learn about real-world problems and solutions to strengthen your understanding and skill level

6

We help you study - our focus is on real learning, not just the course or the exam, so we support you to make the most of the course and to improve your exam technique

“The Trainer made complex Technologies easier to understand with his explanations and demonstration throughout the course. Everything needed to study was provided for you which made it easy to focus on the course. The venue and classroom was excellent.”

Glenroy Thompson

Online50

“This course covered all objectives without a feeling of being rushed through it. The instructor made the course more enjoyable with a funny and relaxed approach whilst still sharing his wide knowledge on all the topics.”

Gareth James

AIRBUS

“”

“”

“”

Microsoft

Microsoft

Readynez has been awarded with the Microsoft Learning Partner award in Denmark no less than 5 times as the first and only education partner ever!

Plus - in 2017 we were named among 2800 partners worldwide as a finalist for the Microsoft Global Learning Partner of the Year!

WHAT'S INCLUDED

Everything! In addition to your all-inclusive course package specifically designed to your
requirements, we go the extra mile to make sure you have everything you need and will
attend to every detail, so you can focus solely on your studies and certification goals.

Wherever you are in the world, you can experience a distraction-free environment by staying in one of our purpose-built training centres. To make it easy for you to train with us, we offer your a transporation service.
We´ll pick you up and drop you off after your course, from/to designated pick-up points - so you won´t have to think about how to reach us or get back home.

Accommodation

Our unique accelerated learning methodology offers you maximum knowledge within minimum time in a distraction-free environment.

You´ll be staying in a comfortable single room with private bathroom facilities and all amenities taken care of. Your room is on site, very close to your classroom, so you won´t be wasting any energy on gettting to and from.

Hands-on training

With Readynez you will learn by doing.

We help you study - our focus is on real learning and your expert Instructor will be teching you using our unique lecture/lab/review methodology that helps you learn more and retain knowledge better.

All course materials

All course materials are included in your course fee. There is no hidden cost.

We supplement the full courseware with our expert guidance and relevant, real-world situational reviews empowering your business to get real business value from this course.

Instructor-led programme

We provide the best conditions for you to learn.

Your training is in safe hands with us. We use the best instructors in the world, who will be using our unique accelerated learning methods to teach you. With our guidance you will be maximising your learning and be able to put your new skills to use in no time.

24 hour classroom access

Train as it suits you.

When you´re staying with us - there will be no limits to your learning. Your classroom will be open at all hours, so you have complete freedom to train and review as you please, without being limited by schedules.

All meals

We´ll take good care of you.

Your training days start with a full breakfast in the dining room, with its fantastic view of Oresund. Mornings and afternoons, good coffee and home-baked coffee bread will be served. Later, lunch is served and in the evening, you will enjoy your dinner as the sun sets over Denmark.

Certification guarantee

If the unlikely thing happens, and you don´t pass first time.

The Certification Guarantee allows you to train again for free in a 12 month period, if you do not pass first time. You only pay for any exams, labs and accommodation.

Onsite testing

Examination as part of your course.

As a part of your course, you will take your exams on site before you leave the course centre. This way, you are tested while knowledge and exam technique are fresh in your mind and you have the best possible chance of passing.

Certification

What do you get?

As part of your course, you will be prepared for, and tested in, the following exam, which is covered by your Certification Guarantee:

Exam 70-761: Querying Data with Transact-SQL

Microsoft Software Assurance Vouchers

You may be entitled to heavily discounted Microsoft training with SA vouchers. If you are unsure how many vouchers you have available, we can help you find out.

Fill in this form and we'll get back to you quickly to let you know how many SA Vouchers you have.

Your full name*

Work email*

Phone number*

In addition to professional experience, you must have the following technical knowledge:

Working knowledge of relational databases.

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

Working knowledge of Transact-SQL.

Do you have what it takes?We´ll help you decide – Call us to discuss your technical background, experience and qualifications to determine how we can help you succeed in this Readynez course.

Just call us and speak to one of our enrolment consultants.

DATES

Here are the planned dates for your course.
Book now and get ready for your future.

On this accelerated 3 day Networking with Windows Server 2016 course you'll develop the fundamental skills you need to develop and manage your Windows Server environment. This will help you to bring the in-built networking benefits of Windows Server 2016 to your business, fast.

Thank you, for signing up to our Firebrand newsletter. You will hear from us soon.

Readynez

Since 2001, we´ve been working to accelerate digital transformation for people and businesses.With Readynez you are empowered to achieve any vision for your talent strategy, so you can reach the next level of performance and be ready for the future.

We are here to help you – use the form below or call us at +45 8818 4320

*Required fields

Your full name*

Error

Company*

Error

Work email*

Error

Phone number*

Error

How can we help you?*

Error

Please fill in missing fields to complete form.

Inquiry sent

Thank you, your inquiry has been received – we will be in touch as soon as possible.

Chat with us about any question you might have. We´re to help you prepare for your future. Please just choose the person best suited to assist you. Please wait a few seconds while we discover who´s free...

Inquiry sent

Thank you, your inquiry has been received – we will be in touch as soon as possible.