Azure SQL Database tutorial with an end result of a working PowerApps sql app

In this video, you will learn how to get started using Azure SQL Databases. This video is focused on making sense to technical and non-technical users alike with a focus on getting you productive as quickly as possible.

If you are into PowerApps this is everything you need to know to go from building apps on SharePoint or Excel and doing them with true SQL.

You will learn how to:
* Sign up for an Azure SQL account
* How to make your first database
* How to install SQL Management Studio
* How to export your existing Excel file into SQL
* How to create a SQL primary key
* And how to build a PowerApp from that data

CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (MyID)

Video: PowerApps on-premise SQL Databases

[againstthemachine]

I struggled not being able to edit my fields, only to find out that I didnt set a PK on one of my tables and you mentioned it at the end of this video. You saved me hours of frustration. Thank you boss!

[dannipals]

It's 2021 - And this is the best video I have seen for Primary key. You could rebrand/rename this video for "SQL set primary key - tutorial"

[taichi]

Thanks Shane for the great video! You made it fun and easy to learn. One thing to point out though, in your video at 23:30 when you execute the query again, your query wasn't actually showing the MyID column as you said. In order to see that new identity column, you'll either need to regenerate the select query from the table or add the MyID column to that existing query.

[rolando]

Hello Shane,

Thank you for all these video lessons. Sharing all this knowledge with us it is a philanthropic act. I want to let you know that I'd like to see more videos about "PowerApps and Azure SQL Databases".

[FSWEB]

Hi mate.
Fantastic tutorial!
I like how you go straight to the point, no tech talk...
Thanks for taking the time to do this.

[jayong]

OMG Shane! your PRO TIP saved me!! The edit form appeared after adding the primary key. Thank

[ricksegalCanada]

Crazy weird you don't have a zillion subscribers. Your videos are outstanding.

[mariocibao]

Shane Thanks, this video goes right to the point of what I was looking for.

[andresmota]

Nice tip about plus button not visible in powerapps.
Thanks for all your videos.

[hoyty]

Thanks for the video. Watched and created first Azure SQL instance. Got it connected to Powerapps as replacement for Sharepoint List.

[JimmyC_Dev]

You REALLY saved my bacon re: that Primary Key - THANKS!!!!

[cristiancampo]

Thanks Shane for yet another amazing video! just a quick question, do I need to provide access to the SQL db for all my users? I tried doing an app with SQL connection, I can see the data but they cant. Thanks again for your amazing help on the PowerApp community

[adrianrolon]

In that example you are the administrator of that database. How can other people use the app, adding, eliminating and editing records? Do you manage those permissions from power apps or do you require a special configuration at SQL Managment Service to grant those permissions? Great video as always!

[stuartrobinson]

Another great vid. Helped me sus out connecting canvas app to Azure SQL. Thanks

[TheSuperbabb]

Nouuu, the primary key .... Many thanks for the TIP !!!

[pastorlightfoot]

Another great video Shane. Really liked how you stepped through every step along the way,

[uniQue_XL]

Great vid!!
As a non sql users that was very clear explanation.
Thanks a lot!!

[GinGersound]

Shane - great Video (as always)!

Quick question. Why is CDS better than SQL? Currently using SharePoint lists with my first app but I’m currently evaluating data solutions for the next version of our internal business app. As a data analyst I’m naturally drawn to SQL but I don’t want to overlook the better solution.

[jlh]

Great Azure SQL Database tutorial Shane! Much appreciated!! Once an application is created, how are others allowed to access the SQL Database? Are apps built using an application ID that has RW but not admin? Or does each user need to have an Azure/SQL License?

[KP-bvrh]

Great Vid!
One correction - in your query to add a primary key you should replace with "PK_VideoData_MyID".