-
To get started with the Excel Brownbag 101, download the Excel Spreadsheet and following the instructions on each tab: https://github.com/akgilbert/training/blob/master/Excel%20101%20Brownbag.xlsx
-
The training goes over the following:
- Intro Formulas Warm up: sum and division
- Advanced Formulas, part I: if/then
- Advanced Formulas, part II: vlookup
- Messy List Cleaning
- Pivot Tables
-
To get started with the SQL Training, go to SQLFiddle.com
-
Add the schema_build.sql code to the pane on the right then press the Build Schema button below: https://github.com/akgilbert/training/blob/master/schema_build.sql
-
Add the training_code.sql code to the pane on the left then press the Run SQL button below: https://github.com/akgilbert/training/blob/master/training_code.sql
-
As you're running the lines of code, read the comments marked with dashes
--
to understand what you're building. You'll add one layer at a time, until you reach the final code: https://github.com/akgilbert/training/blob/master/code_final.sql -
This training goes over the following:
- Basic SQL syntax (select, from, limit)
- Aggregrates (count, sum, group by, order by)
- Case Statements
- Joins (Left Join only)
- Outer and Inner Queries
Please add an issue to the repo or reach out to [email protected] with any questions on this training!