From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a database - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Create a database
- [Instructor] In this section we're going to talk about creating a database. We can do this either by typing in commands or using the graphical interface. I'll demonstrate both. First for typing in commands, we'll open up a new query in Management Studio, and this is surprisingly easy. We'll use the keyword create, the keyword database and then we just need to provide a name for the database and this can be almost anything. It's not going to affect the functionality, so I'll call mine Demo database. Then I'll click on the red exclamation point for execute, and at the bottom we get a message saying commands completed successfully, so I now have a new database that I just accepted all the defaults. I didn't enter any commands to change any of the default values, so we got a default database. It hasn't come up in object explorer yet, so I'll go to databases, I'll right-click and go to refresh, and now we see Demo database one. Many of the advanced options of creating a database can be…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.