Database Development

In today's competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization's processes and give it a competitive edge. Some data analysis tasks may require that you query multiple tables simultaneously or create complex views of data.

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables; modifying table structures; inserting, updating, or deleting data; and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction.

Organizations typically store their most critical information the information used to manage day-to-day operations—within a database. The ability to retrieve and analyse this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

The Introduction to SQL with PostgreSQL course provides an in-depth introduction to SQL and relational databases, focusing on PostgreSQL as the database management system. The course covers essential topics such as querying and sorting data, filtering records with WHERE, advanced SELECT statements, subqueries, joins, unions, and conditional processing using CASE. Students will also learn to insert, update, and delete records, and create tables in PostgreSQL. Through hands-on exercises and real-world examples, learners will gain the skills necessary to perform effective data analysis using SQL and PostgreSQL.

This 2-day entry-level course examines the services and features of Microsoft SQL 2022. The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes.

There are instructor materials available for this course.

Audience profile

This course is designed for novices and professionals who are interested in interacting with databases using the SQL language. 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. As an introductory course, it doesn’t require any previous knowledge of SQL, databases, or information technologies.

Why choose this course?

- Meticulous content relevance, tailored to Microsoft SQL 2022.

- Content on obsolete technology has been removed.

- Offers an array of demonstrations that bolster the learning material.

- Expert instructional design ensures a superior learning experience.

- Labs are developed by Waypoint in parallel with courseware, so they are 100% aligned.

Structured Query Language (SQL) is fundamental to all relational database operations. In this hands-on Advanced SQL course, you will learn to maximize the potential of the SELECT statement by writing robust queries using the most effective methods for your application. You'll test your queries and learn to avoid common errors and pitfalls. The course also covers alternative solutions to various problems, allowing you to choose the most efficient solution for each situation.

Unlock the full potential of PostgreSQL with this comprehensive three-day, instructor-led course. Designed for database administrators and IT professionals, this hands-on training equips you with the expertise to install, configure, manage, and optimise PostgreSQL databases across multi-platform environments. You’ll learn how to implement robust backup and recovery strategies, improve performance and scalability, and maintain efficient, stable systems. Whether you are new to PostgreSQL or looking to expand your existing skills, this course provides the practical knowledge needed to succeed in today’s database landscape.

Introduction to Oracle SQL is a hands-on, beginner-friendly course designed to teach the core concepts and practical skills of working with SQL in an Oracle Database environment. Whether you're pursuing a career in data analysis, software development, or database administration, this course provides the essential foundation for managing and querying relational data using Oracle SQL.
Students will learn how to create and manage tables, retrieve and filter data, use built-in functions, perform joins and subqueries, manipulate data using DML commands, and create views. Each topic is reinforced with real-world examples and practical exercises to build confidence and deepen understanding.

Introduction to Oracle PL/SQL is a hands-on course designed for those who already understand Oracle SQL and want to dive into the powerful procedural capabilities of PL/SQL. This course teaches the core concepts and structures of PL/SQL programming and equips learners to develop robust, secure, and maintainable applications within the Oracle Database environment.
Participants will explore key PL/SQL features, including blocks, variables, control structures, subprograms (procedures and functions), exception handling, cursors, packages, and triggers. Each concept is reinforced with practical exercises and real-world examples to solidify understanding and build real development skills.

This course is designed to teach students how to build efficient, database-driven applications using Oracle APEX (Application Express). It begins with an introduction to APEX—tracing its evolution and highlighting its growing importance in the tech industry as a powerful low-code platform for rapid application development.
Students will explore APEX’s architecture, core components, and the key programming languages it relies on—primarily SQL and PL/SQL. They’ll gain a solid understanding of the different roles within the APEX ecosystem and examine various deployment options, preparing them for real-world collaboration and application delivery.

The course is highly practical, with hands-on labs focused on creating queries, designing intuitive user interfaces, and building functional, scalable applications. This approach bridges theory and practice, ensuring students walk away with the experience needed to develop secure, enterprise-grade applications using APEX.

