0
DATA WAREHOUSING (PART 3): SUPPLEMENT FOR SQL WORKSHOP WITH DATA SCIENCE AT UCSB AND FEMALE ACTUARIAL ORGANIZATION

DATA WAREHOUSING (PART 3)

SUPPLEMENT FOR SQL WORKSHOP WITH DATA SCIENCE AT UCSB AND FEMALE ACTUARIAL ORGANIZATION

MD, SQL

MEDIUM

last hacked on Aug 09, 2017

<img src='https://scontent-sjc2-1.xx.fbcdn.net/v/t1.0-9/18423732_1090338297776716_6714511282731679602_n.jpg?oh=73bd1e70ace1fe07ffdebc54c4312fc8&oe=59A74D87' width='700px'>
# SQL Workshop 5/20 ## Data Science at UCSB and FACTOR (Female Actuarial Organization) **Contributors** + Raul Eulogio + Ashley Samudio + Jun Seo Park Relevant Links: + [Data Science at UCSB](http://datascience.pstat.ucsb.edu/) + [FACTOR at UCSB](http://factor.webs.com/) + [Inertia7](https://www.inertia7.com/) ## Downloading MySQL Workbench + [Macs](https://github.com/raviolli77/SQL_Workshop/blob/master/downloadMySQLServer.md) + Windows - Download *MySQL* Installer and run + Setup Type: select *"Developer Default"* + Check Requirements: Click *"Execute"* and run through all the installations (there will be a lot) + Once everything finishes, click *"Next"*; ignore the message that you need another Python installation, this is not necessary + Proceed with the rest of the installation + If major issues occur, cancel the installation, re-run MySQL Installer and remove all packages, then try to reinstaller beginning with *"Developer Default"* ## **Goal** For this workshop, we will focus on basic functionalities within a *MySQL* context. As well as some theory with respect to *Data Warehousing* to give context to attendees the usefulness of **SQL** data storage. ## **Process** This stucture will be similar to the [Python Workshop](https://github.com/UCSB-dataScience-ProjectGroup/Python_Workshop), except instead of being handed a dataset you will be handed a *database*. Presentation: + [Data Warehousing](https://www.inertia7.com/projects/5) + [SQL Syntax](https://www.inertia7.com/projects/66) + [Student Collaboration](https://www.inertia7.com/projects/70) Databases: + [Northwind Database](https://github.com/dalers/mywind) + [World Database](https://dev.mysql.com/doc/index-other.html) + [Iris Database](https://github.com/raviolli77/SQL_Workshop/tree/master/data/iris) ## **Step 1: Repository** For this step you will create a **GitHub** repository with the following requirements: + README detailing + List of contributors + Description of data set + Along with any process taken to retrieve the data set + Link to the source of data set + The problem you are trying to solve (i.e. the instructions on the file for your given data set) ## **STEP 2: Do Analysis** Simple as that do analysis on the database you chose to use (Goes without saying that you should be able to successfully load the database into the *MySQL Workbench*). As soon as I'm done lecturing we will branch off into teams and you will work with a team to make some interesting observations. + Make insightful comments about queries (practice exercises included in Github repository) + Use **R** or **Python** to go beyond (I hope most people from **DS** will do this.) + Upload all relevant files to *GitHub* and if time permits we can do a 2 minute showcase of people's results. ## Assignments Assignments can be found here: + [Northwind Assignments](https://github.com/raviolli77/SQL_Workshop/blob/master/exercises-northwind.md) + [w3schools Assignments](https://github.com/raviolli77/SQL_Workshop/blob/master/exercises-w3schools.md) ## Download: + [Macs](https://dev.mysql.com/downloads/mysql/) + [Windows](https://dev.mysql.com/downloads/installer/) ## Resources + [Ravi's Data Warehousing Notes](https://github.com/raviolli77/understandIngRelationalDatabases) + [w3schools SQL Tutorial](https://www.w3schools.com/SQL/deFault.asp) + [Tom Jewett's Database Design Tutorial](http://www.tomjewett.com/dbdesign/dbdesign.php) + [TutorialsPoint's Data Warehousing Tutorial](https://www.tutorialspoint.com/dwh/dwh_olap.htm) + [Concept Hierarchies Tutorial And Examples](http://athena.ecs.csus.edu/~olap/olap/OLAPoperations.php) + [SearchDataManagement's Definition of OLAP](http://searchdatamanagement.techtarget.com/definition/OLAP) + [Managing Database Objects in SQL](http://www.informit.com/articles/article.aspx?p=1216889&seqNum=2)

COMMENTS


back to all projects