| 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/MichaelMalz/CST1602/Schedule/ |
Upload File : |
<?
// MichaelMalz/CST1602/CST1602_Schedule.phpinc
#if ( $_SESSION['userId'] == 1 ) require('MichaelMalz/ScheduleCode.phpinc');
$week = 0; if ( !isset($class['meetingTime'][1]) ) $class['meetingTime'][1] = $class['meetingTime'][0];
$dayAdd = 3;
#d_Var("\$_SERVER['HTTP_HOST']",$_SERVER['HTTP_HOST'],'d');
?>
<fieldset><legend><?=$title?></legend>
<? require('MichaelMalz/WebMeetingLink.phpinc'); ?>
<ol start="1">
<!-- Week 1 -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('URL','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('MichaelMalz/Schedule_week1.phpinc'); ?>
<li>Demonstrate installing MySQL Server, MySQL Workbench.</li>
<br>
<? require('MichaelMalz/Schedule_week1_Assignments_Begin.phpinc'); ?>
<? require('MichaelMalz/Schedule_week1_Assignments_End.phpinc'); ?>
</li>
<br>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ul>
<ol type="i">
<li><?=labLink(1)?></li>
<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>
</ol>
</ul>
</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('URL','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>Review the Module 1 quiz in D2L</li>
<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>Discuss creating a database using a GUI and the command line.
<li>Discuss creating a database table using a GUI and the command line.
</ol>
</li>
<li>
Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
<ol type="i">
<li>Complete the Module 2 quiz in D2L</li>
<li><?=labLink(2)?></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 4: Tuesday 9/13 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
<? lectureLinks(array(array('URL','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>Review the Module 2 quiz in D2L</li>
<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>Complete the Module 3 quiz in D2L</li>
<li><?=labLink(3)?></li>
<li><?=labLink(4)?></li>
<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('URL','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>Review the Module 3 quiz in D2L</li>
<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>Complete the Module 5 quiz in D2L</li>
<li><?=labLink(5)?></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('URL','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://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>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('URL','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://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('URL','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="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('URL','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="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)?>
<span class="attention nowrap">No live meeting this week. View recorded lecture.</span>
<? lectureLinks(array(array('URL','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="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(6)?></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('URL','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/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(7)?></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('URL','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-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(8)?></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('URL','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.html">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('URL','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-administration.aspx">MySQL Administration</a>.</li>
<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/upgrading.html">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 Tuesday, November 26<sup>th</sup> 2024.</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 Tuesday, November 26<sup>th</sup> 2024.</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 Tuesday, November 26<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 Tuesday, November 26<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; ?>
<?
?>