Course Taxonomy: Technology Platforms

Jenkins User Boot Camp (Java/Python)

Part 1: Source Control Management with Git

  1. Purpose and overview of Git
  2. Use cases for Git
  3. Git flow
  4. Git providers
  5. Git configuration
  6. Finding help on Git
  7. Creating Local Git Repositories
  8. Basic Commands: add, commit, status, log
  9. Comparing commits: git diff
  10. Using a Repository: git push
  11. Branches: creating, merging and deleting
  12. Resolving merge conflicts
  13. Managing Pull Requests
  14. Using SSH keys with git platform private repositories

Part 2: Continuous Integration/Continuous Deployment with Jenkins

  1. Continuous Integration / Continuous Delivery (CI/CD): Jenkins
  2. CI/CD = Continuous Integration / Continuous Deployment
  3. Jenkins use case, purpose & history
  4. Architecture
  5. Using Plugins
  6. Initializing a Jenkins Master
  7. Projects / jobs
  8. Freestyle UI jobs
  9. CI/CD as Code: Pipeline Projects
  10. Declarative versus Scripted pipelines
  11. Views and folders
  12. Managing credentials and secrets
  13. Distributing workloads – Master and Agent nodes
  14. Integrating with Git: Source Control Management
  15. Triggers: Scheduled Polling and Webhooks
  16. Notifications: Instant Messaging Integration
  17. Requiring human input and approval
  18. Automated code linting and testing
  19. Jenkins Integration with managed nodes
  20. Continuous deployment through Jenkins

Part 3: Code Deployment and Release Management

  1. Java
    1. Building an artifact
    2. Storing Artifacts locally
  2. Python
    1. Building an artifact
    2. Storing Artifacts locally

Part 4: Notifications with Slack

  1. Integration setup
  2. Using Slack for CI/CD notifications

Part 5: Linux Management

Splunk Boot Camp

*All lab exercises are run in a Linux environment. A Windows environment can be provided upon request. 

Part 1: Introduction to Splunk

  1. What’s Splunk?
  2. Authentication Methods
  3. Access Controls & Users
  4. Products, Licensing, and Costs
  5. Quick Tour Guide: User Interface
  6. Exercise: Lab Environment and Configuration

Part 2: Indexes

  1. Splunk Data
  2. What are Indexes?
  3. What are Indexers?
  4. Exercise: Create Your First Index
  5. Search-Head
  6. Index Clusters
  7. Index Pipeline
  8. Exercise: Upload Data Manually
  9. Events
  10. Fields & Field Extraction
  11. Exercise: Using the Field Extractor Tool
  12. Forwarders
  13. Metrics
  14. Exercise: Using the Forwarder to Send Data
  15. Removing Data

Part 3: Splunk Architecture

  1. Components of Splunk Deployments
  2. Deployment Scenarios

Part 4: Search Processing Language

  1. What is Search Processing Language (SPL)?
  2. Searching Operators
  3. Search Commands
  4. Search Pipeline
  5. Exercise: Search Examples
  6. Subsearches
  7. Commonly Used Search Commands
  8. Exercise: Search Examples II
  9. Drilldowns
  10. Lookups
  11. Exercise: Using Lookups
  12. Optimize Searches
  13. Exercise: Search Examples III

Part 5: Dashboard & Visualizations

  1. Dashboards in Splunk
  2. Creating Dashboards
  3. Visualization Types
  4. Search as Reports
  5. Dashboards
  6. Exercise: Creating a Dashboard
  7. Drilldown
  8. Forms
  9. Exercise: Add Input Forms
  10. Exercise: Drilldown

Part 6: Alerts

  1. Creating Alerts
  2. Scheduling Alerts
  3. Alerts Notifications
  4. Exercise: Creating Alerts

Part 7: Scheduled Reports

  1. Creating Scheduled Reports
  2. Exercise: Create a Scheduled Report

Part 8: Putting All Pieces Together

Exercise: As a final lab, you’ll configure a typical scenario when using Splunk. You'll install and configure an NGINX, then the Splunk forwarder to collect logs in Splunk. The idea is that you can apply everything you've learned within the Bootcamp: creating searches, visualizations, dashboards, etc.

Advanced Kubernetes Boot Camp

Part 1: Core Concepts

