This is the second course in our Specialization in Teradata and Data Analysis. In the first course, we set up the concepts, principles, and practical basics to install software, load data, and design a logical and physical data model. In this second course, we'll improve our techniques for data analysis, with an eye on efficiency and storage for your real-world applications on the job.
This is the second course in our Specialization in Teradata and Data Analysis. In the first course, we set up the concepts, principles, and practical basics to install software, load data, and design a logical and physical data model. In this second course, we'll improve our techniques for data analysis, with an eye on efficiency and storage for your real-world applications on the job.
In Module 1, we’ll grow your SQL Toolkit with multi-table, aggregate functions like SUM, AVG, MAX and COUNT. We’ll also expand your concept of primary and foreign keys, so you can make your first JOIN commands in SQL and define relationships between tables.
Our second module is focused on SQL subqueries. We’ll start with single-row subqueries, comparing them to JOIN commands. Then we’ll examine multiple-row subqueries, which allow you to compare a value against multiple values returned from a subquery.
In Module 3, we’ll examine SQL Techniques. We’ll recognize use cases and strategies to use windowed functions in SQL. We’ll define the structure of hierarchical queries in SQL. And we’ll identify for using indexes, so we can optimize our tables for data retrieval.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.