Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Nederland)
Part of the BPP Education Group
024-8457770
Microsoft - Querying Data with Microsoft Transact-SQL certification
Overview
On this accelerated Microsoft Querying Data with Microsoft Transact-SQL course, you’ll learn the basics of Microsoft's dialect of the standard SQL language: Transact-SQL.
In just 2 days, you’ll learn to query and modify data in relational databases that are hosted in Microsoft SQL Server-based database systems, including:
- Microsoft SQL Server
- Azure SQL Database
- Azure Synapse Analytics
There is no exam for this course. As a Microsoft Gold Partner for Learning, and through Firebrand’s Lecture | Lab | Review methodology, you’ll get access to the Microsoft Official Curriculum (MOCs), exams, and learn from Microsoft Certified Trainers (MCTs).
Audience
This course is ideal if you need to write basic SQL or Transact-SQL queries, including:
- Data analysts
- Data engineers
- Data scientists
- Database administrators
- Database developers
Benefits
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
Curriculum
Course DP-080T00: Querying Data with Microsoft Transact-SQL
- Module 1: Getting Started with Transact-SQL
- Lab: Get started with SQL Server query tools and writing queries in T-SQL
- Module 2: Sorting and Filtering Query Results
- Lab: Sort and filter data returned by SELECT queries
- Module 3: Using Joins and Subqueries
- Lab: Write queries with JOIN operations
- Lab: Write SELECT statements using subqueries
- Module 4: Using Built-in Functions
- Lab: Built-in functions
- Module 5: Modifying Data
- Lab: Modify data
Exam Track
There is no exam for this accelerated course.
What's Included
Your accelerated course includes:
- Accommodation *
- Meals, unlimited snacks, beverages, tea and coffee *
- On-site exams **
- Exam vouchers **
- Practice tests **
- Certification Guarantee ***
- Courseware
- Up-to 12 hours of instructor-led training each day
- 24-hour lab access
- Digital courseware **
- * For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
- ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
- *** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.
Prerequisites
There are no formal prerequisites for this accelerated course.
Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.
Reviews
Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.41% have said Firebrand exceeded their expectations.
Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.
"Very informative course which will prove very useful in the future."
MK. (3/10/2022 (Monday) to 4/10/2022 (Tuesday))
"Very good experience with the online-lecture, the instructor was very good and also engaged with topics the participants were confronted with at work, which was not necessarily part of the curriculum. Managed to stay in time."
Anonymous, Sopra Steria. (3/10/2022 (Monday) to 4/10/2022 (Tuesday))
"Really enjoyed the course, learnt a lot in 2 days. Tutor was very knowledgeable"
SB. (3/10/2022 (Monday) to 4/10/2022 (Tuesday))
"Training was very good, explanation was very clear and teacher detailed a lot, so for a 3 day course and to have a first understanding of POWER BI is good."
Rosanna Seerattan Cruz, JTI. (19/3/2024 (Tuesday) to 21/3/2024 (Thursday))
"The instructor and the structure of the course were very clear."
EK, JTI. (19/3/2024 (Tuesday) to 21/3/2024 (Thursday))
Course Dates
|
Start |
Finish |
Status |
Location |
Book now |
|---|---|---|---|---|
|
19/2/2024 (Monday) |
20/2/2024 (Tuesday) |
Finished - Leave feedback |
- |
|
|
24/6/2024 (Monday) |
25/6/2024 (Tuesday) |
Wait list |
Nationwide |
|
|
5/8/2024 (Monday) |
6/8/2024 (Tuesday) |
Limited availability |
Nationwide |
|
|
16/9/2024 (Monday) |
17/9/2024 (Tuesday) |
Open |
Nationwide |
|
|
28/10/2024 (Monday) |
29/10/2024 (Tuesday) |
Open |
Nationwide |
|
|
9/12/2024 (Monday) |
10/12/2024 (Tuesday) |
Open |
Nationwide |
|