Teradata: Improving Analysis and Storage

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Teradata: Improving Analysis and Storage

Coursera · Intermediate ·📊 Data Analytics & Business Intelligence ·3mo ago

Key Takeaways

Improves analysis and storage techniques in Teradata, focusing on efficiency and storage for real-world applications

Original Description

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.
Watch on External: Coursera ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
12.4 Million US Business Registrations Are Sitting on State Open-Data Portals, Free
Unlock 12.4 million US business registrations for free from state open-data portals and boost your business intelligence
Dev.to · Brad Ju
📰
Mau Naik Level? Ini Advanced Data Science Techniques untuk Data Analytics
Learn advanced data science techniques for data analytics to improve business decision-making
Medium · Data Science
📰
I Finally Understood AWS Data Pipelines After Following a Single Customer Click
Learn how to understand AWS Data Pipelines by following a customer click, making it easier to design and implement data workflows
Dev.to · Anupa Supul
📰
Beyond the Basics: Streamlit, Dash, and Bokeh for Interactive Dashboards
Learn to create interactive dashboards with Streamlit, Dash, and Bokeh, going beyond basic data visualization tools
Dev.to · RoyserVillanueva
Up next
ChatGPT Will Make Your Excel & Google Sheets x10 Better!
Educraft
Watch →