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
-22%
AZ-104T00-A: Microsoft Azure Administrator
Course Description: This course teaches IT Professionals how to manage …
-35%
PL-300: Microsoft Power BI Data Analyst
Course Description: This course will discuss the various methods and …
DP-300T00: Administering Microsoft Azure SQL Solutions
Course Description: This course provides students with the knowledge and …
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
Free
Implementing A SQL Data Warehouse
Course Description This course provides students with the knowledge and …
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing a logical design for a data warehouse
Implement a physical design for a data warehouse
Create Columnstore indexes
Implementing an Azure SQL Data Warehouse
Describe the key features of SSIS
Implement a data flow by using SSIS
Implement control flow by using tasks and precedence constraints
Create dynamic packages that include variables and parameters
Debug SSIS packages
Describe the considerations of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios
55321: SQL Server Integration Services
Course Description This instructor-led course is intended for IT professionals …
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
Featured
55315: Introduction To SQL Databases
Course Description This three-day instructor-led course is aimed at people …
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
Developing SQL Data Models
Course Description The focus of this 3-day instructor-led course is …
What you'll learn
Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
55353: Administering A SQL Database Infrastructure
Course Description This instructor-led course provides students who administer and …
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
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
