SQL for Data Analysis: Weekender Crash Course for Beginners

4.3 (11677)
Онлайн-курс
Payment
Обучение платное
Language
Английский
Duration
3.5 часа курса
Курс от Udemy
Чему вы научились?
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!)
О курсе

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:

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

  • Программа
    Welcome!
    Introduction to the Course and Your Instructors
    WATCH ME NOW!
    Welcome to the course!We really want you to finish this course.But instead of setting that as your goal, instead, we challenge you (!) to watch just 30 seconds a day for the next two weeks.That's it. Can you spare 30 seconds a day?I think you can.Note: 2 Links below:1.) Link to download Udemy's mobile app so you can learn on the go2.) Link to Stanford Professor BJ Fogg's Tiny Habits method (the inspiration for this 30 second challenge)
    A Note from Your Humble Leaders
    Getting Started (Downloading a Text Editor!) - All OS
    In this lecture we will take the first step to getting started!We will be downloading an AWESOME (and free) text editor called Sublime Text.http://www.sublimetext.com/
    Getting set up: No installation necessary!
    Intro to MySQL
    What the heck is a relational database?
    [QUIZ] What the heck is a relational database?
    This is just a short quiz to reinforce a couple of the points that we made in the last lecture.
    Da SQL Basics: Skeleton of a Query
    In this lecture we go over the basic outline of a SQL query.A SQL query is made up of three main sections and phrases. They are SELECT, FROM, WHERE
    BRAINBUSTER:
    • Write a query to find all customer names (first and last) and email addresses for customers of store number 2
    We will be showing you the query and answer for that brainbuster in the next lecture. Good luck!
    SQL QuerySkeleton
    Here are a couple questions about the structure of a SQL query.
    [Brainbuster] Build Your First Query!
    Требования
    • No previous technical knowledge required
    Лекторы
    A Course You'll Actually Finish
    A Course You'll Actually Finish
    A Course Series
    David Kim
    David Kim
    Product Manager at Udemy
    Peter Sefton
    Peter Sefton
    Data Scientist at Udemy
    Платформа
    /storage/img/providers/udemy.svg
    Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
    Рейтинг
    4.3
    (5513)
    (4177)
    (1515)
    (338)
    (264)
    Комментарии (11677)
    Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»