| Course Name |
Hours |
List Price |
Content |
| 10987 - Performance Tuning and Optimizing SQL Databases |
28.00 |
$2,319.00 |
|
Description: This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Audience profile
The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Skills gained
Describe the high level architectural overview of SQL Server and its various components.
Describe the SQL Server execution model, waits and queues.
Describe core I/O concepts, Storage Area Networks and performance testing.
Describe architectural concepts and best practices related to data files for user databases and TempDB.
Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
Explain data collection strategy and techniques to analyze collected data.
Understand techniques to identify and diagnose bottlenecks to improve overall performance.
# of Days:
|
| 20761 - Querying Data with Transact-SQL |
35.00 |
$2,899.00 |
|
Description: This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 5 teach the remaining skills required to take exam 70-761.
Audience profile
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who arent necessarily database-focused; namely, report writers, business analysts and client application developers.
# of Days:
|
| Access 2019 Level 2 |
7.00 |
$289.00 |
|
Description: Your training and experience using Microsoft Office Access has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.
# of Days:
|
| Access 2019 Level 3 |
7.00 |
$299.00 |
|
Description: Youve covered many of the basic functions of Microsoft Office Access, and now youre ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.
# of Days:
|
| Adobe Captivate 2019 Essentials |
14.00 |
$799.00 |
|
Description: In this course, you will cover the core Adobe Captivate skills needed to create interactive eLearning and mLearning content. You will also learn how to create a soft-skills lesson from scratch. Youll learn to record and produce software demonstrations, and interactive training simulations. By the time you finish this course, youll know how to control the mouse pointer and add such standard objects as text captions, images, and highlight boxes. Youll be able to record, import and edit audio, and further enhance the learner experience by adding interactivity via click boxes, buttons and text entry boxes.
Have you already created content using Microsoft PowerPoint? Dont throw that presentation away. Youll learn how to import existing PowerPoint content into Captivate. Last, but not least, youll learn to publish your project in SWF and HTML5 formats so that your content can be uploaded to a web server for consumption on virtually any device, including the iPad, iPhone and other mobile devices.
# of Days:
|
| Adobe Captivate 2019: Beyond the Essentials |
14.00 |
$799.00 |
|
Description: You will quickly learn Captivates higher-end functionality while improving your production skills via project templates, object styles, master slides, Themes and advanced actions. You will learn to collaborate with team members via Captivates powerful commenting features and Acrobat.com. Youll enhance the learners experience via variables that will make it seem like each eLearning lesson you produce has been customized for and is talking directly to your customer.
# of Days:
|
| Angular: Comprehensive Angular 8 Programming (WA2890) |
35.00 |
$2,899.00 |
|
Description: The Comprehensive Angular 8 Programming Training course covers all the essential topics found in the introductory course as well as additional topics typically encountered while developing real-world applications. The course is designed to get students up and running with basic Angular development and provide the knowledge needed for more challenging tasks.
The Angular JavaScript framework supports the creation of single-page browser applications as well as responsive web sites and hybrid mobile applications.
This course covers all the basics including: Typescript, components, directives, services, pipes, form development, HttpClient and observables. In addition it covers advanced usage of HttpClient, observables and routing. Added to that are topics on consuming WebSockets data, Testing and Debugging of Angular applications.
The included labs provide students with hands-on experience programming and troubleshooting Angular code.
In this training, attendees will learn how to:
Develop single page Angular applications using Typescript
Set up a complete Angular development environment
Create Components, Directives, Services, Pipes, Forms and Custom Validators
Handle advanced network data retrieval tasks using Observables
Consume data from REST web services using the Angular HTTP Client
Handle push-data connections using the WebSockets protocol
Work with Angular Pipes to format data
Use advanced Angular Component Router features
Test and debug Angular applications using built in tools
Work with Angular CLI
# of Days:
|
| Application Development using .NET Core and Blazor |
35.00 |
$2,750.00 |
|
Description: Blazor is one of the most exciting web development technologies, that allows for C to be used both on the server-side and client-side. The client-side C code is converted to web assembly that is downloaded by the browser. All modern browsers support the web assembly standard, so development under Blazor runs on any browser. The major benefit of Blazor is the elimination of Javascript on the client-side. This leads to higher reliability and also makes more involved user interface development easier. The course covers fundamentals of Blazor including some intermediate level concepts such as components, forms and validation, dependency injection, state management, handling errors and security and Identity implementations. Integrating Blazor with .NET Core web applications is also presented along with some intermediate level .NET concepts.
# of Days:
|
| CEH: Certified Ethical Hacker |
35.00 |
$3,249.00 |
|
Description: This class will immerse the student into an interactive environment where they will be shown how to scan, test, hack and secure their own systems. The lab intensive environment gives each student in-depth knowledge and practical experience with the current essential security systems. Students will begin by understanding how perimeter defenses work and then be lead into scanning and attacking their own networks, no real network is harmed. Students then learn how intruders escalate privileges and what steps can be taken to secure a system. Students will also learn about Intrusion Detection, Policy Creation, Social Engineering, DDoS Attacks, Buffer Overflows and Virus Creation. When a student leaves this intensive five day class they will have hands on understanding and experience in Ethical Hacking.
# of Days:
|
| CHFI: Computer Hacking Forensic Investigator |
35.00 |
$3,249.00 |
|
Description: Computer hacking forensic investigation is the process of detecting hacking attacks and properly extracting evidence to report the crime and conduct audits to prevent future attacks. Computer forensics is simply the application of computer investigation and analysis techniques in the interests of determining potential legal evidence. Evidence might be sought in a wide range of computer crime or misuse, including but not limited to theft of trade secrets, theft of or destruction of intellectual property, and fraud. CHFI investigators can draw on an array of methods for discovering data that resides in a computer system, or recovering deleted, encrypted, or damaged file information. The CHFI course will provide participants the necessary skills to identify an intruders footprints and to properly gather the necessary evidence to prosecute in the court of law.
Securing and analyzing electronic evidence is a central theme in an ever-increasing number of conflict situations and criminal cases. Electronic evidence is critical in the following situations:
Computer forensics enables the systematic and careful identification of evidence in computer related crime and abuse cases. This may range from tracing the tracks of a hacker through a clients systems, to tracing the originator of defamatory emails, to recovering signs of fraud.
# of Days:
|
| CND: Certified Network Defender |
35.00 |
$3,249.00 |
|
Description: Certified Network Defender (CND) is a vendor-neutral, hands-on, instructor-led comprehensive network security certification training program. It is a skills-based, lab intensive program based on a job-task analysis and cybersecurity education framework presented by the National Initiative of Cybersecurity Education (NICE). The course has also been mapped to global job roles and responsibilities and the Department of Defense (DoD) job roles for system/network administrators. The course is designed and developed after extensive market research and surveys.
The program prepares network administrators on network security technologies and operations to attain Defense-in-Depth network security preparedness. It covers the protect, detect and respond approach to network security. The course contains hands-on labs, based on major network security tools and techniques which will provide network administrators real world expertise on current network security technologies and operations. The study-kit provides you with over 10 GB of network security best practices, assessments and protection tools. The kit also contains templates for various network policies and a large number of white papers for additional learning.
# of Days:
|
| CompTIA: A+ Core 1 |
35.00 |
$2,395.00 |
|
Description: CompTIA A+ certified professionals are proven problem solvers. They support todays core technologies from security to cloud to data management and more. CompTIA A+ is the industry standard for launching IT careers into todays 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 (Exam 220-1001) course provides the background knowledge and skills you will require to be a successful A+ technician. It will help you prepare to take the CompTIA A+ Core Series certification examination (exam number 220-1001), in order to become a CompTIA A+ Certified Professional.
# of Days:
|
| CompTIA: A+ Core 2 |
35.00 |
$2,395.00 |
|
Description: CompTIA A+ certified professionals are proven problem solvers. They support todays core technologies from security to cloud to data management and more. CompTIA A+ is the industry standard for launching IT careers into todays 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 2 (Exam 220-1002) course provides the background knowledge and skills you will require to be a successful A+ technician. It will help you prepare to take the CompTIA A+ Core Series certification examination (exam number 220-1002), in order to become a CompTIA A+ Certified Professional.
# of Days:
|
| CompTIA: Security+ Certification |
35.00 |
$2,499.00 |
|
Description: Security+ Certification is the primary course you will need to take if your job responsibilities include securing network services, network devices and network traffic. It is also the main course you will take to prepare for the CompTIA Security+ examination. Topics covered include: identification of security threats, hardening internal systems and services, hardening internetwork devices and services, securing network communications, managing a PKI, managing certificates, enforcing an organizational security policy monitoring the security infrastructure.
# of Days:
|
| Continuous Delivery Using Azure DevOps Services |
14.00 |
$995.00 |
|
Description: This two-day course provides students with the DevOps principles and related hands-on practices to work better as a team, scale their agility, share and integrate their work, and deliver working software continuously in order to enable faster delivery of value and receive early and valuable feedback. To maximize learning, students will work in teams, in a common team project, on a common case study.
# of Days:
|
| CyberSec First Responder (CFR) |
35.00 |
$2,495.00 |
|
Description: This course covers network defense and incident response methods, tactics, and procedures that are in alignment with industry frameworks such as NIST 800-61r2 (Computer Security Incident Handling Guide), US-CERTs National Cyber Incident Response Plan (NCIRP), and Presidential Policy Directive (PPD)-41 on Cyber Incident Coordination. It is ideal for candidates who have been tasked with the responsibility of monitoring and detecting security incidents in information systems and networks, and for executing standardized responses to such incidents. The course introduces tools, tactics, and procedures to manage cybersecurity risks, identify various types of common threats, evaluate the organizations security, collect and analyze cybersecurity intelligence, and remediate and report incidents as they occur. This course provides a comprehensive methodology for individuals responsible for defending the cybersecurity of their organization.
# of Days:
|
| Excel 2019 Level 1 |
7.00 |
$279.00 |
|
Description: The Computer Workshop writes their own curriculum for Excel making it easy to customize a class specific to your needs. Many think they are past the basics, but our course has many valuable shortcuts and quick data entry methods built in to give you a good foundation. So even if you have used Excel for a number of years, it is worth taking the Level 1 class. Our course will make ordinary tasks much easier for you to accomplish, and in much less time.
Upon successful completion of this course, you will be able to customize the interface to better suit your needs, create lists, efficiently develop Excel worksheets and workbooks, use basic excel function formulas, apply formatting to content, create customize number formats, control how spreadsheets are printed, as well as be able to find and replace content.
You will:
Get started with Microsoft Office Excel 2019
Customize the interface
Perform calculations
Modify a worksheet
Format a worksheet
Print workbooks
Edit contents
# of Days:
|
| Excel 2019 Level 3 |
7.00 |
$299.00 |
|
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
# of Days:
|
| Microsoft Office 365 Online with Teams for the Desktop |
7.00 |
$399.00 |
|
Description: This course is an introduction to Microsoft Office 365 with Teams in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Teams lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference.
Using the Office 365 suite of productivity apps, users can easily communicate and collaborate together through Microsoft Outlook mail and Teams messaging and meeting functionality. Additionally, the Microsoft SharePoint team site provides a central storage location for accessing and modifying shared documents. This course introduces working with shared documents in the familiar Office 365 online appsWord, PowerPoint, and Excelas an alternative to installing the Microsoft Office desktop applications. This course also introduces several productivity apps including Yammer, Planner, and Delve that can be used in combination by teams for communication and collaboration.
In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment.
You will:
Sign in, navigate, and identify components of the Office 365 environment.
Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve.
Collaborate and work with colleagues using the Yammer and Planner apps.
Use email and manage contacts with Outlook on the web.
Collaborate using Teams.
Configure Teams.
# of Days:
|
| Tableau Advanced |
14.00 |
$1,299.00 |
|
Description: This two day course is designed to provide you with the skills required to become a Tableau power user. The course is designed for the professional who has solid working experience with Tableau and wants to take it to the next level. You should have a deep understanding of all the fundamental concepts of building worksheets and dashboards, but may scratch your head when working with more complex issues.
# of Days:
|
| Word 2019 Level 1 for Windows |
7.00 |
$279.00 |
|
Description: These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. Its impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, youll need to know the ins and outs of electronic word processing.
Microsoft Word 2019 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, youll learn how to use Word 2019 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certifications.
# of Days:
|