SQL and Data Science – Introduction

About this course

The course introduces data science through the analysis of structured data held in databases. Participants explore how to create, manage and edit tables, then use SQL statements to retrieve, sort, group and summarise records from a single table. They also learn to produce simple reports and transfer data into and out of SQL. The course then considers how SQL can work with other applications, including websites and desktop software, alongside approaches for incorporating unstructured information such as customer feedback or social media comments.

What you'll learn

• Create, manage and edit data tables using SQL
• Retrieve records from a single database table with SQL queries
• Sort, group and summarise database records
• Produce simple reports from queried data
• Import and export data using SQL
• Explain ways SQL can integrate with websites and desktop applications

Is this course right for you?

The course is labelled Beginner (A1) and is intended for learners starting to explore SQL and data science. The stated entry requirements include being a competent computer user and having an interest in collecting and manipulating data for analysis.

• Suitable for learners interested in working with business or other computer-held data
• Requires general computer competence