A290/A590
Access to Posted Meeting Guides.

All published guides are PDF files, created originally with Microsoft PowerPoint or Microsoft Word.

You must be officially enrolled in A290/A590 and have a valid IU Network ID to access these Meeting Outlines.

Section I: Introduction: Database Fundamentals, Tables, and SQL.

• Meeting 1 Slides - Course Introduction and Introduction Database Concepts. (POSTED 5/13 @ 9:30am)
• Meeting 2 Slides - Basics Components of a "Table" and Introduction to SQL(posted 5/14 @ 9:30am)
• Meeting 3 Slides - What Defines a "Sound" Database and Introduction to SQL (posted 5/20 @ 9:30am)
• Meeting 3 Guide - Using puTTY, Accessing Silo, Learning our DB passwords, and Logging in and Using MariaDB/mySQL. (posted 5/20 @ 9:30am)
• Meeting 4 Slides - More Database Basics and Introduction to SQL and MariaDB/mySQL(posted 5/21 @ 9:\30am)
• Meeting 4 Guide - Using phpMyAdmin and Loading Table Files. (posted 5/21 @ 9:30am)
• Meeting 5 Guide - Introductions to Queries/Statements. (posted 5/27 @ 9:30am)
• Meeting 6 Guide - More With Queries/Statements. (posted 5/28 @ 9:30am)
• Meeting 7 Guide - Sub-Queries and Joining Tables in different ways. (posted 6/3 @ 9:30am)
• Meeting 8 Guide - Combining Queries and Manipulating Data in our tables. (posted 6/4 @ 9:30am)
• Meeting 9 Guide - More With Inserting/Updating/Deleting Data. (posted 6/10 @ 8:30am)
• Meeting 10 Guide - More With Tables and SQL Views. (posted 6/11 @ 8:30am)
• Meeting 11 Guide - SQL Stored Procedures and SQL Dump. (posted 6/17 @ 9:30am)
• Meeting 12 Guide - No formal Guide, Review of work to be completed and a discussion of select JIT SQL topics and Final CAT.