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)
تسجيل الدخول للتعليقالوضع التفاعلي
اختبار
الإجابة الصحيحة:
فيديوهات ذات صلة
Dune: Part Two (2024) 4K - Paul Kills Baron Harkonnen | Movieclips
Margot Robbie's Hilarious Speech for Brad Pitt's Supporting Actor Win | EE BAFTA Film Awards 2020
The Ending Of Breaking Bad Finally Explained
Master in Bio-Pharmaceutical Sciences - Leiden University
Quidditch World Cup | Harry Potter and the Goblet of Fire
Adam Finer - Learn BI Online
اختبار
الإجابة الصحيحة:
تظهر الاختبارات أثناء مشاهدة الفيديو
نصيحة للحفظ
من هذا الفيديو
ابدأ تعلم اللغات مجاناً
