Description
Explore the world of advanced database management with our Microsoft SQL Server training.
Learn how to write powerful queries, optimize database performance, and work effectively with SQL. This course offers a mix of theory and practice, allowing you to quickly develop skills to set up, manage and configure databases. Learn the basics of SQL Server components and learn how to identify network security risks. In addition, you will gain insight into advanced topics such as automation and software-defined networking.
Get ready for an advanced level in database management and one of the official Microsoft exams.
In short, Unleash the full power of Microsoft SQL Server with our Advanced Querying training and optimize your SQL skills for maximum database performance. Sign up now for an in-depth learning experience!
What do you learn?
- Explore SQL Server data types and learn data conversions for effective storage and manipulation.
- Understand and implement different types of subqueries for advanced query constructs.
- Work with various table expressions such as views, inline functions, and derivative tables for modular query approaches.
- Use ranking, offset, and aggregation window features to analyze data in a flexible way.
- Develop advanced query skills, including pivoting, unpivoting, and error handling techniques, for effective SQL Server implementations.
Audience
This course focuses on Database Administrators, Database Developers, and Business Intelligence professionals. Attendees are likely to be strongly represented by SQL users with expertise who are not necessarily database-oriented or planning to take the exam, such as report writers, business analysts, and client application developers.
We expect each participant to already have knowledge of:
- Basic knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and core features.
- Completed “Basic Querying Microsoft SQL Server 2012” training or similar knowledge.
What do we expect from each participant?
- Active participant during the lessons
- Self-study and labs to be carried out alongside the lessons
Methods
What does the process look like?
The process consists of 2 days.
You will have the time to further process the subject matter into self-study, create the labs and prepare for the next lesson.
We also recommend that you prepare the lessons carefully each time, because not all subject matter can be covered during the process.
What does your day look like?
- 8h45 - 9u00 | Reception
- 9:00 - 12:00 | Training
- 12:00 - 13:00 | Lunch
- 13:00 - 16u00 | Training
- 4:00pm - 4:30pm | Completion
- 4.30 pm - 5.30 pm | Networking option (optional)
Contents
Day 1:
Module 1: Exploring SQL Server Datatypes
- Lab 1: Writing queries for dates and times.
- Lab 2: Dealing with character data and functions.
Module 2: Subquery Techniques
- Lab 3: Writing queries with stand-alone subqueries.
- Lab 4: Using Exists predicate in subqueries.
Module 3: Working with table expressions
- Lab 5: Creating views and working with inline features.
- Lab 6: Using derivative tables and CTEs.
Module 4: Window Features
- Lab 7: Applying ranking, offset, and aggregate functions.
- Lab 8: Creating windows with the Over clause.
Day 2:
Module 5: Pivoting and Grouping Sets
- Lab 9: Writing queries with PIVOT and UNPIVOT
- Lab 10: Working with Grouping Sets, CUBE, and ROLLUP
Module 6: Executing stored procedures
- Lab 11: Using the EXECUTE statement for stored procedures
- Lab 12: Passing parameters to stored procedures
Module 7: Programming with T-SQL
- Lab 13: Declaring and Using Variables
- Lab 14: Applying control of flow elements.
Module 8: Implementing Error Handling
- Lab 15: Implementing Error Handling with TRY/CATCH
- Lab 16: Using THROW for error forwarding to a client.
Certification
Training and course recognition
This course is based on Microsoft's official training materials.
Trainers in this process are certified by Microsoft and have relevant experience.
Post-training certification
There is no officially recognized certificate for this training. Previously, this was the 70-461.
You will receive a Multimedi certificate of participation after completing this course.
Post-training
- Microsoft Certified: Azure Data Fundamentals (DP-900):
- This certification focuses on the basics of cloud data workloads. It covers Azure data storage options, data modeling, data manipulation, and Azure SQL Database basics.
- Microsoft Certified: Data Analyst Associate (DA-100):
- This certification focuses on data analysis using Power BI and SQL. It covers topics such as data preparation, modeling, visualization, and implementation of data solutions.
- Microsoft Certified: Azure Database Administrator Associate (DP-300):
- If you're more focused on managing databases in the Azure cloud, this certification is suitable. It includes tasks such as database deployment, security, performance optimization, and managing databases in Azure.
- Microsoft Certified: Azure AI Engineer Associate (AI-100):
- For those who want to specialize in artificial intelligence and machine learning on Azure, this certification is relevant. It covers topics such as designing and implementing solutions for natural language processing, speech, computer vision, and recommendation systems.