This material was originally developed by Heather Wade, with Class 1 Data Modeling material adapted from Pamela Fox's one day workshop. Reworked for PostgreSQL by Courtney Lenna Schirf.
The course is meant to be taught in a two four-hour classes.
A database is an organized collection of data. In this class, we will discuss the science (and art) of storing and retrieving data. As anyone who has tried to analyze data using Excel can attest, it is not as simple as it might seem.
Are you a developer (web or otherwise) and wish to learn more about the backend stack? Are you a support professional looking to enter a more technical track? Are you an analyst who would like to learn how your reports get run? Are you a business owner or hobbyist who'd like to design your own database system? Or maybe you're thinking about becoming a database professional? If you answered yes to any of the questions above or are just generally interested in learning more about databases - this class will get you started!
This eight hour course runs on Saturday and Sunday:
- Class 1 - Intro to Data Modeling
- Class 2 - Intro to SQL, Retrieving Data
- Class 3 - Intermediate SQL, Joins, & DML
- Class 4 - DDL & Advanced Topics
Please bring a laptop you feel comfortable using.
You can change theme colors by changing the theme css to any of the following options:
<link rel="stylesheet" href="css/theme/gdidefault.css" id="theme">
<link rel="stylesheet" href="css/theme/gdilight.css" id="theme">
<link rel="stylesheet" href="css/theme/gdisunny.css" id="theme">
<link rel="stylesheet" href="css/theme/gdicool.css" id="theme">You can change the text editor theme by changing the highlight.js css to the following options:
<link rel="stylesheet" href="lib/css/dark.css">
<link rel="stylesheet" href="lib/css/light.css">You can change transition by changing the reveal transition property in Reveal.initialize
Reveal.initialize({
transition: 'default', // default/cube/page/concave/zoom/linear/none
});