Most popular
55232-A: Writing Analytical Queries for Business Intelligence
What you'll learn
Identify independent and dependent variables and measurement levels in their own analytical work scenarios.
Identify variables of interest in relational database tables.
Choose a data aggregation level and data set design appropriate for the intended analysis and tool.
Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others.
Create stored procedures, views, and functions to modularize data retrieval code.
Describe the purpose of analytical queries
Describe the function of TSQL data retrieval in an analytics/business intelligence environment
Describe the primary functions of the database engine
Discuss TSQL as a declarative language
Identify variables of interest in database tables
Write basic SELECT queries
Implement column expressions in SELECT queries
Implement column and table aliases
Describe data types and Implement data type conversions
Implement built-in functions
Use WHERE and ORDER BY clauses in SELECT queries
Discuss and describe the conceptual flow of JOIN operations
Implement INNER and OUTER JOIN operations on two or more tables
Describe the order of operations of SELECT clauses
Combine JOIN operations with WHERE and ORDER BY
Describe the row granularity of result sets
Discuss and implement aggregate functions to achieve required row granularity
Use GROUP BY to calculate aggregate values for groups
Use HAVING to filter records in the result set by aggregate value
Combine GROUP BY and HAVING with WHERE and ORDER BY
Describe and discuss the rationale of creating intermediate results sets within SELECT queries
Implement non-correlated and correlated subqueries
Implement derived tables
Implement Common Table Expressions
Create intermediate to advanced TSQL queries to retrieve result sets for analysis
Identify scenarios in which views, table-valued functions, and stored procedures simply data retrieval
Compare and contrast views, table-valued functions, and stored procedures
Create views, table-valued functions, and stored procedures
Describe the security requirement for creating database objects
Implement views, table-valued functions, and stored procedures for users with read-only access to source data
Describe the properties of database connection strings
Run queries from, and return results to, Excel, PowerBI, and RStudio
Export query results to external text files using the SSMS results pane, the bcp utility, and the Import/Export Wizard
Microsoft Office Access 2019: Part 1
What you'll learn
Navigate within the Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom reports.
AI-102T00: Designing & Implementing An Azure AI Solution
What you'll learn
Describe considerations for AI-enabled application development
Create, configure, deploy, and secure Azure Cognitive Services
Develop applications that analyze text
Develop speech-enabled applications
Create applications with natural language understanding capabilities
Create QnA applications
Create conversational solutions with bots
Use computer vision services to analyze images and videos
Create custom computer vision models
Develop applications that detect, analyze, and recognize faces
Develop applications that read and process text in images and documents
Create intelligent search solutions for knowledge mining.
Featured
Microsoft Office Word 2019: Part 3
What you'll learn
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
DP-300T00: Administering Microsoft Azure SQL Solutions
What you'll learn
Plan, deploy and configure Azure SQL offerings
Monitor database performance and tune a database and queries for optimum performance
Plan and configure a High Availability Solution
PL-900T00: Microsoft Power Platform Fundamentals
What you'll learn
Describe Microsoft Power Platform components
Describe Microsoft Dataverse, Connectors and AI builder
Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services
Identify benefits and capabilities of Microsoft Power Platform
Identify the basic functionality and business value Microsoft Power Platform components
Implement simple solutions with Power Apps, Power Automate, Power BI, and Power Virtual Agents
Identify when to use each Microsoft Power Platform component application to create business solution
Learn the value of using Microsoft Power Platform to create business solutions
Learn the components and features of Microsoft Power Platform
Descibe the difference between Dataverse and Common Data Model
Explain use cases and limitations of business rules and process flows
Explain what environments, tables, columns, and relationships are in Dataverse
Learn how other organizations digitize their processes using Power Apps
See Power Apps in action and learn options for making your first app
Learn about what Power Apps is and its business value
See how Power Automate works and looks from the user’s perspective
Build a simple flow
Learn the business value and features of Power Automate
See how Power BI works and looks from the user’s perspective
Learn how to build a simple Power BI dashboard
Describe the business value and features of Power BI
Describe the business value and features of Power Virtual Agents
Build a basic chatbot
Learn essential components that make up Power Virtual Agents and chatbots
Microsoft Office Access 2019: Part 2
What you'll learn
Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.
PL-600 Power Platform Solution Architect
What you'll learn
Becoming a Solution Architect/Getting to know your customer
Conceptualizing the design from requirements
Project governance and working as a team
Power Platform Architecture
Data Modeling
Analytics and artificial intelligence
Power Apps Architecture
Application Lifecycle Management (ALM)
Power Automate Architecture
Security Modeling
Integration
Dynamics 365 Applications Architecture
Power Virtual Agents architecture
Robotic Process Automation
Testing and Go Live
Microsoft Office OneNote 2016
What you'll learn
In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.
Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.
-35%
Trending
55232-A: Writing Analytical Queries for Business Intelligence
What you'll learn
Identify independent and dependent variables and measurement levels in their own analytical work scenarios.
Identify variables of interest in relational database tables.
Choose a data aggregation level and data set design appropriate for the intended analysis and tool.
Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others.
Create stored procedures, views, and functions to modularize data retrieval code.
Describe the purpose of analytical queries
Describe the function of TSQL data retrieval in an analytics/business intelligence environment
Describe the primary functions of the database engine
Discuss TSQL as a declarative language
Identify variables of interest in database tables
Write basic SELECT queries
Implement column expressions in SELECT queries
Implement column and table aliases
Describe data types and Implement data type conversions
Implement built-in functions
Use WHERE and ORDER BY clauses in SELECT queries
Discuss and describe the conceptual flow of JOIN operations
Implement INNER and OUTER JOIN operations on two or more tables
Describe the order of operations of SELECT clauses
Combine JOIN operations with WHERE and ORDER BY
Describe the row granularity of result sets
Discuss and implement aggregate functions to achieve required row granularity
Use GROUP BY to calculate aggregate values for groups
Use HAVING to filter records in the result set by aggregate value
Combine GROUP BY and HAVING with WHERE and ORDER BY
Describe and discuss the rationale of creating intermediate results sets within SELECT queries
Implement non-correlated and correlated subqueries
Implement derived tables
Implement Common Table Expressions
Create intermediate to advanced TSQL queries to retrieve result sets for analysis
Identify scenarios in which views, table-valued functions, and stored procedures simply data retrieval
Compare and contrast views, table-valued functions, and stored procedures
Create views, table-valued functions, and stored procedures
Describe the security requirement for creating database objects
Implement views, table-valued functions, and stored procedures for users with read-only access to source data
Describe the properties of database connection strings
Run queries from, and return results to, Excel, PowerBI, and RStudio
Export query results to external text files using the SSMS results pane, the bcp utility, and the Import/Export Wizard
Microsoft Office Access 2019: Part 1
What you'll learn
Navigate within the Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom reports.
AI-102T00: Designing & Implementing An Azure AI Solution
What you'll learn
Describe considerations for AI-enabled application development
Create, configure, deploy, and secure Azure Cognitive Services
Develop applications that analyze text
Develop speech-enabled applications
Create applications with natural language understanding capabilities
Create QnA applications
Create conversational solutions with bots
Use computer vision services to analyze images and videos
Create custom computer vision models
Develop applications that detect, analyze, and recognize faces
Develop applications that read and process text in images and documents
Create intelligent search solutions for knowledge mining.
Featured
Microsoft Office Word 2019: Part 3
What you'll learn
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
DP-300T00: Administering Microsoft Azure SQL Solutions
What you'll learn
Plan, deploy and configure Azure SQL offerings
Monitor database performance and tune a database and queries for optimum performance
Plan and configure a High Availability Solution
PL-900T00: Microsoft Power Platform Fundamentals
What you'll learn
Describe Microsoft Power Platform components
Describe Microsoft Dataverse, Connectors and AI builder
Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services
Identify benefits and capabilities of Microsoft Power Platform
Identify the basic functionality and business value Microsoft Power Platform components
Implement simple solutions with Power Apps, Power Automate, Power BI, and Power Virtual Agents
Identify when to use each Microsoft Power Platform component application to create business solution
Learn the value of using Microsoft Power Platform to create business solutions
Learn the components and features of Microsoft Power Platform
Descibe the difference between Dataverse and Common Data Model
Explain use cases and limitations of business rules and process flows
Explain what environments, tables, columns, and relationships are in Dataverse
Learn how other organizations digitize their processes using Power Apps
See Power Apps in action and learn options for making your first app
Learn about what Power Apps is and its business value
See how Power Automate works and looks from the user’s perspective
Build a simple flow
Learn the business value and features of Power Automate
See how Power BI works and looks from the user’s perspective
Learn how to build a simple Power BI dashboard
Describe the business value and features of Power BI
Describe the business value and features of Power Virtual Agents
Build a basic chatbot
Learn essential components that make up Power Virtual Agents and chatbots
Microsoft Office Access 2019: Part 2
What you'll learn
Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.
PL-600 Power Platform Solution Architect
What you'll learn
Becoming a Solution Architect/Getting to know your customer
Conceptualizing the design from requirements
Project governance and working as a team
Power Platform Architecture
Data Modeling
Analytics and artificial intelligence
Power Apps Architecture
Application Lifecycle Management (ALM)
Power Automate Architecture
Security Modeling
Integration
Dynamics 365 Applications Architecture
Power Virtual Agents architecture
Robotic Process Automation
Testing and Go Live
Microsoft Office OneNote 2016
What you'll learn
In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.
Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.
-35%
Featured Courses
Featured
55315: Introduction To SQL Databases
Course Description This three-day instructor-led course is aimed at people …
55315: Introduction To SQL Databases
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
Featured
55316: Administering A SQL Database
Course Description This instructor-led course provides students who manage SQL …
55316: Administering A SQL Database
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Featured
Microsoft Office Word 2019: Part 3
Course Description: Microsoft® Word enables you to do far more …
Microsoft Office Word 2019: Part 3
What you'll learn
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
Featured
Microsoft Office Word 2019: Part 2
Course Description: After you master the basics of creating, editing, …
Microsoft Office Word 2019: Part 2
What you'll learn
Organize content using tables and charts.
Customize formats using styles and themes.
Insert content using Quick Parts.
Use templates to automate document formatting.
Control the flow of a document.
Simplify and manage long documents.
Use mail merge to create letters, envelopes, and labels.
Featured
Microsoft Office Word 2019: Part 1
Course Description: These days, most people take electronic word processing …
Microsoft Office Word 2019: Part 1
What you'll learn
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Create and format tables.
Format text and paragraphs.
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.
Featured
Microsoft Office PowerPoint 2019: Part 2
Course Description: Meetings, instruction, training, pitches; these are all a …
Microsoft Office PowerPoint 2019: Part 2
What you'll learn
Customize design templates.
Use ink to hand draw elements.
Add tables.
Add charts.
Work with media.
Build advanced transitions and animations.
Finalize a presentation.
Customize presentation navigation.
Secure and distribute a presentation.
Featured
Microsoft Office PowerPoint 2019: Part 1
Course Description: It’s hard to imagine a day going by …
Microsoft Office PowerPoint 2019: Part 1
What you'll learn
Identify the basic features and functions of PowerPoint.
Develop a PowerPoint presentation.
Perform advanced text editing operations.
Add graphical elements.
Format graphical elements.
Prepare to deliver your presentation.
Featured
Microsoft Office Excel (2019-2016-2013): Advanced
Course Description: Clearly, you use Excel a lot in your …
Microsoft Office Excel (2019-2016-2013): Advanced
What you'll learn
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.
Featured
Microsoft Office Excel (2019-2016-2013): Intermediate
Course Description: Whether you need to crunch numbers for sales, …
Microsoft Office Excel (2019-2016-2013): Intermediate
What you'll learn
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
Course Description: Organizations the world over rely on information to …
Microsoft Office Excel (2019-2016-2013): Basic
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
All Microsoft Courses
Microsoft Online Training Courses - Live
CCS Learning Academy is an official Microsoft Gold partner!
Search here for available courses. If you would like to purchase training for a large group, please contact us for custom pricing. View Certification
Filter by Topic
Filter by Vendor
Microsoft Office Access 2019: Part 1
Course Description: Data is everywhere. Most job roles today involve …
What you'll learn
Navigate within the Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom reports.
Featured
Microsoft Office Excel (2019-2016-2013): Advanced
Course Description: Clearly, you use Excel a lot in your …
What you'll learn
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.
Featured
Microsoft Office Excel (2019-2016-2013): Intermediate
Course Description: Whether you need to crunch numbers for sales, …
What you'll learn
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
Course Description: Organizations the world over rely on information to …
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
55299-A: SharePoint 2019 Site Owner Training
Course Description: This SharePoint 2019 Site Owner class is for …
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create and edit web page content.
Learn to create site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions
Understand what Site Templates are.
Understand the different Tpes of Site Templates that come “Out of the Box”
Creating a new site using Site Templates
Create a Project site.
Create a Team site.
Create a Community site.
Create a Blog site.
Manage the sites listed in the Top Link Bar.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Understand how to add content to the Site Home page.
Understand how to create a wiki page library.
Understand how to add Web Parts.
Understand how to manage Web Parts.
Understand Site Columns.
Understand Content Types.
Understand how to create Site Columns.
Understand how to create Content Types.
Understand how to create a document template for a Content Type.
Understan how to assign a Content Type to a list or library.
Understand how to create new items based on a custom Content Type.
Understand SharePoint groups.
Understand how to create SharePoint groups.
Understand how to assign permission in SharePoint.
Understand how to view permission levels.
Understand how to manage permission inheritance at the site level.
Understand how to manage permission inheritance at the list or library level.
Understand how to edit a personal profile.
DP-100T01-A: Designing and Implementing a Data Science Solution on Azure
360° Microsoft Azure data science certification Course The Microsoft Azure …
AZ-500T00-A: Microsoft Azure Security Technologies
Course Description: This course provides IT Security Professionals with the …
What you'll learn
Implement enterprise governance strategies including role-based access control, Azure policies, and resource locks.
Implement an Azure AD infrastructure including users, groups, and multi-factor authentication.
Implement Azure AD Identity Protection including risk policies, conditional access, and access reviews.
Implement Azure AD Privileged Identity Management including Azure AD roles and Azure resources.
Implement Azure AD Connect including authentication methods and on-premises directory synchronization.
Implement perimeter security strategies including Azure Firewall.
Implement network security strategies including Network Security Groups and Application Security Groups.
Implement host security strategies including endpoint protection, remote access management, update management, and disk encryption.
Implement container security strategies including Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
Implement Azure Key Vault including certificates, keys, and secretes.
Implement application security strategies including app registration, managed identities, and service endpoints.
Implement storage security strategies including shared access signatures, blob retention policies, and Azure Files authentication.
Implement database security strategies including authentication, data classification, dynamic data masking, and always encrypted.
Implement Azure Monitor including connected sources, log analytics, and alerts.
Implement Azure Security Center including policies, recommendations, and just in time virtual machine access.
Implement Azure Sentinel including workbooks, incidents, and playbooks.
AZ-120T00-A: Planning and Administering Microsoft Azure for SAP Workloads
Course Description: This course teaches IT Professionals experienced in SAP …
