Analyzing structured data requires understanding the fundamentals of relational databases and practical skills in Structured Query Language (SQL). In addition, the rapid development in social media and smart devices resulted in an explosion of semi-structured or unstructured data available for analysis. New data management techniques hence need to be adopted to handle a large amount of data for analysis. This course emphasizes database concepts and practical skills to analyze structured data through SQL. This course also introduces network risk management, which helps organizations identify and mitigate potential cyber threats, maintain network stability, and ensure secure data process and analysis. In addition, the new trends of data management will be covered. Finally, techniques used to process big data such as Apache Spark and PySpark will be introduced.

CILO-1: Describe the design principles of relational database. CILO-2: Demonstrate the ability to manage and analyse data using SQL. CILO-3: Describe new development in data management. CILO-4: Apply big data processing techniques in business cases.