Information Technology Training Classes and Seminars In Jacksonville, FL

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code....

Until now, you have used SAP® Crystal Reports® to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries. Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved....

This ITIL 4 Foundation training course provides IT leaders, practitioners, support staff, and staff interfacing with the organization’s digital and information systems functions with a practical understanding of the key concepts, common language, principles, and practices that enable successful management of modern IT-enabled services. CCS Learning Academy offers live instructor-led or self-paced online ITIL training courses, both of which prepare participants to earn the ITIL Foundation certifi...

This interactive workshop explains common SQA misconceptions and the six functions SQA should perform to provide far greater value, analyzes why SQA groups so frequently have failed in IS, and presents practical approaches for successfully using SQA effectively throughout any life cycle to produce high quality systems. Because some distinguish SQA as reviewing documents vs. testing’s executing code, key concepts and techniques are presented for reviewing requirements and designs. And, because some still expect an SQA course to be about testing, half of this class does describe testing content more briefly than in our Effective Methods of Software Testing Workshop....

Welcome to Using Microsoft® Windows® 10. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This course will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users....

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of the fundamentals of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools. Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL - Fundamentals of Querying, provides an overview of the SQL commands that can be used to access that data....

This is a deep dive course for experienced Java programmers who are looking to take their Java skills to the next professional level. Students will learn: object-oriented design principles; how to make best use of Java libraries; multithreading and concurrent processing; Network, Java GUI, and Functional programming; advanced data processing; and the best design and programming practices....

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations, people work with a wide variety of devices running on a wide variety of platforms. And sometimes, what works well or looks good on one device, won't work at all on another device. Or, your carefully designed and formatted document may end up looking like a jumbled mess on someone else's computer. So, how do you balance the need to communicate ideas to large groups of people with the enormous diversity found in today's electronic devices? The answer: you don't have to because Adobe created the Portable Document Format (PDF) as a solution to incompatible document formats. Adobe® Acrobat® Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat, you will ensure the integrity of your electronic documents regardless of who views them, on what devices, or with what operating systems. And that will give you the confidence and peace of mind that comes with knowing that what you meant to communicate is what your document recipients will see....

This CompTIA® Cloud+ certification training course will prepare you to pass the CompTIA Cloud+ CV0-002 exam and earn the corresponding certification. You will also learn to apply the skills required to evaluate and implement standard deployments. You will implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions. This Cloud+ course will also teach you to manage workload migrations, manage cloud vendors to control costs, use automation and orchestration to bring business value from cloud solutions, and ensure security of cloud implementations using cybersecurity best practices. The CompTIA® Cloud+ certification exam voucher is included with this course. Should you fail on the first attempt, we will then give you a second voucher at no cost. Exam Prep Software All of our CompTIA classes include access to web-based practice exams. CompTIA certification exams are very rigorous and challenging. By studying after the class and using these practice exams, you will greatly improve your chances of passing the actual certification exam the first time. Exam prep software is included with all of our CompTIA classes....

This one-day class offers tips, tricks and timesavers that will help you get the most from PowerPoint. It is a easy fast-paced class that will touch on most of the popular PowerPoint features and how to access them efficiently. This is a great "refresher" course for those with prior PowerPoint experience who want to quickly update their skills and learn the latest tips, tricks and timesavers. This class is taught using PowerPoint 365 / 2019. While many topics will be valid for PowerPoint 2016 users, about half of the topics will be available exclusively to Office 365 subscribers such as Designer, Morph and Zoom....

This is an introductory Python programming course which provides a strong foundation that would allow students to further their skills with additional education. The course begins with an overview of Python and quickly has students building simple applications. Python syntax, including function and module design is considered. File consumption and exception handling are also included early in the class. In addition, there is an examination of using different data types....

In this Python training course, learners already familiar with Python programming will learn advanced Python techniques. This advanced Python course is taught using Python 3; however, differences between Python 2 and Python 3 are noted....

This one-day Microsoft Word Training class offers tips, tricks and timesavers that will help you get the most out of Word. It is a multi-faceted, fast-paced class that will touch on most of the popular Word features and how to access them efficiently. This is a great course for individuals with prior Word experience who want to quickly update their skills and learn the latest tips, tricks and timesavers. This course is for individuals using Word 365, 2019 or 2016 software. However, there are very few differences between the 365 and 2016 versions from an end-user's perspective. Our instructors have used all versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the versions of Word will have no problem learning in the 2019 software environment....

