Alex, thank you for this video! Yesterday I tried to create SQL server on Azure myself, but stucked...and today I foud your video, repeated all steps and done my issue!
I had an issue where Azure Data Studio it wouldn't show me my database when trying to make a new connection. If this happens to you I solved it by deleting the cache files located at C:\Users\\AppData\Roaming\azuredatastudio\Azure Accounts and then restarting Azure Data Studio.
Alex, thank you for this video! Yesterday I tried to create SQL server on Azure myself, but stucked...and today I foud your video, repeated all steps and done my issue!
Do video on how to clear azure AZ 900 certificate it helps a lot
Can you please upload advanced level Data Analytics projects for experienced professionals portfolios in Excel, SQL and Power BI 🏂
I had an issue where Azure Data Studio it wouldn't show me my database when trying to make a new connection. If this happens to you I solved it by deleting the cache files located at C:\Users\\AppData\Roaming\azuredatastudio\Azure Accounts and then restarting Azure Data Studio.
How do I get started educating myself to become a Data Analyst?
Complete Alex's bootcamp.
Sql databases are going to be taken over by Fabric ecosystem.
10:12
CREATE TABLE products (
product_id INT NOT NULL PRIMARY KEY,
product_name VARCHAR(50) NOT NULL,
units_in_stock INT NOT NULL,
sale_price DECIMAL(4,2) NOT NULL
);
INSERT INTO products VALUES (1001, 'Chocolate Chip Cookies', 200, 1.50);
INSERT INTO products VALUES (1002, 'Banana Nut Muffin', 180, 2.50);
INSERT INTO products VALUES (1003, 'Croissant', 70, 1.75);
INSERT INTO products VALUES (1004, 'Cheese Danish', 55, 1.85);
INSERT INTO products VALUES (1005, 'Cannoli', 112, 2.25);
INSERT INTO products VALUES (1006, 'Sweet Bread Loaf', 32, 15.50);
INSERT INTO products VALUES (1007, 'Strawberry Macaron', 98, 2.00);
INSERT INTO products VALUES (1008, 'Coffee Cake', 25, 13.00);
INSERT INTO products VALUES (1009, 'Carrot Cake', 15, 14.50);
INSERT INTO products VALUES (1010, 'Chocolate Covered Doughnut', 80, 1.00);