We’ll go deep into different terms of Kubernetes to understand what it takes to build and run scalable systems in production. There are design patterns that you can implement in Kubernetes to extend an existing application without having to change the source code, like a sidecar pattern.

  1. Kubernetes architecture
  2. Imperative commands and descriptive manifests
  3. Pods, deployments, services, namespaces, DaemonSets
  4. Exercise: Working with Pods
  5. Exercise: Working with ReplicaSet
  6. Exercise: Working with Deployments
  7. Exercise: Working with Services
  8. Multi-containers
  9. Init containers
  10. Exercise: Working with StatefulSet
  11. Working with multiple clusters (kubeconfig)
  12. Kubernetes design patterns

Part 2: Networking in Kubernetes

Understanding how networking works in Kubernetes is important because it will help you to configure networking patterns like service discovery for a microservices architecture. But another concept that is taking more relevance are service meshes. We’ll explore what a service mesh is, and we’ll practice using one of the most popular ones: Istio.

  1. Ingress networking
  2. Exercise: Working with Ingress
  3. Networking policies
  4. Exercise: Working with Networking Policies
  5. What’s a service mesh?
  6. Introduction to Istio
  7. Observability with Istio
  8. Networking security with Istio
  9. Canary releases with Istio
  10. Exercise: Working with Istio

Part 3: Creating Scalable and Fault-Tolerant Applications

Kubernetes has a lot of great features built in by implementing the controller pattern. But in many cases, our applications need to include small configurations to help Kubernetes make better decisions to support reliable applications. We’ll see what changes are needed in the applications, and then we’ll deploy and test a sample application.

  1. Working with configuration
  2. Exercise: Working with ConfigMaps
  3. Working with probes
  4. Exercise: Working with Probes
  5. Configuring requests and limits
  6. Taints and tolerations
  7. Exercise: Working with Taints and Tolerations
  8. Node selectors
  9. Configuring scaling policies
  10. Exercise: Configuring scaling policies

Part 4: Development Workflow in Kubernetes

Kubernetes doesn’t have to change the way developers build applications, but they might want to be involved or test in their local workstations when they’re done with their application changes. We’ll discuss some recommended practices and tools.

  1. Packaging and managing applications with Helm
  2. Exercise: Working with Helm
  3. Continuous delivery in Kubernetes
  4. Exercise: Continuous Delivery with Flux
  5. Logging and monitoring systems
  6. Troubleshooting application failures
  7. Exercise: Troubleshooting Applications
  8. Development Toolbox: State of the art

Part 5: Developing Stateful Services

Stateless services are great for certain use cases, but there are scenarios where an application needs to be able to store data permanently, or at least work with data that is not ephemeral. Databases are one example.

  1. Understanding persistent volumes
  2. Exercise: Working with PV and PVC
  3. Backup and restore in Kubernetes
  4. Exercise: Backup and restore with Velero
  5. Databases in Kubernetes

Part 6: Security Practices and Recommendations

Kubernetes is not secure by default, and there are many considerations that you need to be aware of if before exposing your applications to the public internet. Companies usually have existing security policies, so we’ll cover how these security practices apply in a Kubernetes ecosystem.

  1. Authentication and Authorization
  2. Integration with AWS and IAM
  3. Docker image and pods security
  4. Pod Security Context and Policies
  5. Secrets encryption using KMS
  6. Exercise: Security in Kubernetes

Part 7: Extending the Kubernetes API

There are times where we need to extend the Kubernetes API to operate systems more easily. Not everyone will need to build something to extend the Kubernetes API, but it’s very valuable to understand the what, when, and how of custom resource definitions and the operator pattern.

  1. Custom Resource Definition (CRD)
  2. Custom Controllers
  3. Operator Pattern
  4. Operator Framework
  5. Exercise: Creating an Operator

Part 8: What’s Next for Kubernetes?

We’ll discuss other topics related to Kubernetes that might not fit everyone’s use cases, but that as a Kubernetes user you might want to be aware of. For instance, we’ll talk a little bit about having federated clusters, hybrid workloads, and several important tools from the CNCF.

Managing Azure Infrastructure with Terraform

Part 1: Infrastructure as Code

In this section, we will introduce the benefits that Infrastructure as Code (IaC) can bring to organizations and how IaC fits within modern DevOps best practices.

  1. DevOps and GitOps
  2. Principles of Infrastructure as Code
  3. Applying Infrastructure as Code in DevOps
  4. Infrastructure as Code best practices
  5. Benefits of Infrastructure as Code
  6. The case for Terraform

