In this course, you will learn :
- The most important SQL to get your job done quickly.
- SQL should be used to solve real-world business problems.
- Excellent data handling, joining, and summarization abilities.
- How does a real-world relational database work? (using never seen before data).
- To use SQL to create an analysis and solve problems from start to finish.
- And how to choose which animals to see while in Australia ;)
1. Setup: Let's set up, so we can start coding!
- Getting the Software: Downloading the mySQL relational database manager.
- Using the Software: The 3 important parts of mySQL workbench for writing SQL
- Let's code again! Is my name more suited to puppy dogs or humans?
- Uploading the Data: The rich bank relational database unique to this course.
2. Handling Data: The foundation of all data analysis
- SELECT & FROM: Seeing, inspecting, and displaying data.
- FILTERING: Introducing filtering using a fun analogy.
- WHERE: Filtering data in SQL.
- (Cont) WHERE: Filtering Data in SQL
- AND & OR Logic: Introducing a tricky topic using a fun analogy.
- AND & OR: Specifying your filter
- End of the short version of the course
- (Cont) AND & OR: Specifying your filter (Coming Soon)
- AND & OR COMBINED: More realistic and powerful filters.
- IN, LIKE, ANY, NOT, BETWEEN, and IS NULL (Coming Soon)
- ORDER BY: Sorting your data (Coming Soon)
- ARITHMETIC FUNCTIONS: Modifying your numeric columns. (Coming Soon)
- STRING FUNCTIONS: Modifying your string columns. (Coming Soon)
- DATE FUNCTIONS: Modifying your date columns. (Coming Soon)
- CREATE TABLE: Creating new columns and datasets. (Coming Soon)
3. Full Introduction to the Course (COMING SOON)
- Teaching philosophy and lesson structure (Coming soon)
- Why learn data analysis and why SQL (Coming soon)
4. Data Theory: What in the world is data?
- Why data and analysis are so powerful (Coming soon)
- How data is stored and organised (Coming soon)
- How analysts access, handle, and use data (Coming soon)
- Practicing our understanding data theory on a variety of data sets.
5. Joining Data: Gathering data from different sources using JOINS
- JOINS: Using analogies to introduce the theory of joins
- LEFT JOIN: Adding new columns to your existing dataset
- INNER JOIN: Merging your datasets
- UNION: Putting your datasets on top of one another!
6. Problem Solving: Practice with multiple start to finish problems
- CRYPTOCURRENCY: Advising consumer bank CEO on their response to crypto-trading.
- Sharks attack! Driving shark safety policy for the Australian government.
- "Po-po shut us down": Advising the NY Police on improving their public image.
- Salary and Employee Growth at Goggle Inc.
- Blockbuster video and the curious case of...
- Road deaths: How to reduce fatal road crashes in Australia.