By offering this course, you're equipping students with an in-demand skill set that is highly relevant in today’s job market. Graduates will be well-prepared to join development teams looking to leverage Oracle APEX for solving complex business problems with speed and efficiency.

The Advanced Oracle APEX course is designed to elevate your students' proficiency in APEX by focusing on advanced development techniques and features. It builds on foundational knowledge to explore more complex concepts such as session state management, robust security practices, and the nuances of data loading, transformation, and custom authentication workflows.
Structured around real-world, hands-on exercises, this course challenges students to apply their skills in practical scenarios—like securing applications, managing intricate data relationships, and enhancing performance. Each module is designed to reinforce critical thinking and problem-solving in a modern application development context.

Students will delve into advanced UI/UX techniques, improving application usability through sophisticated navigation, interface customization, and responsive design. They’ll also harness the full power of APEX’s data visualization tools and learn how to extend the platform using themes, templates, and plug-ins.

A key component of the course is working with RESTful Web Services. Students will learn how to consume external APIs, integrate third-party services, and publish their own RESTful endpoints to create more interactive and connected applications.

By completing this course, students will be equipped to build secure, scalable, and highly interactive applications that meet enterprise-grade standards. It enhances their readiness for more advanced development roles and makes them strong candidates for organizations seeking to maximize their investment in Oracle APEX.

Offering this course will expand your advanced training portfolio while giving your students a competitive edge in tackling complex projects and excelling in modern application development environments.

This course provides a comprehensive introduction to Toad, a powerful and versatile tool for database development, optimization, and administration. It is designed to equip students with the practical skills needed to work efficiently across all major areas of database management.
The course begins with an overview of Toad’s interface, key features, and customization options, allowing students to tailor the tool to their workflow. From there, it progresses into SQL development, demonstrating how to use Toad’s advanced editor to write, test, and refine SQL code quickly and accurately.

Students will gain hands-on experience managing schemas and database objects, including creating tables, querying views, and exporting data—establishing a solid foundation in real-world database tasks. The course then explores advanced SQL and PL/SQL techniques, focusing on improving code quality, readability, and execution.

A key component of the course is performance tuning, where learners use Toad’s diagnostic and analysis tools to identify bottlenecks and optimize SQL queries for better database performance. Best practices for data loading and exporting are also covered, emphasizing techniques for maintaining data accuracy and integrity.

Participants will be introduced to Toad’s automation tools, which help streamline repetitive tasks and boost productivity, as well as its documentation and collaboration features, including database comparisons and report generation for team communication.

To complete the learning experience, the course introduces Toad’s visual design tools, teaching students how to create entity relationship diagrams and visually construct complex queries—key skills for effective database design and analysis.

Fundamentals of MySQL is the first step in mastering MySQL, the world's most popular open-source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools. This course is perfect for those interested using MySQL for backend data storage in their applications.
Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in creating a hands-on Windows VM.

MySQL for Developers will be useful for anyone who wants to truly master SQL using MySQL. The course covers relational database design, implementation of a database design, and the skills necessary to use a MySQL database as a backend to an application. Along with SQL query skills, the attendee will also learn about query optimization and importing and exporting data.
Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in the creation of a Windows VM configured to support the hands-on activities.

This course covers the fundamentals of Microsoft's version of the standard SQL language known as Transact-SQL. It encompasses both querying and modifying data in relational databases hosted on Microsoft SQL Server-based database systems, which include Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.
This course is beneficial for individuals requiring the ability to write basic SQL or Transact-SQL queries. This audience may include those working with data in roles such as data analysts, data engineers, data scientists, database administrators, or database developers. It is also relevant for individuals peripherally involved with data or those looking to enhance their understanding of working with data, such as solution architects, students, and technology managers.

The Administering Microsoft Azure SQL Solutions (DP-300) certification course imparts students with the knowledge and skills required to administer a SQL Server database infrastructure across cloud, on-premises, and hybrid relational databases. This course is particularly beneficial for those working with Microsoft PaaS relational database offerings. It is also valuable for individuals involved in developing applications that retrieve content from SQL-based relational databases.