Microsoft Querying Data with Transact-SQL - Only 3 Days

Seven reasons why you should sit your Querying Data with Transact-SQL course with Firebrand Training

Find Out How We Help You To Learn New Skills Quickly

  1. You'll be Querying Data with Transact-SQL certified in just 3 days. With us, you’ll be Querying Data with Transact-SQL trained in record time
  2. Our Querying Data with Transact-SQL course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  3. Pass Querying Data with Transact-SQL first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  4. You’ll learn more Querying Data with Transact-SQL. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  5. You’ll learn Querying Data with Transact-SQL faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  6. You’ll be studying Querying Data with Transact-SQL with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified 64,486 professionals, and we’re partners with all of the big names in the business
  7. You'll do more than study Querying Data with Transact-SQL courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

When do you want to sit your accelerated course?

Start

Finish

Status

Location

Book now

Finished

-

 

Limited availability

Dubai/UK

Book now

Open

Dubai/UK

Book now

Open

Dubai/UK

Book now

Here's the Firebrand Training review section. Since 2001 we've trained exactly 64,486 students and asked them all to review our Accelerated Learning. Currently, 96.53% have said Firebrand exceeded their expectations:



"Had a great time at Firebrand. Thank you for all your support."
Jacob Johnson, St Johns School. - Microsoft Windows Server 2016 - Networking (3 days) (14/8/2017 to 16/8/2017)

"Very good course, enjoyable under many aspects. The instructor was very friendly, knowledgeable and patient (I ask many questions). Thank you"
Christian Dornetto, CRM Dynamics Ltd. - Microsoft Specialist: Programming in HTML5 with JavaScript and CSS3 (3 days) (5/8/2017 to 7/8/2017)

"Firebrands intensive courses are great for achieving qualifications fast!"
Muhammed Haque. - Microsoft Specialist: Programming in HTML5 with JavaScript and CSS3 (3 days) (5/8/2017 to 7/8/2017)

"The training was very helpful and puts a lot of things into perspective and real life. It is explained in a way that makes sense, which isn't always captured from a book."
M.J., Knauf Insulation. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (31/7/2017 to 5/8/2017)

"Really enjoyed my short time here. I've made lots of new friends and learned a lot of new stuff within the 6 days that I've been here. Gareth has been great and has helped us through every section of the course."
James Laird, Jmfinn & Co. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (31/7/2017 to 5/8/2017)

"It was a great course, relevant information and a knowledgeable instructor. It helped to make a good bond with other attendees, helping with the evening revision and practice exams together in the hotel bar, or purely just moral support! Be prepared for a lot of intense information, take notes and use whatever vice you need; coffee, sugar, fizzy drinks to keep you alert! I had a great time and would definitely recommend."
KAYLEA REED, UTILITA ENERGY. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (31/7/2017 to 5/8/2017)

"My journey at Firebrand has been great. First course with them, it was extremely informative and I learnt more than I ever would in my own time. The course duration was just right, 6 days to cover 3 modules was perfect. The practice exams are priceless, you can never prepare yourself for the real thing however they got you ready for the daunting aspect of exam conditions. The level of help, support and enthusiasm for us to succeed drives you to do your best (and the failure is not an option T-shirt helps!). Thank you - I will be back!"
Leah Hunt, Scientifica. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (31/7/2017 to 5/8/2017)

"I have learnt a lot this week with Firebrand, their instructors were all friendly and experienced, and have the experience they have in the real world has significantly contributed to my passing this course."
James Gunn, Softwerx. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (31/7/2017 to 5/8/2017)

"The course was great; fast paced enough to keep you interested and the instructors will give you excellent insight the books wont."
R.W., 3T RPD Ltd. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (31/7/2017 to 5/8/2017)

"Excellent Environment and training provided. Thank you"
Anonymous - Microsoft MTA Networking Fundamentals (2 days) (2/8/2017 to 3/8/2017)

