SQL for Data Analysis

This SQL training course will teach students how to write SQL statements to speed up the data analysis process. SQL is the standard language for relational database management systems and is used to communicate with a database. Most of the data processing tasks done under Excel, such as joining tables, calculation, extracting data or data query, can also be accomplished well with SQL. It can even outperform Excel in the context of large volume of data.

Students will be guided through a series of exercises starting from writing simple SQL statements to more complex statements at the end of the course. They will learn how to query data from multiple tables using inner or outer joins methods.

This is an ideal course for analysts who are looking for more efficient ways to analysis and managing data or tools to work in conjunction with Excel.

What you’ll learn

An Overview of Relational Databases

  • The Role of the Database Server
  • Interacting with a Database Server: The Client
  • Databases, Schemas, Tables, Rows and Columns
  • Primary Keys and Foreign Keys Explained
  • Introducing Data Types: Character, Numeric, Date and Time

Introducing SQL

  • Creating and Editing SQL
  • About Statements, Batches and Scripts
  • Executing and Parsing SQL Scripts
  • Using Comments
  • SQL Syntax and The Rules of SQL
  • About Keywords, Identifiers, Operators, Whitespace and Case
  • About the Semi Colon

Retrieving Data with SQL

  • Introducing Queries: The SELECT Statement
  • The Clauses of the SELECT Statement
  • About Optional Clauses and Mandatory Clauses
  • Using FROM to Specify the Source Table(s)
  • Retrieving Entire Tables
  • Retrieving Specific Columns
  • Using Column Aliases to Rename Columns
  • Performing Calculations
  • Using Numeric and String Operators to Create Derived Output
  • Ways of Limiting the Output
  • Using ORDER BY to Sort the Output

Using WHERE to Filter Results

  • Working with Comparison Operators (=, >= etc)
  • Numeric and String Based Filtering
  • Filtering Based on Calculations
  • Eliminating Duplicate Results with DISTINCT
  • Extending Filters with AND and OR
  • Range Filtering using BETWEEN and IN
  • Matching Patterns with LIKE

Getting Results From Multiple Tables

  • Joins Explained
  • The Different Types of Joins
  • Working with Inner Joins and Outer Joins
  • Working with Left Joins and Right Joins
  • Using Table Aliases

Grouping and Summarizing Results

  • Using Aggregate Functions (MAX(), SUM(), AVG(), COUNT() etc)
  • The Way Aggregate Functions Work
  • Using GROUP BY to Group Results
  • The Need for HAVING: Filtering the Result Table

Inserting, Updating and Deleting Data

  • Inserting Single Rows
  • Inserting Multiple Rows
  • Inserting Data from one Table into Another
  • Updating Data
  • Deleting Data

SCHEDULES
 
SQL7112 - 廣東話 10 Nov enrol
 
SQL8021 - 廣東話 08 Feb enrol
RELATING COURSES
  Access
  Access SQL
  Advanced Access
  Certificate course in eShop Production