Part 2: Terraform Overview

This section provides an overview of Terraform concepts and vocabulary and instructs how Terraform manages infrastructure configuration in cloud environments.

  1. Terraform configuration language overview
  2. Terraform CLI
  3. The lifecycle of a configuration
  4. State storage – local versus remote
  5. Connecting to Azure

Hands-on Labs:

  • Setting up a Terraform project

Part 3: Azure Resources

In this section participants will be getting hands-on practice using Terraform to create a simple application environment in Azure, learning the essential constructs in Terraform for defining resources.

  1. Resource metadata and naming best practices
  2. Subscription and resource group
  3. Networking resources (VNet, subnet, network security group)
  4. Compute resources (virtual machine)
  5. Storage resources (storage account, file share, blob storage)
  6. Database resources (SQL database)
  7. Variables
  8. Outputs

Hands-on Labs:

  • Deploying a VNet
  • Adding a virtual machine into your VNet
  • Adding storage and a database
  • Including variables in your code
  • Using Terraform commands to validate and inspect your configuration

Part 4: Terraform Programming

This section introduces programming constructs within Terraform that enable you to add more control and flexibility in defining resources.

  1. Control operations (count, loops, conditional, depends_on, etc.)
  2. Data structures (maps, lists, random_string, etc.)
  3. Data sources
  4. Functions (e.g., lookup, coalesce, join, merge, etc.)
  5. Variable validation
  6. Debugging Terraform

Hands-on Labs:

  • Managing multiple resources through count and loops
  • Using maps and lists in your code
  • Using functions in your code
  • Using Terraform CLI and state manipulation to debug your configuration

Part 5: Modules

This section shows how modules can be used to create reusable components in Terraform and teaches best practices in organizing Terraform code.

  1. Purpose of modules
  2. Modules code file organization structure
  3. Module structure
  4. Module sources and versioning
  5. Nested modules
  6. Publishing modules

Hands-on Labs:

  • Refactoring your earlier lab code to a module
  • Using Azure modules (subscription, metadata, resource group, virtual network)

Part 6: Wrapping Up

This section wraps up the course with reviews to reinforce what you have learned.

  1. Reference material to learn more
  2. Course review
  3. Next steps

Cloud Strategy Boot Camp

Part 1: Fundamentals of Cloud Computing

  1. Tenets of Cloud Computing
    • What makes something “cloud”?
    • The five tenets
    • Why the five tenets are so difficult in practice
    • The cloud mindset
  2. Cloud Deployment Models
    • Types of providers
      • Public
      • Private
      • Hybrid
    • Combining providers
      • Single
      • Multi-cloud
    • Choosing among provider types
    • Using cloud providers securely
  3. Cloud Service Models
    • Infrastructure as a service (IaaS)
    • Platform as a service (PaaS)
    • Software as a service (SaaS)
    • Serverless
  4. Communicating Your Cloud Journey
    • Share your cloud strategy
    • Don’t ignore the people side of strategy success
    • Stay connected regularly and be available
    • Expect challenges and doubters
    • Celebrate your successes and share lessons learned
    • Exercise: Develop a communications plan

Part 2: Cloud Strategy Overview

  1. What Is Cloud Strategy?
    • What it is (and isn’t)
    • Relation to other strategies and plans
    • Once you have one, now what?
  2. From Business Vision to Cloud Strategy
    • Desired business outcomes
    • Potential benefits
    • Potential risks
    • The rise of bimodal IT
    • Business-specific factors
    • Exercise: Align benefits and risks with desired outcomes
  3. Cloud Strategy Council
    • What is it?
    • Why do you need one?
    • Who’s on it?
  4. Services Model
    • Consume
    • Build
    • Broker
    • Hybrid Management
    • Exercise: Develop sample services model
  5. Financial Models
    • How pricing works for cloud services
    • Is cloud cheaper?
    • CapEx vs. OpEx
  6. Principles
    • Why principles matter
    • Common cloud principles
    • How to choose yours
    • Exercise: Select cloud principles for sample case
  7. Workload Inventory
    • The hard work of preparation
    • Exercise: Complete a sample workload inventory
  8. Establish Governance Model
    • Importance of cloud governance
    • Layers of governance
      • Enterprise architecture
      • Technical architecture
      • Application architecture
      • Data architecture
    • Risk and compliance
      • Legal compliance
      • Industry compliance
      • Internal policies
    • Cloud center of excellence
  9. Staffing, Resource, and Training Impacts
    • Assessment of roles needed and impacted
    • Evaluate corporate staffing and resource policies
    • Exercise: Complete a sample training plan
  10. Exit Strategy
    • Why it’s critical to have one
    • Contracts
    • Data ownership and retention
    • Potential risks and issues

