Most popular
Introduction to Premiere Pro CC
What you'll learn
Touring Adobe Premiere Pro CC
Setting up a Project
Importing Media
Organizing Media
Essentials of Video Editing Working with Clips and Markers
Adding Transitions
Advanced Editing Techniques
Putting Clips in Motion
Multi-camera Editing
Editing and Mixing Audio
Sweetening Sound
Adding Video Effects
Color Correction and Grading
Exploring Compositing Techniques
Creating Titles
Managing Your Projects
Exporting Frames, Clips, and Sequences
Authoring DVDs with Adobe Encore
VMware vSphere: Optimize and Scale 7.0
What you'll learn
Configure and manage vSphere networking and storage for a large and sophisticated enterprise
Use VMware vSphere Client to manage certificates
Use Identity Federation to configure VMware vCenter Server to use external identity sources
Use VMware vSphere Trust Authority to secure the infrastructure for encrypted VMs
Use host profiles to manage VMware ESXi host compliance
Create and manage a content library for deploying virtual machines
Manage VM resource usage with resource pools
Monitor and analyze key performance indicators for compute, storage, and networking resources for ESXi hosts
Optimize the performance in the vSphere environment, including vCenter Server
Microsoft Office Outlook 2019: Part 2
What you'll learn
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.
Insert objects in messages, and modify properties and global options.
Organize, search, and manage messages.
Protect your mailbox and manage its size.
Use rules and Quick Steps to automate message management.
Work with advanced calendar settings.
Import and forward contacts.
Manage activities by assigning tasks to others.
Delegate access to and share Outlook items with others.
Archive and back up Outlook items using data files.
SAFe 5.0 Product Owner/Product Manager Training and Certification (POPM)
What you'll learn
Identify the major components of the Scaled Agile Framework
Connect the Scaled Agile Framework to core Lean-Agile principles and values
Identify key roles and responsibilities within a SAFe implementation
Contribute to Portfolio content using epics and the Portfolio kanban
Apply Value Stream strategies to define and manage solution value
Engage in Product Manager strategies
Operate as a SAFe Product Owner
Develop a stakeholder engagement plan
Build and grow communities of practice
Prepare for the exam to earn your POPM Certification
Six Sigma Yellow Belt
What you'll learn
Understand the basic concepts of Six Sigma Yellow Belt
Acknowledge the value of Six Sigma to an organization
Understand the Six Sigma Yellow Belt tools and techniques used to improve processes, customer satisfaction and efficiency
M55144: SQL Server Performance Tuning And Optimization
What you'll learn
SQL 2014 Architecture including the new Cardinality Estimator
Memory-optimized tables
Startup stored procedures
Database structures
Instant File Allocation
Table internals and valued parameters
Concurrency, transactions, and isolation levels
SQL Server locking architecture
Partitioned tables and indexes
Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)
Performance Monitor Tool, execution plans, Data Access Operators, MDW and viewing reports
Create, utilize, manage and monitor indexes
Cardinality Estimator, incremental statistics, computed column statistics, filtered statics, and maintenance
In-Memory OLTP engine, restrictions, the Analyze Migrate Report tool, and in-memory (DMVs)
DP-900T00: Microsoft Azure Data Fundamentals
What you'll learn
Describe core data concepts in Azure.
Explain concepts of relational data in Azure
Identify components of a modern data warehouse in Azure
Computer Vision: How AI Processes Images
What you'll learn
Understand the fundamental concepts of computer vision and image processing
Learn how AI models and algorithms are applied to analyze and interpret visual data
Gain practical insight into developing computer vision applications using frameworks like OpenCV and TensorFlow
Explore advanced topics such as object detection, facial recognition, and image segmentation
Analyze the ethical implications associated with computer vision technologies being intertwined with government
CompTIA Cloud+
What you'll learn
Prepare to deploy cloud solutions.
Deploy a pilot project.
Test a pilot project deployment.
Design a secure network for cloud deployment.
Determine CPU and memory sizing for cloud deployments.
Determine storage requirements for cloud deployments.
Plan Identity and Access Management for cloud deployments.
Analyze workload characteristics to ensure a successful migration to the cloud.
Secure systems to meet access requirements.
Maintain cloud systems.
Implement backup, restore, and business continuity measures.
Analyze cloud systems for the required performance.
Analyze cloud systems for anomalies and growth forecasting.
Troubleshoot deployment, capacity, automation, and orchestration issues.
Troubleshoot connectivity issues.
Troubleshoot security issues.
Trending
Introduction to Premiere Pro CC
What you'll learn
Touring Adobe Premiere Pro CC
Setting up a Project
Importing Media
Organizing Media
Essentials of Video Editing Working with Clips and Markers
Adding Transitions
Advanced Editing Techniques
Putting Clips in Motion
Multi-camera Editing
Editing and Mixing Audio
Sweetening Sound
Adding Video Effects
Color Correction and Grading
Exploring Compositing Techniques
Creating Titles
Managing Your Projects
Exporting Frames, Clips, and Sequences
Authoring DVDs with Adobe Encore
VMware vSphere: Optimize and Scale 7.0
What you'll learn
Configure and manage vSphere networking and storage for a large and sophisticated enterprise
Use VMware vSphere Client to manage certificates
Use Identity Federation to configure VMware vCenter Server to use external identity sources
Use VMware vSphere Trust Authority to secure the infrastructure for encrypted VMs
Use host profiles to manage VMware ESXi host compliance
Create and manage a content library for deploying virtual machines
Manage VM resource usage with resource pools
Monitor and analyze key performance indicators for compute, storage, and networking resources for ESXi hosts
Optimize the performance in the vSphere environment, including vCenter Server
Microsoft Office Outlook 2019: Part 2
What you'll learn
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.
Insert objects in messages, and modify properties and global options.
Organize, search, and manage messages.
Protect your mailbox and manage its size.
Use rules and Quick Steps to automate message management.
Work with advanced calendar settings.
Import and forward contacts.
Manage activities by assigning tasks to others.
Delegate access to and share Outlook items with others.
Archive and back up Outlook items using data files.
SAFe 5.0 Product Owner/Product Manager Training and Certification (POPM)
What you'll learn
Identify the major components of the Scaled Agile Framework
Connect the Scaled Agile Framework to core Lean-Agile principles and values
Identify key roles and responsibilities within a SAFe implementation
Contribute to Portfolio content using epics and the Portfolio kanban
Apply Value Stream strategies to define and manage solution value
Engage in Product Manager strategies
Operate as a SAFe Product Owner
Develop a stakeholder engagement plan
Build and grow communities of practice
Prepare for the exam to earn your POPM Certification
Six Sigma Yellow Belt
What you'll learn
Understand the basic concepts of Six Sigma Yellow Belt
Acknowledge the value of Six Sigma to an organization
Understand the Six Sigma Yellow Belt tools and techniques used to improve processes, customer satisfaction and efficiency
M55144: SQL Server Performance Tuning And Optimization
What you'll learn
SQL 2014 Architecture including the new Cardinality Estimator
Memory-optimized tables
Startup stored procedures
Database structures
Instant File Allocation
Table internals and valued parameters
Concurrency, transactions, and isolation levels
SQL Server locking architecture
Partitioned tables and indexes
Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)
Performance Monitor Tool, execution plans, Data Access Operators, MDW and viewing reports
Create, utilize, manage and monitor indexes
Cardinality Estimator, incremental statistics, computed column statistics, filtered statics, and maintenance
In-Memory OLTP engine, restrictions, the Analyze Migrate Report tool, and in-memory (DMVs)
DP-900T00: Microsoft Azure Data Fundamentals
What you'll learn
Describe core data concepts in Azure.
Explain concepts of relational data in Azure
Identify components of a modern data warehouse in Azure
Computer Vision: How AI Processes Images
What you'll learn
Understand the fundamental concepts of computer vision and image processing
Learn how AI models and algorithms are applied to analyze and interpret visual data
Gain practical insight into developing computer vision applications using frameworks like OpenCV and TensorFlow
Explore advanced topics such as object detection, facial recognition, and image segmentation
Analyze the ethical implications associated with computer vision technologies being intertwined with government
CompTIA Cloud+
What you'll learn
Prepare to deploy cloud solutions.
Deploy a pilot project.
Test a pilot project deployment.
Design a secure network for cloud deployment.
Determine CPU and memory sizing for cloud deployments.
Determine storage requirements for cloud deployments.
Plan Identity and Access Management for cloud deployments.
Analyze workload characteristics to ensure a successful migration to the cloud.
Secure systems to meet access requirements.
Maintain cloud systems.
Implement backup, restore, and business continuity measures.
Analyze cloud systems for the required performance.
Analyze cloud systems for anomalies and growth forecasting.
Troubleshoot deployment, capacity, automation, and orchestration issues.
Troubleshoot connectivity issues.
Troubleshoot security issues.
Featured Courses
Featured
PL-300: Microsoft Power BI Data Analyst
This course will discuss the various methods and best practices …
Featured
CompTIA A+ Core 2
CompTIA’s A+ certification is the industry standard for validating the …
CompTIA A+ Core 2
What you'll learn
Support operating systems.
Install, configure, and maintain operating systems.
Maintain and troubleshoot Microsoft Windows.
Configure and troubleshoot network connections.
Manage users, workstations, and shared resources.
Implement physical security.
Secure workstations and data.
Troubleshoot workstation security issues.
Support and troubleshoot mobile operating systems and applications.
Implement operational procedures.
Featured
PeopleCert SCRUM Master I
Course Description Scrum is a framework that helps teams work …
PeopleCert SCRUM Master I
What you'll learn
At this qualification level, candidates will be introduced to basic concepts, terms, principles and tools used for Scrum as well as why Scrum is needed in modern enterprises, the Scrum methodology, people and culture implications as well as the practices, processes, and technology used for adapting Scrum within an organization.
The definition and purpose of Agile
The three pillars of Scrum: inspection, adaptation, and transparency
The five Scrum values: commitment, focus, openness, respect, and courage
The characteristics of an effective Scrum Master, Product Owner, and developer
The purposes of different Artifacts and Events in Scrum
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
CC – Certified in Cybersecurity Training
Things you will get to learn in our CC – …
Featured
CompTIA Data+
Course Description As the importance of data analytics grows, more …
CompTIA Data+
What you'll learn
CompTIA Data+ gives you the confidence to bring data analysis to life
Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle
Mining data
Manipulating data
Visualizing and reporting data
Applying basic statistical methods
Featured
PeopleCert SCRUM Master II
Course Description Scrum is a framework within which people can …
PeopleCert SCRUM Master II
What you'll learn
At this qualification level, candidates will be introduced to concepts, terms, principles and tools used in the Scrum framework and gain a deep understanding of Scrum best practices as well as a level of expertise that goes beyond a typical team leader or project manager through a unique combination of case studies, storytelling, and practical learning based on the real-life challenges that Scrum Masters face.
The mastery of the Scrum framework centered around the integration of roles, events, and Scrum artifacts, including and supporting the product backlog and sprint backlog
The many soft skills necessary for the Scrum Master, such as servant leadership, facilitation, coaching and mentoring, problem solving, and removing impediments
The true extent of what it means to think and act in an Agile way
The Day-to-Day Work of the Scrum Master in a Sprint
The most common frameworks for scaling Scrum projects with multiple teams and complex products
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.
Popular Topics
Introduction to Angular
.NET Secure Coding
CSS
GitHub
Generative AI for Decision Makers
ASP .Net Web Applications Development
Real World Applications of Generative AI
Next Level Power BI
AI
Applying AI for Cost Savings & Efficiency
Generative AI for Architects
Implementing AI in Automated Enterprise
Jira
Tableau Desktop
Developing AWS Services and Tools
Microsoft Azure
Introduction to Power BI
CISSP
ITIL 4 Foundation Certification Training
C++ 20 Programming
Ethics and AI
AI Automation Strategies
XML Course
Cloud Operations on AWS
Advanced React
Voice Of Innovation
XML Learning
Introduction to Ansible
Tableau
Attacking and Securing C#
AWS
Building a Voice Bot
Automation with Ansible
Hadoop
Data Science and Big Data
Cloud Computing
Generative AI
Modern JavaScript
Introduction to Jira
Tableau Server Administration
Strategic AI Dialogues
JavaScript Essentials'
Core Java Programming
AI Types
Basic Java Programming
AI Principles
CISSP Exam Preparation Course
Git
react native
Java Programming
Responsive Design
AI Tools in Graphic Design
ASP .NET Core
Customer Support with AI
.NET Programming
Django
ITIL 4 Certification
UX Design
JavaScript
MVC Web Application Development by .NET
Microsoft Power BI Data Analyst
Kubernetes
Data Analyst
Mastering React
Microsoft Azure Administrator
Implementing AI in Business
React Course
Microsoft Azure Fundamentals Training Certification
Prompt Engineering for Business Users
Machine Learning Fundamentals
CompTIA Security+
Microsoft Azure Certification
Introduction to AI
CompTIA
HTML5
Introduction to GitHub
Microsoft Azure Fundamentals
CSS3
How AI Process Images
Full Stack Web Development
AI Applications
Introduction to C++
HTM
Python
UI/UX Design
Advance C++ 20 Programming
Privacy and Security in AI
Advanced Angular
All `Live Courses by Practice Area Courses
Test descriptionFilter by Topic
Filter by Vendor
Certified SAFe® Agile Product Manager (APM)
Course Description Recognize how Continuous Exploration fuels innovation and helps …
What you'll learn
Use Design Thinking to achieve desirable, feasible, and sustainable outcomes
Explore market needs, segmentation, sizing, and competitive landscape
Manage value stream economics, including pricing and licensing
Use empathy to drive design
Apply product strategy and vision
Develop and evolve roadmaps
Execute and deliver value using SAFe
Explore innovation in the value stream
Analyze and Visualize Data using Tableau
Course Description: The Analyze and Visualize Data using Tableau Certification …
What you'll learn
Basics about Tableau
How to connect, organize and slice data using Tableau
How to use multiple measures in a view
How learners can successfully show the relationship between various numerical values
How to map and customize data
How to view specific data
How to use quick table calculations to analyze the data in Tableau
How to use basic and advanced calculations in Tableau
How to extract data
What Tableau geocoding is
How to create using parameters
How to make dashboards and stories
Using Tableau to generate statistics
Using Tableau for forecasting
How to compare measures
How to assess the quality of data
How to use Tableau to perform exploratory analysis
Best practices while using Tableau
How to design visualizations for presentations
Architecting on AWS
Course Description In this authorized Amazon Web Services (AWS) course, …
What you'll learn
Making decisions based on the AWS-recommended architectural principles and best practices
Leveraging AWS services to make your infrastructure scalable, reliable, and highly available
Leveraging AWS managed services to enable greater flexibility and resiliency in an infrastructure
Making an AWS-based infrastructure more efficient in order to increase performance and reduce costs
Using the Well-Architected Framework to improve architectures with AWS solutions
To reinforce this material, you will also explore case studies with a variety of AWS infrastructure designs and strategies.
After the course, you will be fully equipped to build and scale a more efficient and reliable IT solution on the AWS cloud environment.
Leading SAFe 5.0 (SA)
Course Description The Scaled Agile Framework (or SAFe) is a …
What you'll learn
How to lead an enterprise Agile transformation
To apply Lean thinking techniques at the Team, Program and Portfolio levels
To apply Lean, Agile and Product Development Flow principles to improve productivity, employee engagement, time to market and quality
How to infuse Agile into your entire organization – not just your IT department
How to create Agile Release Trains that align the efforts of Agile and non-Agile teams to create greater stakeholder value
To encourage collaboration across all the layers of your organization to enable teams to deliver complex cross-functional features in 10-12 week increment
To improve the communication and focus of your organization’s Agile implementation
Prepare to take the SAFe Agilist Certification Exam
55286-A: SharePoint 2019 Power User
Course Description This course delivers the complete site owner story …
What you'll learn
Understand the benefits of using SharePoint in real world scenarios
Create new SharePoint sites to store business information
Create pages to share news and documents
Customize the structure of a site to meet specific business requirements
Create and mange view, columns and apps
Manage the security of a site
Use social tools to communicate with groups of people or the entire organization
Use search to find business information including people to documents
Describe popular reasons to use SharePoint 2019
Understand user roles in SharePoint 2019
Navigate SharePoint 2019
Manage your OneDrive and MySite
Understand the benefits of using site templates when creating new sites
Correctly use Site Collections and Sites
Control site navigation
Delete and Restore sites
Know when to create pages
Create all types of pages
Add content to a page including images and videos
Use publishing page content such as renditions and reuable content
Understand the App template available in SharePoint 2019
Create new apps to store business information
Customize apps with Columns, Views and App settings to make them relevant to specific business
Use SharePoint Apps with other Office applications including Excel and Outlook
Sort and Filter documents
Understand how to create a new approval flow
Understand how to create a new powerapp
Understand and instating a business process
Understand how to share content ina library and associated permissions
Understand how to create new permission levels and security groups
Understand how to add and remove users
Describe the key features of search
Use search to find content including people, sites and videos
Use search web parts to roll up content from multiple locations
Describe the benefits of using SharePoint social tools
Create social content including blog posts, discussions and newsfeed posts
55205-A: Mastering Microsoft Project 2016
Course Description: This three-day, instructor-led course is intended for individuals …
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2016.
Create a Work Breakdown Structure.
Identify Task Types & Relationships.
Define Resources within Project.
Make Work Package Estimates.
Create an Initial Schedule.
Create a Resource Leveled Schedule.
Create Projects from templates, Excel files.
Create Global templates.
Create formulas and graphical indicators.
The steps to record a macro.
Format Output and Print Reports.
Integrate Multiple Projects.
Set up a Project with a Calendar, Start date, and scheduling method.
Understand Manually Schedule vs. Auto Schedule.
Manage multiple projects.
Be able to create a master project list with shared resources.
Have a fundamental understanding of how Microsoft Project will help them track their projects.
Understand what is new in Project 2016 and how it will increase their productivity.
Learn how the ribbon will help them get the most of out of this productivity tool.
Learn how to quickly change views and see what is going on with their projects.
Understand the 5 essential steps in building a successful project plan.
Prepare a new project plan and set the date and other basic information.
Enter detailed project information.
Understand how to sequence tasks.
Understand and define basic resource types.
Assign resources to tasks.
Understand the benefits of baselining a project or specific tasks.
Understand the basics of how to track project progress.
Create a new project using a template, Excel, a SharePoint Tasks List or a new Project file.
Establish one or more calendars to constrain resource availability.
Configure Microsoft Project to calculate the schedule from the Start Date forward or from the Finish Date backward.
Understand how to turn on Manually Schedule and Auto Schedule.
Understand when to use Manually Schedule.
Understand the limitations of Manually Scheduling.
Build and use summary and subordinate tasks.
Understand and use milestones.
How to organize the WBS.
How to format the WBS.
Develop WBS outlines.
Assign completion criteria.
Evaluate the WBS.
Understand and use WBS outlines.
Understand how to link Project artifacts to their projects.
Understand how to create notes on tasks.
Understand the different types of task relationships.
Understand and use various methods to create relationships.
Determine and display task sequence.
Understand how to use Lag, Lead and Delay.
Define the different types of resources.
Define individual resources that will be used on the project.
Record the cost(s) of using each type of resource.
Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource.
Assign values for resources, duration and work.
Understand task types.
Understand Effort Driven scheduling.
Understand material resources and their costs to a project plan.
Identify the critical path.
Understand difference between slack and slippage.
Calculate float.
How to leverage constraints.
How to get the benefit from the Task Inspector, and the impact of changes on a project schedule.
Adjust a project schedule to account for limited resources.
View the overall cost and schedule of a project.
Identify resources that are over- allocated for a project schedule.
Use multiple ways to adjust tasks and assignments to remove over- allocation for any resource.
Set a baseline.
Enter and manage project performance data.
Pick a tracking method.
Perform variance analysis.
Sync Projects results with SharePoint.
Create standardized views, with the power of sorting, filtering and grouping.
Customize a variety of standard reports.
Learn how to use Visual Reports.
Export reports in a variety of formats.
Use common resources among multiple projects.
Link tasks between multiple projects.
Create a consolidated view of multiple projects and shared resources.
Take advantage of the advance features of Microsoft Project.
Be able to create a Macro.
Share common settings among all future projects.
PL-900T00: Microsoft Power Platform Fundamentals
Course Description: Learn the business value and product capabilities of …
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
55232-A: Writing Analytical Queries for Business Intelligence
Course Description: This three-day instructor led course is about writing …
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
