SQL for Data Analytics
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Contact Us
DOWNLOAD COURSE BROCHURE
CERTIFICATES
FLEXIBLE DELIVERY
LIVE SUPPORT
INTERNSHIP AVAILABLE

ABOUT THE COURSE

The course is 100% real-world case study driven, seeking to familiarise students with some essential functions that occur in a real working environment using the most popular data analysis software such as SQL.

UNITS

1. Welcome to Data Analytics

  • What is SQL
  • Types of Databases
  • Understanding Table Structure
  • Data Types
  • Types of Statements and DB Roles

 

2. Retrieving Data

  • The SELECT Statement
  • Retrieving DISTINCT Values

 

3. Grouping and Sorting Data

  • Grouping Data
  • Sorting Data by Columns
  • Using HAVING Clause
  • Using DATE Functions
  • Section Quiz

 

4. Filtering Data

  • Using WHERE Clause
  • Filtering with Comparison Operators
  • Advanced data filtering with AND and OR
  • Using IN, NOT and BETWEEN

 

5. Using Wildcard Filtering

  • Using LIKE and Wildcard Characters
  • Section Quiz

 

6. Summarising Data

  • Using MIN and MAX
  • Using SUM
  • Using AVG
  • Using COUNT
  • Aggregating DISTINCT values
  • Understanding NULL and Using NULL Functions
  • Section Quiz

 

7. Case Statements

  • Understanding CASE Clause
  • Using CASE Clause with Aggregate Functions
  • Section Quiz

 

8. Creating and Manipulating Tables

  • Creating Tables
  • Updating Tables
  • Renaming Tables
  • Understanding Data Inserting into a Table
  • Understanding Data Copying From one Table to Another
  • Updating Data in a Table
  • Deleting Data
  • Deleting Tables
  • Section Quiz

 

9. Table Joins

  • Using Table Aliases
  • Using Different Join Types
  • Using Joins with Aggregate Functions
  • Using UNION Operator
  • Section Quiz

 

10. More examples and Assessment tests on complex queries

UPON COMPLETION

This course is eligible for CPD hours. Upon successful completion of all the required units of this course, students will receive a certificate of completion.

CAREER OPPORTUNITIES

  • Data Scientist
  • Business Analyst
  • Data Analyst
  • Net Developer
  • Project Manager

DURATION

Two days

* Please contact us for the timetable.

ENTRY REQUIREMENTS

No education entry requirements

FINANCE OPTIONS

FINANCE OPTIONS

Fees must be paid within 5 working days of receiving the confirmation of enrolment and invoice for the enrolment fee.

Seed Training Group may cancel an enrolment or discontinue training if fees are not paid as required.

Both direct deposit and credit card are accepted.

*Please refer to the Student Information Handbook for further details regarding Fees & Refund Policy and Procedure.

Trainer’s Profile

Sinem has more than 6 years of experience in data analytics and decision making in global banking, insurance and FMCG industries with a strong big data hands-on experience

TESTIMONIALS
PARTNERSHIP & COLLABORATORS
Call Me Back