| 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:
|
| AWS Technical Essentials (AWS-T-ESS) |
7.00 |
$699.00 |
|
Description: AWS Technical Essentials introduces you to AWS products, services, and common solutions. It provides IT technical end users with basic fundamentals to become more proficient in identifying AWS services so that you can make informed decisions about IT solutions based on your business requirements.
# of Days:
|
| AWS: Exam Readiness Intensive Workshop: AWS Certified Solutions Architect Associate |
35.00 |
$3,500.00 |
|
Description: This five-day, instructor-led course helps busy architects get away from the day-to-day to get focused and ready for their AWS Certified Solutions Architect Associate exam. Attendees learn the fundamentals of building IT infrastructure on AWS, so they can build scalable and resilient solutions in the cloud, by spending the first 3 days on the Architecting on AWS course. Theyll start getting in the exam readiness mindset with bonus end of module quizzes. Next, theyll learn strategies to answer exam questions and avoid common mistakes with the Exam Readiness: AWS Certified Solutions Architect Associate half-day course. The course broadens attendees knowledge of AWS services with deep dives into Amazon Redshift, Amazon Kinesis, and AWS Key Management Service, and then concludes with two quizzes and an instructor guided review of the AWS Certified Solutions Architect Associate practice exam.
# of Days:
|
| AZ204 - Developing solutions for Microsoft Azure |
35.00 |
$2,899.00 |
|
Description: This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.
# of Days:
|
| AZ-400T00: Designing and Implementing Microsoft DevOps solutions |
35.00 |
$2,899.00 |
|
Description: This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms.
Audience profile
Students in this course are interested in implementing DevOps processes or in passing the Microsoft Azure DevOps Solutions certification exam.
# of Days:
|
| Certified Associate in Project Management (CAPM) Certification |
35.00 |
$2,899.00 |
|
Description: This course is designed for persons in a variety of job roles who currently contribute to project teams in various ways, including providing subject matter expertise (e.g., marketing, finance, customer care, processing, fulfillment) and serving as project team sponsors, facilitators, liaisons, or coordinators, but who do not function as project managers and who have little or no formal exposure to or training in standardized project management terminology and processes.
# of Days:
|
| Certified ScrumMaster (CSM) |
14.00 |
$1,499.00 |
|
Description: The Certified ScrumMaster (CSM) course is a two-day, entry-level course taught by a Certified Scrum Trainer. The CSM course is designed to cover all the basics of Scrum so you can begin to fulfill the ScrumMaster role.
In the CSM course, you will learn about:
Scrum basics and core values
How the Scrum framework compares to other methods, such as waterfall
How to identify when to use Scrum
A Scrum teams three roles and responsibilities
Scrum meetings, including the Sprint Review, Sprint Retrospective and Release Planning
Sprint Backlog and Product Backlog
Scrum artifacts, including the Product Backlog, Sprint Backlog and Burndown Charts
Upon completing this course:
Qualification for Certified ScrumMaster (CSM) Certification after passing a short certification exam
Two year membership in the Scrum Alliance
14 PDUs from PMI (Project Management Institute)
PMI-ACPSM: This course counts as 14 of the 21 contact hours for the PMI-ACP certification
# of Days:
|
| CN100: Docker Containerization Essentials |
7.00 |
$750.00 |
|
Description: In this course, youll learn how to create and manage individual containers using the Docker Engine. Well cover best practices in container image design and container deployment and auditing, as well as an introduction to single-node container networking and storage. This course is best practices focused, and is designed to enable rapid successful adoption of containerization from first principles.
Skills Gained
Containerization motivations and implementation
Creating, managing and auditing containers
Best practices in container image design
Single-host container networking
Provisioning external storage
# of Days:
|
| CN120: Kubernetes Application Essentials |
14.00 |
$1,550.00 |
|
Description: Whether your focus is on developing containerized applications or managing a container-centric infrastructure, CN120 introduces Kubernetes container orchestration for everyone involved in the software development life cycle. Through a real-world approach for design and deployment considerations, students can expect to learn about the foundational Kubernetes components required for application workloads. Specifically, students will examine Kubernetes architecture, explore how Kubernetes objects work together for running an application, and learn how Kubernetes makes use of compute, networking, and storage resources.
Skills Gained
Make effective use of pod architecture
Deploy workloads as Kubernetes controllers
Provision configuration at runtime to Kubernetes workloads
Network pods together across a cluster using native services
Provision highly available storage to Kubernetes workloads
Package an application as a Helm chart
# 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:
|
| DA-100T00: Analyzing Data with Power BI |
28.00 |
$2,399.00 |
|
Description: This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Audience profile
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
# of Days:
|
| Excel 2016 Level 1 for Windows |
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 create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.
You will:
? Get started with Microsoft Office Excel 2016.
? Perform calculations.
? Modify a worksheet.
? Format a worksheet.
? Print workbooks.
? Manage workbooks.
Prepares you for the Microsoft Office Specialist exam for Excel 2016 and the Excel 2016 Expert Exam.
# of Days:
|
| Excel 2016 Pivot Tables |
4.00 |
$219.00 |
|
Description: In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the most powerful tools in Excel.
# of Days:
|
| Excel 2019 Data Analysis with Power Pivot |
4.00 |
$219.00 |
|
Description: We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
# of Days:
|
| Excel 2019 Formulas |
6.00 |
$279.00 |
|
Description: In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula auditing tools to trouble shot problems in formulas.
# 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 2 |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2019, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and graphics.
# 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:
|
| Excel 2019 Pivot Tables |
4.00 |
$219.00 |
|
Description: In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition, you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the most powerful tools in Excel.
# of Days:
|
| Intermediate Python 3.x |
28.00 |
$2,399.00 |
|
Description: This 4 day course picks up where Introduction to Python 3.x leaves off, covering some topics in more detail, and adding many new ones, with a focus on enterprise development. This is a hands-on programming class. All concepts are reinforced by informal practice during the lecture followed by lab exercises. Many labs build on earlier labs, which helps students retain the earlier material.
# of Days:
|
| Introduction to Python 3.x |
28.00 |
$2,399.00 |
|
Description: This four day course leads the student from the basics of writing and running Python scripts to more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This is a hands-on programming class. All concepts are reinforced by informal practice during the lecture followed by graduated lab exercises. Python Programming is a practical introduction to a working programming language, not an academic overview of syntax and grammar. Students will immediately be able to use Python to complete tasks in the real world.
# of Days:
|
| ITIL Foundation with Case Study |
21.00 |
$1,979.00 |
|
Description: This course, based on the ITIL best practice service lifestyle approach, provides IT managers, practitioners and anyone who uses IT services with a practical understanding of the key concepts, principles, processes, and functions that enables successful IT Service Management (ITSM) provision. The course intent is to provide proven practical guidance on how to successfully introduce an integrated ITSM framework and how best practices can be adopted and adapted within a students organization. It also prepares students for the ITIL Foundation Certificate Examination.
# of Days:
|
| JavaScript and jQuery |
35.00 |
$2,495.00 |
|
Description: This instructor lead course presents the JavaScript and jQuery skills that you need in a manageable progression, this course is divided into three sections.
The first part of this course covers an introduction to JavaScript. When you finish this section, youll have a solid set of JavaScript skills, especially the skills that help you get the most from jQuery.
After you learn the JavaScript essentials, you will cover the jQuery skills that every web developer should have. You will cover the core jQuery skills followed by a focus on effects and animations, forms and data validation, jQuery plugins, and jQuery UI widgets. Finally, you will learn how to use Ajax and JSON so you can get data from a web server and add it to a web page without reloading the entire page.
We will conclude the class by covering topics to take your JavaScript skills to the next level of expertise. You will learn how to use numbers, strings, dates...how to handle exceptions and use regular expressions...when and how to use browser objects, cookies, web storage, and arrays...and how to create and use your own objects.
# 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:
|
| Microsoft Power BI: Data Analysis Practitioner |
14.00 |
$1,159.00 |
|
Description: As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of big data has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and a competitive advantage.
The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Microsoft Power BI software is designed for this purpose. Power BI 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. Power BIs data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.
# of Days:
|
| Microsoft SharePoint Modern Experience: Site User |
7.00 |
$579.00 |
|
Description: In many professional environments today, people work collaboratively in teams. Information technology and applications facilitate this by allowing people to easily share, access, edit, and save information. Microsoft SharePoint is a platform specifically designed to facilitate collaboration, allowing people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will learn about and use SharePoint to access, store, share, and collaborate with information and documents.
SharePoint is a complex platform with many features and capabilities. A strong understanding of those features and capabilities will allow you to work more efficiently and effectively with SharePoint, and with the documents and data stored in SharePoint. Furthermore, effective use of the Modern UI and Office 365 integrations will streamline tasks, and facilitate collaboration with colleagues in other Office 365 and third-party apps.
Note: The skills covered in this course are appropriate both for Site Users who work in environments with SharePoint Online servers and for those using on-premise SharePoint servers in Modern Experience mode. This course covers the comprehensive suite of SharePoint online features and functions, which may go beyond what is available if the production environment is limited to SharePoint 2019 servers. How the environment is customized and configured will also affect how production sites compare to the sample sites shown in class.
# of Days:
|
| PBICAL: Introduction to DAX for Power BI Desktop Users Level 3 |
14.00 |
$1,190.00 |
|
Description: This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.
# of Days:
|
| PBICDMD: Data Model Design using Power BI Desktop Level 2 |
7.00 |
$595.00 |
|
Description: This is the second course in this custom Power BI Desktop training series. What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.
# of Days:
|
| React using TypeScript |
21.00 |
$1,795.00 |
|
Description: To be completed...
# of Days:
|
| Salesforce Administration and Configuration in Lightning Experience (SP-ADX201) |
35.00 |
$4,500.00 |
|
Description: This class will teach students the foundation of Salesforce in Lightning Experience and to help students prepare for the Salesforce Certified Administrator exam. This class is an alternative to the Administration Essentials for New Admins in Lightning Experience (ADX201) offered by Salesforce.
A student in this class will learn how to administer and configure Salesforce in Lightning and develop new applications utilizing the Force.com platform.
This class is delivered by a senior instructor with many years of real world Salesforce experience. The instructor will cover all the basic administration concepts within Salesforce in addition to sharing real world experiences and best practices.
The class presents a broad range of topics covering just about everything on which a student will be tested. These topics include but are not limited to: basic administration, the Force.com architecture, configuration, customization and data management. There is in depth coverage of system security topics such as: Users, Licenses, Profiles, Field Level Security, Permission Sets, Record Security, Organization Wide Defaults, Role Hierarchy Roles, Sharing Rules, Account Teams, Sales Teams, and Queues. The object model related to sales force automation, marketing automation and service is thoroughly covered as well with sections on: Accounts, Contacts, Opportunities, Products Price Books, Quotes, Leads, Campaigns, Cases, Solutions, Knowledge, Ideas and Answers. The automation of processes within Salesforce including the use of Workflow Rules, Approval Processes, and the Process Builder will be discussed and used in scenario driven exercises. Students will also learn to develop new applications on the Force.com platform using the declarative interface. Analytics, including Lightning Reports, Lightning Dashboards, and list views will be covered in detail as well.
As a participant in the class, each student will be given a practice learning environment to use during hands-on exercises during the class. The student will be able to use this learning environment indefinitely after the class without any additional fee.
# of Days:
|
| Salesforce: Programmatic Development using Apex and Visualforce in Lightning Experience (SP-DEX450) |
40.00 |
$4,500.00 |
|
Description: This Salesforce developer training class was created to help experienced software developers quickly learn how to become a Salesforce Developer. A student will learn the basics of Apex and Visualforce and best practices for integrating Salesforce with other systems. This class is an alternative to the Programmatic Development using Apex and Visualforce (DEX450) class offered by Salesforce. The Stony Point version of the class offers relevant, real world Salesforce programming examples and costs less.
A student successfully completing this class will be well on the way to being prepared for the Salesforce Certified Platform Developer I exam.
This class is delivered by a senior instructor with many years of real world programming experience and will cover the following topics:
The fundamentals of declarative development on the Force.com Platform including custom and standard objects, fields, security, workflow, approval processes, and validation rules
Working with common Force.com development tools, including but not limited to: VS Code, Developers Workbench, Developer Console
Understanding the software development lifecycle on the Force.com platform and utilizing the Metadata API, Unmanaged Packages, Managed Packages and Change Sets
Apex fundamentals, including but not limited to: developing Apex triggers, developing Visualforce custom controllers and controller extensions using Apex, developing email services using Apex, sending emails using Apex and Workflow, and developing test methods.
Visualforce fundamentals, including but not limited to: Consuming standard and custom controllers and controller extensions using Visualforce, utilizing CSS within Visualforce pages, embedding a Salesforce chart on a Visualforce page, utilizing Field Sets, and embedding a Visualforce page in a dashboard
As a participant in this Salesforce developer training class, each student will be given a practice learning environment to use during hands-on exercises during the class. The student will be able to use this learning environment indefinitely after the class without any additional fee.
# of Days:
|
| SQL Level 1 for Windows |
7.00 |
$399.00 |
|
Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables present query results in a report.
# of Days:
|
| SQL Level 2 for Windows |
7.00 |
$399.00 |
|
Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views index data.
# of Days:
|
| Storytelling with Data Using Excel |
7.00 |
$399.00 |
|
Description: The Storytelling with Data course teaches you the fundamentals of data visualization and how to communicate effectively with data. Youll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examplesready for immediate application to your next graph or presentation.
Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal dont make it any easier. This course demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story.
Specifically, youll learn how to:
Understand the importance of context
Determine the appropriate type of graph
Recognize and eliminate the clutter
Direct your audiences attention
Think like a designer when visualizing data
Leverage the power of storytelling to help your message resonate with your audience
# 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 2016 Level 1 for Windows |
7.00 |
$279.00 |
|
Description: Microsoft Word 2016 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 2016 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 exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. In this course, you will learn fundamental Word 2016 skills:
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Format text and paragraphs.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Create and format tables.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
# of Days:
|