Creating altering and dropping a database - Part 2

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 367

  • @dirkmuller6851
    @dirkmuller6851 3 года назад +201

    Even after 8 years and many new releases of SQL Server and competing tutorials, this is still the best SQL tutorial available!

    • @randylucca311
      @randylucca311 3 года назад +1

      i guess I am kind of off topic but do anyone know of a good website to stream new tv shows online?

    • @baylorjacob7792
      @baylorjacob7792 3 года назад

      @Randy Lucca lately I have been using Flixzone. You can find it by googling :)

    • @denverzayden965
      @denverzayden965 3 года назад

      @Randy Lucca lately I have been using Flixzone. Just google for it :)

    • @anupamthakur9870
      @anupamthakur9870 3 года назад +4

      You are right Mr. Dirk

    • @bluehawk8294
      @bluehawk8294 2 года назад +4

      even after 9 years 😂😂

  • @biljanamalesevic2519
    @biljanamalesevic2519 10 лет назад +112

    This is by far the best made tutorial I've ever found on net.

    • @MM-wh8nq
      @MM-wh8nq 4 года назад +1

      Definitely

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад +9

    Hi, the text version of the video is available on myblog. Hope you will find it useful. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

  • @mankillsquare
    @mankillsquare 7 лет назад +8

    It's very good of you to put all the work required into making and narrating these tutorials and then provide it for free! You deserve a medal! And you know your stuff :)

  • @skiptomylute5094
    @skiptomylute5094 5 лет назад +1

    Good people providing free content to the world. This is RUclips at its finest. Thank you!

  • @Algebrodadio
    @Algebrodadio 9 лет назад +25

    Venkat, these tutorials are pure gold. I have learned so so much from them
    Thank you!

  • @brittanyoutlaw5319
    @brittanyoutlaw5319 7 лет назад +28

    Thank you so much for this. Learning this helps enhance my skill set and open up opportunities for better jobs. I am truly grateful and I hope you are blessed greatly for doing such an amazing thing by teaching this to others.

  • @jassimelattar
    @jassimelattar Год назад +2

    This tutorial has 10 years and still better than all the other tutorials !

  • @viniciusqueiroz2713
    @viniciusqueiroz2713 8 лет назад +49

    Hi Venkat! Thank you so much for taking your time to making these classes for all of us! I just wished you to know that your methodology is very good, and you seem to have a very good understanding on all of the concepts of the learning topics.
    Also, your english is quite easy to understand, so that helps a lot!
    Thank you very much, again!

    • @bhartiyasena9189
      @bhartiyasena9189 4 года назад +1

      yes brother he is awesome

    • @viniciusqueiroz2713
      @viniciusqueiroz2713 4 года назад +3

      Wow. Looking back at this, it seems like such a long time. I've got three jobs as a software developer already, started my Master's in Computer Science this year, and kudvenkat's channel helped me so much along the way...
      I hope I can be as clear and didactical with my students in the future as you were with me!
      I gotta thank you yet again, man! Hope you're doing well during this hard time the world is going through.
      Cheers!

    • @bhartiyasena9189
      @bhartiyasena9189 4 года назад

      @@viniciusqueiroz2713 man i am a sstudent i want to ask a question if u can reply
      is .net still a viable option to learn in 2020
      and what type od development i should consider web, app, or something else in .net framework
      happy if u reply

    • @viniciusqueiroz2713
      @viniciusqueiroz2713 4 года назад +1

      ​@@bhartiyasena9189
      I don't see many job openings that require .NET framework knowledge here in Brazil. I don't know about other countries, though...
      Here's the thing: Back in 2018, at my first job I was mostly a mobile app developer (although I had some other tasks as well). I worked with C# Xamarin, and MVVM as design pattern (very similar to MVC). But the team was also flirting a lot with Flutter and React Native at some point (we continued with Xamarin, though, since the project was already going on for like two months). We also used SQLite and MySQL. But the difference in practice is mostly syntax, so just learn one, and the others you may learn as needed.
      I also had to work a little bit with React (for the web front-end) and Node.js (for the web api), and some DevOps tools, such as Jenkins, Kubernetes and AWS.
      My second job was with PHP, but I was REALLY underpaid. I don't talk about it, and don't recommend working with PHP at all.
      My third job was different. I moved to the Machine Learning/Computer Vision, Embedded Systems/IoT area, so I worked with python, and there was little to nothing related to mobile or web apps at that point. The DevOps tools and Clean Code techniques I learned at the first job were still useful, though. We used Azure instead of AWS, though. Very similar.
      So, in short, I would recommend React (web front-end), Node.js (web api), and Flutter, React Native, or even the native languages for Android and/or iOS (for mobile. try all of them, see what you like most and what are the requirements for the places where you'd like to work).

    • @bhartiyasena9189
      @bhartiyasena9189 4 года назад

      @@viniciusqueiroz2713 thanks I am from India here all languages and all things get consumed what u say I am going to make sure I will touch all and make something out of it
      and thanks means a lot

  • @trickswithandro749
    @trickswithandro749 3 года назад +1

    I study databases in class in the online course even I paid for some of them but this course is perfect and complete as I want and still the NO_1 course of the world even after 9 years ago of upload. Thank u sir

  • @AkhilKumar
    @AkhilKumar 10 лет назад +10

    This is the best playlist on youtube for Sql Server tutorials...... thanks :)

  • @mr.prasadyadav
    @mr.prasadyadav 3 года назад +1

    I think you are the Son of "SQL SERVER "...
    what a lecturers you are giving to us ..
    Fantastic Sir it's awesome ...
    Thank You very much Sir ❤️

  • @Steak514
    @Steak514 7 лет назад

    You're a complete life saver. I was completely confused about all these different databases and servers, and this really cleared things up. It's amazing how many garbage step by step instructions are online.

  • @nikita9378
    @nikita9378 3 месяца назад +1

    The knowledge is Awesome ...Thank you so much
    and Let me also take a moment to appreciate the tone of voice you have ...well and soft spoken Gentlemen !!

  • @philmedina9523
    @philmedina9523 6 лет назад +3

    OMG! I finally found a real basics tutorial. Wow! great transitions and you are an ideal professor/master! Thanks for offering this!! I know i've learned a lot already

  • @baburamshapure
    @baburamshapure 7 лет назад +5

    Hi Venkat, greetings of the day! These tutorials are invaluable. I literally learned SQL Server by going through them. Really admire your work and the way your teach, so exhaustive. Thank you man. God bless you!

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  7 лет назад +2

      Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
      I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
      ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
      If you need DVDs or to download all the videos for offline viewing please visit
      www.pragimtech.com/kudvenkat_dvd.aspx
      Slides and Text Version of the videos can be found on my blog
      csharp-video-tutorials.blogspot.com
      Tips to effectively use my youtube channel.
      ruclips.net/video/y780MwhY70s/видео.html
      If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
      ruclips.net/user/kudvenkat
      If you like these videos, please click on the THUMBS UP button below the video.
      May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
      Good Luck
      Venkat

    • @paragdasgupta4981
      @paragdasgupta4981 2 года назад +1

      baburamshapure kotha jaash bapure?

    • @baburamshapure
      @baburamshapure Год назад +1

      @@paragdasgupta4981 😀

  • @geetuarora5567
    @geetuarora5567 9 лет назад +4

    Best videos, I have ever found on net.. Great job!! With teacher like you, every student would ready to learn anything..I guess

  • @sondang5932
    @sondang5932 3 года назад

    YOU ARE THE GOD, I LOVE YOU AND EVERY TUTORIALS YOU'VE MADE, YOU SAVE MY LIFE. TANKS A MILLIONS

  • @PK-mm4bm
    @PK-mm4bm 10 лет назад +10

    The presentation is so good, It's really awesome. Thank you.

  • @pup1407
    @pup1407 10 лет назад +1

    Venkat, This is serious business. You are doing fantastic Job.

  • @CJAM16
    @CJAM16 9 лет назад +1

    only 2 parts in and i'm already enjoying the series. Clear and concise explanation throughout. Good job

  • @chinnijaya
    @chinnijaya 9 лет назад

    really wonderful i am proud that you are from India. Happy to see that lot of foreigners are happy with your teaching.

  • @anandsharan8286
    @anandsharan8286 10 лет назад +1

    Clear, Crisp, Simple and TO the Point.. Keep it up..

  • @MegaCookie1971
    @MegaCookie1971 10 лет назад +2

    Just want to express my bunch of thanks to you. This is an excellent tutorial for me. Awesome! Very simple to understand and toggle along.

  • @krismaly
    @krismaly 9 лет назад +3

    Revisited and watched. I enjoyed watching this video and recommend others to watch. Concepts are clearly explained. Thanks a lot

  • @user-je3ms7nv2v
    @user-je3ms7nv2v 7 лет назад +1

    saw this series few years ago, watch it again, still learn many things, really good.

  • @dikshabhatt9058
    @dikshabhatt9058 6 лет назад

    You have created the best tutorials I have ever found on internet. Thanks a lot!

  • @krismaly6300
    @krismaly6300 8 лет назад +4

    Revisiting to refresh BASICS.
    I enjoyed watching this video and recommend others.
    Thanks for educating the community and appreciate your volunteership.
    Thanks a bunch

  • @mahesh26sai
    @mahesh26sai 6 лет назад

    People like you just make internet a better place for learning.

  • @alamgirhaque3175
    @alamgirhaque3175 10 месяцев назад

    Very easy to understand your explanations. You can explain in a simple way but in details.

  • @hayleybillingham9706
    @hayleybillingham9706 10 лет назад +1

    Thank you, I have an exam in a weeks time so these are the tutorials I will be following for the recap, explained perfectly

  • @felixsage5152
    @felixsage5152 9 лет назад +1

    Simply analysed, well structured and Explicit. Thank you so much. Best Regard

  • @MikeSmith-rn9rr
    @MikeSmith-rn9rr 10 лет назад

    All the information in just the right teaching format. Beautiful!!
    Love the speaker's language dialect too. In the female version only :)

  • @anubhavgupta5756
    @anubhavgupta5756 9 лет назад +2

    Really superb the way you explain.... god bless you...

  • @ManojKumar-cd9lw
    @ManojKumar-cd9lw 8 лет назад +2

    Sir,You are amazing to explain things easily.keep it up..

  • @maneeshaveerareddy4968
    @maneeshaveerareddy4968 8 лет назад +2

    Hey Kudvenkat,
    Great videos ,they are really very helpfull.I really loved the simplicity and easy way of your teaching..thanks for the videos

  • @tbhaskarreddy5342
    @tbhaskarreddy5342 6 лет назад

    Hi Venkat! Thank you so much for taking your time to making these classes for all of us!

  • @motamarriajaykumar8885
    @motamarriajaykumar8885 4 года назад

    clean and clear explanation about everything.Thankyou sir for making these videos open to all.

  • @mehtarahul1419891
    @mehtarahul1419891 11 лет назад +1

    thnks venkat..eveything is so crystal clear..so understandable ..not even to make notes..:-)

  • @najeebather7842
    @najeebather7842 8 лет назад +1

    Thanks very much for this wonderful tutorial.........I see all your tutorials like Jquery, Bootstrap, Wordpress theme customization all are very good and comprehensive explanations. Thanks very much for this ultimate help

  • @beachboybali7925
    @beachboybali7925 8 лет назад +7

    thank you very much for teach us data Base SQL
    it helps for my study thank you

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  8 лет назад +2

      +jaka runi Thank you so much for the feedback. Means a lot. Glad the videos are useful.
      Dot Net & SQL Server training videos for aspiring web developers
      ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
      Download our training videos and slides for offline viewing
      www.pragimtech.com/Order.aspx
      Code Samples, Text Version of the videos & PPTS on my blog
      csharp-video-tutorials.blogspot.com
      Tips to best utilise our channel
      ruclips.net/video/y780MwhY70s/видео.html
      To receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below
      ruclips.net/user/kudvenkat
      Please click the THUMBS UP button below the video, if you think you liked them
      Thank you for sharing the link with your friends who you think would also benefit from them
      Best
      Venkat

  • @aziserak4743
    @aziserak4743 2 года назад

    happy to find you best teacher ever

  • @kumarbomman2228
    @kumarbomman2228 2 года назад

    Venkat sir , This is very useful for everyone because Your Explaining Each Every part of the session Thanks a lot....

  • @shubhamJain-fb3fy
    @shubhamJain-fb3fy 2 месяца назад

    I still revise SQL from these videos even after 7 years!

  • @Elohim7777
    @Elohim7777 6 лет назад

    this guy is a natural teacher..

  • @robl655
    @robl655 9 лет назад

    When I created my database, I had to refresh the project in order to show up... But it didn't look like you had to do that. Any clue why? Awesome videos. These are the best database tutorials on the web!

  • @rahin90
    @rahin90 8 лет назад

    great Teaching. i have been trying to understand the SQL for long time but it has been always hard this made was like peace of cake. thank you very much and keep up the teaching

  • @subhadipmandal3416
    @subhadipmandal3416 3 года назад

    Excellent tutorial on SQL Server. So easy to follow along. Loved this man!!!

  • @krismaly6300
    @krismaly6300 9 лет назад

    I enjoyed watching this video and recommend others.
    Thanks for educating the community and appreciate your volunteership.
    Thanks a bunch

  • @Star-vg7ix
    @Star-vg7ix 3 года назад

    Wish if I knew about these videos a VERY long time ago. Exceptional job in explaining SQL.

  • @philthomas2378
    @philthomas2378 9 лет назад

    Sooo many thanks for the tutorials. I am trying to fill in the gaps on the difference between a really old version of Microsoft SQL, MYSQL and MS SQL 2012 that I am trying to set up. These are just the job!

  • @krismaly6300
    @krismaly6300 7 лет назад

    Revisiting to refresh basics
    I enjoyed watching this video and recommend others.
    The host is an expert in MS SQL and Dot Net Programming.
    He is an excellent teacher and a nice person to share the knowledge to community.
    Thanks for educating the community and appreciate your volunteer-ship.
    Thanks a lot

  • @battikishorebabu7601
    @battikishorebabu7601 8 лет назад

    Good Explanation Venkat, your videos will drive us easily to learn SQL.

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад +2

    Hi, thank you very much for the update. Yes, you are right sp_renameDB is deprecated and should be avoided in all future developments. Sure, will add a pop-up in the video.

    • @vishaljhaveri6176
      @vishaljhaveri6176 2 года назад

      Thank you Sir. Your tutorials are quite helpful.

  • @user-yf9np2vy8j
    @user-yf9np2vy8j 9 лет назад +6

    Thank you ! the tutorial is amazing!

  • @dheerajrao3719
    @dheerajrao3719 3 года назад

    He is the best. Best explanation.. Thanks so much Venkat.

  • @dawit7956
    @dawit7956 9 лет назад +1

    So much thank you Mr, Venkat.....!! You did great effort to make it interesting and helpful....

  • @ajazmiah
    @ajazmiah 7 лет назад

    For now understand that he is the BEST!! :)

  • @rotrose7531
    @rotrose7531 5 лет назад

    Thank you very much! Like any other your videos, your explanation always set you apart from others. Best.

  • @naseerk2089
    @naseerk2089 9 лет назад

    You are doing great job venkat..appreciate you. Good class with good english and explanation..god bless you...Thank you verymuch...

  • @gangar1869
    @gangar1869 3 года назад

    The best tech tutorials ever..

  • @santoshkumar-sl7sv
    @santoshkumar-sl7sv 11 лет назад

    Venkat.. these tutorials helps much..u r doing a great job...appreciate u r motive and help..

  • @sujjilist
    @sujjilist 3 года назад

    Best explanation listened so far

  • @MrBlackitalian
    @MrBlackitalian 11 лет назад +2

    sp_renameDB has been removed from Microsoft SQL, only use the ALTER option. Please add a popup in the video to clarify, other wise very helpful. Thank you.

  • @jasperism1807
    @jasperism1807 6 лет назад

    simplest explanation and easiest way to learn by having #kudvenkat... NOWORDS... 💐.g8 wrk.today is my frst visit.. vryyyyy impressed.

  • @yousufjagirdar5780
    @yousufjagirdar5780 7 лет назад

    videos are awesome ...........the english which u have u have used is very easy to understand.........

  • @kavishan2241
    @kavishan2241 9 лет назад +1

    bravo..good job man..really its supporting more for beginners like me..thanks not good enough word to share.

  • @kamleshjsrboy
    @kamleshjsrboy 9 лет назад +1

    Good explanation with clear voice .,Great job venkats

  • @RahulKumar-xj4zo
    @RahulKumar-xj4zo 3 года назад

    Very nicely explained. Basic to complex in detail. Engaging tutorials

  • @gurungoracle
    @gurungoracle 9 лет назад +1

    explained concisely. thanks, great video

  • @rylnitu
    @rylnitu 11 лет назад

    Great teacher !! very informative and knowledgable .THanks!

  • @muhammadumer2011
    @muhammadumer2011 4 года назад

    Excellent tutorial clear explain each and every point in a professional way

  • @Millingu
    @Millingu 9 лет назад

    This is the best tutorials of SQL ever on youtube. you are a blessing to us. Very good explanations and vivid practicals. Thank you.

  • @hack001011
    @hack001011 10 лет назад

    Great lessons I am excited to watch more. Keep up the good work. There are a lot of junk tutorials out there I would say this tops them all.

  • @manjeetkumargupta
    @manjeetkumargupta 9 лет назад +1

    really amazing tutorial .....thanx..

  • @noorhirjee2274
    @noorhirjee2274 9 месяцев назад +1

    How to write a query
    to create a database
    Example FRIEND and Family.
    Thanks

  • @kogulselvanathan4218
    @kogulselvanathan4218 3 года назад

    Excellent tutorial, helpful to the point slides. Thanks for the tutorial, Venkat.

  • @Genovia816
    @Genovia816 3 года назад

    You are so thorough! I love it

  • @user-je7py6fp8j
    @user-je7py6fp8j Год назад

    Nice and to the Point turorial. Much Appreciated

  • @anonagain
    @anonagain 7 лет назад

    Content and presentation are both excellent - thank you!

  • @nameethapatel5131
    @nameethapatel5131 4 года назад

    Thank you for your time and effort. We really appreciate it.

  • @farrukhaari810
    @farrukhaari810 4 года назад

    Excellent 👍. Your fan from pak.

  • @NirajKumar-hw6ph
    @NirajKumar-hw6ph 2 года назад

    Amazing sir Thanku so much for this wonderful video

  • @adilwagle73
    @adilwagle73 6 лет назад +1

    Sir your video give us a lot of knowledge and teaches us a lot Sir can you make tutorial on windows form because i found only one video for windows form on your channel.

  • @kenvng
    @kenvng 2 года назад

    Thank you very much for sharing your knowledge. I am most grateful. God blesses.

  • @gebremedhinfitsum1693
    @gebremedhinfitsum1693 3 года назад

    pure and clear tutorial ..TNXS Sir

  • @okey6845
    @okey6845 7 лет назад

    you are simply the best. Thank you for the videos

  • @canny255
    @canny255 3 года назад

    Well presented!! Thanks a lot!!

  • @kunnudev7250
    @kunnudev7250 4 года назад +1

    Great job

  • @faltu1.0
    @faltu1.0 7 лет назад

    Thanks a lot !!!
    You're a perfect teacher.

  • @enockoloo3814
    @enockoloo3814 Год назад

    i like the clear explanation - good job bro.

  • @FinalCounterStrike
    @FinalCounterStrike 9 лет назад +2

    Simply Awesome

  • @sarvamangalarudraiah7832
    @sarvamangalarudraiah7832 3 года назад

    Awesome videos love to watch n learn the things

  • @akshaydalvi4545
    @akshaydalvi4545 11 лет назад

    hello venkat sir, like you said in this video that when you delete databases both ldf and mdf files get deleted ,then how does one recover database if he/she accidently delete database ...thankyou :)

  • @RainnMakerr
    @RainnMakerr 11 лет назад

    very clear and to the point. Good Work and thanx

  • @surbhisingh4437
    @surbhisingh4437 8 лет назад +1

    Awesomely explained !

  • @saumyaranjanswain1708
    @saumyaranjanswain1708 8 лет назад

    I can't find such a wonderful video for pl/Sql .I would be extremely pleased if u could make a series for Pl/sql

  • @a2zanalyticsgyan923
    @a2zanalyticsgyan923 11 лет назад

    ur tutorial z just awwsum.....c#,.net,sql sever ...all video tuotorials r informative....hats off 2 u sir..::)

  • @PatrickFallah
    @PatrickFallah 8 лет назад

    Thanks Venkat for your Videos its helps me a lot in my studies

  • @manikantakandukuri2569
    @manikantakandukuri2569 4 года назад +1

    i have small question,when we rename the database in SSMS whether it rename in our system or not?(like whether the same database MDF and LDF files will be renamed?)