The video owner has disabled playback on external websites.
This video is no longer available on YouTube.
This video cannot be played right now.
Watch on YouTube
Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
学習統計
CEFRレベル
難易度
字幕 (331 セグメント)
- In this video you are gonna learn the basics
of SQL querying in just 15 minutes
and by the time we are finished
you'll be wondering what all the fuss was about.
Are you ready?
Then let's get started.
(upbeat music)
Hello and welcome to Vitamin BI,
bringing new business intelligence for beginners and beyond.
On this channel, I help you do more with data.
So if you are new here, consider subscribing.
Right, so as I said in my intro,
I'm going to teach you the basics
of SQL querying the essentials that you'll need to know
if you are considering becoming a business
intelligence analyst.
Obviously we can only go so far in 15 minutes
but I promise you that by the time we are finished
you'll be able to understand quite a lot
of what you might be called upon to do.
We'll be focusing specifically on querying data,
not creating or deleting databases, tables or data.
Just selecting data
from tables that we want to return for our specific needs.
Before we get started, let me give you a little context.
You might be wondering why you need to learn SQL.
With BI Tools becoming more and more sophisticated
can't they write the SQL queries for me?
The answer to that is yes and no.
Yes, when it comes
to requesting data for different charts, graphs
and tables that you might want to present in dashboards.
In these cases the BI tool will have some kind
of graphical interface to be able to drag
and drop fields to return data.
But no, in that in a lot
of cases you'll need to write SQL queries to
pre aggregate filter and select only the data necessary
for the project that you are working on.
These are often called views
and you create views mainly because it's more efficient
than connecting to all data when you only need some of it.
So you could have a table that contains millions
of rows of data, but by creating a view of it
your BI tool will only need to work
with a few thousand,
making analysis and presenting results much faster.
So you see, knowing how to query
with SQL is a useful skill to have.
Let's jump onto my computer and get started.
So today we are working
with a SQL light database that I found online
containing data compiled
from the FIFA video game by EA Sports.
So soccer stats, I'll leave a link to the database
in the description if you want to play around with it too.
In terms of the tool I'm using
to query the database, it's called Navicat.
It's the premium version that allows you to connect to
and query pretty much any relational database
but they also have a version
for specific RDBMS, like MySQL, SQL Server, et cetera.
Link also in the description.
Here we are in the Navicat interface.
On the left we can see that I'm connected
to the Soccer DB connection that I've created
and in that connection is a database called main.
完全な字幕は動画プレーヤーで利用可能
コメント (0)
ログインしてコメントインタラクティブモード
クイズ
正解:
クイズ
正解:
動画を見ながらクイズが表示されます
覚え方のコツ
この動画より
無料で語学を始める
