1 / 27

Mastering Databases: A Comprehensive Course by Dr. Karl Horak

Join Dr. Karl Horak's engaging session to learn the ins and outs of databases. Explore various types, learn database management tools, and dive into practical exercises. Get ready for a dynamic learning experience!

hunter
Download Presentation

Mastering Databases: A Comprehensive Course by Dr. Karl Horak

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. Database Design 1 CMS 476 Dr. Karl Horak, Instructor

  2. Session 1 • Administrivia • Course Overview • Week in Review • Application du Jour • Lecture: The Who, What, When, Where and Why of Databases • Demonstration: Introduction to Access • Exercises

  3. Course Overview • Instructor background • Expectations of students • Grading • Reference material • Organization and presentation • Tools and resources

  4. Instructor Background • PhD, U of A, 1981 • Majored in Botany, Ecology, Statistics and Genetics • Numerical taxonomy and agricultural statistics • Adjunct Professor, CSF since 1990 • Principle Member of Technical Staff, Sandia National Laboratories • Cooperative International Progams • Heavily involved in information management—this class is about what I really do every day

  5. Current Projects • RPT Image Comparison • Global Engagement website • Spent nuclear fuel assessment survey • Wide-area networking technologies for border monitoring

  6. My Toolset • SQL • Access • VBA • Python • Plone

  7. The Bottom Line • Nice people • Cool projects • Interesting travel

  8. Expectations of Students • Preparation • Attendance • Participation • Homework • Exam

  9. Grading

  10. Reference Material • http://home.comcast.net/~karlhorak/476_SYL.htm • http://dir.yahoo.com/Computers_and_Internet/Software/Databases/ • http://en.wikipedia.org/wiki/Database • http://ocw.mit.edu (especially http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/6-830Fall-2005/CourseHome/index.htm) • or just Google for it Where’s the textbook?! At your fingertips …

  11. Organization and Presentation • Week in review—databases in real life • Recap—highlights of previous topics and this week’s podcast • Application du jour—samples of databases in action • Tonight’s lecture topic • Demonstration • Exercises and Q&A

  12. Tools and Resources • Access—http://office.microsoft.com/en-us/access • MySQL—http://www.mysql.com • Plone—http://plone.org

  13. Onward…!

  14. Week in Review Or, what I did on my summer vacation • RPT—Access and Python • NEN survey tool • WACSI • MMNA

  15. Application du Jour • WACSI • “Web Access for Civil Society Improvements” • Middle East Regional activity • Internet-centered collaboration • Focused on: • Societal improvements • Economic development • Women’s empowerment • Education • Religious tolerance • Human rights • http://unm.wacsi.edu

  16. Tonight’s Lecture Topic:Who, What, When, Where and Why • What is a database? • Why you should care? • Who uses databases? • When should you use a database? • Where are the databases?

  17. What is a Database? • Webster: “a usually large collection of data organized especially for rapid search and retrieval (as by a computer)” • Horak: All computerized digital information is a database, it just doesn’t know it yet.

  18. Wherefore and Why • Seek and you shall find … well, maybe • “If you don’t know what you’re looking for, you’ll find it.” • “If a piece of data is in a computer twice, one of the copies is wrong.” • The two R’s • Retrieval • Redundancy

  19. What is a Database? Part 2 Types of Databases: • Unstructured (Free-text) • Flat file (e.g., Excel) • Hierarchical (C:\) • Relational (Access, MySQL, Oracle) • Object-oriented (Zope)

  20. Who and When? • DBA = Database Administrator • Anyone with large volumes of data • Anyone with complex questions • Everybody needs databases, they just don’t know it yet

  21. Where are they? Some Examples • http://www.travelschlepp.com • prius.xls • Your hard drive • EFAC.mdb • http://freeplone2.openia.com/mmna

  22. Demonstration • Introduction to MS Access • EFAC database • Terminology • Tables = spreadsheets • Records = rows • Fields = columns • Getting around in Access http://home.comcast.net/~karlhorak/SQLexercises.mdb

  23. Getting Data Out • QBE • Drag-and-drop tables, fields, relationships • Visual query builder • SQL • Manually created and edited • Text-based • SPARQL • RDF and XML-based • Web 2.0

  24. SQL • SELECT <fieldlist or expression> • From <table or query> • Where <condition> • Order by <field or expression> • Group by <field> • Having <condition> • ;

  25. QBE

  26. Exercises and Q&A • Download and open the EFAC database • Familiarize yourself with the structure and the data • Answer some questions by building queries

  27. Queries • Display all data in the table. • Display just facility type and country for all items in the table. • Display the facility type, capacity, and capacity units for just the facilities in Brazil • Display facility type, country, and capacity in kgU/year (hint: capacity is in metric tons, 1000 kg). Include a column that displays the units as "kgU/year".

More Related