Database Management   

In this course, students build upon their basic PHP skills and knowledge of MySQL to build database-driven websites using PHP and MySQL.

PHP has been a popular server-side web technology for almost two decades—longer than any other commonly used programming language for building database-driven websites. Although PHP can be used with any of the popular databases (e.g., SQL Server, Oracle, PostgreSQL), it is most commonly paired with MySQL. The MySQL training portion of the course covers the MySQL-PHP connection. Learning to use PHP and MySQL together positions you well for jobs maintaining the millions upon millions of websites built on these technologies. You will also be able to build websites from scratch, though you will need to know other technologies, such as HTML and CSS.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. Chromebooks are not compatible.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins. Setup instructions can be found here.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Students taking this PHP course should already have basic PHP and MySQL skills. They will build upon those skills to learn to build database-driven websites from PHP and MySQL.

1. Working with Databases
1. Objects
2. Attributes / Properties
3. Behaviors / Methods
4. Classes vs. Objects
5. Connecting to a Database with PDO
6. Introducing the Poetree Database
7. phpMyAdmin
8. Querying Records with PHP
9. Queries Returning Multiple Rows
10. Adding Pagination
11. Sorting
12. Anticipating Foul Play
13. Filtering
2. Exception Handling
1. Uncaught Exceptions
2. Throwing Your Own Exceptions
3. Catching Exceptions
4. Exceptions
5. Division Form
6. PDOExceptions
7. Logging Errors
8. The dbConnect() Function
9. When Queries Fail to Execute
10. Preparing for the Catching Errors Exercise
11. Catching Errors in the PHP Poetry Website
3. Sending Email with PHP
1. mail()
2. Setting Up PHPMailer
3. Mail Server
4. Including a Mail Configuration File
5. Sending Email with PHPMailer
6. PHPMailer Methods and Properties
7. Creating a Contact Form
4. Authentication with PHP and SQL
1. The Registration Process
2. Passwords and Pass Phrases
3. Registration with Tokens
4. Creating a Registration Form
5. Sessions
6. Cookies
7. Logging In and Out
8. $_REQUEST Variables
9. Resetting the Pass Phrase Introduction
5. LAB: Inserting, Updating, and Deleting Poems
1. Submitting a New Poem
2. Showing All User's Poems in on the Poems Page
3. Editing an Existing Poem
4. Deleting a Poem

What you will learn

• Learn to manipulate and manage database data with PHP
• Learn to authenticate users with PHP
• Learn to manage sessions with PHP
• Learn to send email with PHP
• Understand how MySQL works with PHP

How you will benefit

• With PHP and MySQL skills, you will be able to create everything from intranets for companies needing to manage internal data to large database-driven websites
• PHP has been around longer than any other commonly used server-side programming language, and there are millions of websites that still use it today. Knowing PHP opens up opportunities for you to maintain and build upon those websites
• Organizations store data in databases and MySQL is the most popular open source database Knowing how to query those databases opens up opportunities for you to build reports for such organizations

Advance your knowledge of SQL in this flexible self-paced online course. You will learn how to write, design, and test complex SQL queries.

When it comes to query language for relational database management systems, SQL is the industry benchmark. This flexible, self-paced course will help you advance your knowledge and keep pace with today's SQL standards. You will practice designing, writing, and testing complex SQL queries to execute on a practice database using SQL Server Express.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

• SQL Server Express
• SQL Server Management

Advance your knowledge of SQL in this flexible self-paced online course. You will learn how to write, design, and test complex SQL queries.

SQL Review

In this introductory lesson you will review SQL and database terms and concepts. You will also install SQL Server Express and SQL Server Management Studio (SSMS) to use throughout the course in your learn-by-doing practices. And, you will use SQL code scripts to create a practice database in SQL Server.

Joining Multiple Tables

In this lesson you will learn about join statements and how join queries make it possible to retrieve data from more than one table. You'll also practice how to write well-designed join queries that retrieve result-sets that meet your requirements.

Filtering Rows

Databases can contain massive amounts of data. Learning how to filter the rows that will limit the result-set is extremely important. In this lesson, you will explore various ways to write SQL queries that retrieve a filtered result-set that meets defined criteria.

Grouping and Summarizing Rows

Because of the size of databases, it is important to design SQL queries that retrieve results-sets with data that is organized. In this lesson, you will practice designing queries that group similar data and summarize result-sets. You will explore aggregate functions and how they can be used in producing result-sets that can be used for data analysis.

