| 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/_Archive/MMDT1145/_Archive/ |
Upload File : |
<?
// Lesson06.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
$thisFile=__FILE__; $thisLine=__LINE__; include('application.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/courseInfo.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('classInfo.phpinc');
$title = "Lesson 6: Advanced SQL and MySQL";
$headTitle = '_CST_ - '.$courseNumber.' '.$courseTitle.' - '.$title;
$pageTitle = $courseNumber.' '.$courseTitle.'<br>'.$title;
$pageMenu = 'Course/courseMenu.phpinc';
$smallTitle = true;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$sectionTitle = $courseNumber.' '.$courseTitle.' - '.$title;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionHeader.phpinc');
?>
<p>
<fieldset><legend>Description</legend>
Begin an understanding of advanced SQL and MySQL.
</fieldset>
<fieldset class="pio"><legend>Personalized Instruction</legend>
<ol start="1" class="pio">
<li>Read Chapter 6 <i>Advanced SQL and MySQL</i> in <?=$textbook['Title1']?><?=$textbook['Edition1Edition']?>.</li>
</ol>
</fieldset>
<fieldset class="pio"><legend>Objectives</legend>
<ol class="obj pio" start="45">
<!-- Chapter 6: Advanced SQL and MySQL 45 -->
<li>Understand Database Design.</li>
<li>Perform Joins.</li>
<li>Group Selected Results.</li>
<li>Create Indexes.</li>
<li>Use Different Table Types.</li>
<li>Performing FULLTEXT Searches.</li>
<li>Describe Transactions.</li>
</ol>
</fieldset>
<fieldset><legend>Evaluations</legend>
There are no formal evaluations for this lesson.
</fieldset>
<?
$thisFile=__FILE__; $thisLine=__LINE__; include('ReferencesResources.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionFooter.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
?>