Don't like banners? Log in and we will make sure you see no banners. For free.
[FreeTutorials.Us] [UDEMY] SQL for Data Analysis Weekender Crash Course for Beginners [FTU]

[FreeTutorials.Us] [UDEMY] SQL for Data Analysis Weekender Crash Course for Beginners [FTU]

Other
Size
674 MB
Seeders
0
Leechers
0
Files
78
Category
Other
Added
at 8:52pm GMT+1
Infohash
de31f7413c9d2769c8fdbc28c7f5b3d7262ce01e
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
For More Udemy Free Courses >>> https://freetutorials.us/

For more Lynda and other Courses >>> https://www.freecoursesonline.me/

Forum for discussion >>> https://1hack.us/







Using MySQL but applicable to Oracle SQL, Microsoft SQL Server, and PostgreSQL. Taught by a Data Scientist and PM.



Created by: A Course You'll Actually Finish, David Kim, Peter Sefton

Last updated: 4/2019

Language: English

Caption (CC): Included

Torrent Contains: 83 Files, 6 Folders

Course Source: https://www.udemy.com/sql-for-newbs/



What you'll learn



• Analyze user behavior

• Find actionable customer/business insights

• Make data-driven decisions

• Measure and track marketing efforts

• Discover sexy marketing stats (e.g. 1 in 4 people love toast!)



Course content

all 37 lectures 03:33:19



Requirements



• No previous technical knowledge required



Description



Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.



This SQL course has been taken by fine marketing folks at Google, Facebook, Amazon, Lyft, and Udemy.



Your Story:



Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw.  He wanted to add "SQL" as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview.  But getting there would take forever. Better to just "fake it til' you make it"... right?



Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?



Our Story:



David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They've since helped many team members buff up their data analysis skills and helped students land jobs!



What You'll Learn:



If you have no technical background, don't be afraid! We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. Note: this courses teaches you real-world SQL - not just the theory in abstract, but real skills you can use to get more data-driven in your current job.



How This Course is Structured:



• In this course we'll be pretending we're a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.

• We'll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes

• To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing

• We'll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)

• We'll be actively involved in the discussion board answering any questions you might have! Don't be afraid to ask!



A Note About Pedagogy:



We know what it's like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don't want that to happen with this course. We want this to be a course you'll actually finish. We believe half of learning is motivation and engagement, so we've tried extra hard to make this course fun, relevant, entertaining, and punchy - no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us)!



FAQs:



1. Do I need to purchase any software to take this course? Nope! Everything we use to do data analysis with MySQL is completely free. We'll walk you through the installation and set-up of any software we'll be using.

2. Can I take this course with Linux? The set-up and installation lectures we've created are for Windows and Mac, and we don't currently have specific installation lectures for Linux.



Who this course is for:



• Marketers

• Startup folks

• Non-technical folks

• Aspiring Data Analysts

• Recent College Grads

• Job-seekers.








