This course is designed for those who are interested in learning the fundamentals of a database system and basic structured query language (SQL).The course does not require any pre-requisite skills other than basic knowledge of using and navigating Windows. You will be introduced to the background of different database systems and the history of SQL. The course however focuses on relational database system (RDBM). The course is a blend of theory and practical work. Students will be taught how to install a relational database server and its related graphical user interface - SQL Server Management Studio (SSMS). Next, two sample databases will be installed (as provided by Microsoft) to practice SQL statements. Moreover, you will be instructed on how to create your database. Within your database, you will be taught about designing tables and declaring their corresponding attributes (columns), data types, and other characteristics such as /Not and uniqueness. This leads to defining the primary key (PK) in a table. Once a database and its table(s) are defined, you will be taught through examples to populate them with data. Data manipulation language (DML) is the main focus of this course, in which you will learn how to make use of the information/data stored in tables. Starting with the basics of SQL i.e. SELECT-FROM-WHERE, we will proceed to learn how to use calculations in SQL. You will also be taught SQL (both mathematical and string) functions, along with different SQL clauses such as TOP, HAVING, GROUP BY, etc. You will also be taught how to join multiple tables using a foreign key (FK). Finally, the UPDATE statement will be taught to show how to modify data in a database. Once completed, students will be able to install a database server, create their database, make tables, define attributes, PK, and FK, and manipulate/modify data in their database using SQL statements. A practice exercise is a part of the course as well.
