Database Design & Management


Relational Database Management Systems (RDBMS) represent arguably the most important
class of software programs in modern enterprises. They support transactional systems, they
power websites and mobile apps, and they house much of these data for later analysis. As an
analyst in the modern enterprise you must be able to design, implement and effectively use
Fortunately RDBMS all adopt the same language: Structured Query Language (SQL). Thus,
knowledge of SQL is portable across products. SQL is both a DDL (data definition language) and
a DML (data manipulation language). It gives you the ability to create and modify databases, as
well as to analyze their content. While the advent of Big Data and noSQL databases adds new
and powerful weapons to the data scientist’s quiver, fluency in the use of SQL remains the
cornerstones of your preparation.
Course Objectives
Upon successful completion of this course you will be able to:
1. develop a valid data model
2. implement a relational database using the MySQL RDBMS
3. formulate and execute complex relational database queries with SQL
4. understand the basics of R as a programming language
5. use R to extract data from a MySQL database and provide a basic analysis of the data

For further information please refer to the Online Courses Catalogue – CLICK HERE

For lecture materials please refer to KIRO – CLICK HERE

*Materials available when lectures start