INLS 623 Fall 2017 - Database Systems II

Course Overview

Intermediate-level design and implementation of database systems, building on topics studied in INLS 523. Additional topics include MySQL, indexing, XML, and non-text databases..

Syllabus

Instructor

Dr. Carter

Lectures

Room: Manning 001

Time: Thursday - 5:15 pm - 8:00 pm

NOTE: Bring your laptops every Thursday. You will use them for exercises.

Book

Fundamentals of Database Systems, Sixth Edition Elmasri, R. and Navathe, S.B., Pearson Addison Wesley. (5th edition is also okay – but chapters are moved around)

Getting Help and Class Discussion

We will be using Piazza for class discussion and getting help. The system is highly catered to getting you help fast and efficiently from classmates and myself. Rather than emailing questions to me, I encourage you to post your questions on Piazza. If you do not get a response within a day or two on Piazza, please send mail to carterjl@cs.unc.edu. But try Piazza first. .

Before posing a question, please check if this question has been asked before. This will reduce post clutter and reduce our burden. Repeat questions will be ignored by the instructors.

Piazza allows anyone to respond. So if you see a question that you think you can respond to, please do so, as that will reduce our burden and help you "teach" your fellow students.

This will be a form of class participation that will be noted when I allocate my fudge points!

If you have any problems or feedback for the developers, email team@piazza.com.

Signup Link:https://piazza.com/unc/fall2017/inls623

Class page: https://piazza.com/unc/fall2017/inls623/home

Tentative Schedule (Has Broken Links for Material Not Covered so Far)

 

 

Unit

Assignment

Slides

Book Chapters

1

Introduction

 

PowerPoint 2007

Chapter 1

2

Database Normalization

Assignment 1

PowerPoint 2007

Chapter 15

1

Advanced SQL

 

PowerPoint 2007

Chapter 5

2

Database Application Development and Internet Applications

Assignment 2

PowerPoint 2007

Chapter 14

1

Stored Procedures

 

PowerPoint 2007

1

Indexing

  Assignment 3

PowerPoint 2007

1

Transactions

 

PowerPoint 2007

1

Graph Databases

  Assignment 4

PowerPoint 2007

1

Decision Trees

 

PowerPoint 2007 (Big Data)
PowerPoint 2007 (Data Mining)
PowerPoint 2007 (Weka)

1

Triggers

 

PowerPoint 2007

In class exercise 1 MySQL Commands
In Class Exercise 2
In Class Exercise: Data Mining Machine Learning
In Class Exercise: Decisions Trees