"Its been really hard work, but really worth the time. "
Jeffrey Vermunt, MK2. - Microsoft MCSE: Communication (Skype for Business) (6 days) (17/7/2017 to 22/7/2017)

"Training has been of high standards and quality and why I have returned for 3rd time to train with them. I would highly recommended Firebrand Training to anyone wanting to certify themselves."
S.B., Sutaj Ltd. - Microsoft MCSE: Communication (Skype for Business) (6 days) (17/7/2017 to 22/7/2017)

"Great course with a brilliant course teacher. The instructor managed to dumb down complex concepts and made an interactive educative environment."
Mohammad B, CRMCS Consultancy. - Microsoft Specialist: Programming in C# (4 days) (3/7/2017 to 6/7/2017)

"The training is very good. It is not passive, so you have to work hard, but you get all the key information you need to build upon - with your own reading and revision adding the extra insight needed for the exam. My expectation before the course was that I might pass one of the three exams, but I soon realised that if I was prepared to work in the evenings as the instructor encouraged us all to, then I could get through them all (so far Ive passed 2 with one more this afternoon!). It was up to me now. Having passed an MCP in server 2003 through self-study - which took nearly 12 months - I was very impressed with how much you can learn when able to get the answers you need from a subject matter expert and how quickly you can get through a single exam - a matter of a few days. The labs were also very useful for getting hands-on experience and testing out what you had learned during the day. In terms of the accommodation and food, it was excellent - a small issue with my shower was fixed within hours and the staff are all friendly and very professional. You get a very good choice of food and if you prefer a low carb diet like myself then thats no problem. If you prefer to relax in the evening then there is a decent bar where you can take some time out with your new friends. "
Ben Kane, Euro Recycling. - Microsoft MCSA: Windows Server 2016 (11 days) (24/6/2017 to 4/7/2017)

"Excellent learning environment, knowledgeable staff. Well paced course syllabus."
Matthew Ottley, Manuli Hydraulics UK Ltd. - Microsoft MCSA: Windows Server 2016 (11 days) (24/6/2017 to 4/7/2017)

"5th Course at firebrand, and as always a great experience. Trainers are friendly and willing to answer most any questions you may have, even if they have to get back to you later 10/10"
Ethan ODonnell. - Microsoft Windows Server 2016 - Networking (3 days) (28/6/2017 to 30/6/2017)

"Very happy with the course and cannot wait to come back for mtadev in a couple of months. Definitely enjoy server work."
Jamie H., Watchfinder&co. - Microsoft MCSA: Windows Server 2016 (11 days) (24/6/2017 to 4/7/2017)

"Have been to Firebrand several times and the training is of a high standard. Great way to get qualified in a short time."
Richard Smith, Redcare (5G Communications). - Microsoft MCSA: Windows Server 2012 R2 (9 days) (13/5/2017 to 21/5/2017)

"If you are prepared to attend an intense training course, Firebrand is for you. After 3 days of training, I gained a huge amount of knowledge. Just be ready to learn! And take your skills to the next level."
Mark Cunningham, Capgemini. - Microsoft Specialist: Dynamics CRM 2016 Customisation and Configuration (4 days) (16/5/2017 to 19/5/2017)

"Firebrand provides great training with brilliant instructors. The course was enjoyable and the resources I had access to were fantastic"
Azimuth Jenkins, Capgemini. - Microsoft Specialist: Dynamics CRM 2016 Customisation and Configuration (4 days) (16/5/2017 to 19/5/2017)

"Very professional, interesting, comprehensive training! "
Michal Jarosinski, UTILITA.ENERGY. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (8/5/2017 to 13/5/2017)

"Highly engaging trainer! Found the MCSA Server 2012 course to be intense but it was helped along the way with the unique and fun way that the trainer took with his approach to it. Hes very, very knowledgeable in the subject which is helped with live notes to take a way (a first for me!) and provided time to carry out labs to test out what is learnt in theory."
The Vinh Hoang, Agent Provocateur Ltd. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (1/4/2017 to 9/4/2017)

