SQL Server 2005 is the next-generation data management and analysis solution which delivers increased security and availability to enterprise data and analytical applications.
Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is the rebranding of Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile 3.0) without the desktop restriction. SQL Server Mobile 3.0 was released in 2005 with Microsoft Visual Studio 2005 and with SQL Server 2005. SQL Server Mobile 3.0 is supported on devices and on Tablet PCs. SQL Server Mobile 3.0 is also partially supported on desktop computers.
To use SQL Server Mobile 3.0 on desktop computers, either Visual Studio 2005 or SQL Server 2005 must be installed. However, with SQL Server Compact Edition, this restriction has been removed. With SQL Server Compact Edition, you can develop and deploy applications independent of SQL Server 2005 and of Visual Studio 2005.
Fundamentals of SQL Server 2005
Setting up Environment
Introduction to Database
Working with Data Types and Tables
Data Manipulation Language (DML)
Constraints and Joins
SQL Built-in Functions and Set Operators
Indexes and Database Views
Introduction to T-SQL
Implementing Stored Procedures and Triggers
Aesthetic design, highly interactive and dynamic GUI.
Bookmark Management System - You can bookmark important lessons to watch them again.
Self-assessments with instant results.
Software glossary for each respective Azimuth online course.