As a result of the company's project, it has been working on the database for a while. Take advantage of this period of time, the knowledge of the database is a comb and induction, in order to later need, it is convenient to view.
The database used mainly has oracle10g and Sqlserver2008 two kinds, the two kinds of databases are displayed separately, the content involves the basic knowledge of database, the application of database principle, the use of SQL syntax, functions, stored procedures, cursors, transactions, transformation of heterogeneous data, optimization of billions of data.
1.Sqlserver Database BasicsIntroduction to 1.1Sqlserver Databases 1.2Sqlserver Statement Execution Order1.3Sqlserver principle2.Sqlserver Database Applications 2.1 Basic usage 2.2 Views, stored procedures, cursors2.3 indexes, functions (built-in functions, custom functions)3.Sqlserver Database Advanced 3.1Sqlserver Database new syntax optimization of 4.Sqlserver database 4.1 View of the query plan 4.2 Optimization Steps5Sqlserver. Database backup mechanismImport and export of 5.1Sqlserver databases
SQL Server Database Summary