"Really impressed with the training and the on-site facilities. Its been a great experience. "
Matt Hill, Coeo Ltd. - Microsoft Azure Academy: Data Lake & Data Factory (2 days) (30/3/2017 to 31/3/2017)

"Good experience at the course. Great introduction and working experience with Data Lakes and Data Factory. The instructor was very patient and clear."
Terry Choo, eBECS. - Microsoft Azure Academy: Data Lake & Data Factory (2 days) (30/3/2017 to 31/3/2017)

"The training is very intensive, but everything is taken care of and thought about. The instructor was immensely knowledgeable and had huge amounts of experience. The facility is excellent too."
Matt Bridgeworth, Softcat plc. - Microsoft Specialist: Architecting Microsoft Azure Solutions (2 days) (29/3/2017 to 30/3/2017)

"Firebrand delivers a complete studying experience that is geared towards results. Tutors and support staff are excellent with incredible knowledge and outstanding customer service. The immersive format is absolutely critical to the success of the training approach and delivers results time after time. If you want your organisation and your staff to develop and succeed then Firebrand is the training partner that you need. Completely committed to delivering the results that you deserve. Love it........"
Paul OSullivan, CSC. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (13/3/2017 to 21/3/2017)

"Very useful, very intense, Plenty of information to take in but it was all useful and will be practical for when i take it back to work. Only positives to say really."
Aman Kumar, DMS. - Microsoft MTA Database Fundamentals (2 days) (20/3/2017 to 21/3/2017)

"We had Phil Anderson, a very nice and intelligent man. He had to put through a lot of information. I did not take the exam at the end of the week, because I am a person who needs more time to process information. The course was structured and well done by Phil. I would recommend him as a trainer. Teacher gets a 9. The facilities of the training were good. Everything was prepared before the training, so it had an easy start. "
Danny van Oijen, Havenziekenhuis. - Microsoft MCSA: Windows 10 (6 days) (13/3/2017 to 18/3/2017)

"Very hard work, but it gets you through the course. My brain is so full!"
Chris Fitz-Avon. - Microsoft Developing ASP.NET MVC Web 4 Applications (3 days) (14/3/2017 to 16/3/2017)

"I would recommend Firebrand to anyone who wants to get qualified quickly in a fast learning environment. The days are tough but rewarding as well."
Nick Margerum, React CP. - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (13/3/2017 to 15/3/2017)

"Excellent training. For anyone planning to take certification it's helpful and intensive. This training helped me understand the new features of the software and how to use those for performance improvement of our data model."
Brinda Jana, British Red Cross. - Microsoft MCSA: SQL Server 2016 - Business Intelligence Development (5 days) (6/3/2017 to 10/3/2017)

"Great delivery and having the freedom to learn key areas critical to my job made this course fantastic. The fact that I had a VM remotely accessible from my hotel room was a big help, allowing me to mess around with settings. "
Paul Robertshaw. - Microsoft MCSA: Windows Server 2012 R2 & MCSE: Server Infrastructure (15 days) (25/2/2017 to 11/3/2017)

"A very informative course, ideal for any server administrator. Covered many areas that my personal studying and experience hadnt reached."
PhIllip Edwards, Telis LTD. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"I love coming to do my training down at Firebrand, this is the 5th time I have been down here and I have always gained lots of experience from the courses. "
N.M. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Having little knowledge before attendance im leaving with much more confidence and understanding."
P.R. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Every one of the instructors Ive had on courses here has been amazing in there own way. They are all experts in the field when it comes to the knowledge required to pass these courses."
Jai Hayes. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Firebrand Training goes into depth on the all the training courses they do, they provide all the information required for exam and do it in such a way that is easy to understand. All the instructors are friendly and always willing to help."
Adam Sells, Hospice in the Weald. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Excellent learning ennvironment dedicated to your specific requirements. Great professional networking as well."
K.P. - Microsoft MCSA: Windows 10 (6 days) (20/2/2017 to 25/2/2017)

