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)
برای نظر دادن وارد شویدثبتنام کن و همه امکانات رو باز کن
پیشرفتت رو دنبال کن، واژگان رو ذخیره کن و تمرین کن
حالت تعاملی
آزمون
پاسخ صحیح:
ویدیوهای مرتبط
Watch a Seahorse Give Birth to 2,000 Babies | National Geographic
Harvard Orator Eunice Alison Nyang’or Mwabe | Harvard Commencement 2019
SQL Basics for people with no prior knowledge 🤷♀️🤷♂️
How Did the 'Unsinkable' Titanic End Up at the Bottom of the Ocean? | National Geographic
What polls can actually tell us
Adam Finer - Learn BI Online
آزمون
پاسخ صحیح:
آزمونها هنگام تماشای ویدیو ظاهر میشوند
راهنمای حفظ
از این ویدیو
شروع رایگان یادگیری زبان
