报告题目：An Introduction to SQL and Database Management Systems
Dr Brendan Hayes is an Assistant Professor in the School of Electronic Engineering in Dublin City University (DCU). He received his PhD in Electronic Engineering (2016) from DCU. Dr Brendan Hayes is the primary module lecturer on the Control Systems Analysis course, guest lecturer on the Web Application Development course and provides supplementary lectures on Object Oriented Programming and Mathematical Techniques and Problem Solving. In addition, he has academic responsibility for the School’s Chinese collaborative education programmes. He is a member of the Institute of Electrical and Electronics Engineers (IEEE).
Relational databases systems are the most common database management systems today (DBMS). These relational DBMSs organize data into separate structures called tables, which can be linked via common information to make data storage more efficient. A DBMS is like a traditional filing system in that it stores individual groups and pieces of information. Standard Query Language (SQL) is the most popular language for interacting with databases.In this lecture, Dr. Hayes will present an overview of the Relational Data Model first described by Dr. Codd in 1970. He will use an online interactive tool to demonstrate the fundamentals of the SQL language for interacting and editing information in a database. The importance of topics such as primary and secondary keys, null values and more advanced queries will be highlighted through the use of examples.