Part 3: Beginning Cloud Adoption

  1. Cloud Adoption Framework
    • Assess
    • Perform
    • Extend
    • Improve
  2. Assess Your Cloud Readiness
    • Initiating your adoption planning
    • Conducting cloud readiness assessments inventorying
    • Interpreting readiness results
    • Moving from assessment to action plan
    • Exercise: Complete a sample readiness assessment
  3. Cloud Migration Decision Framework: The 6Rs
    • Replace
    • Refactor
    • Rehost
    • Retain
    • Retire
    • Replatform
    • Exercise:Apply cloud migration decision framework to a sample case
  4. Select Your First Cloud Service
    • Prioritize candidate services
      • Select candidates for your first cloud service
      • Assess service criticality of each candidate
      • Assess risk and benefit of each candidate
      • Decide on the first cloud service
    • Architect selected cloud service
      • Cloud native
      • 12 factor app methodology
      • LIFESPAR
      • Exercise: Rearchitect sample architecture for cloud migration
    • Evaluate cost and return
      • Maximize your cloud value
        • Avoid surprise bills
        • Use demand forecasting effectively
        • Trade off space and time to save money
        • Hit your uptime targets without breaking the bank
      • Assess benefits of cloud service
        • Operational efficiencies or agility
        • Changes in staffing and skill sets
          • Operations
          • Development
          • Security
        • Expected cost savings from infrastructure
        • Determine costs of cloud services
        • Assessing impact on staff resources
      • Compute cloud service costs
        • Throughput
        • Compute time
        • Scalability
        • Resiliency
      • Exercise: Estimate cost for sample architecture for public cloud providers

Part 4: Extending and Improving Adoption

  1. Assess Hybrid Operating Challenges
    • Development and testing
      • Development toolchain
      • Debugging in the cloud
      • Testing
    • Operations
      • The rise of SRE
      • Moving administration up the stack
      • Aligning cloud service monitoring and on-premises monitoring
      • Survey of SRE vendors and tools
    • Security
      • Incident and event management
      • Auditing
      • Policy enforcement
      • Penetration testing
      • Threat assessment and modeling
      • Vulnerability management
    • Identity and access controls
      • The continuum of identity from on-premises to IDaaS
      • Understand the benefits and trade-offs of IAM protocols
      • Identity as the new edge
      • The hidden costs of identity in SaaS
      • Survey of cloud IAM vendors
    • Environment management
      • Moving from on-premises environments to cloud environments
      • Hybrid environment challenges
    • Configuration management
      • Impact of cloud service models on configuration
      • Storing secrets securely
      • Managing secrets over time
      • Monitoring for drift
      • Survey of configuration management vendors and tools
    • Deployment and release management
      • A new philosophy of release management
      • Separating deployment from release
      • Monitor and recover from failed deployments
      • Data management
        • Implement proper security controls
        • Plan a successful data migration effort
        • Establish audit and traceability
        • Analysis and reporting from the cloud
          • Business continuity and disaster recovery
            • Evaluate business continuity procedures
            • Evaluate disaster recovery procedures
  1. Improve Cloud Adoption Practices
    • Conduct regular retrospectives
    • Improve automation
    • Manage workloads
    • Refine governance, security, and risk processes
    • Train and develop staff
    • Monitor cloud consumption
    • Perform ongoing security and risk assessments

 Part 5: Wrap Up

  1. Our Cloud Strategy Journey
  2. What To Do Now
  3. Final Thoughts

Jira and Agile Projects

