Naming Reports4:45 with Alena Holligan
The report page is looking good. But it's hard to know which report is actually being run. Let's change our header text to include more detail.
fetch() Fetches a single row from a result set
fetchAll() Returns an array containing all of the result set rows
- Allow users to enter their own date range.
- Combine Project with Date Range
- Combine Category with Date Range.
- Sort Tasks by Date
- Sort Tasks by Time
- Group Tasks by Day
- Group Tasks by Week
Additional Course Suggestions
This course covers powerful SQL features in helping you answer more interesting questions about your data.
Data Science Basics: Uses Python but the Principles Apply
This course will follow the basic procedures of conducting data science work, namely selecting and describing data, and munging it into a communicable form. At the end of this course, students will be able to pick a small dataset available online and, using Python language, quickly calculate descriptive statistics and show their results with basic charts and tables.
You need to sign up for Treehouse in order to download course files.Sign up