File list
  • [FreeTutorials.Us] [UDEMY] SQL for Data Analysis Weekender Crash Course for Beginners [FTU]
  • 0. Websites you may like/How you can help Team-FTU.txt 229 B
  • 1. Welcome!/1. Introduction to the Course and Your Instructors.mp4 38.5 MB
  • 1. Welcome!/1. Introduction to the Course and Your Instructors.vtt 5.4 KB
  • 1. Welcome!/2. WATCH ME NOW!.mp4 7.8 MB
  • 1. Welcome!/2. WATCH ME NOW!.vtt 4.9 KB
  • 1. Welcome!/2.1 Tiny Habits w Dr. BJ Fogg - Behavior Change.html 83 B
  • 1. Welcome!/2.2 Udemy - Online Courses from the World's Experts.html 90 B
  • 1. Welcome!/3. A Note from Your Humble Leaders.html 707 B
  • 1. Welcome!/4. Getting Started (Downloading a Text Editor!) - All OS.mp4 3.9 MB
  • 1. Welcome!/4. Getting Started (Downloading a Text Editor!) - All OS.vtt 4.2 KB
  • 1. Welcome!/5. Getting set up No installation necessary!.mp4 9.6 MB
  • 1. Welcome!/5. Getting set up No installation necessary!.vtt 4.5 KB
  • 2. Intro to MySQL/1. What the heck is a relational database.mp4 26 MB
  • 2. Intro to MySQL/1. What the heck is a relational database.vtt 11.5 KB
  • 2. Intro to MySQL/2. [QUIZ] What the heck is a relational database.html 115 B
  • 2. Intro to MySQL/3. Da SQL Basics Skeleton of a Query.mp4 34 MB
  • 2. Intro to MySQL/3. Da SQL Basics Skeleton of a Query.vtt 16 KB
  • 2. Intro to MySQL/4. SQL Query Skeleton.html 115 B
  • 2. Intro to MySQL/5. [Brainbuster] Build Your First Query!.mp4 15.9 MB
  • 2. Intro to MySQL/5. [Brainbuster] Build Your First Query!.vtt 10 KB
  • 3. Basic Queries/1. COUNT() and GROUP BY.mp4 21.1 MB
  • 3. Basic Queries/1. COUNT() and GROUP BY.vtt 11.5 KB
  • 3. Basic Queries/10. Arithmetic & Order By.mp4 32.6 MB
  • 3. Basic Queries/10. Arithmetic & Order By.vtt 19.4 KB
  • 3. Basic Queries/11. [Brainbuster] Finding Your Top-Performing Store.mp4 12.8 MB
  • 3. Basic Queries/11. [Brainbuster] Finding Your Top-Performing Store.vtt 7.3 KB
  • 3. Basic Queries/12. LEFT(), MIN() AND MAX().mp4 17.6 MB
  • 3. Basic Queries/12. LEFT(), MIN() AND MAX().vtt 17.9 KB
  • 3. Basic Queries/13. [Brainbuster] Finding Your Active Users - Last Rental Time by Customer.mp4 897.4 KB
  • 3. Basic Queries/13. [Brainbuster] Finding Your Active Users - Last Rental Time by Customer.vtt 1.4 KB
  • 3. Basic Queries/14. [Brainbuster] Finding Month over Month Revenue Growth.mp4 8.1 MB
  • 3. Basic Queries/14. [Brainbuster] Finding Month over Month Revenue Growth.vtt 8.2 KB
  • 3. Basic Queries/15. DISTINCT.mp4 11.1 MB
  • 3. Basic Queries/15. DISTINCT.vtt 10.8 KB
  • 3. Basic Queries/16. [Brainbuster] Find Distinct Films Rented Each Month.mp4 6 MB
  • 3. Basic Queries/16. [Brainbuster] Find Distinct Films Rented Each Month.vtt 7.7 KB
  • 3. Basic Queries/17. IN().mp4 8.8 MB
  • 3. Basic Queries/17. IN().vtt 10.1 KB
  • 3. Basic Queries/18. Comparison Operators and HAVING.mp4 7.3 MB
  • 3. Basic Queries/18. Comparison Operators and HAVING.vtt 10.2 KB
  • 3. Basic Queries/19. [Brainbuster] Breaking Down Revenue by Store and Rating.mp4 7.7 MB
  • 3. Basic Queries/19. [Brainbuster] Breaking Down Revenue by Store and Rating.vtt 6.4 KB
  • 3. Basic Queries/2. Brainbuster TWEAK.html 747 B
  • 3. Basic Queries/20. Nested Queries.mp4 59.9 MB
  • 3. Basic Queries/20. Nested Queries.vtt 7.7 KB
  • 3. Basic Queries/21. Nested Queries vs. Temporary Tables.mp4 14.3 MB
  • 3. Basic Queries/21. Nested Queries vs. Temporary Tables.vtt 3.7 KB
  • 3. Basic Queries/22. Add your new skills to LinkedIn!.html 797 B
  • 3. Basic Queries/3. COUNT() and GROUP BY.html 115 B
  • 3. Basic Queries/4. [Brainbuster] Organize movies by rating!.mp4 12.5 MB
  • 3. Basic Queries/4. [Brainbuster] Organize movies by rating!.vtt 7.5 KB
  • 3. Basic Queries/5. Connecting Tables.mp4 16.9 MB
  • 3. Basic Queries/5. Connecting Tables.vtt 9.8 KB
  • 3. Basic Queries/6. Connecting Tables (Warm-up for Brainbuster).html 116 B
  • 3. Basic Queries/7. [Brainbuster] Connect Tables.mp4 14.3 MB
  • 3. Basic Queries/7. [Brainbuster] Connect Tables.vtt 8.7 KB
  • 3. Basic Queries/8. [Brainbuster] Finding your best selling products (Rental Count by Movie).mp4 15.9 MB
  • 3. Basic Queries/8. [Brainbuster] Finding your best selling products (Rental Count by Movie).vtt 9.5 KB
  • 3. Basic Queries/9. Having trouble understanding connecting tables.html 517 B
  • 4. BONUS Lectures/1. BONUS JOINs.mp4 24.7 MB
  • 4. BONUS Lectures/1. BONUS JOINs.vtt 26.3 KB
  • 4. BONUS Lectures/2. [Brainbuster] BONUS JOINs.mp4 26.6 MB
  • 4. BONUS Lectures/2. [Brainbuster] BONUS JOINs.vtt 9.3 KB
  • 4. BONUS Lectures/3. What is a Cohort Analysis.mp4 30.4 MB
  • 4. BONUS Lectures/3. What is a Cohort Analysis.vtt 10.3 KB
  • 4. BONUS Lectures/3.1 Cohort Analysis Article from Kissmetrics.html 125 B
  • 4. BONUS Lectures/4. Cohort Analysis Preamble.html 382 B
  • 4. BONUS Lectures/5. Cohort Analysis Query - Time to get FANCY.mp4 25.3 MB
  • 4. BONUS Lectures/5. Cohort Analysis Query - Time to get FANCY.vtt 22.9 KB
  • 4. BONUS Lectures/6. A Request from Your Humble Leaders.html 1.8 KB
  • 5. Appendix A Alternative Installation/1. Installation Guide.html 559 B
  • 5. Appendix A Alternative Installation/2. Getting Set Up (Installation) - Mac Version.mp4 96.8 MB
  • 5. Appendix A Alternative Installation/2. Getting Set Up (Installation) - Mac Version.vtt 22.8 KB
  • 5. Appendix A Alternative Installation/2.1 mysql_mac_instructions.txt.txt 2.3 KB
  • 5. Appendix A Alternative Installation/2.2 Sakila Db.zip 703.5 KB
  • 5. Appendix A Alternative Installation/3. Getting Set Up (Installation) - Windows 32-bit Version.mp4 65.1 MB
  • 5. Appendix A Alternative Installation/3. Getting Set Up (Installation) - Windows 32-bit Version.vtt 210 B
  • 5. Appendix A Alternative Installation/3.1 Sakila Db.zip 703.5 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents