Shulou(Shulou.com)06/01 Report--

1. Basic concepts of database

Data: symbols that describe things

Datasheet: consists of records (rows) and fields (columns)

Databases: collection of data tables

Database management system: manage and maintain the database DBMS

Database administrator: DBA is responsible for database management and maintenance

Database system: composed of hardware, operating system, database, database management system, application software and users

2. DBMS data model:

Mesh model: supports many-to-many and many-to-one relationships

Hierarchical model: supports one-to-many

Relational model: through the Emurr model (entity-diagram)

3. Mainstream databases:

SQL Server: only on Windows platform, simple and easy to use

Oracle: produced by Oracle, mainstream platform, security, perfection and complex operation

DB2:IMB Company, large, safe and perfect

Mysql: open source, small, fast and stable

4. the concept of relational database:

Primary key Primary Key:

It consists of one or more fields and is unique. Null values are not allowed. A table can only have one primary key.

Candidate key:

Optional key for primary key, which can have more than one

Foreign key:

Add the primary key to the second table, which is called the foreign key in the second table, and is used to contact other tables. It is not allowed to reference tuples that do not exist.

5. Data integrity rules:

Entity integrity: cannot be empty

Domain integrity rules: whether the values of a column are valid

Referential integrity: references to tuples that do not exist are not allowed

User-defined integrity: constraints on specific data

6. SQL 2008R2 64-bit installation preparation:

CPU: supports 64-bit and above 1.4G

Memory: more than 1G

Hard disk: more than 3.6g

Operating system: 2003 sp2 64-bit except web version

2008 64-bit all versions

Security: use firewalls, isolate other services, configure secure file systems, and disable unnecessary protocols

7. Start and stop SQL

① Server Manager

② configuration Manager

③ ssms Management console

8. Registration server: save instance connection information for easy linking and management

You need to specify:

Server type, instance name, authentication method

Verification method:

① Windows authentication, allowing only operating system accounts to log in

② mixed authentication: allows Windows and SQL Server authentication, and sa is the SQL administrator

9. Database classification:

System database: (automatically created, not deleted)

Master: record system-level information

Model: template database

Msdb: agents schedule alerts and jobs

Tempdb: temporary database

User database: created manually, can be deleted

10. Common tools:

SSMS:SQL management console, configuration, management, development of SQL components, the most commonly used tools

Configuration Manager: network configuration settings, port number: 1433

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.