EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

Introduction to Data Analysis Using SQL for Beginners

Course outline

5 days
Discuss this programme →

Duration

Introduction to Data Analysis Using SQL for Beginners

5 days

Overview

This course is designed for beginners who want to learn the fundamentals of data analysis using SQL (Structured Query Language). SQL is a powerful language for managing and manipulating relational databases, making it an essential skill for anyone working with data. Throughout the course, participants will gain hands-on experience in querying databases, performing data manipulation, and extracting valuable insights from structured data.

Prerequisites

No prior knowledge of SQL or database management is required. Basic computer literacy and familiarity with spreadsheet software (e.g., Excel) is recommended.

Lesson 1: Understanding Databases

  • Overview of databases and their importance
  • Types of databases (relational, non-relational)

Lesson 2: Introduction to SQL

  • Basic SQL syntax
  • Common data types in SQL
  • Creating a database and tables

Lesson 1: SELECT Statement Basics

  • Retrieving data from a single table
  • Using aliases for columns

Lesson 2: Filtering Data

  • WHERE clause for conditional retrieval
  • Logical operators (AND, OR, NOT)

Lesson 1: Sorting Data

  • ORDER BY clause
  • Sorting results in ascending and descending order

Lesson 2: Grouping Data

  • GROUP BY clause
  • Aggregate functions (COUNT, SUM, AVG, MAX, MIN)

Lesson 1: Understanding Joins

  • INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
  • Combining data from multiple tables

Lesson 2: Working with Relationships

  • Foreign keys and primary keys
  • Establishing and maintaining relationships

Lesson 1: Inserting Data

  • INSERT INTO statement
  • Adding records to a table

Lesson 2: Updating and Deleting Data

  • UPDATE and DELETE statements
  • Modifying and removing records

Lesson 1: Subqueries

  • Understanding subqueries
  • Using subqueries in SELECT statements

Lesson 2: Views

  • Creating and using views for data abstraction
  • Modifying and dropping views

Lesson 1: Aggregating Data

  • GROUP BY with multiple columns
  • GROUP BY with ROLLUP and CUBE

Lesson 2: Common Table Expressions (CTEs)

  • Creating and using CTEs for complex queries

Lesson 1: Basics of Data Visualization

  • Importance of visualization in data analysis
  • Simple charts and graphs using SQL

Lesson 1: Applying SQL in Business and Research

  • Case studies and examples from various industries
  • Practical applications of SQL in real-world scenarios

Module 10: Final Project and Practical Application

  • Capstone project: Applying SQL skills to analyze a provided dataset
  • Presenting findings and insights
  • Peer review and feedback

Programme scope, delivery arrangements and suitability are confirmed during enquiry.