From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Database schemas - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Database schemas
- [Instructor] Schemas allow us to group related tables together so that we can manage them and assign permissions to tables as a group. Usually these table groups are going to mirror the same types of groups that you already have in your organization. You might have a sales team, and an operations team, and a product development team. Each of these groups of workers generates data that's unique to their department, but still contributes to the larger pool of data collected by the company. Schemas work the same way in organizing your databases. If I expand the LandonHotel database, and then expand the Tables folder, we'll see that all of the existing tables that we have are currently in the dbo schema. dbo stands for database owner, and it's the default schema that gets created for all new databases. We can create our own schema and start organizing these tables better with a simple line of Transact-SQL code. To get started, we'll come up here and we'll start up a New Query window…
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.