Part 1 – JIRA Fundamentals

  1. Using JIRA
  • The JIRA workspace
  • Mapping JIRA features to common agile & scrum practices
  • Tickets in JIRA
  1. Team roles and JIRA
  • Review: Agile and Scrum basics
  • Team members
  • ScrumMasters & Product Owners
  • JIRA features for supporting Agile teams
  1. JIRA issues and Agile Projects
  • What’s possible with JIRA
  • Navigating JIRA
  • Creating, editing and transitioning issues
  • Types of issues
  • JIRA’s standard hierarchy
  • Stories, prioritizing & estimating
  • Managing backlogs in JIRA

Hands-On Exercise: Using issues to track, link, and cross-reference agile projects

  1. JIRA workflows
  • Project roles & permissions
  • Components
  • Releases
  • Projects to products
  • Views of projects within JIRA
  1. Search and Exploring Data
  • Prioritizing & searching JIRA issues
  • Views & options for meaningful results
  • Using filters
  • Using JIRA Query Language (JQL)
  • Saved searches and re-use
  • Using dashboards & subscriptions

Hands-On Exercise: Defining search criteria and using JQL, detail view, list view, filters & subscriptions

Part 2 – Applying JIRA to Enterprise Work

  1. Managing agile & kanban boards in JIRA
  • Aligning agile boards with team needs
  • Scrum vs. Kanban boards
  • Using Kanban boards
  • Typical team member duties in JIRA
  • Supporting sprint planning and resource assignments
  • Managing your backlog efficiently with JIRA
  • Epics, stories, and sub-tasks
  • Releases and release reporting
  1. Sprints in JIRA
  • Starting a sprint
  • Active sprints
  • Quick filters for managing work
  • Swimlanes
  • Closing a sprint

Demo – Using Agile Boards for backlogs and sprints

During this in-depth demonstration, we will show you how to use JIRA for some of the most common agile project needs. This demo will cover:

  1. Agile Board Navigation
  2. Compare Scrum and Kanban boards
  3. Using Backlog mode
  4. Filtering the Backlog
  5. Planning a Sprint
  6. Starting a Sprint
  7. Managing Work in an Active Sprint
  8. Closing a Sprint
  1. Analyzing reports in JIRA
  • Built-in JIRA reports and their benefits
  • Analyzing reports
  • Using information in JIRA to make decisions
  1. JIRA scrum boards and agile reports
  • Burndown Charts
  • Sprint Report
  • Epic Burndown
  • Release Burndown
  • Velocity Charts
  • Control Charts
  • Cumulative Flow Diagram
  1. JIRA Kanban Board reports
  • Control Charts
  • Cumulative Flow Diagrams
  • Work in Progress (WiP) and JIRA

Part 3 – Scaling JIRA enablement

  1. Using JIRA to enable Agile projects at scale
  • Managing multiple projects in JIRA
  • Cross-referencing and linking issues
  • Portfolio and program support with JIRA
  • Managing releases
  • Reporting
  • JIRA plugins
  1. Building Dashboards in JIRA
  • Creating, editing, and sharing dashboards
  • Dashboard gadgets to present information
  • Where do gadgets get their data?
  • Configure dashboard gadgets with project data and/or filtered data
  • Dashboard layouts
  • Dashboard troubleshooting
  1. Course conclusion: charting your path
  • Discussion: Top three opportunities for improvement using JIRA
  • Immediate next steps for your team
  • Expert Q and A

Microsoft Power BI Boot Camp

Part 1: What is BI

  1. Business Intelligence Overview
  2. Evolution of Business Intelligence
  3. Common Challenges
  4. Benefits of Power BI

Part 2: Getting Started with Power BI

  1. Overview & Pricing/Licensing
  2. Components of Power BI
    1. Power BI Desktop
    2. Power BI Mobile
    3. Power BI Embedded
    4. Power BI Gateway
  3. Building Blocks of Power BI
    1. Datasets
    2. Visualization
    3. Reports
    4. Tiles
    5. Dashboards
  4. Power BI Workflows
  5. Resources for Inspiration

Demo: Quick Tour of Power BI Service

Lab Exercise: Quick Tour of Power BI Service

Part 3: Getting Data

  1. Navigating Power BI Desktop
  2. Connect to Data Sources in Power BI Desktop
    1. File Data Sources
    2. Database Data Sources
    3. Azure Data Sources
    4. Online Service Data Sources
    5. Miscellaneous Data Sources
  3. Clean and Transform your Data
  4. Advanced Data Sources
    1. Advanced Editor
    2. Shaping Data
    3. Applied Steps
  5. Transformations
  6. Cleaning Irregularly Formatted Data
  7. Data Types
  8. Combining Data
  9. AI Analytics
    1. Text Analytics
    2. Vision
    3. Azure Machine Learning
    4. Invoking the Shared Models
    5. Considerations and Limitations

