SQL: Table Transformation

Codeacademy
Online

Free

Important information

  • Course
  • Online
  • When:
    Flexible
Description

The following course, offered by Codeacademy, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information! Practice more SQL in this course that covers how to manipulate and transform data.

Important information
Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

SQL
Subqueries
Set Operations
Conditional Aggregates
String Functions

Course programme

Unit 1 : Subqueries
Lesson: Subqueries Use subqueries to transform table data by nesting one query within another query.

Unit 2 : Set Operations
Lesson: Set Operations Learn about set operations, a method of utilizing data from multiple tables.

Unit 3 : Conditional Aggregates
Lesson: Conditional Aggregates Use conditional aggregate functions to transform data based on a set of conditions.

Unit 4 : Date, Number, and String Functions
Lesson: Date, Number, and String Functions Use built-in date, number and string functions to manipulate table data.