csci 2141 intro to databases n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
CSCI 2141: Intro to Databases PowerPoint Presentation
Download Presentation
CSCI 2141: Intro to Databases

Loading in 2 Seconds...

play fullscreen
1 / 9

CSCI 2141: Intro to Databases - PowerPoint PPT Presentation


  • 110 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'CSCI 2141: Intro to Databases' - mirit


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
csci 2141 intro to databases

CSCI 2141: Intro to Databases

Winter 2013

Dr. Kirstie Hawkey

who am i
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
course website
Course Website
  • web.cs.dal.ca/~hawkey/2141
    • Syllabus
    • Resources
    • Slides
    • Assignments/Project details
coursera
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!
what we will cover
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
my philosophy
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
why databases why this course
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
for the next class
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?