SQL Server Tutorial For Beginners | SQL Server Management Studio Install & Tips 2022

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 106

  • @czanderrr
    @czanderrr 4 місяці тому +11

    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.

  • @aayushisinghbais2133
    @aayushisinghbais2133 Рік тому +28

    I am a complete beginner to sql and this video was so clear, helpful and informative. Thank a lot for this great video!

    • @EddieEmma-mj2ht
      @EddieEmma-mj2ht 4 місяці тому

      Heyy im a beginner too but I’m lost , any tips?

    • @edgarsi
      @edgarsi 2 місяці тому

      @@EddieEmma-mj2ht stop hitting girls on youtube lol

    • @IMMABUSTYOURASS
      @IMMABUSTYOURASS Місяць тому

      @@EddieEmma-mj2ht Use a map

  • @apdoahmed9495
    @apdoahmed9495 Рік тому +32

    Hey at 11:10 what did u actually press to rename the table?
    and my table is still not appearing

    • @chongweikhang2369
      @chongweikhang2369 11 місяців тому +24

      Press Ctrl+S (to save) and it will prompt you to rename table. Ta-da welcome

    • @CoolMonkey_at_his_PRIME
      @CoolMonkey_at_his_PRIME Місяць тому

      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

  • @betallyoungattractive644
    @betallyoungattractive644 6 місяців тому +5

    Simple, clear, and to the point. Best dang tech video on youtube.

  • @alivalishov
    @alivalishov Рік тому +1

    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 👍

  • @linzileong
    @linzileong 2 місяці тому

    Awesome Introduction!! New to MS SQL from Oracle database world. This is very informational. Very clear, simple and practical!

  • @Edu1923
    @Edu1923 8 місяців тому

    Starting from the ground up. Thank you!

  • @kopilkaiser8991
    @kopilkaiser8991 2 місяці тому

    I will follow this playlist all the way through. Thank you for this tutorial series 😊⭐️⭐️⭐️⭐️⭐️ 5 star tutorial by Teddy as always

  • @PRNTCo-s5p
    @PRNTCo-s5p 7 місяців тому

    Just started on it! Very informative and refreshing. Natural born teacher. Keep it up!💯

  • @flavianunes7423
    @flavianunes7423 2 роки тому +3

    Thank you very much! This really helped as I had many issues trying to install the software.

  • @CoolMonkey_at_his_PRIME
    @CoolMonkey_at_his_PRIME Місяць тому

    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

  • @jeff-creations
    @jeff-creations 4 місяці тому

    Yes the video was helpful and added value, like always with all of your videos Teddy. Thanks man!

  • @maksymandrzejdrzyzgiewicz5096
    @maksymandrzejdrzyzgiewicz5096 Рік тому +16

    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!!!

  • @emmanuelphiri2086
    @emmanuelphiri2086 Рік тому

    Definitely the best sql intro video I've ever come across

  • @paweweichbroth7972
    @paweweichbroth7972 5 місяців тому

    Dear Teddy. Thank you for preparing and sharing this course. I do appreciate your great work.

  • @opowiadacz4335
    @opowiadacz4335 10 місяців тому

    Great tutorial - I really appreciate the flow and energy of your telling!

  • @Coder991
    @Coder991 2 роки тому +2

    Brilliant! Clear, informative, compact.

  • @data_kom
    @data_kom 7 місяців тому

    Concise and crisp. Thanks Teddy

  • @CMT-p6q
    @CMT-p6q Рік тому

    great value, you were very clear, ease to understand, and really explained it to start bring value as soon as possible to the team.

  • @boddaamar5006
    @boddaamar5006 9 місяців тому

    Thank you for your help very I wish you all the best in future

  • @shameless-samurai
    @shameless-samurai 8 місяців тому

    Thank you for the tutorial, It's very helpful!

    • @TeddySmithDev
      @TeddySmithDev  8 місяців тому +1

      No prob. Thank you for your time!

  • @StraitProtein
    @StraitProtein Місяць тому

    i love this guy. i wish we can be friends lol

  • @jaycobkelbs
    @jaycobkelbs Рік тому

    I've learned so much. Thank you for sharing your knowledge to us.

  • @SasBald
    @SasBald 6 місяців тому

    Thanks!

    • @TeddySmithDev
      @TeddySmithDev  6 місяців тому

      Wow! You must be rich to be giving out $10 lol

  • @PhillStone
    @PhillStone Місяць тому

    great video! Thanks!

  • @rolivasarhelyi
    @rolivasarhelyi 2 роки тому

    Thank you for starting this series

  • @patmarek1222
    @patmarek1222 8 місяців тому

    Awesome vid! Thanks!

  • @Joseph-sq6ir
    @Joseph-sq6ir 9 місяців тому

    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 :)

  • @edgardomachado2704
    @edgardomachado2704 Рік тому

    thank you every information you provide was very clear and easy

  • @Cyclist_Adanvanture
    @Cyclist_Adanvanture 3 місяці тому

    Excellent meaaaAAANN. Thanks a lot.

  • @samr317
    @samr317 5 місяців тому

    Very useful.Many thanks :)

  • @jaidenmcneeley3930
    @jaidenmcneeley3930 2 місяці тому

    banger video series

  • @segaran
    @segaran Рік тому

    man!! this is so valuable!

  • @DanaYMama
    @DanaYMama Рік тому

    Informative and easy to follow. ❤

  • @xaiveradams1372
    @xaiveradams1372 Рік тому

    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.

    • @TeddySmithDev
      @TeddySmithDev  Рік тому

      Thank you for sharing. Helps others troubleshoot 👍

  • @jclopez4079
    @jclopez4079 Рік тому +2

    What did you click when you enter a name for the table?

  • @tu_mateusz
    @tu_mateusz Рік тому +1

    07:03 i cant choose any Server Name.. Whats wrong?

  • @adomako5863
    @adomako5863 2 роки тому +2

    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.

    • @TeddySmithDev
      @TeddySmithDev  2 роки тому +2

      No plans for desktop because I’m web dev. You can watch my other tutorials if you want a web versionz

  • @LibertyGarden
    @LibertyGarden 2 місяці тому

    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.

    • @TeddySmithDev
      @TeddySmithDev  2 місяці тому +1

      for simple scenarios, you would prob just give analysts only read access and let them work directly with centralized server.

    • @LibertyGarden
      @LibertyGarden 2 місяці тому

      @@TeddySmithDev Thank you.

  • @tiobeto6983
    @tiobeto6983 4 місяці тому

    Excelente explicación!!!!

  • @ZapRodil461
    @ZapRodil461 8 місяців тому

    Awsome !

  • @codevanie-misery
    @codevanie-misery Рік тому +1

    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.

    • @SQLPVP
      @SQLPVP Рік тому

      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.

  • @aiupal7490
    @aiupal7490 Місяць тому

    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

  • @quangvungoc307
    @quangvungoc307 2 роки тому

    great video!

  • @AliceWerner-h9n
    @AliceWerner-h9n Рік тому +1

    LIstening to this.. being a DBA.. and giggling. LOL

  • @ayanfeatolagbe
    @ayanfeatolagbe 10 місяців тому

    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?

    • @TeddySmithDev
      @TeddySmithDev  10 місяців тому +1

      For ARM, a docker instance of “Azure SQL Edge” plus Azure Data Studio. For intel, just docker sql server and Azure Data Studio.

    • @ayanfeatolagbe
      @ayanfeatolagbe 10 місяців тому

      @@TeddySmithDev thank you very much!! this is really helpful

  • @sutofana
    @sutofana 26 днів тому

    loved it

  • @harrisonwright3900
    @harrisonwright3900 11 місяців тому

    how did you get it to start cause mine keeps failing?

  • @fredisatya8747
    @fredisatya8747 7 місяців тому

    Thank you very much

  • @josemariarodriguez7845
    @josemariarodriguez7845 7 місяців тому

    Everybody: Why we are downloading version 2019 if the title says 2022? There is an upgrade afterwards in the course? Many tanks.

  • @mikorangoro
    @mikorangoro Рік тому +1

    hello Im miko oro good student

  • @richardodeikyei6062
    @richardodeikyei6062 3 місяці тому

    There's no popup notification to make me write a name for the datatype

  • @emanjamal8695
    @emanjamal8695 Рік тому

    thanks a lot!!!

  • @MOHAMEDETAHIRI-b8f
    @MOHAMEDETAHIRI-b8f 3 місяці тому

    THANKS

  • @efratkopel4664
    @efratkopel4664 10 місяців тому

    what can i do if i dont know mt Server name? how can i get it?

  • @chadgregory9037
    @chadgregory9037 2 роки тому

    hey Teddy, you ever think about trying the Barkley Marathons?? =]

    • @TeddySmithDev
      @TeddySmithDev  2 роки тому +1

      I’m planning on running Barkley Classic next year (hopefully) !

    • @chadgregory9037
      @chadgregory9037 2 роки тому

      @@TeddySmithDev That's probably a more realistic goal haha

  • @warzonecod-gamer5941
    @warzonecod-gamer5941 Рік тому

    What is uses SQL for?

  • @NotAHomelessGamer
    @NotAHomelessGamer Рік тому

    Your discord link doesn't work anymore.

  • @georgestechtips1353
    @georgestechtips1353 2 місяці тому

    what if i am on an apple silicon mac?

    • @TeddySmithDev
      @TeddySmithDev  2 місяці тому

      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.

  • @AndresGomez-so1vr
    @AndresGomez-so1vr 5 місяців тому

    how can i install this program on linux??

  • @lifeisgreen2592
    @lifeisgreen2592 11 місяців тому +2

    "Excel on steroids"

  • @卡李咯咯咯
    @卡李咯咯咯 4 місяці тому

    IS THIS SQL FREE TO INSTALL?

  • @sebastiangallo4776
    @sebastiangallo4776 Місяць тому +1

    He calls S-Q-L "sequel" but calls "GUI" G-U-I made me laugh.

  • @Teddy-Tech-Tutorials
    @Teddy-Tech-Tutorials 9 місяців тому

    Bro my Name 😂

    • @TeddySmithDev
      @TeddySmithDev  9 місяців тому +1

      Lmao I subbed. Two Teddy’s 2 Many Views 🤣

    • @Teddy-Tech-Tutorials
      @Teddy-Tech-Tutorials 9 місяців тому

      @@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! 😅

  • @KerryKier
    @KerryKier Місяць тому

    My staff uses Excel as a database. Excel is NOT a database and stop using as one 😂

  • @hanhpham3227
    @hanhpham3227 3 місяці тому +4

    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.

  • @mcintosh7437
    @mcintosh7437 8 місяців тому +1

    Teddy Smith saving the day! 🦸 Thanks for the Help! 🙌