SQL for Newbs: Beginner Data Analysis

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | 1.39 GB

Genre: eLearning | Language: English

For non-technical folks and marketers. Mainly using MySQL but applicable for PostgreSQL / Postgres, SQL Server, etc.

Bill just graduated from college and had no real marketable skills (especially as a humanities major). As he was trying to fill up his resume to make himself look impressive, he found himself listing Microsoft Word and PowerPoint in the 'skills' portion of his resume. Awesome. Not.

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. 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.

What You'll Learn:

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. Even if you have no technical background, don't be afraid!

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)!