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
Desbloqueie ferramentas de aprendizado com IA
Cadastre-se para acessar ferramentas poderosas que ajudam a aprender mais rápido com cada vídeo.
Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
Estatísticas de aprendizado
Nível CEFR
Dificuldade
Legendas (331 segmentos)
- 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.
Legendas completas disponíveis no player de vídeo
Pratique com exercícios
Gere exercícios de vocabulário, gramática e compreensão deste vídeo
Comentários (0)
Faça Login para ComentarCadastre-se para desbloquear todos os recursos
Acompanhe seu progresso, salve vocabulário e pratique com exercícios
Modo interativo
Questionário
Resposta certa:
Vídeos relacionados
The Godfather - Luca Brasi
(Black Mirror) San Junipero - I Guess I'm Ready
You can be happy without changing your life | Cassie Holmes | TEDxManhattanBeach
What is schizophrenia? - Anees Bahji
Two “Game of Thrones” actors reveal how the show’s scripts are kept secret
Adam Finer - Learn BI Online
Questionário
Resposta certa:
Os quizzes aparecem enquanto você assiste ao vídeo
Dica de memorização
Deste vídeo
Aprenda idiomas de grátis
