Professor Mark Grimes

13.1 - String manipulation SQL functions

13.3 - Hierarchical Queries

Modules 13.1-13.3 Part 1: DECODE and Case

1.6 - Data Models

2.2 - ER Grammar

1.3 - Limitations of File Systems

DB 1 Assignment 4 Walkthrough

DB1 Assignment 2 Walkththrough

Learn SQL - Stored Procedures and Triggers (Part 4)

10.2 - Multiple Table DDL

1.1 - Data, Information, and Metadata

2.3 - Entities and Attributes

3.3 - Modeling Errors

BZAN 6356 Lecture 6.2: Create, Read, Update, and Delete in MongoDB

10.1 - Single Table DDL

2.4 – Relationships

SQL Project DDL Instructions

DB1 Assignment 1 Walkthrough

3.1 - Bearcat Incorporated Part 1

Tutorial - Configuring PostgreSQL in Amazon RDS

BZAN 6356 Lecture 12.2: Create, Read, Update, and Delete in Redis

Tutorial - Importing data into PostgreSQL

BZAN 6356 Lecture 12.3: Data Structures in Redis

Module 12.1 Part 2: GROUP BY and aggregate functions

Course Wrap up

3.2.4 - Decomposed Design-Specific ERD

BZAN 6356 Lecture 1.0: Introduction to Non-Relational Databases

BZAN 6356 Lecture 13.0: Key-Value Databases Part 2: DynamoDB

Learn SQL - CRUD in SQL (Part 2)

6.7 - Mapping an ER Model to a Logical Schema

BZAN 6356 Lecture 5.0: Column Family Databases - HBase Part 2

13.5 - 13.6 - Analytical Functions

BZAN 6356 Lecture 10.3: Cypher, Indexing, and Constraints in Neo4j

BZAN 6356 Lecture 5.3: Querying HBase using Hive and HQL

Learn SQL - Creating and ERD and DDL (Part 1)

BZAN 6356 Lecture 7.2: Advanced MongoDB Queries

2.6 - Deletion Constraints

Learn SQL - Creating SQL Views (Part 5)

6.4 - Relational Algebra

1.4 - Three Schema Architecture

BZAN 6356 Lecture 7.1: Importing data into MongoDB

Modules 8.4 - 13.1 Part 2: String Concatenation and SubStr

3.2 - Bearcat Incorporated Part 2

6.3 - Data Integrity Constraints

1.5 - Characteristics of Database Systems

Learn SQL - ACID and Transactions (Part 3)

13.1 - String manipulation SQL functions