This was a fantastic video. I'm not entirely new to SQL, but I've only ever used it at work on a fully configured/connected SQL Server that a coworker set up for me so I could do the queries I need to do. So I was pretty clueless trying to get this set up on my home machine. Looking forward to messing around at home and getting better at all of this.
Ctrl + S, Also you can change the table name by right clicking and going to properties, In right pane change name (Name) to the name you prefer. Default its ur DB name. Also if the table is already created. you can right click "dbo.table" into the name you prefer
I've got an interview coming up for a sysadmin role where the most important task is SQL server management and I've never even heard about this technology as someone who just programs. When I hear you speaking in terms of 'when you'll be working, it'll be such and such', it literally is an anxiolytic. I'm going to be sending my application in a week, it's by a reference, and I REALLY need this job. I'm going to come back here in 1-2 weeks and report if I actually got the job or not. But if I do, man, it'll be because of you!!!
Went through the whole series. It was great. Helped a lot with my module. Everything is clear and clean. Also good examples. It would be nice if u could add what shortcut keys you use. overall it's great 5/5
7:22 Hiya, great video! I’m trying to import the WideWorldImporters sample database using restore database in the object explorer, but I get the message “an exception occurred while executing a Transact-SQL statement or batch”. I’ve got the database .bak file in my backups folder in my SQL program files but it’s still not showing! Dyou know any fixes for this? Thanks :)
Thank for the tutorial. Is it possible in SQL Server for users to create DBs for different analysis scenarios much like they would do in Access? We tend to use Access like Excel, so everyone has Access DBs on their desktop to run analysis scenarios.
Thank you for this Teddy. May you do a series on how to connect a C# project to a SQL Server Database and run a GUI with buttons? I'm running Visual Studio 2022.
At around 11:30 You say you have to Refresh to show the Table.. I actually had to save the table first and then it showed up... You don't really allude to it, call me dumb but it took me a bit to get to that point to realize what you did and then refreshed to show the table in the Object Explorer.
Hi, great video! I tried downloading micrsoft SQL server, but it's not supported by MAC. Do you have any work-around or recommend another SQL server that is supported by a MAC?
I figured it out - I typed in the same thing he had, but with my computer name instead of his, clicked connect, and clicked through a few warning messages.
I created DBTest but I cannot see it. It does not appear. When I create it again it says it already exist. I created a different one and it is not appearing.
hi, I have followed your step and done install the ssms after restart my laptop but it can't show up in my laptop, so I can't open my ssms. Anyone know the reason
@@TeddySmithDev Looks like it's a Teddy takeover in the tech tutorial universe! I just hit subscribe on your channel, making it an official Teddy double feature. The world better brace for the bear-y best in tech content. Let the Teddy tutorials begin - may the most pawsome channel win! 😅
This was a fantastic video. I'm not entirely new to SQL, but I've only ever used it at work on a fully configured/connected SQL Server that a coworker set up for me so I could do the queries I need to do. So I was pretty clueless trying to get this set up on my home machine. Looking forward to messing around at home and getting better at all of this.
I am a complete beginner to sql and this video was so clear, helpful and informative. Thank a lot for this great video!
Heyy im a beginner too but I’m lost , any tips?
@@EddieEmma-mj2ht stop hitting girls on youtube lol
@@EddieEmma-mj2ht Use a map
Simple, clear, and to the point. Best dang tech video on youtube.
Hey at 11:10 what did u actually press to rename the table?
and my table is still not appearing
Press Ctrl+S (to save) and it will prompt you to rename table. Ta-da welcome
Ctrl + S, Also you can change the table name by right clicking and going to properties, In right pane change name (Name) to the name you prefer. Default its ur DB name. Also if the table is already created. you can right click "dbo.table" into the name you prefer
Thanks!
Wow! You must be rich to be giving out $10 lol
Awesome Introduction!! New to MS SQL from Oracle database world. This is very informational. Very clear, simple and practical!
Thank you very much! This really helped as I had many issues trying to install the software.
Starting from the ground up. Thank you!
Definitely the best sql intro video I've ever come across
Just started on it! Very informative and refreshing. Natural born teacher. Keep it up!💯
Brilliant! Clear, informative, compact.
I've got an interview coming up for a sysadmin role where the most important task is SQL server management and I've never even heard about this technology as someone who just programs. When I hear you speaking in terms of 'when you'll be working, it'll be such and such', it literally is an anxiolytic. I'm going to be sending my application in a week, it's by a reference, and I REALLY need this job. I'm going to come back here in 1-2 weeks and report if I actually got the job or not. But if I do, man, it'll be because of you!!!
Any Update?
yeah man , give us something
Hey man, where are you now?
Bruh
Please update bud
Great tutorial - I really appreciate the flow and energy of your telling!
I am a beginner to SQL and i started watching this tutorial, the way you are explaining is clear and understandable. Keep it like this 👍
Dear Teddy. Thank you for preparing and sharing this course. I do appreciate your great work.
I will follow this playlist all the way through. Thank you for this tutorial series 😊⭐️⭐️⭐️⭐️⭐️ 5 star tutorial by Teddy as always
Yes the video was helpful and added value, like always with all of your videos Teddy. Thanks man!
Thanks Jeff!
Concise and crisp. Thanks Teddy
great value, you were very clear, ease to understand, and really explained it to start bring value as soon as possible to the team.
Went through the whole series. It was great. Helped a lot with my module. Everything is clear and clean. Also good examples. It would be nice if u could add what shortcut keys you use. overall it's great 5/5
Thank you for starting this series
I've learned so much. Thank you for sharing your knowledge to us.
Thank you for your help very I wish you all the best in future
Thank you for the tutorial, It's very helpful!
No prob. Thank you for your time!
7:22 Hiya, great video! I’m trying to import the WideWorldImporters sample database using restore database in the object explorer, but I get the message “an exception occurred while executing a Transact-SQL statement or batch”. I’ve got the database .bak file in my backups folder in my SQL program files but it’s still not showing! Dyou know any fixes for this? Thanks :)
great video! Thanks!
Excellent meaaaAAANN. Thanks a lot.
Awesome vid! Thanks!
Very useful.Many thanks :)
thank you every information you provide was very clear and easy
Excelente explicación!!!!
great video bro
Informative and easy to follow. ❤
What did you click when you enter a name for the table?
press Ctrl then S
i love this guy. i wish we can be friends lol
man!! this is so valuable!
Thank for the tutorial. Is it possible in SQL Server for users to create DBs for different analysis scenarios much like they would do in Access? We tend to use Access like Excel, so everyone has Access DBs on their desktop to run analysis scenarios.
for simple scenarios, you would prob just give analysts only read access and let them work directly with centralized server.
@@TeddySmithDev Thank you.
Thank you very much
Thank you for this Teddy.
May you do a series on how to connect a C# project to a SQL Server Database and run a GUI with buttons? I'm running Visual Studio 2022.
No plans for desktop because I’m web dev. You can watch my other tutorials if you want a web versionz
At around 11:30 You say you have to Refresh to show the Table.. I actually had to save the table first and then it showed up... You don't really allude to it, call me dumb but it took me a bit to get to that point to realize what you did and then refreshed to show the table in the Object Explorer.
Thank you for sharing. Helps others troubleshoot 👍
Hi, great video! I tried downloading micrsoft SQL server, but it's not supported by MAC. Do you have any work-around or recommend another SQL server that is supported by a MAC?
For ARM, a docker instance of “Azure SQL Edge” plus Azure Data Studio. For intel, just docker sql server and Azure Data Studio.
@@TeddySmithDev thank you very much!! this is really helpful
07:03 i cant choose any Server Name.. Whats wrong?
you have to save the table first
@@AmruthRajPichandi how do you save the table?
I figured it out - I typed in the same thing he had, but with my computer name instead of his, clicked connect, and clicked through a few warning messages.
THANKS
LIstening to this.. being a DBA.. and giggling. LOL
I just got normalized!!!!!
I created DBTest but I cannot see it. It does not appear. When I create it again it says it already exist. I created a different one and it is not appearing.
Try to right click on the database tree and click Refresh. When you create a database using T-SQL, SSMS does not refresh the GUI.
hi, I have followed your step and done install the ssms after restart my laptop but it can't show up in my laptop, so I can't open my ssms. Anyone know the reason
banger video series
thanks a lot!!!
how did you get it to start cause mine keeps failing?
There's no popup notification to make me write a name for the datatype
hello Im miko oro good student
👍
great video!
what can i do if i dont know mt Server name? how can i get it?
Everybody: Why we are downloading version 2019 if the title says 2022? There is an upgrade afterwards in the course? Many tanks.
Awsome !
hey Teddy, you ever think about trying the Barkley Marathons?? =]
I’m planning on running Barkley Classic next year (hopefully) !
@@TeddySmithDev That's probably a more realistic goal haha
What is uses SQL for?
Your discord link doesn't work anymore.
how can i install this program on linux??
loved it
what if i am on an apple silicon mac?
use Azure Edge docker image with Azure Data Studio. It's newer way better. When I remake course in 2025-2026, that's what im using.
IS THIS SQL FREE TO INSTALL?
Yes
He calls S-Q-L "sequel" but calls "GUI" G-U-I made me laugh.
Bro my Name 😂
Lmao I subbed. Two Teddy’s 2 Many Views 🤣
@@TeddySmithDev Looks like it's a Teddy takeover in the tech tutorial universe! I just hit subscribe on your channel, making it an official Teddy double feature. The world better brace for the bear-y best in tech content. Let the Teddy tutorials begin - may the most pawsome channel win! 😅
My staff uses Excel as a database. Excel is NOT a database and stop using as one 😂
I think you should make a detailed script for your videos so you don't stumble over it too much. It's distracting and difficult to understand.
"Excel on steroids"
Teddy Smith saving the day! 🦸 Thanks for the Help! 🙌