DATA WAREHOUSING (PART 3)

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

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







keep exploring!

back to all projects