Grow Your IT & Business Skills & Get Certified

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them. The course is designed as a blended learning experience that combines instructor-led training with online materials. The hands-on exercises in the course are based on Learn modules, and students are encouraged to use the content on Learn as reference materials to reinforce what they learn in the class and to explore topics in more depth.

CompTIA A+ certified professionals are proven problem solvers. They support today's core technologies from security to cloud to data management and more. CompTIA A+ is the industry standard for launching IT careers into today's digital world. It is the only industry recognized credential with performance-based items to prove pros can think on their feet to perform critical IT support tasks in the moment. It is trusted by employers around the world to identify the go-to person in end point management and technical support roles. CompTIA A+ is regularly re-invented by IT experts to ensure that it validates core skills and abilities demanded in the workplace. The Official CompTIA® A+® Core 1 and Core 2 (Exams 220-1001 and 220-1002) course provides the background knowledge and skills students will require to be a successful A+ technician. It will help them prepare to take the CompTIA A+ Core Series certification examinations (exam numbers 220-1001 and 220-1002), in order to become a CompTIA A+ Certified Professional.

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.

The Managing Microsoft Teams course is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. Microsoft Teams admins configure, deploy, and manage Office 365 workloads for Microsoft Teams that focus on efficient and effective collaboration and communication in an enterprise environment. This course covers six central elements - Microsoft Teams overview, implementing governance, security and compliance for Microsoft Teams, preparing the environment for a Microsoft Teams deployment, deploying and managing teams, managing collaboration and managing communication in Microsoft Teams.

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.

Adobe® Photoshop® CC (2019): Part 1 focuses on some of the basic features of Photoshop so that the student can navigate the environment and use Photoshop tools to work with photographic images. In addition, the orientation to Adobe® Bridge and organization of files in Bridge is covered. Although Photoshop is used by a variety of professionals, from photographers to designers to videographers, Photoshop Part 1 will focus mainly on the photography component. The illustration and animation techniques are covered in subsequent levels of Photoshop. This course is a great component of your preparation for the Adobe Certified Expert (ACE): Photoshop CC exam and the Adobe Certified Associate (ACA) Visual Communication Using Adobe Photoshop CC exam.

Security remains one of the hottest topics in IT and other industries. It seems that each week brings news of some new breach of privacy or security. As organizations scramble to protect themselves and their customers, the ability to conduct penetration testing is an emerging skill set that is becoming ever more valuable to the organizations seeking protection, and ever more lucrative for those who possess these skills. In this course, students will be introduced to some general concepts and methodologies related to pen testing, and they will work their way through a simulated pen test for a fictitious company. This course can also assist them if they are pursuing the CompTIA PenTest+ certification, as tested in exam PT0-002. The course is designed to provide content and activities that correlate to the exam objectives, and therefore can be a resource as you prepare for the examination.

This course teaches IT Professionals how to secure identities, manage their Azure subscriptions, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

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.