SQL for Business

Learn exactly how to query databases and extract data so you can get a job, or improve your career with sound analysis.
3.7 (11 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
147 students enrolled
$100
Take This Course
  • Lectures 15
  • Contents Video: 1 hour
    Other: 1 min
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

No setup required! If you have an internet connection, you can do everything in this course (including the hands-on work)

  • Getting started with SQL queries (SELECT, JOIN, WHERE, etc.)
  • Aggregate Functions (SUM, MAX, AVG, etc.)
  • Comparison of Excel functions and queries

Your Story

Sue is a business professional for a growing startup in Silicon Valley. She runs marketing campaigns for her firm, but doesn't know how to aggregate the data from these efforts. As a result, she doesn't have a firm grasp on what is and isn't working. She knows she would be more valuable to the company if she could interpret the data and give her managers detailed results.

Jerry is a student finishing up his degree and looking to get into the business field. His instructors say it is important to have something that makes you stand out from the crowd, and Jerry wants to stand out with his ability to interpret numbers and make business decisions. His only problem is that he doesn't know how to access and pull the information he needs from databases. He has explored various SQL blogs online, but hasn't been able to find a comprehensive course that can give him the confidence to pull data from databases on his own.

Our Story

Tom and Taylor work with SQL on a daily basis as database engineers. But the road to understanding SQL was not an easy one. Even though they both have degrees in Information Systems, they were taught very little SQL in school. What about online courses? All they could find were free bits of information with little instruction on the one end, to complex certification courses that assumed the reader was well-versed in tech talk on the other end. The road wasn't easy, and getting their first SQL job was a mystery, because they didn't really know what they were getting into. After finding out the hard way, Tom and Taylor have discovered how to learn fast and easily. They know how to cut past the tech-talk and get straight to practical application, where all the real learning happens. They have created this course for you, so that you can learn quickly and get to improving your business processes.

Master SQL To Use In Your Business Analysis

  • Hands-on SQL Writing and Coaching
  • Report Retrieval From SQL Database
  • Advanced SQL Filtering

Feel Confident in Your Ability to Write and Interpret SQL

As we move further into the 21st century, massive amounts of data are collected on a wide variety of topics. Once you have the data, you can analyze it - but what if you don't know how to extract the data in the first place? SQL is the way that your data is stored, and you need to be able to find that data to understand it. Your ability to interpret information is tied to your effectiveness as a business person, and is linked with your worth to your company. If you are looking for a raise or promotion, or even a better job altogether, you will need to know SQL.

Content and Overview

In over 2 hours, this course covers how to extract data from SQL databases to generate a variety of business reports. To get good at SQL, you are going to need motivation. And there is no better way to get that motivation than to quickly have a tangible product of your efforts. That is why after the first video, you will have already used a database to create your first business report. That's right, this isn't a "sit back and watch the instructor" kind of course - you'll be writing SQL yourself, right from the get go. Don't worry though, we'll guide you along the whole process, and demonstrate before asking you to follow suit.

From there, we'll repeat the process with 3 other reports, each time adding new elements to give us more useful data. Admittedly, it might feel a little like a whirlwind, but you'll be excited at your new-found skills, and after the initial report making, we will take you back and review all of the fundamentals, so that you will feel confident that you can reproduce your results when you are on your own.

Who is this course for?

  • Business professionals who need to know how to get information from databases (learn general SELECT statements)
  • College students looking to enter the business world
  • NOT for SQL professionals looking to take their database skills to the next level
  • NOT for people who already understand basic SELECT statements. This course will not cover new material if that's the case

What will students need to know or do before starting the course?

  • Make sure you have an internet connection so you can watch the videos and browse to our website for doing the course exercises. You won't need any other materials for this course
  • Get in the mindset to learn quickly and jump right into practical application. This is not one of those courses where you sit back and watch hours of video
  • NO prior SQL knowledge is required

What makes this course different?

  • No setup is required. You will be able to run all of your SQL from our site, whether you're on your phone, or on your computer.
  • There is no fluff in this course. You'll learn the basics of SQL by immediately using databases to create business reports. We'll go through how to make the reports initially, explain what is going on, and then go back through the reports more in depth

At the end of my course, students will be able to...

  • Confidently run general SQL that will fuel your business analysis
  • Create a customer reports, employee performance reports, product trend reports, and customer value reports, all from the SQL database

What are the requirements?

  • No experience or knowledge is required - everything is shown in this course!
  • Have access to a desktop computer with internet (phones can work, although it will be tough to practice on a small screen)
  • Be ready for hands-on learning right from the start

What am I going to get from this course?

  • Make data-driven decisions
  • Navigate database data
  • Increase personal worth to the company
  • Track marketing efforts

What is the target audience?

  • College students entering the business sphere
  • Business professionals

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Basics
Introduction
Preview
04:11
The Basics
Preview
02:43
3 questions

Let's see what you've learned so far!

Section 2: Customer Report
Link For SQL Play Pen
Article
SELECT and FROM Clauses
Preview
05:04
WHERE Clause
04:38
SQL Queries Used In This Section
Article
SELECT and FROM Clauses
3 questions
Section 3: Employee Performance Report
Selecting Multiple Tables At The Same Time With JOINS
04:29
Using The ON Clause To Properly Match Joined Tables
07:04
Choosing Columns For The SELECT Clause
05:46
Filtering With The WHERE Clause
04:16
SQL Queries Used In This Section
Article
1 question

JOINS, ON Clause, selecting specific columns

Section 4: Product Overall Performance Report
Aggregate Functions
05:14
GROUP BY Clause
04:38
SQL Queries Used In This Section
Article
Aggregation and GROUP BY
2 questions
Section 5: Course Summary
Course Summary
04:16

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Taylor Chiu, SQL Database Engineer, Web Designer, Instructor

Hi there, my name is Taylor Chiu of LearnToSQL. Ever feel like you want to know more about coding or other tech stuff, but can't because you aren't good at it, or can't speak the lingo? If so, I've been in your shoes, and I know how to get past that sticking point. I'm more naturally a business and sports guy, but made the transition into my current job of database engineer (where I've been for the last 2 years) because I wanted to expand my horizons. It hasn't been an easy process, but it has been very rewarding.

The thing is, anyone can get good at tech, you just have to be persistent. And it doesn't hurt to have someone who can speak to you in a way you understand, until you're able to understand the ins-and-outs technically. That's what I want to provide for you.

Ready to start learning?
Take This Course