SQL Server2008 from getting started to fully proficient in SQL database video tutorials

1th. SQL Server 2008 Getting Started Knowledge:
Introduction to 1.SQL SERVER 2008
2. Database Concepts
3. Relational database
4. Paradigm
5.e-r Model
6.SQL Server 2008 Architecture
7. Installing the IIS Service
8. Install SQL Server
9. Uninstalling SQL Server
The 2nd Chapter uses SQL Server 2008 Administration Tools:
1. Using SQL Server Management Studio
2. Template Resource Manager
3.SQL Server Books Online
4.SQL Server Configuration Manager
5.SQL Server Business Intelligence Development Studio
6.SQL Server Perimeter Application configurator
sqlcmd tools in 7.SQL Server 2008


The 3rd chapter manages the database:
1. Composition of the database
2. Creating a database using Administrative Tools
3. Creating a database with statements
4. View database Status
5. Modify the database
6. Deleting a database
7. Detaching and attaching databases
8. Shrinking the database
9. Database Snapshots
10. Create a data snapshot
11. Copying a database


4th. SQL Server 2008 Data Sheet Management:
1. Data type of the field
2.CREATE Table Statement
3. Create a data table
4. Using temporary tables
5. Setting the Identity field
6. Using default values
7. Create a constraint
8. Modify the table
9. User-defined data types
10. Usage Rules
11. Dismiss and delete rules
12. Data Relationship Diagram

5th. Manipulating schemas, indexes, and views:
1. Create a View
2. Modify the view and delete the view
3. Modifying data through a view
4. Overview of the index
5. Create an index
6. Managing Indexes
7. Full-text indexing and catalogs
8. Create a schema
9. Modifying and deleting schemas
10. Clustered indexes and nonclustered indexes


the 6th Chapter data Query and management:
1. Simple SELECT statement
2. Set query Criteria
3. Sorting
4. Grouping
5. Using Functions
6.having clause
7. Inserting Data
8. Use the Insert ... SELECT statement
9. Use SELECT ... INTO statement
10.UPDATE Statements
11. Using the FROM clause in an UPDATE statement
12.DELETE Statements
13.TOP keywords and top expressions
14.COMPUTE clause
15. Using operators in the WHERE clause

The 7th Chapter Operation inquiry:
1. Basic Connection
2. Internal Connection
3. Left Outer connection
4. Right outer connection
5. Fully Connected
6. Cross-connect
7. Self-connect
8. Joint Queries
9. Using sub-queries
10. Nested subqueries
11.XML Query
12.FOR XML clauses
13.EXISTS keyword Query
14. Inquiry intersect
15. Poor query except

The 8th chapter of Transact-SQL programming:
1.transact-sql Overview
2. Constants and Variables
3. Operators
4. Expressions
5. Notes
6.IF ... Else Statement
7.IF ... Else Statement Nesting
8.case Statements
9.case Statement Example
10.while Statements
11.while Statement Example
use other statements in 12.while statements
13.WAITFOR Delay Statement
14.GOTO Statements
15.TRY.. Catch error Handling Statement
16. Mathematical Functions
17. String Functions
18. Example of using String functions
19. Aggregation Functions
20. Date and Time functions
21. Scalar-valued functions
22. Table-Valued functions
23. Cursors Overview
24. Declaration of Cursors
25. Manipulating Cursors
26. Determine Cursor extraction status
27. Cursor Application Example
28. Business
29. Lock
30. System and meta-data functions
31.BEGIN ... End Statement Block
32.SQL Server 2008 Transaction Mode
33.xact_abort Options
34. Deadlock
35. Nesting Transactions

The 9th chapter of the stored procedure:

1. Overview of stored Procedures
2. Create a stored procedure
3. Use parameters with default values
4. Using OUTPUT parameters
5. Stored Procedure Example
6. Modifying stored procedures
7. Delete a stored procedure
8. Rules for designing stored procedures
9. System Stored Procedures
10. Temporary Stored procedures
11. Nesting Stored Procedures
12. View Stored Procedures


The 10th Chapter triggers:
1. What is a trigger
2. Create an INSERT trigger
3. Create a Delete trigger
4. Create an UPDATE trigger
5. Creating DDL triggers
6. Managing triggers
7. Nested triggers
8. Recursive triggers

11th security mechanism for SQL Server 2008:
1.sql Server 2008 security mechanism
2.SQL Server Authentication Mode
3. Create a Windows login account
4. Create a SQL Server login account
5. Create a database user
6. fixed server role
7. Fixed database role
8. User-defined database roles
9. Application Roles
10. Permissions
11. Managing Roles
12.DENY Veto Priority

12th. Backup and Recovery database:
1. Backup Overview
2. Create a backup device
3. Create a full backup
4. Create additional backups
5. General Recovery
6. Point-in-time recovery
7. Other Backup Options

13th. Automating SQL Server 2008 Databases:
1.SQL Server 2008 Automation Overview
2. Configure Database Mail
3. Send a test email
4. Create an operator
5. Creating a Fail-safe operator
6. Create a job (top)
7. Create a job (bottom)
8. Overview of Alarms
9. Create an alert
10. Database Maintenance
11. Maintenance Plan Wizard

14th Chapter Integration Services:
1. Integration Services Overview
2. Create an SSIS project
3. Run the SSIS package
4. Using the Import and Export Wizard
5. Package Configuration
6. Package Installation

The 15th Chapter Reporting Service:
1. Reporting Services Overview
2. Designing a report using the Report Wizard
3. Using Report Designer
4. Design Parametric reports
5. Configure the report server
6. Publish the report
7. Manage Reports

The 16th Chapter Analysis Service:
1. Analysis Services Overview
2. Create an analytics service project
3. Create a cube
4. Process and browse cubes
5. Add Filter Criteria
6. Using the Data Mining wizard

The 17th Chapter uses. NET to access SQL Server:
1.ADO. NET basic knowledge
2.SqlConnection
3.SqlCommand
4.SqlDataAdapter
5.SqlDataReader
6.DataSet
7.DataTable
8. Calling a stored procedure
9..net Transaction Processing

The 18th Chapter monitors SQL Server:
1. Create a Trace
2. Database Tuning Wizard
3. Tracking Applications

The 19th chapter uses the CLR to access SQL Server:
1.CLR function
2.CLR Stored Procedures
3.CLR Trigger

The 20th Chapter uses SMO to access SQL Server:
1. Create an SMO project
2. Connect to SQL Server
3. Creating a database using SMO
4. Create a table using SMO
5. Creating a stored procedure using SMO
6. Create a trigger using SMO

21st SQL Server Other operations:
1.SQL Server 2008 memory allocation
2.PowerShell 1.0
3. Replication Concepts
4. Create a snapshot publication
5. Create a Snapshot subscription
6.APPLY operator
7.SQL Server 20,084 new sorting functions
synonyms in 8.SQL Server 2008


:Http://www.fu83.cn/thread-268-1-1.html

SQL Server2008 from getting started to fully proficient in SQL database video tutorials