From the course: SQL Server Fundamentals: Master Basic Query Techniques
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding servers, databases, and tables - SQL Tutorial
From the course: SQL Server Fundamentals: Master Basic Query Techniques
Understanding servers, databases, and tables
- [Instructor] When the SQL Server installation is up and running, you'll have set up a local instance of a SQL Server on your computer that you can connect to through SSMS. When you open the program, this connect to server window pops up, and I automatically have the server name that was generated on my machine selected, and I just click connect. If you have a machine that's powerful enough, you could have more than one instance installed, and if you're working for a company that uses SQL Server, they probably have many servers that people with the right permissions can connect to, but for this course, you'll only need the one. If we go over here to the Object Explorer panel on the left and expand our list of options for this server, if that hasn't happened already, we've got a bunch of different folders here, but for this course, we're only concerned with the database folder, which I'll expand by clicking on the plus…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.