1 / 9

CSCI 2141: Intro to Databases

CSCI 2141: Intro to Databases. Winter 2013 Dr. Kirstie Hawkey. Who am I?. Assistant Professor Undergrad Committee (advisor) Dalhousie, UBC, Dalhousie Research: Human-Computer Interaction, Usable Privacy & Security, Visual Analytics, Mobile Graphics

mirit
Download Presentation

CSCI 2141: Intro to Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSCI 2141: Intro to Databases Winter 2013 Dr. Kirstie Hawkey

  2. Who am I? • Assistant Professor • Undergrad Committee (advisor) • Dalhousie, UBC, Dalhousie • Research: Human-Computer Interaction, Usable Privacy & Security, Visual Analytics, Mobile Graphics • Room 225 Goldberg (also office in Mona Campbell) • Office hours: typically Mon & Fri, 10:30-12:30 • hawkey@cs.dal.ca

  3. Course Website • web.cs.dal.ca/~hawkey/2141 • Syllabus • Resources • Slides • Assignments/Project details

  4. Coursera • https://class.coursera.org/db/class/index • Current is self-study • New course starting Jan 15th • Taught by Stanford’s Dr. Jennifer Widom (of the text book fame) • Sign up • I will assign videos from time to time • Exercises, assignments, exams offer practice • Nice mapping of how info is covered in the various text books • … and that certificate if you want another piece of paper!

  5. What we will cover • Database (DB) components • DB design using entity-relationship (relational, object oriented) • SQL • Transactional properties and techniques to support them • Take a look at some of the emerging database trends • Distributed databases, cloud computing, big data, semi-structured data models, NoSQL • Project: MySQL + web interface • Security

  6. Security

  7. My philosophy • Talking heads only go so far • Need to think and try and explain and practice to truly understand • Assignments are primarily to help you learn, evaluation is secondary • Can do in groups (up to 3 people) • Marked for completeness (50%) and correctness (50%) for a subset of questions • Quick turnaround of answers • Project will give you some real world experience implementing DB concepts • Tests will ask you to explain and apply the concepts learned • Pop quizzes let me see how you are doing, encourage you to keep up • We will go over the answers in the class after the quiz

  8. Why databases? Why this course? • Required course? (BCS, Binf, BSc) • Prerequisite for: 3151 Web Intelligence, 3172 Web Centric Computing, 3190 Community Outreach, 4140 Advanced DB Systems, Co-op • Career path? • Career beacon • Hidden career path… • We are all end users

  9. For the next class • Sign up for the db class on coursera • Watch the intro video • Familiarize yourself with the resources • Choose a secondary information source • Textbook, website (share with me!), coursera …. • Come prepared with tales of poor DB design • Home depot • Others?

More Related