SQL Query Writing for Beginners
4.5 (62 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,457 students enrolled

SQL Query Writing for Beginners

Learn SQL in a Magical Way (with Cinderella and Fairy Tales)
4.5 (62 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,457 students enrolled
Created by Karen C
Last updated 8/2018
English
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 article
  • 50 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand what a Relational Database is and why it's so special. Have an understanding of how data is stored in a relational database and later retrieved for helpful purposes. Write fabulous SQL queries!
Requirements
  • You should be able to use a PC at a beginner's level.
Description

SQL is one of the most in demand skills a person can have.  Learning SQL can mean more money and more marketability.  Who doesn't want that?   If this wasn't enough, understanding how to use SQL gives you power because it allows you to get at information in ways those who do not know SQL cannot.  It allows you to understand data in an entirely new and mind expanding way.

So now that we covered "Why SQL?" let's talk  "Why This Course?"

This course is for you if don't necessarily consider yourself a techie person, but are interested in getting involved in one of the biggest, most in-demand industries in a fun way.   This course is also for you if you aren't a fan of boring textbooks but are a fan of whimsy.

Throughout this course, you will be taken into the Fairy Tale world where you will help Cinderella and her kingdom use data in all sorts of cool ways.    I have the strongest desire to make this class so fun and magical that you learn one of the top skills around in a completely pain free and delightful way.

One additional differentiation about this course is there are no barriers to entry.  You can start this course right away without downloading a lot of programs.  You can simply watch the videos and complete the activity sheets and at the end of the course, you will be well on your way to becoming a SQL query writing pro.  Many SQL courses and books will select a specific SQL program.  You’ll spend the first few lessons downloading all of these tools and be exhausted by the time you actually get to the course content.  I didn’t want to waste any of our time doing that in the start because this course is focused on the big concepts of SQL query writing and data retrieval. Once you get these big ideas down, understanding the slight variations in the various SQL programs are minor.  At the end of the course I have some recommendations on where to go next, but I wanted you to be able to take this course with nothing but a notepad or a word doc.   

Ready to get to your SQL query writing mastery?

Great!  Let's do this!

Who this course is for:
  • Anyone who wants to learn how to write awesome SQL queries. Anyone who likes fun and engaging lessons.
Course content
Expand all 28 lectures 03:07:17
+ Meeting the Team
10 lectures 01:10:04
Meeting the Team
05:10
Cathy Creator
06:12
Cathy Creator and Datatypes
09:45
Norma Notnormal
11:00
Primary Keys and Foreign Keys
08:42
Inga and Manny
09:51
Getting Data Out
04:47
Princessware
07:19
Data Entry Dwarves
01:30
Your Query Tool
05:48
+ Query Time!
7 lectures 51:07
The Where Clause
08:24
More Operators
07:11
Multiple Conditions
07:35
Even More Operators!
07:45
Functions
04:28
Group By
06:58
More Functions
08:46
+ Fancy Queries
7 lectures 43:53
Constants and Calculated Columns
07:17
Aliasing and Order By
08:01
Distinct
08:05
Inner Joins
03:26
Left Outer Joins
07:12
Sub-queries 1
09:12