SQL Server Tutorial - Part 1 - Basics, Installing, User/Roles, Database file structure and anatomy

Sdílet
Vložit
  • čas přidán 19. 08. 2024
  • - MS SQL Server
    - Get & Install
    - SQL Server Management studio
    - Users/Logins/Roles
    - Database files
    - Anatomy of SQL Server data file
    - Basic query
    - Management queries

Komentáře • 61

  • @ladellweinbach5467
    @ladellweinbach5467 Před 8 lety +2

    I needed to come up to speed on SQL Server very quickly and found your tutorial extremely helpful. Thanks for sharing and it was the perfect set of beginning information.

  • @tkattas7942
    @tkattas7942 Před 8 lety

    Thanks for this,the first subject in my network security course will be SQL,it will be nice to know this stuff before I even get to school.

  • @PelczarTomasz
    @PelczarTomasz Před 6 lety

    PL-SQL and Transact-SQL are scoring the very similar special casus for keyword SELECT. Instruction SELECT...FOR XML (by attributes like RAW, AUTO or Explicit similar to the common on whole SQL COMMIT and ROLLBACK and implicite-explicite in C++) is able to check whole ontology (including XML Schemas) and validate informations even same good as scrpit by Perl, Ruby on Rails, Python or Jython (the etc) ... UNION and UNION ALL are same on both Oracle and Microsoft version. Personally I do not know how by PL-SQL can be check or search XML information datagram document, but SELECT INTO is very similar to this case, which can be used similar to the Trigger. Excellent as sum up can be introduction to LINQ, best as always are free compilers, parsers and validators on our WWW`s ... Before ontologies we had LISP, DATALOG and PROLOG ... Knowledge data bases and data mining is the future, but also alredy done and implemented ...

  • @Ratchet2022
    @Ratchet2022 Před 5 lety

    Very well articulated. Thank you for keeping your listeners' comprehension in mind. I was able to follow everything you did. Thank you very much. I'm looking forward to my database management class this next semester!

    • @maximmakai9327
      @maximmakai9327 Před 3 lety

      i guess I'm kinda randomly asking but does anybody know of a good website to watch new movies online?

  • @MarieSueMax
    @MarieSueMax Před 9 lety +20

    this video is great besides the sound quality

  • @jebcrack
    @jebcrack Před 7 lety

    Very helpful and clear explanations

  • @vikramsarabhai1
    @vikramsarabhai1 Před 5 lety

    If You are having a hard time with the low volume, I suggest you download a Volume Booster extension for Chrome or any other browser you are using .
    It will help with any video you are having trouble with.
    Below are a few options to check out from the Chrome store.
    chrome.google.com/webstore/detail/volume-master/jghecgabfgfdldnmbfkhmffcabddioke
    chrome.google.com/webstore/search/volume%20booster?_category=extensions
    Hope this helps.

  • @ibha1981
    @ibha1981 Před 6 lety

    Very very good, thank you. Keep up the good work.

  • @joshuablauvelt9662
    @joshuablauvelt9662 Před 5 lety +1

    Closed captions would be VERY helpful!

  • @shivakumarbn1722
    @shivakumarbn1722 Před 7 lety

    it was a nice video

  • @techschool9967
    @techschool9967 Před 6 lety

    Thanks sir for your great help.

  • @MsJsmk
    @MsJsmk Před 8 lety

    Nice tutorial

  • @CheckAG
    @CheckAG Před 8 lety +1

    Good presentation dude...

  • @stperkin
    @stperkin Před 8 lety +11

    These are super helpful! Thanks for posting. But curse that student with the cough sitting next the microphone. He keeps hurting my ears.

    • @tjcdesign8377
      @tjcdesign8377 Před 7 lety

      yeah agreed. coughing guy needs to move away from the microphone or attend remotely.

    • @stperkin
      @stperkin Před 7 lety +2

      Haha, yeah. Wait, no. That seems a bit much....

    • @Jaydyte
      @Jaydyte Před 7 lety +3

      What nonsense is this??? Cursing another innocent human for a cough he cannot help and wishing he will "die" already??? People please be careful, don't just think you say can say anything on the internet against people...it might just return back upon you, if the person you're cursing is innocent :(

    • @segarcea4106
      @segarcea4106 Před 6 lety

      He doesn't even cough so frequently. Poor guy is most likely trying to hold it in.

  • @brendyabu3044
    @brendyabu3044 Před 8 lety

    that's very wonderful

  • @rienzshana7072
    @rienzshana7072 Před 8 lety

    nice video.. i just hoping everytime you write the code.. or do something with it, please zoom it.. i cant see the code you're typing or the one you're right/left clicking.. sorry for my bad grammar btw, still its a nice tutorial video.

  • @cwatry2453
    @cwatry2453 Před 6 lety

    Good content and very helpful; however, the sound quality (aside from the cougher) was marginal at best. I had a hard time following the conversation b/c every time you turned your head the volume and clarity of your voice diminished. I had to rewind and re-watch several segments multiple times. Suggest using a dedicated microphone for better sound quality which would also minimize the interruptions from audience noise.

  • @ExcelDestination
    @ExcelDestination Před 8 lety +1

    Nice Tutorial!

  • @noahlipton6130
    @noahlipton6130 Před 7 lety

    I just installed the Server Management Studio my question is how to create a server to play around on. Thanks in advanced.

  • @monkeypeas
    @monkeypeas Před 6 lety +2

    How is the coughing guy closer to the microphone than the speaker?

  • @emanakasolo7716
    @emanakasolo7716 Před 7 lety

    Thanks for sharing, I had issues with creating a superuser with failed to logon but I had to restart the sql server(mssqlserver service) which fixed the login problem

  • @aljosakovacevic4324
    @aljosakovacevic4324 Před 7 lety

    thanks it helped.

  • @adeinkheart3111
    @adeinkheart3111 Před 8 lety

    Great job but for the sound ish. I tried to be attentive as possible but it didn't come close.

  • @Anjum2287
    @Anjum2287 Před 9 lety

    Hi,
    I am using sqlserver 2014 managmnt studio.I am unable to create a database and edit the path.It doesn't allow me to change the path column while creating.unable to find file error pops up.any reason

  • @tivideosAZ
    @tivideosAZ Před 7 lety +1

    Hi,
    Your presentation is very good..clear and understandable.
    I downloaded SQL Server Express 2014. Connected as Windows Authentication. Then Setup the superadmin login etc . per your instruction. Then when I ran another instance of the Manament Studio and tried to connect to it using the Sql Server Authentication and the superadmin login I created, it is giving me this error -
    "A connection was successfully established with the server, but then an error occurred during the login process(provider:shared Memory provider, error 0 - No process is on the other end of the pipe.) (Microsoft SQL Server Error: 233).
    No process is the other end of the pipe"
    Please help..!

    • @JismalJamal
      @JismalJamal Před 6 lety

      Try to set Server authentication to "SQL Server and Windows Authentication Mode" , this setting can be found under Server properties->Security

    • @kdjksj029
      @kdjksj029 Před 5 lety

      I fixed this by going into SQL Server Configuration Manager and enabling the Named Pipes and TCP/IP protocols. Then I restarted the SQL Server service, reopened SQL Server Management studio, refreshed the server (right click the server in the left-hand menu and click "refresh"), and I was able to login.
      Also, go to the Server properties and select "SQL Server and Windows Authentication mode" under Security (this alone usually fixes the problem, but if not follow the steps above). I hope that helps anyone having the same problem.

  • @ABMA79
    @ABMA79 Před 6 lety

    you illustration is beyond excellent. But I do have a question though. During the login creation of superadmin, it gets created successful, but when i open a new SSMS, it refuses to connect. In the additional information, it says the login was successful, but there was no pipe. I couldnt understand the message. Same issue came up when I created the user_changeman. Same message was displayed.
    please give me advise, how can i fix this issue?
    Best regards and your illustration is exceptionally amazing.
    Thanks a lot.

  • @icylag3056
    @icylag3056 Před 7 lety

    when you click download on the windows page, which file should you download to install? theres like 20 in the list

  • @kennethkibuga8938
    @kennethkibuga8938 Před 6 lety

    Hello, videos are very helpful thanks. I have a question regarding access, I attempted to create a database and I received an error - states " denies permission to create database error code 262.

  • @robertchimaev5998
    @robertchimaev5998 Před 8 lety

    отличные видео! спасибо. случайно нет этих лекций по sql или что то подобного в тексте?

  • @Plamena95
    @Plamena95 Před 7 lety

    Hi, very helpful tutorial.But I have a problem -
    "Cannot connect to .\SQLEXPRESS.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233".
    This happens when I start the program and try to log in with superadmin or user_changeman. I did the same thing as You and I downloaded and installed Sql server and MSQLMS as I watched the video so I dont know what is the problem.Any help?

  • @TheBoxBox920
    @TheBoxBox920 Před 7 lety

    @fdzjuba can you or someone help me please? once i change the path to c:\sqldata and the other to c:\sqllog @15:53 and hit I okay, i get the error message -
    Created failed for Database 'newdatabase'.
    An exception occured while executing a Transact-SQL statement or batch
    Directroy lookup for the file "c:\sqldatabase
    ewdatabase.mdf" failed with the operating system error 2(the systek cannot find the file specified.).
    CREATE DATABASEE failed. Some file names listed could not be created. Check related errorrs. (Microsoft SQL Server, Error:5133)
    Please help! I couldnt find any solutions online!!

  • @byrdassociates2321
    @byrdassociates2321 Před 9 lety +1

    Sql server hardware is this the same as your video.

  • @paulchesa8963
    @paulchesa8963 Před 6 lety

    Are you going to post on indexing or any other SQL tutorial?

  • @MRozziMusic
    @MRozziMusic Před 8 lety

    When I try to connect using the superadmin account, it tells me this: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)"
    Any ideas on what I may be doing wrong?

    • @MRozziMusic
      @MRozziMusic Před 8 lety

      Nevermind, I was using the wrong server. The SQLExpress one needs to be the one you use.

  • @heatherherrmann1777
    @heatherherrmann1777 Před 7 lety

    If only he would quit hitting the table.... Can't even make it to the dude coughing because the banging is driving me nutso. Oh well. I bet it was a good lesson.

  • @fahamarahmani7223
    @fahamarahmani7223 Před 7 lety

    when i want to connect to server it has error 161

  • @superuser8861
    @superuser8861 Před 7 lety +1

    pls include a cc

  • @SeorangNeo
    @SeorangNeo Před 8 lety +1

    29:52

  • @TheMuha1995
    @TheMuha1995 Před 8 lety

    What is the name of this guy who is in the video?

  • @HorizonGBRS
    @HorizonGBRS Před 8 lety

    Hi can't anyboady help me on Skype with this please.

  • @asv1452
    @asv1452 Před 7 lety

    Who is the author? Is he russian?

  • @salamsucuksosis
    @salamsucuksosis Před 8 lety +12

    can you just kick that coughing guy?

    • @tonchus9212
      @tonchus9212 Před 8 lety +6

      not cool jesus :|

    • @KnightSRB
      @KnightSRB Před 7 lety

      why? maybe boy is ill...like you never had a cough..

    • @tjcdesign8377
      @tjcdesign8377 Před 7 lety

      İsa Mesih Yolunda's point is that it is very distracting when trying to learn. We miss things due to the coughing. I repeated it 3 times and still couldn't infer what was said.

    • @vallindionhanex
      @vallindionhanex Před 7 lety

      booo!!!

    • @Jaydyte
      @Jaydyte Před 7 lety

      You want someone to "kick that coughing guy" And you have a picture of Jesus as your avatar??? Please remove it, you're not worth having the picture, you're wicked with no compassion, a fake Christian, repent.

  • @salamsucuksosis
    @salamsucuksosis Před 8 lety +3

    coughing men ... thats annoying

  • @tcolvin211
    @tcolvin211 Před 9 lety

    ???

  • @Izaankhondaker
    @Izaankhondaker Před 7 lety

    Video is great; sound quality worse, Tutor is worst