Design Databases using Microsoft SQL Server and SQL Server Management Studio
What you will learn
Microsoft SQL Server Database Server Setup
Connect SSMS to SQL Server
Design database and table
Create relationships between database tables
Import data into table from a csv file
Implement primary key in database design
Implement foreign key in database design
Edit table structure
Add identity column to table
Description
Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.
A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense. In the end, you are much more likely to end up with a database that meets your needs and can easily accommodate change.
You will learn how to decide what information you need, how to divide that information into the appropriate tables and columns, and how those tables relate to each other.
It is a good idea to write down the purpose of the database on paper — its purpose, how you expect to use it, and who will use it. For a small database for a home based business, for example, you might write something simple like “The customer database keeps a list of customer information for the purpose of producing mailings and reports.” If the database is more complex or is used by many people, as often occurs in a corporate setting, the purpose could easily be a paragraph or more and should include when and how each person will use the database. The idea is to have a well developed mission statement that can be referred to throughout the design process. Having such a statement helps you focus on your goals when you make decisions.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.
Content