Recorded Lectures


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

WebEx recordings:

Topic:
CST1602-20150825 1843-1
Create time:
8/25/15 1:43 pm
File size:
83.91MB
Duration:
1 hour 9 minutes
Description:
Introduction. Chapter 1 slides. Students: read chapter 1 and start reading chapter 2. Install Oracle. Students: Have Oracle installed for next class meeting.
Streaming recording link:
Download recording link:

Topic:
CST1602-20150827 1841-1
Create time:
8/27/15 1:41 pm
File size:
188.15MB
Duration:
1 hour 9 minutes
Description:
Lab01 - Installed Oracle. Screenshot showing that you have Oracle running. Representative screenshot attached.

Topic:
CST1602-20150901 1834-1
Create time:
9/1/15 1:34 pm
File size:
227.93MB
Duration:
1 hour 17 minutes
Description:
Lab02 Screenshot with Oracle SQL Developer open. Show your tables (under LocalHost) are created.

Topic:
CST1602-20150903 1840-1
Create time:
9/3/15 1:40 pm
File size:
176.25MB
Duration:
1 hour 16 minutes
Description:
Lab03 - Two screenshots. One screenshot for Chap 2 Hands on Assignment #10. Another screenshot for Chap 2 Advanced Challenge #2.

Topic:
CST1602-20150908 1833-1
Create time:
9/8/15 1:33 pm
File size:
190.1MB
Duration:
1 hour 13 minutes
Description:
Lab04 - Do Advanced Challenge at the end of Chapter 3. There are 3 parts. Do all 3 parts. Screenshot of new tables on connections of left side and all the SQL commands as well.

Topic:
CST1602-20150910 1839-1
Create time:
9/10/15 1:39 pm
File size:
100.63MB
Duration:
1 hour 8 minutes
Description:
Chap4 slides. Insert record to verify constraint.

Topic:
CST1602-20150915 1836-1
Create time:
9/15/15 1:36 pm
File size:
180.55MB
Duration:
1 hour 21 minutes
Description:
Lab05 - Screenshot of Chap4 Hands-On Assignment #1 & #2.

Topic:
CST1602-20150917 1837-1
Create time:
9/17/15 1:37 pm
File size:
153.59MB
Duration:
1 hour 7 minutes
Description:
Lab06 - Chapter 4 Hands-On Assignment 4-6.

Topic:
CST1602-20150922 1842-1
Create time:
9/22/15 1:42 pm
File size:
203.01MB
Duration:
1 hour 15 minutes
Security:
   
Description:
Lab07 Ch4 Advanced Challenge

Topic:
CST1602-20150924 1839-1
Create time:
9/24/15 1:39 pm
File size:
120.54MB
Duration:
1 hour 4 minutes
Security:
   
Description:
Lab08 Insertion of account mangers

Topic:
CST1602-20150929 1834-1
Create time:
9/29/15 1:34 pm
File size:
101.14MB
Duration:
1 hour 9 minutes
Security:
   
Description:
Ch5 UPDATE and DELETE and COMMIT and ROLLBACK

Topic:
CST1602-20151001 1840-1
Create time:
10/1/15 1:40 pm
File size:
228.39MB
Duration:
1 hour 2 minutes
Security:
   
Description:
Lab09 Table locks.

Topic:
CST1602-20151006 1838-1
Create time:
10/6/15 1:38 pm
File size:
246.38MB
Duration:
1 hour 18 minutes
Security:
   
Description:
Lab10 Ch5 Case Study City Jail

Topic:
CST1602-20151008 1856-1
Create time:
10/8/15 1:56 pm
File size:
121.09MB
Duration:
48 minutes
Security:
   
Description:
Lab11 Sequence Examples

Topic:
CST1602-20151013 1835-1
Create time:
10/13/15 1:35 pm
File size:
61.15MB
Duration:
35 minutes
Security:
   
Description:
B-tree index

Topic:
CST1602-20151020 1839-1
Create time:
10/20/15 1:39 pm
File size:
188.32MB
Duration:
1 hour 1 minute
Security:
   
Description:
Chapter 7 account creation and privileges.

Topic:
CST1602-20151022 1835-1
Create time:
10/22/15 1:35 pm
File size:
75.83MB
Duration:
50 minutes
Security:
   
Description:
Lab12 Chapter 7 Hands-On Assignment

Topic:
CST1602-20151027 1840-1
Create time:
10/27/15 1:40 pm
File size:
112.39MB
Duration:
1 hour 7 minutes
Security:
   
Description:
Lab13 Chapter 8 book examples

Topic:
CST1602-20151029 1855-2
Create time:
10/29/15 1:55 pm
File size:
71.72MB
Duration:
46 minutes
Security:
   
Description:
Lab 14 Chapter 8 Hands-On Assignments

Topic:
CST1602-20151103 1938-1
Create time:
11/3/15 1:38 pm
File size:
133.92MB
Duration:
1 hour 13 minutes
Security:
   
Description:
Lab15 Ch9 join customers that bought a book title

Topic:
CST1602-20151105 1959-1
Create time:
11/5/15 1:59 pm
File size:
105.63MB
Duration:
49 minutes
Security:
   
Description:
Lab16 Ch9 outer left join

Topic:
CST1602-20151110 1942-1
Create time:
11/10/15 1:42 pm
File size:
109.07MB
Duration:
1 hour 4 minutes
Security:
   
Description:
Ch9 sets. Ch9 Hands-On Assignments.

Topic:
CST1602-20151112 1937-1
Create time:
11/12/15 1:37 pm
File size:
119.44MB
Duration:
1 hour 10 minutes
Security:
   
Description:
Ch9 Hands-On Assignments.

Topic:
CST1602-20151117 1947-1
Create time:
11/17/15 1:47 pm
File size:
181.17MB
Duration:
1 hour 19 minutes
Security:
   
Description:
Lab17 Ch9 Hands-On Assignments

Topic:
CST1602-20151119 1935-1
Create time:
11/19/15 1:35 pm
File size:
156.93MB
Duration:
1 hour 9 minutes
Security:
   
Description:
Ch10 Examples.

Topic:
CST1602-20151124 1947-1
Create time:
11/24/15 1:47 pm
File size:
85.06MB
Duration:
1 hour 3 minutes
Security:
   
Description:
Ch10 Hands-On Assignments.

Topic:
CST1602-20151201 1940-1
Create time:
12/1/15 1:40 pm
File size:
195.4MB
Duration:
1 hour 12 minutes
Security:
   
Description:
Lab18 Ch10 Hands-On Assignments

Topic:
CST1602-20151203 1936-1
Create time:
12/3/15 1:36 pm
File size:
135.32MB
Duration:
1 hour 21 minutes
Security:
   
Description:
Ch11 Hands-On Assignment

Topic:
CST1602-20151208 1951-1
Create time:
12/8/15 1:51 pm
File size:
108.49MB
Duration:
48 minutes
Security:
Description:
Lab19 Ch11 Hands-On Assignment

Topic:
CST1602-20151210 1933-1
Create time:
12/10/15 1:33 pm
File size:
153.93MB
Duration:
1 hour 8 minutes
Security:
Description:
Lab20 Ch12 Hands-On Assignment. How PHP interfaces to SQL.