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.

Discover the powerful mail merge feature from Outlook to quickly build customized emails, labels, and letters. Create and set up data files from scratch or connect to names in Excel or Outlook.?

All projects introduce change into organizations which invariably change the way stakeholders work. Organizational change management (OCM) is about the people side of change – helping them let go of old practices and embrace the new. Through this interactive workshop, you will learn techniques to clearly define the change, generate support, assess organizational readiness, develop a change management plan, effectively address resistance, and identify the critical success factors to sustain the change once it is implemented. In short, you will leave class ready to participate as a valuable change agent in any change initiative. Note: This course will earn you 7 PDUs.

To meet the demands of individuals and organizations for flexible, reusable, and easily modified visual content, Adobe Systems has created a cadre of applications that collectively provide a scalable, end-to-end solution for nearly every type of visual design project one can contemplate. Called Creative Cloud® (CC), the collection of applications perform specialized design tasks while interoperating among each other to deliver content. This course focuses on Adobe® Illustrator® CC (2019), the component within CC used to create 'drawn' graphics, while enabling its users to integrate content from other domains (such as photo-oriented graphics and animation, which belong to Adobe® Photoshop® and other applications). With Illustrator's many easily used tools, you will discover that not only can you unlock the same creative impulses you've always had as you've picked up a pencil to sketch out an idea, but also capture those multiple ideas and 'what ifs' during the creative process in ways that you never imagined. And for those of you who are just embarking on building your creative skills, you will be surprised at 'how good' your work will appear, even at the outset of your exploration of the world of graphic design. This course is a great component of your preparation for the Adobe Certified Expert (ACE) Illustrator CC exam and the Adobe Certified Associate (ACA) Graphic Design & Illustration Using Adobe Illustrator exam.

CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making. CompTIA Data+ gives you the confidence to bring data analysis to life. As the importance for data analytics grows, more job roles are required to set context and better communicate vital business intelligence. Collecting, analyzing, and reporting on data can drive priorities and lead business decision-making.

This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.

The Certified Ethical Hacker (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 so you will be better positioned to set up your security infrastructure and defend against attacks. By providing an understanding of system weaknesses and vulnerabilities, the CEH course helps?students learn to protect their organizations and strengthen?their?security controls?in order to?minimize the risk of a malicious attack. 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 toward proving the required knowledge and skills needed to achieve the CEH credential and perform the job of an ethical hacker. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits,?and technologies. The Certified Ethical Hacker has been battle-hardened over the last 20 years, creating hundreds of thousands of Certified Ethical Hackers employed by top companies, militaries, and governments worldwide. In its 12th version, the Certified Ethical Hacker provides comprehensive training, handson learning labs, practice cyber ranges for engagement, certification assessments, cyber competitions, and opportunities for continuous learning into one comprehensive program curated through our new learning framework: • 1. Learn • 2. Certify • 3. Engage • 4. Compete The C|EH® v12 training program includes 20 modules covering various technologies, tactics, and procedures, providing prospective ethical hackers with the core knowledge needed to thrive in cybersecurity. Delivered through a carefully curated training plan that typically spans five days, the 12th version of the C|EH® continues to evolve to keep up with the latest OS, exploits, tools, and techniques. The concepts covered in the training program are split 50/50 be

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.

Many of us flinch when we hear terms like depreciation, cash flow, balance sheet, and (worst of all!) budgets. However, these are all important concepts to understand if you’re going to succeed in today’s business world, particularly as a supervisor. Even better, financial terms are not as scary as they seem.

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.

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.