"Super fast paced course in which I learnt so much!"
Claire Farina. - Microsoft MTA HTML5 App Development Fundamentals (2 days) (22/2/2017 to 23/2/2017)

"I love coming down to firebrand for my training, its really intense but very rewarding. Staff and trainers are so professional and knowledgeable "
Simon Leyland, Prodo Digitalhtml. - Microsoft MTA HTML5 App Development Fundamentals (2 days) (22/2/2017 to 23/2/2017)

"Training was extremely engaging and i am happy to say i have walked away with a lot of knowledge and NOTES! The tutor used multiple training styles so it gave everyone in the classroom the opportunity to work with their learning style. Overall a good course taught by a very good tutor. "
Daniel Whitley. - Microsoft MTA HTML5 App Development Fundamentals (2 days) (22/2/2017 to 23/2/2017)

"Intensive but enjoyable course. First step on the ladder towards MCSD."
Jason Hinsley, IM Tec Solutions. - Microsoft MTA Software Development Fundamentals (2 days) (20/2/2017 to 21/2/2017)

"I loved it! I did a 2-day course was very fast-paced and intense, the instructor was very personable, enthusiastic, extremely knowledgeable and an all-round fun guy to talk to. I learned way more than I thought I could within 2 days. The whole experience was very enjoyable and I would highly recommend it. Im already looking forward to my next course. "
Ashleigh Bair. - Microsoft MTA Software Development Fundamentals (2 days) (20/2/2017 to 21/2/2017)

"Firebrand provide an ideal training that shortens the length of the time that the training takes whilst providing all the required content. The course was delivered with a smile and a laugh. "
Tim Headicar. - Microsoft MCSA: Windows Server 2016 (11 days) (11/2/2017 to 21/2/2017)

"I have had a great 11 days on this course, i have learnt all i need to pass the exams, the instructor was great and very knowledgeable. I will be looking to come back and further my qualifications here again."
T.S. - Microsoft MCSA: Windows Server 2016 (11 days) (11/2/2017 to 21/2/2017)

"I have been to Firebrand 9 times now and looking forward to coming back again! Having all resources that I could possibly need within 1 facility means that the time here can be dedicated solely to training and get the best accelerated experience. "
R.M, Gamma. - Microsoft MCSA: Windows Server 2016 (11 days) (11/2/2017 to 21/2/2017)

"My experience at Firebrand was amazing. The instructors level of knowledge was beyond my expectations and the facilities were excellent"
John Cutt. - Microsoft MCSE: SharePoint 2016 (6 days) (6/2/2017 to 11/2/2017)

"The training I received at whilst training with Firebrand was excellent. 11 Days on the course was hard work and demanded a lot of will power. I put in the time and effort and it paid off for me. Thank you to all involved. See you next time."
M.C. - Microsoft Dynamics CRM 2016 (11 days) (29/1/2017 to 8/2/2017)

"I found the courses, trainers and accommodation very good. I learnt a lot and felt very comfortable. I think accelerated learning is a good way to learn and firebrand delivers this very well."
Joanne Nash, Fujitsu Services. - Microsoft Dynamics CRM 2016 (11 days) (29/1/2017 to 8/2/2017)

"It was intense but provides the focus necessary to achieve so much in such a short time. The environment prevents distraction, the course material was detailed and the instructor very knowledgeable and helpful."
Tunde Tayo. - Microsoft Dynamics CRM 2016 Cloud (7 days) (2/2/2017 to 8/2/2017)

On this 3-day accelerated Querying Data with Transact-SQL course you will develop your understanding of managing, querying and programming data through Transact-SQL components. You will also learn the skills to use Transact-SQL language, relevant to all of the SQL Server disciplines. These skills will help you run advanced queries against your data to extract insight to drive your business' performance.

