New databases are easy to create in SQL Server Management Studio. In this video, Adam demonstrates how to create a new database in the system, and how to set the most important properties when creating the files on disk. Starting file sizes and file-size growth increments are established, and a standardized file path is chosen for the new database.
- [Voiceover] Installing an example database is…a good start, but what you probably really wanna know is…how to create a database for your own personal project…or organization.…Creating databases in SQL Server Management Studio…is pretty straightforward.…We'll start by right-clicking on the Databases node…at the top of the Object Explorer window.…Then, from the pop-up menu, we'll choose New Database.…On this window, we have several pages for General Items,…Options, and File Groups.…We're gonna focus on the General Items in the first tab.…At the top of the General Items page is where we will…name our database.…
Feel free to name yours whatever you'd like,…I'm gonna simply name mine MyDatabase.…On the bottom in this Database files section,…you'll some activity taking place as we type in the name,…so let's go ahead and take a look at what just happened.…Our database is going to be comprised of two separate files…on our hard drive: one to store the data,…and a LOG file to keep track of the transactions…and messages generated as we work with the data.…
This course introduces the most important features of SQL Server 2016, and is designed to act as the student's very first look at how the server operates. Adam Wilbert shows how to install a local copy of SQL Server; demonstrates the working environment, SQL Server Management Studio; and walks students through their first hour creating tables, defining relationships, and writing and running queries with Transact-SQL commands. Everything you need to accomplish to create your first database is covered in just 80 minutes. Start watching to get up and running with this professional-grade database management system.
- What is SQL Server?
- Configuring the server
- Creating a new database and data tables
- Joining tables with keys
- Creating a SELECT statement
- Writing an UPDATE statement
- Adding data with the INSERT statement