SQL Server Tutorial - Part 1 - Basics, Installing, User/Roles, Database file structure and anatomy
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
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.
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.
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 ...
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!
i guess I'm kinda randomly asking but does anybody know of a good website to watch new movies online?
this video is great besides the sound quality
Very helpful and clear explanations
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.
Very very good, thank you. Keep up the good work.
Closed captions would be VERY helpful!
it was a nice video
Thanks sir for your great help.
Nice tutorial
Good presentation dude...
These are super helpful! Thanks for posting. But curse that student with the cough sitting next the microphone. He keeps hurting my ears.
yeah agreed. coughing guy needs to move away from the microphone or attend remotely.
Haha, yeah. Wait, no. That seems a bit much....
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 :(
He doesn't even cough so frequently. Poor guy is most likely trying to hold it in.
that's very wonderful
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.
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.
Nice Tutorial!
I just installed the Server Management Studio my question is how to create a server to play around on. Thanks in advanced.
How is the coughing guy closer to the microphone than the speaker?
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
thanks it helped.
Great job but for the sound ish. I tried to be attentive as possible but it didn't come close.
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
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..!
Try to set Server authentication to "SQL Server and Windows Authentication Mode" , this setting can be found under Server properties->Security
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.
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.
when you click download on the windows page, which file should you download to install? theres like 20 in the list
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.
отличные видео! спасибо. случайно нет этих лекций по sql или что то подобного в тексте?
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?
@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!!
Sql server hardware is this the same as your video.
Are you going to post on indexing or any other SQL tutorial?
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?
Nevermind, I was using the wrong server. The SQLExpress one needs to be the one you use.
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.
when i want to connect to server it has error 161
pls include a cc
29:52
What is the name of this guy who is in the video?
Hi can't anyboady help me on Skype with this please.
Who is the author? Is he russian?
can you just kick that coughing guy?
not cool jesus :|
why? maybe boy is ill...like you never had a cough..
İ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.
booo!!!
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.
coughing men ... thats annoying
???
Video is great; sound quality worse, Tutor is worst