Demo: Quick Tour of Power Query Editor

Lab Exercise: Import Data and Create Queries with Power BI Desktop

Lab Exercise: Transform Data

Lab Exercise: Combining Data

Lab Exercise: Create a Report using Power BI Desktop

Lab Exercise: Publish a PBIX File to the Power BI Service

Part 4: Power BI and Excel

  1. Excel Integration
    1. Import an Excel Table into Power BI
    2. Use Excel as a Dataset
    3. Import Excel Files with Data Models
    4. Connect, Manage and View Excel in Power BI
  2. Publishing and Sharing

Part 5: Modeling Data

  1. Overview
  2. How to Manage Your Data Relationships
  3. Create Calculated Columns
  4. Optimizing Data Models for Better Visuals
  5. Create Measures and Work with Time-Based Functions
  6. Create Calculated Tables
  7. Explore Time-Based Data
  8. Grouping
  9. Binning
  10. Hierarchies

Demo: Modeling Relationships Column by Example Conditional Columns, Groups, Hierarchies

Part 6: Visualizations

  1. Overview
  2. Create and Customize Simple Visualization
    1. Numerical Fields
    2. Text Fields
    3. Geographic Fields
  3. Modify Colors Insert Static Objects, and Set Page Properties
  4. Styling with Shapes, Text Boxes, and Images
  5. Page Layout and Formatting
  6. Z-Order of Report Elements
  7. Customize Visuals with Summarizations
  8. How to:
    1. Use Combination Charts
    2. Manage Slicers and Sync Slicer
    3. Use Map Visualizations
    4. Implement Tables and Matrixes
    5. Apply Conditional Formatting
    6. Interpret Scatter Charts
    7. Work with Water & Funnel Chart
    8. Use Gauges and Single Number Cards
  9. Creating Complex Interactions Between Visuals
  10. Advance Concepts and New Features
    1. Decomposition Tree
    2. Key Influencers
    3. Insights
    4. Visual Hierarchies and drill-down behavior
    5. Custom Visualizations
    6. Drillthrough
    7. Analytics Pane
    8. Forecasting
    9. Tooltips
    10. Chiclet Slicer
    11. Hierarchy Slicer
    12. Synoptic Panel
  11. Other Powerful Custom Visualizes
    1. Pivot Slicer
    2. Smart Filter
    3. Hierarchy Filter
    4. Card Browser
    5. Visio Visual
    6. Infographic Designer
    7. D3JS Visualizer

Demo: Visualizations, Slicers, and Advanced Interactions

Part 7: Publishing and Sharing

  1. Print and Export Power BI dashboards
  2. Creating Content Packs
  3. Publishing to Web
  4. Embed in SharePoint
  5. Export to PowerPoint
  6. Power BI Mobile
  7. Creating Workspaces in Power BI

Part 8: Exploring Data

  1. Overview
  2. Use Quick Insights
  3. Create and Configure a Dashboard
  4. Shared Dashboards with your Organization
  5. Display Visuals and Tiles Full-Screen
  6. Edit Tile Details
  7. Get More Space on Your Dashboard
  8. Ask Questions of your Data with Natural Language
    1. Custom Q&A suggestions
    2. Adding Q&A to a Report
    3. Adding a Q&A to a Report
    4. Q&A Tooling
    5. Review Questions
    6. Teach Q&A
    7. Manage Terms
    8. Data Sources for Q&A
    9. Bulk Synonyms
    10. Q&A Best Practices
  9. Bookmarks
  10. Themes

Demo: Quick sights

Demo: Q&A in Dashboards and Reports

Demo: Bookmarks

Part 9: Administration & Security

  1. Securing Content in Power BI
    1. My workspace
    2. Sharing a Dashboard
    3. Sharing to Web
    4. Admin Access
  2. Row-level Security
  3. Permissions
  4. Defining and Creating toles within Power BI Desktop
  5. Row-Level Security
  6. Managing Data Capacity
  7. Subscriptions
  8. Resources

