Choose an SQL Admin Topic

Choose a topic from below to begin.

Topic	Description	Take Test
All Topics	Cover all the topics on offer	Take Test
Relational Databases	Test your knowledge of Client Server databases in comparision with flat file databases, Transaction and Data Warehousing databases	Take Test
T-SQL	Test your knowledge of basic T-SQL statements and the differences between DDL and DML T-SQL	Take Test
SQL Server Licensing	Test your knowledge of the licensing models of SQL Server	Take Test
SQL Server 2000	Test your knowledge of SQL Server 2000, specifically the differences between this version and previous versions	Take Test
SQL Server 7	Test your knowledge of SQL Server 7, specifically the differences between this version and previous versions	Take Test
SQL Server 6.5	Test your knowledge of SQL Server 6.5, specifically the differences between this version and later versions	Take Test
SQL Server Installation	Test your knowledge of the installation of SQL Server, from prerequisites to collations, character sets, sort orders and custom installs	Take Test
Upgrading SQL Server	Test your knowledge of SQL Server upgrade paths. Upgrading from previous versions of SQL Server, side by side upgrades, complications, and compatibility problems	Take Test
Configuring SQL Server	Test your knowledge of the configuration of SQL Server using both Enterprise Manager and Query Analyser. Topics include configuration and optimisation	Take Test
Enterprise Manager	Test your knowledge of working with Enterprise Manager, including backing up and restoring databases and general database management	Take Test
Query Analyser	Test your knowledge of working with Query Analyser, including creating, managing and backing up databases using Data Definition Language	Take Test
Linked Servers	Test your knowledge of SQL Server linked servers, including linking to databases besides SQL Server, previous SQL Server versions and managing the security of those links	Take Test
Data Import, Export and Transformations	Test your knowledge of Importing and Exporting from SQL Server, including the Bulk Insert command, Bulk Copy program and Data Transformation Services	Take Test
Data files and filegroups	Test your knowledge of maintaining database files and filegroups, including shrinking your databases	Take Test
RAID Configurations	Test your knowledge of the benefits of various Redundant Array of Inexpensive Disks (RAID) and the best solutions for SQL Server	Take Test
SQL Server Security	Test your knowledge of SQL Server security including authentication, database and server roles and ownership chains	Take Test

Copyright © 2003-2012 SQL Training | Privacy Policy | Terms & Conditions

This material is not sponsored, endorsed or affiliated with Microsoft®. SQL Server® is a registered trademark of Microsoft®.
Although the authors of this site have made every effort to ensure the information on this website is correct, the authors do not assume and hereby disclaim any liability to any party for loss or damage caused by errors, omissions or misleading information.