Dustin Ormond

Data Protection: Database Security and SQL Injections

Relational Database Modeling: Integrity Constraints

Firewalls: Application Proxy Firewall

Advanced SQL: Multiple Joins

Firewalls: Interesting but Scary Statistics

NoSQL: Creating Databases in MongoDB

Advanced SQL: Joins (NATURAL JOIN)

SQL DDL: Creating Tables (Foreign Keys and Default Values)

Database Application Development: Inserting Into a MySQL Database Using PHP

Database Application Development: Universal Code for Generating HTML Tables with PHP and MySQL

NoSQL: Counting, Sorting, and Limiting Documents in MongoDB

ERD: Associative Entities

SQL DCL: Granting and Revoking Privileges

Host Hardening: Group Policy Objects

ERD: Associative Entities

ERD: Relationship Cardinalities

ERD: Attributes

NoSQL: Deleting Documents, Collections, and Databases in MongoDB

SQL DDL: Removing Objects

Database Application Development: Creating and Using Forms with PHP and MySQL (Learning Activity)

Database Application Development: Creating and Using Forms with PHP and MySQL

ERD Summary

Advanced SQL: Self Joins

Normalization: Transitive Functional Dependencies

Relational Database Modeling: Summary Example

NoSQL: Creating Collections in MongoDB

Advanced SQL: Views

Normalization: Functional Dependency Summary Steps

NoSQL: Updating Documents and Altering Fields in MongoDB

SQL TCL: Database Changes (COMMIT & ROLLBACK)

Database Application Development: Populating Drop-down Menus with PHP and MySQL

Database Security: Encryption

Database Application Development: Inserting Into a MySQL Database Using PHP (Learning Activity)

Database Application Development: Other Commands Using Last Insert ID with PHP and MySQL

Database Application Development: Populating Drop-down Menus with PHP and MySQL (Learning Activity)

Database Application Development: Generating HTML Tables with PHP and MySQL (Learning Activity)

Advanced SQL: SQL/PSM Routines (Triggers)

Database Development Summary

Normalization: Full and Partial Functional Dependencies

Database Application Development: Generating HTML Tables with PHP and MySQL

Relational Database Modeling: Mapping Entities to Relations

Forensics: Analysis and Interpretation

Advanced SQL: Joins (OUTER JOIN)

Normalization: Operations and Anomalies

Data Protection: Auditing

SQL DDL: Creating Tables (Unique and Auto-increment)

Advanced SQL: Joins (INNER JOIN)

ERD: Entities

SQL DQL: Querying Records (Boolean Operators & NULL Values)