Part 10: Introduction to DAX

  1. DAX Calculation Types
    1. Calculated Columns
    2. Calculated Measures
  2. DAX Functions
    1. Aggregation Functions
    2. Counting Functions
    3. Logical Functions
    4. Information Functions
    5. Text Functions
    6. Date Functions
  3. Using Variables in DAX Expressions
  4. Table Relationships in DAX
  5. DAX Tables and Filtering
  6. Quick Measures
  7. What-if Parameters
  8. Dynamic Labeling
  9. Resources

Demo: Quick Measures

Demo: What-if

Demo: Dynamic Labeling

Hands-on Lab Exercises:

  • Retail Sales Exercise
  • Retail Analysis – Overview
  • Retail Analysis – District Monthly Sales
  • Retail Analysis – New Stores
  • Customer Profitability Exercise
  • Customer Profitability – Team Scorecard
  • Customer Profitability – Industry Margin Analysis
  • Customer Profitability – Executive Scorecard
  • Opportunity Analysis: Exercise
  • Opportunity Analysis – Opportunity Count
  • Opportunity Analysis – Revenue Overview
  • Opportunity Analysis – Upcoming Opportunities
  • Opportunity Analysis – Region Stage Counts
  • Opportunity Analysis Data Model

Docker Containerization Boot Camp

Students should bring laptops to class. This 3-day Docker training workshop is conducted as a continuous hands-on lab. From the initial install to the multi-container application stack, you will learn Docker through real-world practice.

Part 1: Introduction

  1. What can you use Docker for?
  2. A logical segregation of duties
  3. The relationship between Docker and SOA
  4. How Docker fits into the development lifecycle
  5. How Docker ensures consistency from development through UAT and staging, and on to production
  6. Example use cases of Docker in the real world

Part 2: The components of Docker

  1. Underlying technology
  2. Docker client and server
  3. Filesystem images
  4. Registries
  5. Containers
  6. Networking

Part 3: Getting set up to start using Docker

  1. Getting set up on Windows
  2. Getting set up on the Mac
  3. Trying out our first container
  4. Getting set up for production on Linux
  5. Tweaking your production environment for best performance
  6. User interfaces for Docker management

Part 4: Container management

  1. Container naming
  2. Starting and stopping containers
  3. Attaching to a container
  4. Seeing what is happening in a container
  5. Running a process inside a container
  6. Daemonizing a container
  7. Automatic container restarts
  8. Deleting containers when we are finished with them

Part 5: Docker images and repositories

  1. Docker images explained
  2. How Docker images work
  3. Getting a list of images
  4. Searching for images on a repository
  5. Pulling an image
  6. Creating our own image
  7. Specify an image in a Dockerfile
  8. Building Dockerfile images
  9. Using the build cache for templating
  10. Viewing the image we have created
  11. Launching a container using our new image

Part 6: Registries

  1. What is the Docker hub?
  2. Pushing images to the Docker hub
  3. Running your own internal Docker registry
  4. Testing the internal registry

Part 7: A simple use case

  1. A single container static website
  2. Setting up a container running Nginx
  3. Launching our static site
  4. Updating our static site from git or bitbucket

Part 8: Continuous integration with Docker

  1. How Docker enables and supports CI
  2. Getting set up for Jenkins and Docker
  3. A basic Jenkins job
  4. Multi-configuration jobs
  5. Drone
  6. Shippable

Part 9: A more complex use case: Multi container application stacks

  1. A container for our NodeJS application
  2. A base image for our Redis containers
  3. Creating our Redis back-end cluster
  4. Capturing logs
  5. Managing containers

Part 10: Docker orchestration and service discovery

  1. Getting set up with Fig
  2. Configuring the fig.yml file
  3. How to use Fig
  4. Console
  5. Running a Console cluster

Part 11: Integrating with configuration management

  1. Managing your Docker hosts with Chef / Puppet / Ansible
  2. Building containers using configuration management tools
  3. Managing running containers with configuration management

Part 12: Docker and DevOps

  1. Enabling collaboration with Docker
  2. Using Docker to streamline workflow
  3. Using Docker's version control capabilities to enable experimentation and learning
  4. Docker's role in the overall IT value chain
  5. Creating value and quality with Docker
  6. Enabling smoother flow of work

Part 13: Course conclusion, open discussion, and Q&A

  1. Going back to work with a plan
  2. What was not covered in this class
  3. Q&A with the instructor
  4. Goodbyes

