Preview
Video Player
00:00
00:00
Introduction
1:28Find out what we'll be doing in this course and what you'll learn along the way!
[MUSIC]
0:00
Hi, I'm Ben, and in this course we're
going to practice writing SQL reports.
0:04
And we're going to do it from
the perspective of a business analyst
0:09
at a school.
0:12
Like many organizations,
schools have a lot of data, and
0:13
they often need help of
making sense of it all.
0:17
Writing reports for class sizes,
getting students' schedules, or
0:19
maybe even just figuring out what's for
lunch.
0:22
These questions can all be
answered by data in the database.
0:24
And it's going to be your job as
a business analyst to answer them.
0:27
These days, data is everywhere.
0:32
And while this course is centered
around a fictional school,
0:34
the SQL skills you use here will apply
equally well to any other field.
0:36
Once you've got down the basics, writing
reports is pretty similar wherever you go.
0:41
So to help you get some practice, in this
course we'll be sending you to a fictional
0:46
Jefferson Middle School, where you'll
be tasked with writing a series
0:51
of increasingly difficult reports to
help them start off the school year.
0:54
But don't worry,
we won't be sending you unprepared.
0:58
In the rest of this stage, we'll cover
exactly what their database looks like,
1:01
and then give you a few practice
problems to help you get comfortable
1:05
before your first day.
1:07
Also, if you a find a question you
can't answer, don't worry about it.
1:09
Each question will be followed
by a video of the solution.
1:13
So if you're ever feeling frustrated,
you can always just skip ahead and
1:17
see how I do it.
1:21
So whenever you're ready,
join me in the next video
1:22
to start learning how they organize
their data at Jefferson Middle School.
1:25