Complete database concept part-1

1. SQL Server 2008 Architecture
2. Physical Data base Files and Filegroups
3. Data Recovery Model
4. SQL Transaction Log Architecture
5. Truncating the Transaction Log
6. Log truncation occurs at these points
7. The size of a transaction log is therefore controlled in one of these ways
8. Shrinking the Transaction Log
9. Example Truncating / Shrinking the Transaction Log
10. Data base is in FULL Recovery Mode
11. Data base is in SIMPLE Recovery Mode
12. Micro Soft SQL Server 2008 Overview
13. System and User Data bases ( = Oracle Schema )
14. Micro Soft SQL Server 2008 Services
15. Referring Objects
16. Metadata ( Data Dictionary )
17. Micro Soft SQL Server 2008 Logon and Data base Access
18. Micro Soft SQL Server 2008 Query Designer
19. Micro Soft SQL Server 2008 Batch Utility ( osql )
20. SQL Server 2008 Programming Overview
21. Local Variables
22. Distributed Queries
23. Formatting Dates
24. CASE function ( similar to Oracle DECODE )
25. Dynamically constructing SQL statement's
26. Transactions
27. TOP SQL Queries
28. User Tables for specific Data base
29. Primary- and Foreign Key of Tables
30. Create and Manage Database
31. Database Property
32. Change a properties
33. How to create a Database
34. Information about Databases
35. SQL Data Structure
36. Database Recovery Model
37. Check Extents, Pages
38. Trace flags
39. How to take backup of a Database
40. How to restore a Database
41. How to create Table
42. SQL user defined data types
43. SQL BLOBS
44. Computed Column
45. How to generate column value with identity property of SQL
46. How to generate column value with NEWID function of SQL
47. How to create table in specified file group
48. How to generate transact-SQL script
49. Logged and Non-logged bulk copy script
50. About data integrity
51. SQL DEFAULT constraints
52. SQL CHECK constraints
53. SQL PRIMARY KEY constraints
54. SQL FOREIGN KEY constraints
55. What is DEFAULT object
56. What is RULE object
57. How to enable and disable constraints
58. SQL Table structure
59. SQL pages and extents
60. Heap and index allocation Map ( IAM )
61. SQL index structure
62. Non-SQL clustered indexes
63. SQL clustered indexes
64. Sysindex tables
65. How to verify the sysindex tables
66. Full table scan
67. SQL clustered index  with non-SQL clustered index
68. Page split in an index
69. Page splits do not occur in a heap
70. Determining of selectivity
71. Determining of table structure
72. Optimizer statistics
73. Manually creating statistics
74. How to create statistics for whole Database
75. View index statistics and evaluating index selectivity
76. SQL Views: creating views, Encrypt / Decrypt Views, Up-datable Views, Indexed Views
77. Stored procedures: Populate table with a stored procedure
78. Check Stored Procedure Property
79. How to Recompile all stored procedure, Trigger that reference to a table
80. How to use input parameters
81. How to return value using output parameter
82. How to process OUTPUT value and RETURN parameter
83. How to use last insert @@identity for Foreign Key columns
84. SQL custom message from stored procedure added into event log
85. SQL email interface
86. SQL extended stored procedure
87. SQL user defined functions
88. SQL scalar value user defined functions
89. SQL multi-statement table valued function
90. Trigger: INSERT Trigger, DELETE Trigger, UPDATE Trigger
91. Transact SQL Server example
92. Shrinking a Logfile
93. How to handle NULLs
94. Difference between COUNT( * ) and COUNT( 1 )
95. Is NULL values accepted in Foreign Key?