Office 365 provides many apps for day to day operations, from surveys, communication, project management, and collaboration. The Office 365 Power User Training course provides an in-depth look at how to use features within Teams such as chat, online meetings, calls, and more. Learn the intricate features of Teams, One Drive for Business, Outlook on the Web, Planner, "To-Do" and "Flow". This course is designed to help Power Users and end users make the most of the Office 365 apps....

The new version 8.0 of MySQL added a significant number of administrative features to the MySQL database including improved error logging, password policies, privileges, accounts, and backup and recovery. Students will perform these administration functions using the MySQL workbench and command line utilities during the course of training. The course may be taken by itself as a one day course of training or as a four day course which includes the topics from this course and the topics from the three day Querying MySQL course....

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft Visio provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. In this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend....

Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio drawings. In Visio® Introduction, you learned the basic skills needed to create and modify various Visio drawings. In Visio® Advanced, you will learn about more advanced features—making you a more efficient and effective Visio user....

Organizations use reporting tools to access data sources and generate customized reports. SAP® Crystal Reports® 2020 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation. Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2020 helps you build advanced reports with ease, presenting complex information in an understandable way....

The best way to combat an attack on an organization’s information assets is to have qualified information security professionals with the appropriate practices and controls to implement, monitor, and administer IT infrastructure to ensure data confidentiality, integrity, and availability. This SSCP certification prep course validates student’s ability to identify, evaluate, and prioritize potential threats, manage, and mitigate threats through risk management concepts, assessment activities, and...

This course teaches Azure Solution Architects how to design infrastructure solutions. 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....

This course will empower you to install and administer the Red Hat® OpenShift® Container Platform, with hands-on, lab-based materials that show you how to install, configure, and manage OpenShift clusters and deploy sample applications to further understand how developers will use the platform. This course is based on Red Hat® Enterprise Linux® 7.5 and Openshift Container Platform 3.9. OpenShift is a containerized application platform that allows your enterprise to manage container deployments and scale your applications using Kubernetes. OpenShift provides predefined application environments and builds upon Kubernetes to provide support for DevOps principles such as reduced time to market, infrastructure-as-code, continuous integration (CI), and continuous delivery (CD)....

This course combines the foundations and applications established and covered in Red Hat System Administration I (RH124) and Red Hat System Administration II (RH134). The rapid pace of review and consolidated course timeline allow you to focus on practical application, making this offering best suited for you if you already have significant experience with Linux® administration. This course is based on Red Hat® Enterprise Linux 8....

Red Hat System Administration II (RH134) is designed as the second part of the Red Hat® Certified System Administrator (RHCSA®) training track for IT professionals who have taken Red Hat System Administration I (RH124). The course goes deeper into core Linux® system administration skills, including storage configuration, security feature management, task control, and installation and deployment of Red Hat® Enterprise Linux....

This course demonstrates how to efficiently use AWS security services to stay secure in the AWS Cloud. The course focuses on the security practices that AWS recommends for enhancing the security of your data and systems in the cloud. The course highlights the security features of AWS key services including compute, storage, networking, and database services. You will also learn how to leverage AWS services and tools for automation, continuous monitoring and logging, and responding to security incidents....

CompTIA's Network+ certification is a foundation-level certification designed for IT professionals with around one year of experience, whose job role is focused on network administration.The CompTIA Network+ exam will certify the successful candidate has the knowledge and skills required to troubleshoot, configure, and manage common network devices; establish basic network connectivity; understand and maintain network documentation; identify network limitations and weaknesses; and implement network security, standards, and protocols. The candidate will have a basic understanding of enterprise technologies, including cloud and virtualization technologies. The Official CompTIA® Network+® (Exam N10-008): will teach you the fundamental principles of installing, configuring, and troubleshooting network technologies and help you to progress a career in network administration. In this course, you will build on your existing user-level knowledge and experience with personal computer operating systems and networks to master the fundamental skills and concepts that you will need to use on the job in any type of networking career....