Introduction to Databases

Database: Where to manage data.

The development stage of database: Hierarchical type, net type, relation type.

DB DBMS (Database management System) DBS (Database system)

The mainstream database: Sqlserver,oracle,db2,sybase,access,foxpro

SQL language-internationalization standard. Transaction-sql,pl-sql

Management class book--DBA database management experts.

Development class Book-Developer--sql syntax

Three levels of SQL Server database:

1. File (. mdf.ldf.ndf). 2. Interface. 3. Service.

Experience Edition-no money.

Enterprise Edition--Spend money.

Development version-no money.

How do I authenticate with SQL Server?

1. In Object Explorer, right-click the. Object, select Properties, select "Security" on the left side of the Properties dialog box and select "SQL Server and Windows Authentication" on the right side

2. Set the login password for the SA.

3. Enable the SA account.

Introduction to Databases