That night, I was laughed awake in the Dream (database)

that night, I was in the wake of the Dream database My rule is the fittest.

Database A stay, will not move will not be called more can not eat, but it is an essential thing. Right.

Needless to say, I know, let's take a look here.

DatabaseWhy use a database?

The need for a database:

1. Can be structured to store a large amount of data information, convenient for users to effectively search and access.

Can effectively maintain the consistency of data information, integrity, reduce data redundancy.

　　Can meet the sharing and security requirements of the application.

Database technology can be easily and intelligently analyzed to generate new and useful information.

Line: (record)

Column: (field)

2. Data redundancy: repeatability of the data

3. Database integrity: accuracy

4. When we connect (log in) the database, we must first open the service

Database service open:SQL Server (MSSQLServer) (service)

5. log in to SQL Server two ways:

Windows authentication does not require a password

SQL Server Authentication:thesa password is empty by default

6. Common server

Oracle DB2 SQL Server MySQL sqllite Visual FoxPro access so several

7. Normal people know that the chief is a lot more than the deputy chief, DBS and DBMS are the same, the DBMS is part of the DBS

DBMS:databaseManageMent system: Databases Management Systems

Dbs:database System Database

The composition of the database system:

Database controller and database software system and computer with this software

8. Startup of the database

Novice:

To my Computer → right-click services →sql Server(MSSQLServer)

Normal:

Open Start menu → run →services.msc Enter to open the Services window, SQL Server (MSSQLServer)

Idlers:

Open a Command Prompt window and enter →services.msc to open the Services window.

9.MIcrosoft SQL Server 2008

1.Master Database

The master database records all system-level information for the SQL Server system, including the following three categories.

All login accounts and system configuration settings.

The location of all other databases and database files.

The initialization information for SQL Server.

2.Tempdb Database

The tempdb database holds all the temporary and temporary stored procedures, as well as the temporarily generated worksheets.

The tempdb database is recreated every time that SQL Server is started.

3.Modle Database

The Modle database can be used for all database templates that are created in the system.

4.MSDB Database

The msdb database isused by SQL Server Agent to dispatch alerts, jobs, and logging operations, and records for database backup and restore are also written in the database.

5.Resource

The resource database is a special database and is a read-only database that contains all the system objects in SQL Server that are physically present in the resource database, but logically they appear in the SYS schema of each database, so The resource database is a "hidden" database, and we cannot see him by using the SQL commands to view all the databases.

After reading these believe that you probably have some knowledge of the database!

Do not know the following will be followed by the new, please pay more attention to, thank you, the next period of the explosion map OH

Study is not overnight can learn, learning is boundless

That night, I was laughed awake in the Dream (database)