Practical SQL Beginner Tutorial Using Adventureworks Database Part 1

SQL is one of the fastest-growing programming languages. It is widely used by Data Analyst, Data Scientist, Database Administrators, Backend Developers, etc..

As an aspiring Business Intelligence analyst and Data Analyst, you are often faced with data from different databases as against the conventional Excel files you learnt building visualization with.

You will need to demonstrate a very good knowledge of SQL as business questions will be answered not just through the drag and drops Power BI environment but by demonstrating an understanding which addresses where the data required to answer this question resides in the database, how to retrieve it, what format must it be to be fit for the analysis, etc..

This is why you need to learn Structured Query Language. Business questions beget Queries.

As a beginner or intermediate learner, this series of videos will help you learn SQL in a practical way.

These are the few of the queries written in this video
select * from [HumanResources].[Employee]
select loginid, JobTitle, HireDate from [HumanResources].[Employee]
select top 20 loginid, JobTitle, HireDate from [HumanResources].[Employee]
select * from Person.Person
select FirstName, LastName from person.Person
select FirstName + ' ' + LastName as Fullname from person.Person

Please click this link to check the previous videos in this series:

The ultimate goal of this video series is to teach how to Analyse data using Microsoft Power BI and SQL Database.
#adventureworks #database #mysql #sqltutorial

[samuelarojojoye]

This is very helpful Mr Ola. You are also a good teacher, thank you. Looking forward to the subsequent videos

[vigcee]

Great teaching bro. Keep up the good work. You are a great teacher. I will always recommend you.

[azeezadegbenro]

Thank Ola Charles, Always making learning so simple and fun!!! I learned, practiced and got results. Glad to journey with SQL more.

[padhmeshu]

awesome video.. I did watch 2 other video of others but they didnt explain properly as you did.. appreciate it.

[GABGITAU]

does anybody has a link to practice sql querries and answers related to ms adventureworks ? pls share

[covenantolayinka]

Thank you so much. I was getting frustrated until I stumbled on this video.

[rosemaryojo]

Exactly what I needed, very explanatory thank you for this.

[monographicmonologues]

Good tutorial. I hope to see many more!

[georgeaboh]

Thanks Ola for this video. You are good in imparting knowledge.

[azeezadegbenro]

Question: pls what is the query to write if i want to see the "bottom'' instead of top?