| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1602/Schedule/ |
Upload File : |
<?
// JimMartinson/CST1602/CST1602_Schedule.phpinc
#if ( $_SESSION['userId'] == 1 ) require('JimMartinson/ScheduleCode.phpinc');
$week = 0; if ( !isset($class['meetingTime'][1]) ) $class['meetingTime'][1] = $class['meetingTime'][0];
#d_Var("\$_SERVER['HTTP_HOST']",$_SERVER['HTTP_HOST'],'d');
?>
<fieldset><legend><?=$title?></legend>
<? require('JimMartinson/WebMeetingLink.phpinc'); ?>
<ol start="1">
<!-- Week 1: Tuesday 8/23 (Willmar) -->
<!-- Lecture took 1 hr -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/VtRDNqquDVmfUmNPw2MGMoZjSOMIHQamTqk742bCMbwQpuEBisXDvG_oyQjGxIwZ.Y-9p6p0iSvxpBrg3?startTime=1692727335000','text'),array('URL','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<? require('JimMartinson/Schedule_week1.phpinc'); ?>
</li>
<li>
<? require('JimMartinson/Schedule_week1_Assignments_Begin.phpinc'); ?>
<? /** / Insert other week 1 assignments in <li></li> tags below. /**/ ?>
<li>Read <a href="https://en.wikipedia.org/wiki/MySQL">MySQL</a>.</li>
<li>Read <a href="https://en.wikipedia.org/wiki/MySQL_Workbench">MySQL Workbench</a>.</li>
<li>Browse <a href="https://www.khanacademy.org/computing/computer-programming/sql">Intro to SQL: Querying and managing data</a>.</li>
<? require('JimMartinson/Schedule_week1_Assignments_End.phpinc'); ?>
</li>
</ul>
</li><!-- END Week 1 -->
<!-- Week 2: Tuesday 8/30 (Hutchinson) -->
<!-- Lecture took 1 hr -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/pr7XXjDiCx1lgcO_gvft86yoQx6ldd_0KqLExGpBkuB4ep7wLhDqFQ75NfhDnGVZ.weonA08Nld9hzq0z?startTime=1693332077000','text'),array('https://minnstate.zoom.us/rec/share/pr7XXjDiCx1lgcO_gvft86yoQx6ldd_0KqLExGpBkuB4ep7wLhDqFQ75NfhDnGVZ.weonA08Nld9hzq0z?startTime=1693336600000','Lab 1 demo'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="https://en.wikipedia.org/wiki/MySQL">MySQL</a>.</li>
<li>Discuss <a href="https://en.wikipedia.org/wiki/MySQL_Workbench">MySQL Workbench</a>.</li>
<li>Discuss <a href="https://www.khanacademy.org/computing/computer-programming/sql">Intro to SQL: Querying and managing data</a>.</li>
<li>Demonstrate installing MySQL Server, MySQL Workbench, and <a href="../../Setup/WebServices/WebServices.cmd">WebServices.cmd</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li><?=labLink(1)?></li>
<li>Read <a href="https://en.wikipedia.org/wiki/Database_engine">Database engine</a>.</li>
<li>Browse <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html">The InnoDB Storage Engine</a>.</li>
<li>Browse <a href="http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html">Alternative Storage Engines</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 2 -->
<!-- Week 3: Tuesday 9/06 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week,0,'<span class="attention">Class canceled for today.</span> I am home sick.')?>
</li><!-- END Week 3 -->
<!-- Week 4: Tuesday 9/13 (Hutchinson) -->
<!-- Lecture took 2.5 hr / 2.5 hr -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/pb98F7LbfhjQQDqqutCYnWGJLslGIWuSI4-xyFYMM9ZBduyTJYjOmRR7M-Z1-q5i.4TnFJJRG77y6d10P?startTime=1694541797000','text'),array('https://minnstate.zoom.us/rec/share/pb98F7LbfhjQQDqqutCYnWGJLslGIWuSI4-xyFYMM9ZBduyTJYjOmRR7M-Z1-q5i.4TnFJJRG77y6d10P?startTime=1694547089000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="https://en.wikipedia.org/wiki/Database_engine">Database engine</a>.</li>
<li>Discuss <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html">The InnoDB Storage Engine</a>.</li>
<li>Discuss <a href="http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html">Alternative Storage Engines</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li>Browse <a href="http://dev.mysql.com/doc/refman/5.5/en/programs.html">Chapter 4 MySQL Programs</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 4 -->
<!-- Week 5: Tuesday 9/20 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/CmB8OYK5nsEyfnP5tRIL445ML2mERE5PJfcmygjPkK4iUZS1pDinYnWByCh_gNmo.6XKmvRR-NDzxTNMb?startTime=1695146468000','text'),array('https://minnstate.zoom.us/rec/share/CmB8OYK5nsEyfnP5tRIL445ML2mERE5PJfcmygjPkK4iUZS1pDinYnWByCh_gNmo.6XKmvRR-NDzxTNMb?startTime=1695147881000','text'),array('https://minnstate.zoom.us/rec/share/CmB8OYK5nsEyfnP5tRIL445ML2mERE5PJfcmygjPkK4iUZS1pDinYnWByCh_gNmo.6XKmvRR-NDzxTNMb?startTime=1695152116000','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://dev.mysql.com/doc/refman/5.5/en/programs.html">Chapter 4 MySQL Programs</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li><?=labLink(2)?></li>
<li>Browse <a href="http://dev.mysql.com/doc/refman/5.5/en/server-administration.html">MySQL Server Administration</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 5 -->
<!-- Week 6: Tuesday 9/27 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/6DGEYwUBID3Ffw8_AR4WzaF8Zj1Cx9W7CG2_JiaJz3xT1xt4DBg_KMLz-KjxGVXJ.STtfjDqYtnVUztiO?startTime=1695751254000','text'),array('https://minnstate.zoom.us/rec/share/6DGEYwUBID3Ffw8_AR4WzaF8Zj1Cx9W7CG2_JiaJz3xT1xt4DBg_KMLz-KjxGVXJ.STtfjDqYtnVUztiO?startTime=1695755433000','Lab 3 and 3.5 demo'),array('https://minnstate.zoom.us/rec/share/6DGEYwUBID3Ffw8_AR4WzaF8Zj1Cx9W7CG2_JiaJz3xT1xt4DBg_KMLz-KjxGVXJ.STtfjDqYtnVUztiO?startTime=1695757904000','MAC command file'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://dev.mysql.com/doc/refman/5.5/en/server-administration.html">MySQL Server Administration</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li><?=labLink(3)?></li>
<li><?=labLink(3.5)?></li>
<li>Read <a href="http://dev.mysql.com/doc/refman/5.5/en/security.html">Chapter 6 Security</a>.</li>
<li>Read <a href="http://dev.mysql.com/doc/refman/5.5/en/language-structure.html">Chapter 9 Language Structure</a>.</li>
<li>Browse <a href="https://dev.mysql.com/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 6 -->
<!-- Week 7: Tuesday 10/04 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/NPCebFTC03bmdeu5Pay6aKejnMfZN0B-aQaOeoPs1zu_zsxmxwofAczZxEERaFW_.TfmLNsNeiESACRec?startTime=1696356099000','text'),array('https://minnstate.zoom.us/rec/share/NPCebFTC03bmdeu5Pay6aKejnMfZN0B-aQaOeoPs1zu_zsxmxwofAczZxEERaFW_.TfmLNsNeiESACRec?startTime=1696362321000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://dev.mysql.com/doc/refman/5.5/en/security.html">Chapter 6 Security</a>.</li>
<li>Discuss <a href="http://dev.mysql.com/doc/refman/5.5/en/language-structure.html">Chapter 9 Language Structure</a>.</li>
<li>Discuss <a href="https://dev.mysql.com/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li>Read <a href="http://dev.mysql.com/doc/refman/8.0/en/data-types.html">Chapter 11 Data Types</a>.</li>
<li>Read <a href="http://dev.mysql.com/doc/refman/8.0/en/functions.html">Chapter 12 Functions and Operators</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 7 -->
<!-- Week 8: Tuesday 10/11 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/7z8lxoSzqT20OCPj9jD_WkkUoKv7ioMhoV2WNT1NCY0Hn97lB45KOLa8tAiYXxB6.Bw-W584Hd4TCdZxV?startTime=1696960913000','text'),array('https://minnstate.zoom.us/rec/share/7z8lxoSzqT20OCPj9jD_WkkUoKv7ioMhoV2WNT1NCY0Hn97lB45KOLa8tAiYXxB6.Bw-W584Hd4TCdZxV?startTime=1696966819000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/data-types.html">Chapter 11 Data Types</a>.</li>
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/functions.html">Chapter 12 Functions and Operators</a>.</li>
<li>Discuss <a href="../Resources/BackupPriveleges.txt">Backup Priveleges</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+2)?>:
<ol type="i">
<li>Browse <a href="https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html">Chapter 25 Stored Objects</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx">MySQL Stored Procedure</a>.</li>
<li>Browse <a href="https://dev.mysql.com/doc/refman/8.0/en/dynindex-statement.html">Statement/Syntax Index</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 8 -->
<!-- Week 9: Tuesday 10/18 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/dd4i49ycXfPr4gfsolppdJQ6coXZhBmkcUa8hQR96aIwJOE3SY4u01CQFVfNOk82.1RjXzf0A3VvWyjw1?startTime=1697565692000','text'),array('https://minnstate.zoom.us/rec/share/dd4i49ycXfPr4gfsolppdJQ6coXZhBmkcUa8hQR96aIwJOE3SY4u01CQFVfNOk82.1RjXzf0A3VvWyjw1?startTime=1697571611000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html">Chapter 25 Stored Objects</a>.</li>
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/dynindex-statement.html">Statement/Syntax Index</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li>Browse the <a href="http://www.mysqltutorial.org/mysql-if-statement/">MySQL IF Statement</a>.</li>
<li>Browse the <a href="http://www.mysqltutorial.org/mysql-case-statement/">MySQL CASE Statement</a>.</li>
<li>Browse the <a href="http://www.mysqltutorial.org/stored-procedures-loop.aspx">MySQL Loop in Stored Procedures</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 9 -->
<!-- Week 10: Tuesday 10/25 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/wBRifE2rnpHIxEQeFLf-b-WvzdfHH3Kfw67Qu2TZngC_eBBB9PGOdTSC1nExioHX.IcKCvdUNkbl4ZMdP?startTime=1698170576000','text'),array('https://minnstate.zoom.us/rec/share/wBRifE2rnpHIxEQeFLf-b-WvzdfHH3Kfw67Qu2TZngC_eBBB9PGOdTSC1nExioHX.IcKCvdUNkbl4ZMdP?startTime=1698175849000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/views.html">25.5 Using Views</a></li>
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html">25.9 Restrictions on Views</a></li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx">MySQL Stored Procedure</a>.</li>
<li>Discuss the <a href="http://www.mysqltutorial.org/mysql-if-statement/">MySQL IF Statement</a>.</li>
<li>Discuss the <a href="http://www.mysqltutorial.org/mysql-case-statement/">MySQL CASE Statement</a>.</li>
<li>Discuss the <a href="http://www.mysqltutorial.org/stored-procedures-loop.aspx">MySQL Loop in Stored Procedures</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx">MySQL Stored Procedure</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li><?=labLink(4)?></li>
<li><?=labLink(5)?></li>
<li>Browse <a href="http://www.mysqltutorial.org/listing-stored-procedures-in-mysql-database.aspx">Listing Stored Procedures in a MySQL Database</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-error-handling-in-stored-procedures/">MySQL Error Handling in Stored Procedures</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-signal-resignal/">Raising Error Conditions with MySQL SIGNAL / RESIGNAL Statements</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-stored-function/">MySQL Stored Function</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 10 -->
<!-- Week 11: Tuesday 11/01 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/rymvVpr7iyZxwmzSreJ3hHsF-Gk04oOnX4KXLXVxb0jwDMMkGmqQZYMXI83xc6Uq.Q0wGNVYuNRNJDUKW?startTime=1698775367000','text'),array('https://minnstate.zoom.us/rec/share/rymvVpr7iyZxwmzSreJ3hHsF-Gk04oOnX4KXLXVxb0jwDMMkGmqQZYMXI83xc6Uq.Q0wGNVYuNRNJDUKW?startTime=1698780513000','text'),array('https://minnstate.zoom.us/rec/share/rymvVpr7iyZxwmzSreJ3hHsF-Gk04oOnX4KXLXVxb0jwDMMkGmqQZYMXI83xc6Uq.Q0wGNVYuNRNJDUKW?startTime=1698780285000','Lab 6 discussion'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://www.mysqltutorial.org/listing-stored-procedures-in-mysql-database.aspx">Listing Stored Procedures in a MySQL Database</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-error-handling-in-stored-procedures/">MySQL Error Handling in Stored Procedures</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-signal-resignal/">Raising Error Conditions with MySQL SIGNAL / RESIGNAL Statements</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-stored-function/">MySQL Stored Function</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li><?=labLink(6)?></li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-cursor/">MySQL Cursor</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-triggers.aspx">MySQL Triggers</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/sql-triggers.aspx">Introduction to SQL Trigger</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-trigger-implementation.aspx">MySQL Triggers Implementation</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/create-the-first-trigger-in-mysql.aspx">Create Trigger in MySQL</a>.
<li>Browse <a href="http://www.mysqltutorial.org/mysql-triggers/create-multiple-triggers-for-the-same-trigger-event-and-action-time/">Create Multiple Triggers For The Same Trigger Event And Action Time</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/managing-trigger-in-mysql.aspx">Managing Triggers in MySQL</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-triggers/working-mysql-scheduled-event/">Working with MySQL Scheduled Event</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-triggers/modifying-mysql-events/">Modifying MySQL Events</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 11 -->
<!-- Week 12: Tuesday 11/08 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/CnBmBGaRoYolu3WNZEuDAJ9w_stthyFkBWhO0k2VNynDDNVg01hKkYhBKxJHTwM.2-qGhJiKFl9QN_3V?startTime=1699383862000','text'),array('https://minnstate.zoom.us/rec/share/CnBmBGaRoYolu3WNZEuDAJ9w_stthyFkBWhO0k2VNynDDNVg01hKkYhBKxJHTwM.2-qGhJiKFl9QN_3V?startTime=1699389657000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-cursor/">MySQL Cursor</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-triggers.aspx">MySQL Triggers</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/sql-triggers.aspx">Introduction to SQL Trigger</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-trigger-implementation.aspx">MySQL Triggers Implementation</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/create-the-first-trigger-in-mysql.aspx">Create Trigger in MySQL</a>.
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-triggers/create-multiple-triggers-for-the-same-trigger-event-and-action-time/">Create Multiple Triggers For The Same Trigger Event And Action Time</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/managing-trigger-in-mysql.aspx">Managing Triggers in MySQL</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-triggers/working-mysql-scheduled-event/">Working with MySQL Scheduled Event</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-triggers/modifying-mysql-events/">Modifying MySQL Events</a>.</li>
<li>Review <a href="http://www.mysqltutorial.org/mysql-stored-function/">MySQL Stored Function</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li><?=labLink(7)?></li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-views-tutorial.aspx">MySQL Views</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/introduction-sql-views.aspx">Introduction to Database View</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-views.aspx">Views in MySQL</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/create-sql-views-mysql.aspx">Creating Views in MySQL</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/create-sql-updatable-views.aspx">Creating MySQL Updatable Views</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-view-with-check-option/">Ensuring Views Consistency Using WITH CHECK OPTION Clause</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/mysql-view-local-cascaded-in-with-check-option">Understanding LOCAL & CASCADED in WITH CHECK OPTION Clause</a>.</li>
<li>Browse <a href="http://www.mysqltutorial.org/managing-sql-views.aspx">Managing Views in MySQL</a>.</li>
</ol>
</li>
</ul>
</li><!-- END Week 12 -->
<!-- Week 13: Tuesday 11/15 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/mFt8ZJwr0GLvC6DhJV1hS5cMmUiATu_HpRqv9iUV4xuSIt-bseHND4zuLj6l82eC.TNZk2KgaA6YIumKx?startTime=1699988619000','text'),array('URL','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-views-tutorial.aspx">MySQL Views</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/introduction-sql-views.aspx">Introduction to Database View</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-views.aspx">Views in MySQL</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/create-sql-views-mysql.aspx">Creating Views in MySQL</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/create-sql-updatable-views.aspx">Creating MySQL Updatable Views</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-view-with-check-option/">Ensuring Views Consistency Using WITH CHECK OPTION Clause</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-view-local-cascaded-in-with-check-option">Understanding LOCAL & CASCADED in WITH CHECK OPTION Clause</a>.</li>
<li>Discuss <a href="http://www.mysqltutorial.org/managing-sql-views.aspx">Managing Views in MySQL</a>.</li>
<li>Discuss class tasks.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li>Browse <a href="http://www.mysqltutorial.org/mysql-administration.aspx">MySQL Administration</a>.</li>
<li>Read <a href="https://dev.mysql.com/doc/refman/8.0/en/upgrading.htmll">Upgrading MySQL</a>.</li>
<li>Read <a href="https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html">Upgrading MySQL on Windows</a>.</li>
<li>Read <a href="https://severalnines.com/database-blog/tips-for-upgrading-mysql-5-7-to-mysql-8">Tips for Upgrading to from MySQL 5.7 to MySQL 8</a>.</li>
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+2)?>:
<ol type="i">
<!--<li><?=labLink(8)?></li>-->
<li><?=labLink(9)?></li>
</ol>
</li>
</ul>
</li><!-- END Week 13 -->
<!-- Week 14: Tuesday 11/22 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/FF4rG04rJpyvXRiJXEvodPZUDMEn8Zc3mBVgUZA1VRv03H8SZWRp_ObTSos2PuwO.RGBJ8PMl3CPsDRI9?startTime=1700593433000','text'),array('https://minnstate.zoom.us/rec/share/FF4rG04rJpyvXRiJXEvodPZUDMEn8Zc3mBVgUZA1VRv03H8SZWRp_ObTSos2PuwO.RGBJ8PMl3CPsDRI9?startTime=1700600420000','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
<ol type="i">
<li>Discuss <a href="http://www.mysqltutorial.org/mysql-administration.aspx">MySQL Administration</a>.</li>
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/upgrading.htmll">Upgrading MySQL</a>.</li>
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html">Upgrading MySQL on Windows</a>.</li>
<li>Discuss <a href="https://severalnines.com/database-blog/tips-for-upgrading-mysql-5-7-to-mysql-8">Tips for Upgrading to from MySQL 5.7 to MySQL 8</a>.</li>
</ol>
</li>
<li>All assignments are due by Wednesday, December 13<sup>th</sup> 2022.</li>
<li>Please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
</ul>
</li><!-- END Week 14 -->
<!-- Week 15: Tuesday 11/29 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<span class="attention nowrap">No class meetings this week.</span>
<? lectureLinks(array(array('URL','text'),array('URL','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<b>There is no lecture this week.</b> <span class="note normal">Contact me and I will open a web meeting for help with labs.</span></li>
<li>All assignments are due by Wednesday, December 13<sup>th</sup> 2022.</li>
<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
<il>Complete all unfinished labs.</il>
</ul>
</li><!-- END Week 15 -->
<!-- Week 16: Tuesday 12/06 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<span class="attention nowrap">No class meetings this week.</span>
<? lectureLinks(array(array('URL','text'),array('URL','text'),array('URL','text'))); ?>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li><!-- Tuesday 1:00pm-3:30pmm -->
<b>There is no lecture this week.</b> <span class="note normal">Contact me and I will open a web meeting for help with labs.</span></li>
<li>All assignments are due by Wednesday, December 13<sup>th</sup> 2022.</li>
<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
<il>Complete all unfinished labs.</il>
</ul>
</li><!-- END Week 16 -->
<!-- Week 17: Tuesday 12/13 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week,0,'<span class="attention">Finals Week.</span>')?><?=classWeekShowHideUL($class['startDate'],$week)?>
<span class="attention nowrap">No class meetings this week.</span>
<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
<li>All assignments are due by Wednesday, December 13<sup>th</sup> 2022.</li>
<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
<il>Complete all unfinished labs.</il>
</ul>
</li><!-- END Week 17 -->
</ol>
</fieldset>
<? /** / ?>
<? /**/ ?>
<? $LOCK_BELOW = $week; ?>
<?
?>