SQL: Table Transformation

Online Course

Codecademy
SQL: Table Transformation

What is the course about?

SQL: Table Transformation
The course SQL: Table Transformation is an online class provided by Codecademy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Practice more SQL in this course that covers how to manipulate and transform data.

Course description
  • SQL: Table Transformation
  • 3 Hours
  • This course lets you get more sophisticated with what you can do with data. Even if you are not doing data analysis yourself, understanding what is possible is essential in today’s data-driven world.
  • In this course created in partnership with Looker, you’ll learn more about manipulating data stored in relational databases using SQL. You will become familiar with subqueries, set operations, conditional aggregates, and more.
  • Subqueries
  • Use subqueries to transform data tables by nesting one query within a query.
  • Set Operations
  • Use set operations to query data from multiple tables.
  • Conditional Aggregates
  • Learn about conditional aggregates, a way to use aggregate functions based on a given set of conditions.
  • Date, Number, and String Functions
  • Use built-in date, number, and string functions to transform table data.

Prerequisites & Facts

SQL: Table Transformation

Course Topic

Development, ECMAscript, Web Development

University, College, Institution

Codecademy

Course Skill Level

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Degree & Cost

SQL: Table Transformation

To obtain a verified certificate from Codecademy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.
Codecademy
SQL: Table Transformation
provided by Codecademy

Reviews

[display-frm-data id=”8278″ filter=”1″]

Please select a valid form
Here you can find information, reviews and user experiences for the course “SQL: Table Transformation“. The provider of the course – “Codecademy” – will be glad to answer any questions you may have about the class, click here to use the offical support channels. It would be great if you could share your experience of participating in the course – Your honest review will surely help others to choose the right class!
School: Codecademy
Topic: SQL