SQL SERVER DATABASE COMPLETE | CREATE DATABASE TABLE SQL DATA | SQL Server Tutorial For Beginners
3SQL Server Tutorial For Beginners | Microsoft SQL Server Tutorial | SQL Server Training |
Tittle:
SQL SERVER DATABASE COMPLETE | CREATE DATABASE TABLE SQL DATA | SQL Server Tutorial For Beginners
-----------------------------------------------------------------------------------------------------------------------
Description Video:
-----------------------------------------------------------------------------------------------------------------------
Some database terms to know
Access organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a spreadsheet. In a simple database, you might have only one table. For most databases you will need more than one. For example, you might have a table that stores information about products, another table that stores information about orders, and another table with information about customers.
Each row is more correctly called a record, and each column, a field. A record is a meaningful and consistent way to combine information about something. A field is a single item of information — an item type that appears in every record. In the Products table, for instance, each row or record would hold information about one product. Each column or field holds some type of information about that product, such as its name or price.
A good database design is, therefore, one that:
Divides your information into subject-based tables to reduce redundant data.
Provides Access with the information it requires to join the information in the tables together as needed.
Helps support and ensure the accuracy and integrity of your information.
Accommodates your data processing and reporting needs.
The design process
The design process consists of the following steps:
Determine the purpose of your database :
This helps prepare you for the remaining steps.
Find and organize the information required
Gather all of the types of information you might want to record in the database, such as product name and order number.
Divide the information into tables
Divide your information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table.
Turn information items into columns
Choose each table’s primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
Set up the table relationships
Look at each table and decide how the data in one table is related to the data in other tables. Add fields to tables or create new tables to clarify the relationships, as necessary.
Refine your design
Analyze your design for errors. Create the tables and add a few records of sample data. See if you can get the results you want from your tables. Make adjustments to the design, as needed.
Apply the normalization rules
Apply the data normalization rules to see if your tables are structured correctly. Make adjustments to the tables, as needed.
Top of Page Determining the purpose of your database
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.
Who should go for this course?
This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
- - - - - - - - - - - - - -
Project
In the project you will be creating a Database using MySQL on STUDENT DATA MANAGEMENT SYSTEM :-
- - - - - - - - - - - - - -
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.
-----------------------------------------------------------------------------------------------------------------------
ignore tags:
#sql
#sqlserver
#sqla
#sqlqueries
#sql_server
#sqlite
#sqlforbeginners
#sqlforbeginners
#sqlserver2019
#sql2018
#sql18
#sql19
#sqltraining
#sqlinterviewquestions
ignore keywords:
sql,sql tutorial,learn sql,sql for beginners,mysql, basics,sql course,sql tutorial for beginners,sql training,what is sql,learn sql beginners,sql full course,sql crash course,sql server,free sql course,sql beginners,sql basics for beginners,sql beginner,mysql mysql tutorial,sql videos,sql database,learn mysql,sql query,sql уроки,learn sql ,ms sql,sql programming,sql queries,sql training videos @MicrosoftSQLServer
@SQLServer101 .