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

Understanding servers, databases, and tables - SQL Tutorial

From the course: SQL Server Fundamentals: Master Basic Query Techniques

Start my 1-month free trial

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…

Contents