Managing Projects with Microsoft 365

  • Introduction to Project Management in Microsoft 365
    • Overview of tools and applications for managing tasks and projects
  • Introduction to Teams
    • Creating Teams
    • Creating Channels
    • Adding Channel Apps
    • Teams Apps
  • Introduction to SharePoint
    • Creating SharePoint Sites
    • SharePoint integration with Teams
  • Permissions Management in Microsoft 365 and SharePoint
    • Microsoft 365 Groups
    • Working with SharePoint Groups and Permissions
  • SharePoint Lists
    • Creating SharePoint Lists
    • Creating Columns
    • Creating and Working with Views
  • SharePoint Libraries
    • Creating SharePoint Libraries
    • Creating Columns
    • Creating Views
  • Document Management Tools
    • Version Control
    • Check In / Check Out Controls
    • Alerts
    • Working with Sensitivity Labels in SharePoint
  • Microsoft Planner
    • Planner Basic vs Planner Premium
    • Creating Basic Plans
    • Creating Premium Plans
    • Working with Microsoft Copilot for Planner
    • Integrating Plans into Teams
  • Microsoft Loop and Loop Components
    • Creating Microsoft Loop Workspaces
    • Creating Loop Pages
    • Creating Loop Components
    • Sharing and Embedding Loop Components
  • Microsoft Project Professional
    • Creating Project Plans
    • Creating Tasks
    • Scheduling Tasks
    • Working with Resources
    • Tracking Project Progress
    • Advanced Task Scheduling Features
    • Sync Project Plans with SharePoint
  • Automating Project Management Processes with Power Automate
    • Working with the built-in Sign Off Process
    • Creating Custom Workflows in Power Automate

Microsoft SharePoint Site Owner and Power User Boot Camp

Section 1 – Introduction to SharePoint

  • Introduction to SharePoint
  • How does SharePoint fit into Microsoft 365
  • Common SharePoint Deployments
  • Empowering Your Team and Building Your Single Source of Information

Section 2 – Understanding SharePoint Architecture in SharePoint Online

  • Old vs New SharePoint Architecture
  • Understanding Hub Sites
  • Creating SharePoint Sites
  • Teams sites and Communication Sites

Lab 1 – Creating Your SharePoint Sites

Section 3 – Permissions and Access Management

  • Understanding 365 Groups for Permissions
  • Working with SharePoint Groups
  • Working with Permissions Inheritance in SharePoint
  • Creating Custom Permissions in SharePoint

Lab 2 – Working with Permissions in SharePoint

Section 4 – SharePoint Lists

  • What is a List in SharePoint?
  • Classic vs Modern Lists
  • What is Metadata and How is it Used?
  • Creating and Working with List Views
  • How to Create Columns
  • Working with Different Column Types
  • How to Create and Deploy Site Columns

Lab 3 – Creating List Columns and Views

Section 5 – SharePoint Libraries

  • What are SharePoint Libraries
  • Reviewing Document Lifecyle
  • Creating Modern Document Libraries
  • Using Version Control in SharePoint
  • Understanding Draft Item Security
  • Working with Version History
  • Understanding Check in and Check Out Controls

Lab 4 – Creating SharePoint Libraries

Section 6 – Enterprise Content Management 

  • Understanding Tools for Content Management
  • Why to Avoid Folders in SharePoint
  • How to Create Libraries Without Folders
  • Building Content Types
  • Best Practices and Planning for Document Management

Lab 5 – Building Content Types in SharePoint

Section 7 – Practical Knowledge Check

  • A review of concepts covered so far in the class. Students work a practical scenario without step-by-step instructions to reenforce the covered learning concepts of the class to this point.

Section 8 – Business Process Automation in Power Automate

  • Introduction to Power Automate
  • Understanding Instant, Scheduled, and Push Button Workflows
  • Working with Workflow Triggers
  • Understanding Workflow Actions
  • Understanding Workflow Controls
  • Creating a Flow in Power Automate integrated with Microsoft Forms
  • Working with the SharePoint Built-In Sign Off Flow

Lab 6 – Creating and Using Power Automate Flows

Section 9 – SharePoint Site Design

  • Working with SharePoint Modern Pages
  • Review of SharePoint Web Parts
  • Creating New SharePoint Pages

Lab 7 – Customizing Your SharePoint Pages