Datapolitan-Training parks-advanced-analysis-sql issues

Datapolitan-Training / parks-advanced-analysis-sql

A one-day class reinforcing the skills necessary to leverage a relational database to clean, process, and visualize NYC Parks data

http://training.datapolitan.com/parks-advanced-analysis-sql

Creative Commons Attribution Share Alike 4.0 International

0 stars 0 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Add SQL Murder Mystery

#70 datapolitan opened 5 years ago
0
Instructions for Expression.Error

#69 datapolitan opened 5 years ago
0
Add Info Slide

#68 datapolitan closed 5 years ago
0
Demonstrate query editing as standard

#67 datapolitan closed 5 years ago
1
Add illustration of database structure

#66 datapolitan opened 5 years ago
1
Add discussion of NUMERIC vs VARCHAR for identifiers to slide

#65 datapolitan closed 5 years ago
0
Add queries to workbook for annotation

#64 datapolitan closed 5 years ago
1
Display Table Schemas for Example Tables

#63 datapolitan opened 5 years ago
0
Beef up JOINs discussion

#62 datapolitan closed 5 years ago
4
Add CASE Statement for Boro

#61 datapolitan closed 5 years ago
0
Rethink Documentation Discussion Placement

#60 datapolitan closed 5 years ago
0
Using functions with text -> LEFT(propid,1) -> LEFT(omppropid,1)

#59 datapolitan closed 5 years ago
0
Add stats on Daily Tasks

#58 datapolitan closed 5 years ago
0
Add propositional logic resource

#57 datapolitan closed 5 years ago
0
Add the Query Source Edit for the in Applied Steps

#56 datapolitan closed 5 years ago
2
Add comment on the BIT data type

#55 datapolitan closed 5 years ago
1
Update Navigator image

#54 datapolitan closed 5 years ago
1
Parks update the Power Query Add-In

#53 datapolitan opened 5 years ago
1
Manipulating -> Transforming in 5 Data Analytics Tasks

#52 datapolitan closed 5 years ago
0
New chart for Value of Data

#51 datapolitan closed 5 years ago
1
Add link to Dashboard

#50 datapolitan closed 5 years ago
0
Add sql to the code blocks for formatting

#49 datapolitan closed 5 years ago
0
Add Encryption Warning

#48 datapolitan closed 5 years ago
0
Add Query previews for tbl_ref_calendar queries

#47 datapolitan closed 5 years ago
0
Replace Daily Tasks with tbl_ref_calendar data

#46 datapolitan closed 5 years ago
0
Add Database to Workbook

#45 datapolitan closed 5 years ago
5
Fix join to pull from the tbl_PIPAllSites

#44 datapolitan closed 5 years ago
0
Add TOP limit to the graffiti and nhours queries

#43 datapolitan closed 5 years ago
0
Fix first database images

#42 datapolitan closed 5 years ago
0
Add SQL Server endpoint to the workbooks

#41 datapolitan closed 5 years ago
0
Put the SQL Server endpoint in the slides

#40 datapolitan closed 5 years ago
0
Add link to the Google Drive submit

#39 datapolitan closed 5 years ago
0
Add C Block Wrap-up

#38 datapolitan closed 5 years ago
0
Fuller discussion of Joins?

#37 datapolitan closed 5 years ago
1
Describe the intended result of running YEAR() query

#36 datapolitan closed 5 years ago
2
SELECT Your Turn should be on the tbl_ref_calendar

#35 datapolitan closed 5 years ago
0
Add instructor/TA information

#34 datapolitan closed 5 years ago
0
Add A Block Wrap-Up re:implementation guide

#33 datapolitan closed 5 years ago
0
Add in the SELECT TOP to get limited rows

#32 datapolitan closed 5 years ago
2
Add SELECT TOP to limit query size

#31 ebrelsford closed 5 years ago
1
Fix Eric's Twitter link

#30 datapolitan closed 5 years ago
0
How to get column names with SQL Server

#29 datapolitan closed 5 years ago
4
Squeeze down vlookupfunction.png to better fit slide

#28 datapolitan closed 5 years ago
1
Add acknowledgement we're switching to tbl_dailytasks

#27 datapolitan closed 5 years ago
1
Add Carter's new position

#26 datapolitan closed 5 years ago
0
Add Contact Info Slide and Survey Slide

#25 datapolitan closed 5 years ago
0
Add Screen Shot of SSMS

#24 datapolitan closed 5 years ago
0
Add SSMS Resources to slides

#23 datapolitan closed 5 years ago
0
Add link to workbook

#22 datapolitan closed 5 years ago
0
Ensure all students have Power Query installed

#21 ebrelsford closed 5 years ago
0