10985: Introduction to SQL Databases
This course describes fundamental database concepts including database types, database languages, and database designs
Database Courses
10987: Performance Tuning and Optimizing SQL Databases
This course provides attendees, who manage and maintain SQL Server® databases, with the knowledge and skills to performance tune and optimize their databases.
10990: Analyzing Data with SQL Server Reporting Services
This course teaches attendees how to implement a SQL Server® 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
20461 Querying Microsoft SQL Server 2014
This course provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft® SQL Server® 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
20462 Administering Microsoft SQL Server 2014 Databases
This course provides participants with the knowledge and skills to maintain a Microsoft® SQL Server® 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
20463 Implementing a Data Warehouse with Microsoft SQL Server 2014
This course describes how to implement a data warehouse platform to support a BI solution. Participants will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. NOTE: It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
20464 Developing Microsoft SQL Server 2012/2014 Database
This course introduces participants to SQL Server® and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
20465 Designing Solutions for Microsoft SQL Server 2012/2014
The focus of this course is on planning and implementing enterprise database infrastructure solutions by using SQL Server® and other Microsoft® technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.
20466 Implementing Data Models and Reports with SQL Server 2012/2014
The focus of this course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint® Server PerformancePoint Services, and discover business insights by using data mining.
20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012/2014
This course teaches participants how to plan and design a BI solution that is based on Microsoft® SQL Server® 2014 and other Microsoft BI technologies.
20761: Querying Data with Transact-SQL
This course is designed to introduce participants to Transact-SQL and give a good understanding of the language. This course also teaches the skills required to take the certification exam.
20762: Developing SQL Databases
This course provides participants with the knowledge and skills to develop a Microsoft® SQL Server® 2016 database. It focuses on teaching individuals how to use SQL Server® 2016 product features and tools related to developing a database.
20764: Administering a SQL Database Infrastructure
This course provides participants who administer and maintain SQL Server® databases with the knowledge and skills to administer a SQL Server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
20765: Provisioning SQL Databases
This course is designed to teach participants how to provision SQL Server® databases both on-premise and in SQL Azure®.
20767: Implementing a SQL Data Warehouse
This course provides attendees with the knowledge and skills to provision a Microsoft® SQL Server® database. It covers SQL Server provision both on-premise and in Azure®, and covers installing from new and migrating from an existing install.
20768: Developing SQL Data Models
The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course also helps you prepare for the certification exam.
20777: Implementing Microsoft Azure Cosmos DB Solutions
This course teaches participants to design, build, and troubleshoot Microsoft® Azure® Cosmos DB solutions that meet business and technical requirements.
40364: Database Administration Fundamentals
In this course, participants will be introduced to database design and administration. They will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database. This course also helps participants prepare for the Microsoft® Technology Associate certification exam.
40562: Migrating SQL Databases to Azure
In this workshop, participants will work as a group to set up and configure a serverless architecture within Azure® using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos DB, and Azure Storage. The focus is on removing server management from the equation, breaking down the solution into smaller components that are individually scalable, and allowing the customer to only pay for what they use.
55315: Introduction to SQL Databases
The course describes fundamental database concepts including database types, database languages, and database designs.
55317: Querying Microsoft SQL Server 2022
This course teaches participants how to use basic Transact-SQL statements and other languages to query modern editions of Microsoft® SQL Server® and Azure® SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. By using demonstrations and hands-on labs, participants will learn to perform these tasks using SQL Server, Azure Data Studio, and other database tools.
55356: Introduction to SQL Database
This course examines the services and features of Microsoft® SQL from 2012 to 2022, including lessons and lab exercises on key attributes participants will need on the job. It’s designed for novices and professionals who are interested in interacting with databases using Structured Query Language (SQL) and seek foundational knowledge and skills. This audience typically includes people who are moving into a database role or expect their role to require interacting with a database server that uses SQL.
55369: Provisioning Databases on SQL Server
In this course, participants will learn how to provision SQL Server® databases for both on-premises and in Azure®. The course covers new installations and migrations from existing installations. It also covers the concepts, techniques, and best practices for creating, configuring, and managing databases on Microsoft SQL Server.
CompTIA Data+
This course teaches participants the knowledge and skills required to transform business requirements in support of data-driven decisions. They will learn to do so by mining and manipulating data, applying basic statistical methods, and analysing complex data sets while adhering to governance and quality standards throughout the entire data lifecycle. In addition, this course will help prepare participants to take the certification exam. Also, this course may earn participants a Credly Badge.
DP-050T00: Migrate SQL Workloads to Azure®
In this course, participants will explore the objectives of data platform modernization and how it is suitable for given business requirements.
DP-070T00: Migrate Open Source Data Workloads to Azure
This course will enable participants to understand the Azure® SQL Database and educate them on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
DP-080T00 Querying Data with Microsoft Transact-SQL
This course will teach participants how to use Transact-SQL. They will learn to query and modify data in relational databases hosted in Microsoft SQL Server-based database systems, including Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics.
DP-300T00: Administering Microsoft Azure SQL Solutions
This course provides participants with the knowledge and skills necessary to administer a SQL Server® database infrastructure for cloud, on-premises, and hybrid relational databases. These participants work with the Microsoft® PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
DP-900T00: Microsoft Azure Data Fundamentals
In this course, participants will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft® Azure®.
Fundamentals of Databases Using MySQL
Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL® 5.1. In the Fundamentals of Databases Using MySQL® course, you will work with the databases using MySQL®. This will be done by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems.
Microsoft Access for Office 365: Part 1
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® for Office 365™can help participants and their organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
Microsoft Access for Office 365: Part 2
In this course, participants will expand their knowledge of relational database design. They will learn how to promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending their knowledge of Microsoft® Access® for Office 365™ will result in a robust, functional database for their users.
Microsoft Access for Office 365: Part 3
Once participants have covered many of the basic functions of Microsoft® Access® for Office 365™, they are ready to learn advanced Access features. In this course, features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more will be covered. Knowledge of these features separate database professionals from casual database users or occasional designers.
Microsoft Office Access 2010: Part 1
A relational database application such as Microsoft® Office Access® 2010 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, participants will learn how to use Access 2010 to manage their data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
Microsoft Office Access 2010: Part 2
Your training and experience using Microsoft® Access® 2010 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, participants will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2010 will result in a robust, functional database for your users.
Microsoft Office Access 2010: Part 3
You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This course, adds on to the knowledge and skills participants have gained previously and, rounds out their Access education and provides them with marketable job skills.
Microsoft Office Access 2010: Part 4
This course will teach participants how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Microsoft Office Access 2013: Part 1
A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, participants will learn how to use Access 2013 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Microsoft Office Access 2013: Part 2
Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, participants will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.
Microsoft Office Access 2013: Part 3
You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This training, added to that which participants have gained from the previous two levels or experience, rounds out their Access education and provides them with marketable job skills.
Microsoft Office Access 2016: Part 1
A relational database application such as Microsoft Office Access 2016 can help attendees and their organizations collect and manage large amounts of data. Access is a versatile tool. Attendees can use it as a personal data management tool (for their use alone), or they can use it as a construction set to develop applications for an entire department or organization. In this course, attendees will use Access 2016 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Microsoft Office Access 2016: Part 2
In this course, attendees will expand their knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
Microsoft Office Access 2016: Part 3
In this course, attendees will learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training will round out attendees’ Access education and provides them with marketable job skills.
Microsoft Office Access 2019: Part 1
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course focuses on the design and construction of an Access database which entails viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. NOTE: This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Microsoft Office Access 2019: Part 2
Previous training and experience using Microsoft® Office Access® should have given participants basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, they will expand their knowledge of relational database design, promote quality input from users, improve database efficiency and promote data integrity, and implement advanced features in tables, queries, forms, and reports. Extending their knowledge of Access will result in a robust, functional database for their users. This course focuses on the optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. NOTE: This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Microsoft Office Access 2019: Part 3
Participants have covered many of the basic functions of Microsoft® Office Access®, and now they are ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. NOTE: This course is the third part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Microsoft Office Access 2021: Part 1
This course will focus on the design and construction of an Microsoft® Office Access® database. Therefore, participants will learn how to view, navigate, search, and enter data in a database. They will also learn basic relational database design and create simple tables, queries, forms, and reports.
Microsoft Office Access 2021: Part 2
Your training and experience using Microsoft® Office Access® have given you basic database management skills. In this course, participants will expand their knowledge of relational database design. They will learn to promote quality input from users, improve database efficiency and promote data integrity, and implement advanced features in tables, queries, forms, and reports. At the end of this course, participants will be able to create a robust, functional database for their users.
Microsoft® Office Access® 2021: Part 3
This course will focus on managing the database and supporting complex database designs. Participants will learn to import and export data, use action queries to manage data, create complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. NOTE: Knowledge of these features separates database professionals from casual database users or occasional designers
MySQL and PHP — Developing Dynamic Web Applications
MySQL® & PHP are the foundation for developing powerful web applications & dynamic websites that go beyond basic HTML. Through this course, you’ll learn how to develop applications in PHP and use MySQL® efficiently for these applications. Also, combine these applications with time-proven database management techniques to create an efficient, solid and secure user-experience. Participants will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.
Oracle Database 11g Administration Workshop I
This course explores the fundamentals of basic database administration. Expert Oracle® University instructors will reinforce topics with structured hands-on practices that will prepare participants for the corresponding exam.
Oracle Database 11g Administration Workshop II
This training takes the database administrator beyond the basic tasks covered in Workshop I. Participants will begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.
Oracle Database 12c Administration Workshop
This course will teach you about the Oracle® Database architecture. You will discover how to effectively manage an Oracle® Database instance, configure the Oracle® Network Environment and perform database maintenance. Through hands on instruction and exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle® Database.
Oracle Database 12c Install and Upgrade Workshop
This course gives you detailed information to help you install Oracle® Database 12c software. Expert Oracle® instructors will teach you how to create a container database and provision pluggable databases.
Oracle Database 12c Program with PL/SQL
This training starts with an introduction to PL/SQL® and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle® instructors, you'll learn to develop stored procedures, functions, packages and more.
SQL for Data Analytics
This course covers everything participants need to progress from simply knowing basic SQL to telling stories and identifying trends in data. Participants will be able to start exploring their data by identifying patterns and unlocking deeper insights. They will also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, they will understand how to become productive with SQL with the help of profiling and automation to gain insights faster. By the end of the course, participants will be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of analytics professional.
WS-013T00: Azure Stack HCI
This advanced course is to cover advanced topics related to Windows Server® software-defined datacentre, Azure® Stack HCI, and other Azure Stack products. The course also describes the use of existing Microsoft® System Centre products to implement and manage software-defined datacentres with Windows Server 2019.