Subqueries

Subqueries are SQL queries that are written inside another SQL query. Subqueries are used to perform intricate requirements on complex data subsets to retrieve specific data from the database. You will practice writing various subqueries using the practice database.

Tables and Data Maintenance

This lesson is about maintaining the database and data. You will practice using SQL code to modify and add table structures and add new data records. You will also learn about writing SQL queries to modify and delete tables structures and data. Understanding how to write queries to modify, add, and delete is important in order to maintain a database and data that are accurate and up to date.

Unions and Other Joins

Unions are used to retrieve data from more than one table. Instead of returning columns from different tables, a union SQL query combines rows for columns that are the same datatype. In this lesson, you will practice writing SQL queries that retrieve data from multiple tables with specific requirements.

Using String and Date Functions

SQL built-in functions are useful when applied in the right situations. In this lesson, you will work with string and date functions and write SQL queries to retrieve result-sets that manipulate and display data that may be easier to read and understand.

Stored Procedures

User-defined functions are called stored procedures. A stored procedure is a query that is written, saved, and ready to be reused whenever needed. In this lesson, you will practice defining, writing, saving, and executing stored procedures.

Indexes and Views

Indexes are important to database performance. Views are used to simplify access and to secure accessibility to the data. In this lesson, these concepts will be explored and examined as you practice defining and creating SQL queries.

Triggers

A trigger is a user-defined stored procedure that is used for maintaining the database. Once a trigger has been defined and is implemented in the database, it is automatically executed when applicable. In this lesson, you will practice defining, writing, and saving triggers.

SQL Server Management Studio

Understanding the database and its parts is a necessary component of learning SQL. It is difficult to develop and write efficient and well-designed queries without knowing the database and table structures. This last lesson presents SQL queries that retrieve database information. You will also explore the SSMS to make use of its functions as you continue your SQL journey.

This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL.

This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. It does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.

This course starts with the basics of relational databases. You will learn to use simple SELECT queries to pull data, and then move on to more advanced SELECTs and data manipulation. You will shape the results of your queries to create relevant reports. Once you have mastered the basics, you will get hands-on with complex data retrieval methods like subqueries, joins, outer joins, and unions. Finally, you will use INSERT, UPDATE, and DELETE while learning best practices for maintaining your records.

By the end of this MySQL for PHP course, you will know MySQL and SQL well enough to start using it with PHP (and elsewhere).

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. Chromebooks are not compatible.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins. Setup instructions can be found here.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

In this online course you will learn how to connect MySQL to PHP. You will also learn how to create a MySQL database This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. This course does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.

1. Relational Database Basics
   1. Brief History of SQL
   2. Relational Databases
   3. Tables
      1. Rows
      2. Columns
      3. Relationships
      4. Datatypes
      5. Primary Keys
      6. Foreign Keys
      7. Relational Database Management System
   4. Popular Databases
      1. Commercial Databases
      2. Popular Open Source Databases
   5. SQL Statements
      1. Database Manipulation Language (DML)
      2. Database Definition Language (DDL)
      3. Database Control Language (DCL)
2. Simple SELECTs
   1. Introduction to the Northwind Database
   2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
   3. SELECTing All Columns in All Rows
   4. Exercise: Exploring the Tables
   5. SELECTing Specific Columns
   6. Exercise: SELECTing Specific Columns
   7. Sorting Records
      1. Sorting by a Single Column
      2. Sorting By Multiple Columns
   8. Ascending and Descending Sorts
   9. Exercise: Sorting Results
   10. The WHERE Clause and Logical Operator Symbols
       1. Checking for Equality
       2. Checking for Inequality
   11. Exercise: Using the WHERE Clause to Check for Equality or Inequality
   12. Checking for Greater or Less Than
   13. Exercise: Using the WHERE Clause to Check for Greater or Less Than
   14. Checking for NULL
   15. Exercise: Checking for NULL
   16. WHERE and ORDER BY
   17. Exercise: Using WHERE and ORDER BY Together
   18. Checking Multiple Conditions with Boolean Operators
       1. AND
       2. OR
       3. Order of Evaluation
   19. Exercise: Writing SELECTs with Multiple Conditions
   20. The WHERE Clause and Logical Operator Keywords
       1. The BETWEEN Operator
       2. The IN Operator
       3. The LIKE Operator
       4. The NOT Operator
   21. Exercise: More SELECTs with WHERE
