Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)

TOTAL DAYS: 2 | TOTAL HOURS: 13

Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)

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, allowing 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-backed visualizations to show insights and trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Completion of this course will earn 1.15 CEUs.

Delivering Dynamic Virtual Presentations

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Delivering Dynamic Virtual Presentations

Managing the virtual workplace isn’t as scary as it sounds. A lot of the basics of management (including communicating with others, managing performance, building teams, and leading meetings) are the same. This course will cover the differences and give you the skills that you need to successfully lead the virtual workplace.

Developing Your Leadership Style

TOTAL DAYS: 1 | TOTAL HOURS: 1

Developing Your Leadership Style

This program is intended for professional women in any industry that wish to take on a leadership role, network with other professionals, advance their careers, and build competencies to apply and make an impact on their own teams and organizations.

DP-050T00 Migrate SQL workloads to Azure

TOTAL DAYS: 2 | TOTAL HOURS: 16

DP-050T00 Migrate SQL workloads to Azure

In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure.

DP-300T00 Administering Relational Databases on Microsoft Azure

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

DP-300T00 Administering Relational Databases on Microsoft Azure

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

DP-900T00 Microsoft Azure Data Fundamentals

TOTAL DAYS: 1 | TOTAL HOURS: 8

DP-900T00 Microsoft Azure Data Fundamentals

In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

EC-Council Certified Ethical Hacker (CEH) v11

TOTAL DAYS: 5 | TOTAL HOURS: 40

EC-Council Certified Ethical Hacker (CEH) v11

CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 11th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.

EC-Council Certified Network Defender (CND)

TOTAL DAYS: 5 | TOTAL HOURS: 40

EC-Council Certified Network Defender (CND)

Certified Network Defender (CND) is a vendor-neutral, hands-on, instructor-led comprehensive network security certification training program. It is a skills-based, lab intensive program based on a job-task analysis and cybersecurity education framework presented by the National Initiative of Cybersecurity Education (NICE). The course has also been mapped to global job roles and responsibilities and the Department of Defense (DoD) job roles for system/network administrators. The course is designed and developed after extensive market research and surveys.

Excel 2013/2016 Programming with VBA

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Excel 2013/2016 Programming with VBA

Prerequisite

Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.

Completion of this course will earn 1.725 CEUs.

Get Going With QuickBooks 2021 for Windows

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Get Going With QuickBooks 2021 for Windows

– Prerequisites: You can successfully complete this course without any prior software knowledge or computer experience. A basic understanding of the computer operating system you are using is recommended.
– Delivery Method: Instructor-led, self-paced, classroom-delivery learning model with structured hands-on activities.
– Benefits: First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2021.

This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of QuickBooks.
– Get Going With QuickBooks 2021 for Windows (this course)
– Keep Going With QuickBooks 2021 for Windows
– Get Smart With QuickBooks 2021 for Windows

Completion of this course will earn 0.575 CEUs.