Database Courses


10985: Introduction to SQL Databases

This course is aimed at persons looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs

Read More

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.

Read More

10988: Managing SQL Business Intelligence Operations

This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed Business Intelligence (BI) data sources and expanding to personal and external/public data sources.

Read More

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.

Read More

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.

Read More

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.

Read More

20463 Implementing a Data Warehouse with Microsoft SQL Server

This course describes how to implement a data warehouse platform to support a BI solution. Candidates 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.

Read More

20464 Developing Microsoft SQL Server 2012/2014 Database

This course introduces 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.

Read More

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.

Read More

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.

Read More

20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012/2014

This training course teaches participants how to plan and design a BI solution that is based on Microsoft® SQL Server® 2014 and other Microsoft BI technologies.

Read More

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.

Read More

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.

Read More

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.

Read More

20765: Provisioning SQL Databases

This course is designed to teach participants how to provision SQL Server® databases both on-premise and in SQL Azure®.

Read More

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.

Read More

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.

Read More

40364: Database Administration Fundamentals

This course helps you build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.

Read More

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.

Read More

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.

Read More

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.

Read More

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. Today's training, added to that which you've gained from the previous two days, round out your Access education and provide you with marketable job skills.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

Microsoft Office Access 2019 Part 3

Attendees 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.

Read More

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.

Read More

Microsoft® Office Access® 2010: Level 4

This course is designed for students who have a thorough understanding of the basic and advanced user features of Microsoft® Access® 2010, and are interested in learning introductory level administrator skills. The course is also for students who may be working in a web-based environment and may need to adapt Access® applications to the environment.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More