This course is 50% faster than other traditional training courses, meaning you’ll be back in the office sooner, putting your new skills into practice.

You will develop your knowledge and skills of Transact-SQL. Specific skills you will learn include:

  • Create Transact-SQL SELECT queries
  • Implement functions and aggregate data
  • Query data by using table expressions
  • Group and pivot data by using queries
  • Implement error handling transactions
  • Implement data types and NULLs

Firebrand are Microsoft Gold Learning Partners which means you'll benefit from Microsoft's Official Curriculum (MOC), delivered by our experienced Microsoft Certified Trainers (MCT). Our unique Lecture | Lab | Review approach means you’ll get exposure to both the theoretical and practical tasks. This will help you retain information and provide you with the hands-on skills necessary to apply your new skills when you return to the office.

You’ll be prepared for and sit your exam on-site. This is covered by your Certification Guarantee.

This exam is intended for SQL Server database administrators, system engineers and developers with two or more years of experience. This is for professionals looking to validate their skills and knowledge in writing queries.

Read more ...

Interested? See prices or call +971 4 3199019

You'll get certified 50% faster: This means you'll return to the office sooner, putting your new skills to practice.

Microsoft Official Curriculum (MOC): We offer Microsoft Official Curriculum meaning you'll have the latest and most up-to-date curriculum available.

Microsoft Certified Trainers (MCT): You'll learn from our Microsoft Certified Instructors who boast years of industry knowledge. Their experience and unique insights will be used to enrich your learning experience.

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

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

Firebrand Training provides instruction to meet every learning need:

  • Intensive group instruction
  • One-on-one instruction attention
  • Hands-on labs
  • Lab partner and group exercises
  • Question and answer drills
  • Independent study

This information has been provided as a helpful tool for candidates considering training. Courses that include certification come with a certification guarantee. Pass first time or train again for free (just pay for accommodation and exams on your return). We do not make any guarantees about personal successes or benefits of obtaining certification. Benefits of certification determined through studies do not guarantee any particular personal successes.

Read more ...

Interested? See prices or call +971 4 3199019

Course 20761B: Querying Data with Transact-SQL

Module 1: Introduction to Microsoft SQL Server 2016

This module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.

Lessons

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio

Lab : Working with SQL Server 2016 Tools

After completing this module, you will be able to:

  • Describe the architecture and editions of SQL Server 2012.
  • Work with SQL Server Management Studio.

Module 2: Introduction to T-SQL Querying

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

Lessons

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements

Lab : Introduction to Transact-SQL Querying

After completing this module, you will be able to:

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

Module 3: Writing SELECT Queries

This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.

Lessons

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions

Lab : Writing Basic SELECT Statements

After completing this module, you will be able to:

  • Write simple SELECT statements.
  • Eliminate duplicates using the DISTINCT clause.
  • Use column and table aliases.
  • Write simple CASE expressions.

Module 4: Querying Multiple Tables

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

Lessons

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins

Lab : Querying Multiple Tables

After completing this module, you will be able to:

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

This 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 Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values

Lab : 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 Types

This 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 Types
  • Working with Character Data
  • Working with Date and Time Data

Lab : Working with SQL Server 2016 Data Types

After completing this module, you will be able to:

  • Describe numeric data types, type precedence and type conversions.
  • Write queries using character data types.
  • Write queries using date and time data types.

Module 7: Using DML to Modify DataThis module describes the use of Transact-SQL Data Manipulation Language to perform inserts, updates, and deletes to your data.

Lessons

  • Inserting Data
  • Modifying and Deleting Data

Lab : Using DML to Modify Data

After completing this module, you will be able to:

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

Module 8: Using Built-In Functions

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

Lessons

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL

Lab : Using Built-In Functions

After completing this module, you will be able to:

  • Write queries with built-in scalar functions.
  • Use conversion functions.
  • Use logical functions.
  • Use functions that work with NULL.

Module 9: Grouping and Aggregating Data

This 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 Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING

Lab : 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 Subqueries

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

