SQL Introduction

This course provides an outline of the field of data science and an introduction to the process of data mining.

Learning objectives

After completing this course, you should:

• Understand structured data
• Understand the characteristics of SQL, including the constraints, types and some of the sub-languages
• Understand how data retrieval works
• Be able to execute simple queries
• Be able to analyse and optimise query executions using the optimiser
• Understand how to distribute the data

Topics covered

This course addresses the following knowledge areas:

• Structured data
• Raison d'etre
• Characteristics of SQL (contraints, types, sub-languages)
• Data retrieval (simple queries, query execution, distributing data)

XP LEVEL Beginner
DURATION: 2 days
ASSESSMENT: Assignment
SUPPORT: Discussion forum