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.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Excel® can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. 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 Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

The advent of cloud computing and storage has ushered in the era of big data. With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain a competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau® software is designed for this purpose. Tableau was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data-driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data-driven insights with peers, executives, and clients.

This course provides an introduction to supervised models, unsupervised models, and association models. This is an application-oriented course and examples include predicting whether customers cancel their subscription, predicting property values, segment customers based on usage, and market basket analysis.

This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports.

In this course, you will focus on the legacy gateway and router portions of IP Telephony. You will gain extensive experience with the configuration of legacy analog telephony technologies such as Foreign Exchange Station (FXS), Foreign Exchange Office (FXO), and Primary Rate Interface (PRI). In addition to legacy technologies you will gain hands on experience with CUBE and SIP protocols. You will build a working Cisco Unified Communications Manager which will support all major gateway protocols such as MGCP, H.323, and SIP.

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

Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.

The Implementing Cisco Enterprise Advanced Routing and Services (ENARSI) gives you the knowledge you need to install, configure, operate, and troubleshoot an enterprise network. This course covers advanced routing and infrastructure technologies, expanding on the topics covered in the Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) course. This course helps prepare you to take the exam, 300-410 Implementing Cisco® Enterprise Advanced Routing and Services (ENARSI), which leads to the new CCNP® Enterprise and Cisco Certified Specialist – Enterprise Advanced Infrastructure Implementation certifications.

In Adobe® InDesign® CC (2019): Part 1 you were introduced to the many features that help you create professional looking documents. Now you need to create much lengthier interactive documents that need to be accessed across a range of devices. In Adobe® InDesign® CC (2019): Part 2, you will learn advanced InDesign techniques to enhance the look and functionality of your documents. Using Adobe InDesign, you can create interactive documents and export them for viewing in a web browser with various features such as buttons, page transitions, movies and audio files, hyperlinks, and animation. You have the ability to assign color profiles and establish print presets. In creating longer documents, you'll be able to include such features as a table of contents, footnotes, cross-references, and an index. This course is a great component of your preparation for the Adobe Certified Expert (ACE) InDesign CC exam and the Adobe Certified Associate (ACA) Print & Digital Media Publication Using Adobe InDesign exam.

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.