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-2021 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.