Writing your first SQL Statement!

New to writing T-SQL? Patrick walks you through your first SQL statement. Great foundation to have when working with SQL Server or Azure Synapse Analytics!

Download SQL Server Management Studio

Download and install Azure Data Studio

Transact-SQL Reference (Database Engine)


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#AzureSynapse #SQL #GuyInACube

[anhquaranta]

Please do more of these SQL queries! Love to learn about all the other joins as well as stacking tables!!

[kiterbram]

Great video, Patrick.

Would be great to have more SQL videos as it’s an important starting point for data analysts.

Knowing the ETL process, formatting PBI reports & DAX is cool. But it can be frustrating if your initial database is poorly managed & structured.

Would love to learn more about this topic!

[AmritaOSullivan]

Omg. I series on tsql would be amazing

[CrazySwde]

Love that you guys are branching out to other BI tools! Definitely interested in hearing more in the future for when you utilize non-Power BI tools for more complex solutions

[richardgavatin]

Please do more of these SQL queries! A little more complex examples in the next one, temptables, drop tables, multiple joins etc. thanks

[eziola]

Keep the series going! All the way to pivoting data using T-SQL! I like the under 10 minute length

[INDYEAH]

Please do these real time use cases more .. we found all definition stuff online and standard syntaxes but this is really helpful and meaningful why and how we use SQL queries to get the job done !
Please do more of these ! Thank you so much for knowledge.

Your video editing skills are top notch

[StuartGeers]

Can we get more videos (and or a whole series) around sourcing data from SQL tables, especially tables that have many to one relations?

[andrewmayes]

I just started learning SQL this week, on YT of course. Want to use it to advance my career and be an asset to my company. I have always enjoyed y’all’s channel and am excited to follow more SQL here!

[priyanksharma]

I would appreciate more such videos on SQL. Thanks Patrick

[MattiasGregersen]

You described me well - straight into DAX no SQL. But this made it look not so daunting, feels logical 🙂

[triscachappell]

Watch you guys all the time for powering. Please make more sql videos.

[Crazyexycurvy]

This was great - If only my introduction to SQL had been this gentle. This is a very nice way of introducing SQL without it being scary lol.

[egorshiyanov]

Great video as always!
Also want to note that in the case where names of the key columns are identical you can use this pattern: FROM Table1 AS t1 JOIN Table2 AS t2 USING(Key12)
Looking forward to the next video 👍

[MrFastYouxXx]

Hi Patrick,
Can you show us sth about the sql execution plan like best practices, optimization and so on?
That would be great!

[NaraMeerammaTrust]

Very good video explaining all basic SQL foundation required for a Bi consultant.👍👍👍

[manuelromero]

Great video for people starting! Give us some more please!!

[mwaltercpa]

Thank you for this video! Another vote for more SQL please :)

[tanviikhar]

yes want to learn more about azure synapse. Please make more videos.

[asjones]

love this and was looking for others like this for my son to understand the concepts of a relational database, basic T-SQL etc.