Introduction to MS SQL Server Microsoft SQL Server Installation Starting Microsoft SQL Server Introduction to SQL Code Introduction to  Databases Introduction to SQL Operations Variables and Data Types Introduction to SQL Expressions Introduction to Functions Review of Built-In Functions Exception Handling Introduction to Tables The Columns of a Table Introduction to Records Assistance With Data entry Introduction to Data Analysis Topics on Data Selection Sorting Records Introduction to Data Filters Topics on Filtering Records Intro to  Conjunctions/Disjunctions On Conjunctions and Disjunctions Records Maintenance Databases Constraints Data Joins The Types of  Relationships Topics on Data Relationships Uniting-Copying-Merging Records Composite Tables Transactions Introduction to Views Topics on Views Aggregate Queries Kolbot Angkor Chey Computer School www.kaccs.ueuo.com $60 Microsoft SQL Server 2008 Microsoft SQL Sserver Microsoft SQL Server  is a computer  application used to create  desktop, enterprise, and web-based  database applications. It is used at different  levels and with various goals. This web site  provides lessons and topics on how to use  Microsoft SQL Server 2008 to create and  manage databases Microsoft SQL  Server is an  application  used to  create computer  databases for the   Microsoft Windows  family of server   operating systems.  Microsoft SQL Server  provides an  environment used to generate   databases that can be accessed  from  workstations, the Internet, or  other media  such as a personal  digital assistant (PDA).   To follow our lessons, you must  have  access to a computer in  which Microsoft  SQL Server 2008  is installed. To start, you  must  have a computer that runs an   appropriate operating system. If  you are just  learning, you can use  a computer that runs  Microsoft  Windows XP Professional,   Microsoft Windows Vista,  Microsoft  Windows 7  (Professional or Ultimate),   Microsoft Windows Server 2003,  or  Microsoft Windows Server  2008.  Before  installing Microsoft SQL  Server 2008, make  sure you  have installed all service packs  on  your operating system.    Introduction to SQL Server 2008 SQL SERVER OVERVIEW 1. Understanding Client Server Architecture 2. Introducing the Tools 3. Selecting an Edition 4. Creating Sample Databases USING MANAGEMENT STUDIO 1. Arranging the Workspace 2. Registering Servers 3. Explaining Items in the Object Explorer 4. Explaining the Database Properties Dialog 5. Explaining the Columns Properties Dialog 6. Continuing with Object Explorer Items 7. Using the Query Editor WORKING WITH SINGLE TABLE QUERIES (42 min) 1. Understanding Query Flow 2. Filtering Data with the Where Clause 3. Columns, Expressions & Scalar Functions 4. Using Case Expressions 5. Working with Nulls & Coalesce 6. Selecting Environment Functions DESIGNING RELATIONAL DATABASES 1. Understanding Normalization 2. Discovering Patterns 3. Avoiding Over Complexity 4. Managing Optional Data 5. Creating Physical Keys 6. Using the Database Diagrammer Tool 7. Final Comments Trapangtrav village, Svaydangkom commune, Siem Reap City, CAMBODIA.