Recorded Lectures

Attend a WebEx live session:
WebEx meeting room https://mnscu.webex.com/meet/allen.benusa
Password:  cst

WebEx recordings:

Topic:
CST1600-20150825 1541-1
Create time:
8/25/15 10:41 am
File size:
76.66MB
Duration:
1 hour 4 minutes
Description:
Introduction. Chapter 1 slides. Students: read chapter 1 and start reading chapter 2.
Streaming recording link:
Download recording link:

Topic:
CST1600-20150827 1534-1
Create time:
8/27/15 10:34 am
File size:
294.34MB
Duration:
57 minutes
Description:
Attempted to demonstrate phpMyAdmin, but technical issues. Used Oracle MySQL Workbench.

Topic:
CST1600-20150901 1535-1
Create time:
9/1/15 10:35 am
File size:
48.15MB
Duration:
43 minutes
Description:
Quick login into phpMyAdmin for demo. Slides for Chapter 2.
Play

Topic:
CST1600-20150903 1533-1
Create time:
9/3/15 10:33 am
File size:
144.34MB
Duration:
1 hour 16 minutes
Description:
Lab01 - Screenshot of myPhpAdmin showing that you are in your database and created a Student table.

Topic:
CST1600-20150908 1533-1
Create time:
9/8/15 10:33 am
File size:
176.03MB
Duration:
1 hour 8 minutes
Description:
Lab02 - Screenshot showing query of last name and first name fields where last name is Doe. Show query and result.

Topic:
CST1600-20150910 1534-1
Create time:
9/10/15 10:34 am
File size:
162.15MB
Duration:
46 minutes
Description:
Chap3 Constraints. "Attempted" to import database into MySQL. Server crashed.

Topic:
CST1600-20150915 1536-1
Create time:
9/15/15 10:36 am
File size:
211.65MB
Duration:
1 hour 14 minutes
Description:
Lab03 Screenshot showing that you have imported CH03_StoreCo_MySQL.txt into your database. Show the contents of a table as proof.

Topic:
CST1600-20150917 1533-1
Create time:
9/17/15 10:33 am
File size:
297.3MB
Duration:
1 hour 9 minutes
Description:
Lab04 Constraints made - region, store, and employee made.

Topic:
CST1600-20150922 1535-1
Create time:
9/22/15 10:35 am
File size:
271.2MB
Duration:
1 hour 8 minutes
Security:
   
Description:
Lab05 - Query selection filter using LIKE and REGEX

Topic:
CST1600-20150924 1550-1
Create time:
9/24/15 10:50 am
File size:
69.21MB
Duration:
30 minutes
Security:
   
Description:
Lab06 Sort lastname firstname

Topic:
CST1600-20151001 1537-1
Create time:
10/1/15 10:37 am
File size:
218.04MB
Duration:
53 minutes
Security:
   
Description:
How databases are used in day-to-day life. How programming languages connect to databases.

Topic:
CST1600-20151006 1532-1
Create time:
10/6/15 10:32 am
File size:
537.34MB
Duration:
1 hour 8 minutes
Security:
   
Description:
YouTube MySQL Database Tutorial https://www.thenewboston.com/ Tutorials 1-10.

Topic:
CST1600-20151008 1532-1
Create time:
10/8/15 10:32 am
File size:
404.92MB
Duration:
1 hour 2 minutes
Security:
   
Description:
YouTube MySQL Database Tutorial https://www.thenewboston.com/ Tutorials 10-18.

Topic:
CST1600-20151013 1537-1
Create time:
10/13/15 10:37 am
File size:
412.31MB
Duration:
1 hour 10 minutes
Security:
   
Description:
YouTube MySQL Database Tutorial https://www.thenewboston.com/ Tutorials 19-27.

Topic:
CST1600-20151020 1537-1
Create time:
10/20/15 10:37 am
File size:
313.75MB
Duration:
56 minutes
Security:
   
Description:
YouTube MySQL Database Tutorial https://www.thenewboston.com/ Tutorials 27-33.

Topic:
CST1600-20151022 1537-1
Create time:
10/22/15 10:37 am
File size:
290.6MB
Duration:
1 hour 15 minutes
Security:
   
Description:
Lab07 myContacts table query

Topic:
CST1600-20151027 1540-1
Create time:
10/27/15 10:40 am
File size:
196.28MB
Duration:
1 hour
Security:
   
Description:
Lab08 CST1600DB1 count of unique states

Topic:
CST1600-20151029 1536-1
Create time:
10/29/15 10:36 am
File size:
194.77MB
Duration:
1 hour 12 minutes
Security:
   
Description:
JOIN and UNION. Lab09 Show who was responsible for every item sold

Topic:
CST1600-20151103 1647-1
Create time:
11/3/15 10:47 am
File size:
167.51MB
Duration:
52 minutes
Security:
   
Description:
Aggregate functions, join. Lab10 More than average payments

Topic:
CST1600-20151105 1645-1
Create time:
11/5/15 10:45 am
File size:
198.35MB
Duration:
44 minutes
Security:
   
Description:
Lab11 Email creation

Topic:
CST1600-20151110 1637-1
Create time:
11/10/15 10:37 am
File size:
647.66MB
Duration:
1 hour 6 minutes
Security:
   
Description:
Video on Stored Procedures. Lab12 simple email stored procedure.

Topic:
CST1600-20151112 1635-1
Create time:
11/12/15 10:35 am
File size:
169.03MB
Duration:
1 hour 4 minutes
Security:
   
Description:
IF THEN ELSE used in stored procedures. Lab13 credit level.

Topic:
CST1600-20151117 1632-1
Create time:
11/17/15 10:32 am
File size:
151.36MB
Duration:
1 hour 10 minutes
Security:
   
Description:
WHILE DO loop used in stored procedures. Assigned homework set 1. Lab14 While Do loop

Topic:
CST1600-20151119 1635-1
Create time:
11/19/15 10:35 am
File size:
165.78MB
Duration:
1 hour 11 minutes
Security:
   
Description:
Difference in loop types. Lab15 Loop leave iterate

Topic:
CST1600-20151124 1634-1
Create time:
11/24/15 10:34 am
File size:
186.61MB
Duration:
55 minutes
Security:
   
Description:
Lab16 Review query traditional join

Topic:
CST1600-20151201 1637-1
Create time:
12/1/15 10:37 am
File size:
181.98MB
Duration:
1 hour 9 minutes
Security:
   
Description:
Begin forming our procedure to generate employee email addresses with no duplicates.

Topic:
CST1600-20151203 1646-1
Create time:
12/3/15 10:46 am
File size:
195.56MB
Duration:
59 minutes
Security:
   
Description:
Generate unique email address and insert record into table.

Topic:
CST1600-20151208 1636-1
Create time:
12/8/15 10:36 am
File size:
265.29MB
Duration:
1 hour 14 minutes
Security:
Description:
Triggers. Lab17 trigEmailCreate

Topic:
CST1600-20151210 1645-1
Create time:
12/10/15 10:45 am
File size:
202.39MB
Duration:
1 hour 8 minutes
Security:
Description:
Go through solutions to Homework Set #1.