22 - 26 Apr 2024

1 week, 9:00 AM - 5:00 PM

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.

Mon 22 Apr 2024

1 day, 9:00 AM - 5:00 PM (8 hours)

In this course, you will expand your knowledge of relational database design,promote quality input from users, improve database efficiency, promote data integrity, implement advanced features in tables, queries, forms, and reports. This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019/2021.

Mon 22 Apr 2024

1 day, 9:00 AM - 5:00 PM (8 hours)

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Fri 26 Apr 2024

1 day, 9:00 AM - 5:00 PM (8 hours)

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2021. This course focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

29 - 30 Apr 2024

2 days, 9:00 AM - 5:00 PM

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Mon 29 Apr 2024

1 day, 9:00 AM - 5:00 PM (8 hours)

This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2019: Part 1 and Microsoft Office Excel 2019: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.