Lessons

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries

Lab : Using Subqueries

After completing this module, you will be able to:

  • 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 Table Expressions

Previously in this course, you learned about using subqueries as an expression that returned results to an outer calling query. Like subqueries, table expressions are query expressions, but table expressions extend this idea by allowing you to name them and to work with their results as you would work with data in any valid relational table. Microsoft SQL Server 2016 supports four types of table expressions: derived tables, common table expression (CTEs), views, and inline table-valued functions (TVFs). In this module, you will learn to work with these forms of table expressions and learn how to use them to help create a modular approach to writing queries.

Lessons:

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

Lab: Using Table Expressions

  • Writing Queries That Use Views
  • Writing Queries That Use Derived Tables
  • Writing Queries That Use Common Table Expressions (CTEs)
  • Writing Queries That Sue Inline Table-Valued Expressions

After completing this module, you will be able to:

  • Write queries that return results from views.
  • Use the CREATE FUNCTION statement to create simple inline TVFs.
  • Write queries that create and retrieve results from derived tables.
  • Write queries that create CTEs and return results from the table expression

Module 12: Using Set Operators

This module introduces the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.

Lessons:

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

Lab: Using SET Operators

After completing this module, you will be able to:

  • Write queries using UNION, EXCEPT, and INTERSECT operators.
  • Use the APPLY operator.

Module 13: Using Windows Ranking, Offset, and Aggregate Functions

This module describes the benefits to using window functions. Restrict window functions to rows defined in an OVER clause, including partitions and frames. Write queries that use window functions to operate on a window of rows and return ranking, aggregation, and offset comparison results.

Lessons:

  • Creating Windows with OVER
  • Exploring Window Functions

Lab: Using Windows Ranking, Offset, and Aggregate Functions

  • Writing Queries that use Ranking Functions
  • Writing Queries that use Offset Functions
  • Writing Queries that use Window Aggregate Functions

After completing this module, students will be able to:

  • Describe the T-SQL components used to define windows, and the relationships between them.
  • Write queries that use the OVER clause, with partitioning, ordering, and framing to define windows
  • Write queries that use window aggregate functions.
  • Write queries that use window ranking functions.
  • Write queries that use window offset functions

Module 14: Pivoting and Grouping Sets

This module describes write queries that pivot and unpivot result sets. Write queries that specify multiple groupings with grouping sets.

Lessons:

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets

Lab: Pivoting and Grouping Sets

  • Writing Queries that use the PIVOT Operator
  • Writing Queries that use the UNPIVOT Operator
  • Writing Queries that use the GROUPING SETS CUBE and ROLLUP Subclauses

After completing this module, students will be able to:

  • Describe how pivoting data can be used in T-SQL queries.
  • Write queries that pivot data from rows to columns using the PIVOT operator.
  • Write queries that unpivot data from columns back to rows using the UNPIVOT operator.
  • Write queries using the GROUPING SETS subclause.
  • Write queries that use ROLLUP AND CUBE.
  • Write queries that use the GROUPING_ID function.

Module 15: Executing Stored Procedures

This module describes how to return results by executing stored procedures. Pass parameters to procedures. Create simple stored procedures that encapsulate a SELECT statement. Construct and execute dynamic SQL with EXEC and sp_executesql.

Lessons:

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL

Lab : Executing Stored Procedures

  • Using the EXECUTE statement to Invoke Stored Procedures
  • Passing Parameters to Stored procedures
  • Executing System Stored Procedures

After completing this module, students will be able to:

  • Describe stored procedures and their use.
  • Write T-SQL statements that execute stored procedures to return data.
  • Write EXECUTE statements that pass input parameters to stored procedures.
  • Write T-SQL batches that prepare output parameters and execute stored procedures.
  • Use the CREATE PROCEDURE statement to write a stored procedure.
  • Create a stored procedure that accepts input parameters.
  • Describe how T-SQL can be dynamically constructed.
  • Write queries that use dynamic SQL.

