Database Practice and Experience - COMPX223 (2020)

This paper approaches the subject of databases from a practical perspective - how do I create a database and how do I retrieve/update data. Both aspects are heavily addressed in this paper. Database creation and querying, using SQL, will be introduced in lectures as you will master practical skills associated with a commercial Database product (Microsoft SQL Server). The paper also introduces Microsoft's extension to SQL, Transact-SQL, which provides a user interface to SQL Server. This is to promote both understanding and practice of the different tools used to build, access and maintain a database within a Client/Server database computing environment.