Grow Your IT & Business Skills & Get Certified

SQL Server Integration Services is the equivalent of the retired MOC Course 20767CC - Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft® Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do. This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): 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. Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Ex

This course teaches you the skills that are needed to administer IBM WebSphere Application Server V9.This release of IBM WebSphere Application Server provides enhanced support for standards (notably Java 7 EE), emerging technology, and a choice of development frameworks.In this course, you learn how to configure and maintain IBM WebSphere Application Server V9 in a single-server environment. You learn how to deploy enterprise Java applications in a single computer configuration. In addition, you learn how to work with features of WebSphere Application Server V9, such as the wsadmin scripting interface, security, and performance monitoring.Hands-on exercises throughout the course give you practical experience with the skills you develop in the lectures.

In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Azure Active Directory, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.

This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

Azure OpenAI Service provides access to OpenAI's powerful large language models such as GPT; the model behind the popular ChatGPT service. These models enable various natural language processing (NLP) solutions to understand, converse, and generate content. Users can access the service through REST APIs, SDKs, and Azure OpenAI Studio. In this course, you'll learn how to provision Azure OpenAI service, deploy models, and use them in generative AI applications. To complete the hands-on labs in this course, students require an Azure subscription that has been approved for access to the Azure OpenAI service. Access approval can take several days to be granted. See https://learn.microsoft.com/legal/cognitive-services/openai/limited-access for details.

This certification course provides an introduction to ITIL® 4 and how the global service management best practice has evolved to manage services holistically across a Service Value System (SVS). ITIL® 4 provides an end-to-end operating model for the delivery and operation of tech-enabled products and services. It enables IT teams to continue to play a crucial role in wider business strategy and also integrates concepts from other industry best practices such as Lean, Agile and DevOps. The purpose of the ITIL® 4 Foundation qualification is to introduce the management of modern IT-enabled services, to provide an understanding of the common language and key concepts, and to show how organizations and work can improve with the ITIL® 4 guidance. To receive certification, the candidate must successfully pass the ITIL® 4 Foundation exam.

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

This three-day course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course MOC-10985 previously published under the same title.

Information security is a crucial field in the world of business. In this course, students will expand on their knowledge of information security to apply more advanced principles that will keep their organization safe from the many ways it can be threatened. They will apply critical thinking and judgment across a broad spectrum of security disciplines to propose and implement sustainable security solutions that map to organizational strategies; translate business needs into security requirements; support IT governance and risk management; architect security for hosts, networks, and software; respond to security incidents; and more. Today's IT climate demands individuals with demonstrable skills, and the information and activities in this course can help students develop the skill set they need to confidently perform their duties as an advanced security practitioner.

Design secure cloud solutions to data management with AWS Architecting. Learn how to design and build scalable solutions, as well as best practices and optimization recommendations with our AWS Architecting training courses.

Our AWS Developer training courses ensure you have the skills to succeed, both on the exam and in a professional environment. Learn how to configure SDKs and IDE toolkits and understand Deep Learning models.

Use this journey to develop your skills to build simple reports to complex reports, and learn how to create active reports which are available offline from the enterprise data source.

Use this journey to develop your skills in designing models using OLAP cubes, Dynamic Cubes, or relational data sources, and continue your development to design Scorecards.

Mainframe Application Developers create and support computer code used in the organization’s mainframe systems to perform business functions. This includes assisting with the design, coding, and testing of computer programs, analyzing and resolving programming issues, and supporting the business to ensure application programs work as required. Mainframe Application Developers are found in a variety of industries including but not limited to Health Care, Insurance, Retail, Transportation, etc.

System/Computer Operators oversee the systems ensuring all computers are running correctly. This role monitors and controls system console messages, processes and resolves job processing problems performs system backups, maintains peripheral devices, and performs disaster recovery procedures. This role commonly functions within a Data Center.

Systems Programmers program computer system software, including, but not limited to installing and maintaining the system software, managing the installation, performing overall maintenance, tuning, and resolving problems regarding the operating system. The systems programmer provides software and software platforms and administers IBM Mainframes.

ITIL® 4 Foundation introduces the management of modern IT-enabled services, to provide an understanding of the common language and key concepts, and to show how organizations and work can improve with the ITIL® 4 guidance.

Get an introduction to the key principles of service strategy, and learn about the service strategy processes. Discover the importance of governance and related frameworks, and examine implementation considerations and approaches, including organizational design, the role of technology, and service automation.

With LearnQuest's Core Java Curriculum, you'll build your core java skills including Micro Services, REST, and database access. Then you can choose the Spring Framework and/or Web Development Learning Journeys to continue building your skills.