A290/A590 Main Menu

A290/A590
Access to Posted Meeting Guides.

image

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

image

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

image

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

  • Meeting 1 Slides - Course Introduction and Introduction Database Concepts. (posted 6/18 @ 10:00am)
  • Meeting 2 Slides - Basics Components of a "Table" and Introduction to SQL(posted 6/19 @ 10:00am)
  • Meeting 3 Slides - What Defines a "Sound" Database and Introduction to SQL (posted 6/25 @ 10:00am)
  • Meeting 3 Guide - Using puTTY, Accessing Silo, and Using MariaDB/mySQL. (posted 6/25 @ 10:00am)
  • Meeting 4 Slides - More Database Basics and Introduction to SQL and MariaDB/mySQL(posted 6/26 @ 5:00am)
  • Meeting 4 Guide - Using phpMyAdmin and Loading Table Files. (posted 6/26 @ 5:00am)
  • Meeting 5 Guide - Introductions to Queries/Statements. (posted 7/2 @ 9:30am)
  • Meeting 6 Guide - More With Queries/Statements. (posted 7/2 @ 8:00pm)
  • Meeting 7 Guide - Sub-Queries and Joining Tables in different ways. (posted 7/9 @ 9:30am)
  • Meeting 8 Guide - Combining Queries and Manipulating Data in our tables. (posted 7/10 @ 8:30am)
  • Meeting 9 Guide - More With Inserting/Updating/Deleting Data. (posted 7/16 @ 8:30am)
  • Meeting 10 Guide - More With Tables and SQL Views. (posted 7/17 @ 8:30am)
  • Meeting 11 Guide - SQL Stored Procedures and SQL Dump. (posted 7/23 @ 8:30am)
image