From the course: Database Foundations: Application Development
Join today to access over 24,700 courses taught by industry experts.
Add a database to SQL Server
From the course: Database Foundations: Application Development
Add a database to SQL Server
- We need to add our two trees database to the SQL server instance. There are two different ways that we can do that using either our graphical management client, Azure data studio or we can use the command line. Let's take a look at both methods. I'm going to minimize the web browser here and take a look inside of the chapter three folder of the exercise files here. We have the two trees.SQL file. Let me open that up inside of my code editor. Now this script is going to go through and create the two trees database. Then create the customer table inside of that database and finally insert some rows of data into the customer table. I'm going to press control A on my keyboard to select everything and then copy that to my clipboard. Let me go ahead and close out of the code editor now. So let's see the graphical user interface method first. I'm going to open up Azure data studio, then we'll create a new connection. So…
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.