CSCI 2141 Intro to Databases Winter 2013 Dr

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

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

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

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

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

+ Security

+ My philosophy n Talking heads only go so far n Need to think and try and explain and practice to truly understand n Assignments are primarily to help you learn, evaluation is secondary n n n Can do in groups (up to 3 people) Marked for completeness (50%) and correctness (50%) for a subset of questions Quick turnaround of answers n Project will give you some real world experience implementing DB concepts n Tests will ask you to explain and apply the concepts learned n n 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? n Required course? (BCS, Binf, BSc) n n Prerequisite for: 3151 Web Intelligence, 3172 Web Centric Computing, 3190 Community Outreach, 4140 Advanced DB Systems, Co-op Career path? n Career beacon n Hidden career path… n We are all end users

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