3. Advanced SELECTs
   1. Calculated Fields
      1. Concatenation
      2. Mathematical Calculations
      3. Aliases
   2. Exercise: Calculating Fields
   3. Aggregate Functions and Grouping
      1. Aggregate Functions
      2. Grouping Data
   4. Exercise: Working with Aggregate Functions
   5. Selecting Distinct Records
   6. Built-in Data Manipulation Functions
      1. Common Math Functions
      2. Common String Functions
      3. Common Date Functions
   7. Exercise: Data Manipulation Functions
4. Subqueries, Joins and Unions
   1. Subqueries
   2. Exercise: Subqueries
   3. Joins
      1. Table Aliases
      2. Multi-table Joins
   4. Exercise: Using Joins
   5. Outer Joins
   6. Unions
      1. UNION ALL
      2. UNION Rules
   7. Exercise: Working with Unions
5. Inserting, Updating and Deleting Records (if time allows)
1. Inserting Records
2. Updating and Deleting Records

What you will learn

• Understand how MySQL works
• Learn to use SQL to output reports with MySQL
• Learn to modify MySQL data with SQL

How you will benefit

• Organizations store data in databases, and MySQL is the most popular open source database. Knowing how to query those databases opens up opportunities for you to build reports for such organizations
• Database-driven websites require knowledge of SQL, and MySQL is one of the most popular databases used to build these websites, especially those built with PHP. This course gives you the prerequisite knowledge to start learning a server-side language such as PHP to use with MySQL

Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.

SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.
• Dual monitors are helpful but are not required.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.
• Necessary rights (local administrative rights) to install programs on the computer.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

• SQL Server Express
• SQL Server Management Studio

Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.

Introduction to Database Design and SQL

In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database and collecting data is foundational to using SQL to write queries and retrieve data result-sets that are usable.

SQL Server

In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use a SQL code script to create one of the tables for the practice database in SQL Server.

Retrieving Data Result-Sets

SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meets a defined criteria.

Sorting Data

SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will explore and practice defining and writing queries to meet a defined criteria to retrieve the expected result-set.

Designing SQL Data Tables

This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in a RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.

Designing Data Rows

In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table, and you will also practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL code script to populate your tables with enough data rows to use in the learn-by-doing practices in this course.

Getting Data From Two Tables

SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN query statements that are defined to retrieve data result-sets from tables that have a relationship between their PKs and FKs.

Retrieving Data From Multiple Tables

In this lesson, you will continue writing JOIN statement that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.

Keeping the Database Up to Date

The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.

Aggregate Functions

In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.

SQL Views

SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.

Maximize Database Integrity and Performance

Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.

Take your SQL skills to the next level and learn to write queries with PL/SQL in this online SQL training course.

This self-paced SQL training course is perfect for advancing your current SQL skills. While Oracle uses a standard SQL like other major databases, PL/SQL is specific to Oracle. PL/SQL is a procedural language with variables, conditions, loops, subprograms, stored procedures, and functions. By course completion, you will understand and know how to use PL/SQL's main features, including declaring, naming, and assigning variables.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
• Oracle SQL Developer - The client interface for connecting to Oracle (software not included).
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.

Other:

• Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to use PL/SQL to write sophisticated queries against an Oracle database.

1. PL/SQL Basics
1. What is PL/SQL?
2. Blocks
3. Outputting Information
4. Variables and Constants
5. Constants
6. Data Types
7. Naming Variables and Other Elements
8. Embedding SQL in PL/SQL
9. SELECT...INTO and RETURNING...INTO
10. PL/SQL Features
2. Subprograms
1. Introduction to Subprograms
2. Procedures
3. Variable Declarations
4. Dropping a Procedure
5. Parameters
6. Parameters with Default Values
7. Parameter Modes
8. IN Mode
9. OUT Mode
10. IN OUT Mode
11. Named Notation
12. Using SQL in a Subprogram
13. %TYPE
14. Functions
15. Using PL/SQL Functions in SQL Queries
3. Conditional Processing
1. Conditions and Booleans
2. IF-ELSIF-ELSE Conditions
3. ELSIF
4. BOOLEAN Values and Standard SQL
5. The CASE Statement
6. CASE Expressions
4. Exceptions
1. Introduction to Exceptions
2. Predefined Exceptions
3. The EXCEPTION Part of the Block
4. User-defined Exceptions
5. User-defined Exceptions in Subprograms
6. Re-raising Exceptions
7. Naming Unnamed Predefined Exceptions
8. WHILE Loops
9. When to Use Exceptions
5. Cursors
1. Implicit Cursors
2. Explicit Cursors
3. %ROWTYPE
4. Explicit Cursor Use Case
5. Cursor FOR LOOP
6. Cursor Parameters
6. Packages
1. Package Basics
2. The Package Specification
3. The Package Body
4. Building an Employee Package
5. Overloading Subprograms
6. Auditing
7. Validation Procedures
8. Package Cursors
9. Benefits of Packages
7. Triggers
1. What are triggers?
2. Trigger Parts
3. Validation Triggers
4. The WHEN Clause
5. Audit Triggers
6. Statement-level Triggers
7. Compound Triggers
8. Trigger Warning

