James Marks

SQL Aggregates: What are aggregate functions?

PHP Fundamentals Review (Part 5)

(F2017) Database Fundamentals - Installing SSE and SSMS

Deciding Parent and Child tables

MongoDB - Windows Installation and Absolute Basics

PHP Fundamentals Review (Part 3)

SQL Aggregates: COUNT(*) aggregate function

SQL Aggregates: Multiple Aggregates in one query

SQL Aggregates: Combining Multiple aggregate functions

Javascript Basics Tutorial #3 - Simple user input and output.

PROG1735 [Rehash Sessions] NOT NULL Constraints

PHP Fundamentals Review (Part 1)

F2017 Database Essentials - Week 3 - Action Queries: Mistakes to Avoid

(F2017) Database Essentials - Week 2 Review 1 - CREATE TABLE Statement

MMO Case (Part 4) - Important: Don't use "Magic Numbers" in your INSERTs

Writing the foreign key rule and entering valid data

F2017 Database Essentials - Week 3 Review - Logging in and Data Types

Understanding and Diagramming One to many Relationships for SQL

F2017 Database Essentials (Week 5) - Part 4 - Order of Parent Child Queries for DML and DDL

(F2017) Database Essentials - Week 2 Review 2 - Populating Our GAME Table

SQL Aggregates: AVG (Average) function

F2017 Database Essentials (Week 5) - Part 3 - CREATE TABLE Statements with Foreign Keys

F2017 Database Essentials - Week 3 - Action Queries: INSERT

[PROG1735] Working with the One-to-many relationships (GROUP BY, HAVING, etc.)

Reviewing the Account table

F2017 Database Essentials - DML Review

W2019 DML Review and Exercises #1

PROG1735 [Rehash Sessions] SQL Identity Specification

Writing INSERTs with foreign key columns

MMO Case (Part 2) - One-to-Many CREATE TABLE Statements

F2017 Database Essentials (Week 6) - Part 2 - More about Subqueries

MMO Case (Part 5) - How to SELECT data from multiple related tables using JOIN

F2017 Database Essentials - Week 3 - Action Queries: DELETE

SQL DML Series - Multiple Filtering Criteria

[PROG1735] SQL Many to Many Relationships

F2017 Database Essentials (Week 6) - Part 3 - Review: INSERT, UPDATE, DELETE (but with subqueries)

PHP Fundamentals Review (Part 2)

F2017 Database Essentials (Week 6) - Part 4 - Preview: LEFT and RIGHT JOINs

W2019 PROG1195 Lab 2 Review

MMO Case (Part 3) - INSERTing data for One-to-Many Relationships

F2017 Database Essentials (Week 5) - Part 2 - Design Diagrams

F2017 Database Essentials - Intro to Aggregate Functions

MMO Case (Part 1) - One-to-Many Diagrams

F2017 Database Essentials (Week 5) - Part 1 - One-to-Many Intro Lecture

F2017 Database Essentials - Week 3 - Action Queries: UPDATE

SQL Subqueries: MIN() and MAX() in subqueries. "Who's on first?"

Adding some POST data

SQL Aggregates: What are aggregate functions?

PHP Fundamentals Review (Part 4)

F2017 Database Essentials (Week 6) - Part 1 - SELECT using JOIN