SQL: Table Transformation

Codeacademy
Online

Gratis

Informazione importanti

  • Corso
  • Online
  • Quando:
    Da definire
Descrizione

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.

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Da definire
Online

Cosa impari in questo corso?

SQL
Subqueries
Set Operations
Conditional Aggregates
String Functions

Programma

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.