What you will learn

• How to write a simple block of PL/SQL code and about subprograms in PL/SQL
• To create and call procedures and functions
• To write IF conditions, use the CASE statement, and handle exceptions in PL/SQL
• To use implicit and explicit cursors
• To use triggers for validating data and auditing changes to the database

How you will benefit

• Gain skills that every developer needs
• Bring your advanced SQL/PL skills to any web development job
• Advance your career as an Oracle developer

This online Oracle SQL and PL/SQL Developer course will teach you how to use SQL to build applications, generate business reports, master SQL in Oracle, and learn PL/SQL to work within an Oracle database.

Requirements:

Hardware Requirements:

• This course must be taken on a PC.
• Dual monitors are helpful but are not required.

Software Requirements:

• PC: Windows 10 or later (not the Home Edition).
• Browser: The latest version of Chrome (preferred), Microsoft Edge, or Firefox browsers.
• Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course). Please view the required specs ahead of time to make sure that your system is compatible.
• Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
• Adobe Acrobat Reader.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This online course will teach you how to use SQL to build applications or generate business reports and will help you master SQL using an Oracle database. You will also learn how to use the PL/SQL extension language to write sophisticated queries against an Oracle database.

This course will prepare you to enter the job market as an entry-level Oracle SQL Developer or take on more responsibility within your current career. Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data.

1. Oracle SQL and PL/SQL Developer
   1. Oracle SQL
   2. Relational Database Basics
   3. Creating Tables
   4. Basic Selects
   5. Oracle SQL Functions
   6. Aggregate Functions
   7. Joins
   8. Subqueries
   9. Set Operators
   10. Conditional Processing with CASE
   11. Data Manipulation Language
   12. Creating Views
2. Oracle PL/SQL
   1. PL/SQL Basics
   2. Subprograms
   3. Conditional Processing
   4. Exceptions
   5. Cursors
   6. Packages
   7. Triggers
3. Oracle SQL Developer Final Project

What you will learn

• Build applications or generate business reports using Structured Query Language (SQL)
• Master SQL using an Oracle database
• Use PL/SQL extension language to write sophisticated queries against an Oracle database

How you will benefit

• Turn your passion for working with data into a profession by learning to write SQL queries
• Prepare to enter the job market as an entry-level Oracle SQL Developer or to take on more responsibility in your current role
• Set yourself apart from competitors by taking a challenging course in PL/SQL development

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students' needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

This course will teach you how to write SQL queries with Oracle.

Mastering Oracle SQL is one today's most marketable programming skills for end-to-end developers. This online, self-paced course covers the basics of Oracle SQL. You will learn the fundamentals, including queries, procedures, and functions through hands-on assignments. By course completion, your SQL skills will be on par with industry standards.

What you will learn

• How tables are structured and how data is stored
• To use Oracle to output reports and to use SQL functions
• To group data to get aggregate values
• To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
• To use SET operators and to do conditional processing with CASE

How you will benefit

• Gain skills that every developers needs
• Bring your SQL skills to any web development job

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
• Oracle SQL Developer - The client interface for connecting to Oracle (software not included).
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.

Other:

• Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This self-paced training course will teach you the basics of writing SQL queries with Oracle.

1. Relational Database Basics
2. Creating Tables
3. Basic Selects
4. Oracle SQL Functions
5. Aggregate Functions
6. Subqueries
7. Set Operators
8. Conditional Processing with CASE
9. Data Manipulation Language
10. Creating Views

What you will learn

• How tables are structured and how data is stored
• To use Oracle to output reports and to use SQL functions
• To group data to get aggregate values
• To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
• To use SET operators and to do conditional processing with CASE

How you will benefit

• Gain the SQL skills that every developer needs
• Bring your SQL knowledge to any web development job