Module 16: Programming with T-SQL

This module describes how to enhance your T-SQL code with programming elements.

Lessons:

  • T-SQL Programming Elements
  • Controlling Program Flow

Lab: Programming with T-SQL

  • Declaring Variables and Delimiting Batches
  • Using Control-Of-Flow Elements
  • Using Variables in a Dynamic SQL Statement
  • Using Synonyms

After completing this module, students will be able to:

  • Describe how Microsoft SQL Server treats collections of statements as batches.
  • Create and submit batches of T-SQL code for execution by SQL Server.
  • Describe how SQL Server stores temporary objects as variables.
  • Write code that declares and assigns variables.
  • Create and invoke synonyms
  • Describe the control-of-flow elements in T-SQL.
  • Write T-SQL code using IF...ELSE blocks.
  • Write T-SQL code that uses WHILE.

Module 17: Implementing Error Handling

This module introduces error handling for T-SQL.

Lessons:

  • Implementing T-SQL error handling
  • Implementing structured exception handling

Lab: Implementing Error Handling

  • Redirecting errors with TRY/CATCH
  • Using THROW to pass an error message back to a client

After completing this module, students will be able to:

  • Implement T-SQL error handling.
  • Implement structured exception handling.

Module 18: Implementing Transactions

This module describes how to implement transactions.

Lessons:

  • Transactions and the database engines
  • Controlling transactions

Lab: Implementing Transactions

  • Controlling transactions with BEGIN, COMMIT, and ROLLBACK
  • Adding error handling to a CATCH block

After completing this module, students will be able to:

  • Describe transactions and the differences between batches and transactions.
  • Describe batches and how they are handled by SQL Server.
  • Create and manage transactions with transaction control language (TCL) statements.
  • Use SET XACT_ABORT to define SQL Servers handling of transactions outside TRY/CATCH blocks.

Read more ...

Interested? See prices or call +971 4 3199019

You'll sit the following exams, covered by your Certification Guarantee:

  • Exam 70-761: Querying Data with Transact-SQL

This exam will test your knowledge and skills on the following:

  • Manage data with Transact-SQL (40-45%)
  • Query data with advanced Transact-SQL components (30-35%)
  • Program databases by using Transact-SQL (25-30%)

Read more ...

Interested? See prices or call +971 4 3199019

Included in your accelerated training course will be:

  • Microsoft Official Curriculum
  • Exam 70-761: Querying Data with Transact-SQL

Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.

Our Certification Programs includes

  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive Study Materials, Program Courseware and Self-Testing Software including MeasureUp *
  • Fully instructor-led program with 24 hour lab access
  • Examination vouchers **
  • Near site testing, Transportation to/from Testing Center are provided ***
  • Accommodation, all meals, unlimited beverages, snacks and tea / coffee****
  • Examination Passing Policy

Please note

  • * Not on all courses
  • ** Examination vouchers are not included for the following courses: PMP, CAPM, CISA, CISM, CGEIT, CRISC and CISSP CBK Review
  • *** Not included in our PMP, CAPM, CISA, CISM, CGEIT, CRISC, or ITIL Managers and Revision Certifications
  • **** Accommodation not included on the CISSP CBK Review Seminar

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Examination Passing Policy

Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year.  Students will only be responsible for accommodations and vendor exam fees.

Read more ...

Interested? See prices or call +971 4 3199019

You must have a working knowledge of relational databases and basic knowledge of the Microsoft Windows operating system and its core functionality.

Unsure whether you meet the prerequisites?

Don’t worry - we’ll discuss your technical background, experience and qualifications to determine whether this accelerated course suits you.

Just call us on +971 4 3199019 and speak to one of our enrolment consultants.

Firebrand is an immersive environment and requires commitment. Some prerequisites are simply guidelines; you may find your unique experience, attitude and determination enables you to succeed on your accelerated course.

Interested? See prices or call +971 4 3199019