Teradata Fundamentals - Comprehensive SQL course on Teradata

Learn to load data from Azure Blob Storage into Teradata Vantage by creating a storage account, uploading a file, configuring authorization, and using a foreign table and view.

Open the Teradata administrator, establish a connection, and create a work database for the dbc user with allocated space and backup snapshots; then create tables in the worker database.

Create a new Teradata user in the administrator tool, set a password and space types (permanent, pool, temporary), configure profile and default database, then grant or revoke object rights.

Create and link a profile to multiple Teradata users, configure password expiry, account, database, and pool space settings, and apply profile level parameters over user level settings.

Create tables with the create command, define columns and a primary index in Teradata, then insert values, delete rows, and drop tables, noting unique versus non unique primary indexes.

Explore alter and update commands in Teradata to add, drop, modify, or rename columns, adjust data types, and increment salaries. See practical examples demonstrating table changes and salary updates.

Learn Teradata fundamentals by using the select statement to display all records or specific columns from a table, and apply the where clause to filter results by criteria.

Discover how the order by clause sorts data by salary in descending or ascending order, using DESC or ASC, including multiple columns and column position references to resolve ties.

Learn how the extract command retrieves year, month, day, hour, minute, and second from dates and timestamps in Teradata SQL. Use it on columns to compute tenure and time components.

Learn how to use the concatenate function in Teradata to combine strings, such as first name and last name, and build phrases like 'my name is' with aliases.

Explore how the substring function extracts a portion of a string by specifying a starting position and length, with examples using Renaldo, William, Trump, and the length function.

Explore the Teradata index function to locate a character's position in a string, returning the first occurrence's index and zero when the character is absent.

discover how to use the trim function in Teradata to remove spaces and unwanted characters from the start and end of strings, with practical examples and simple aliasing.

Teradata fundamentals show how the upper and lower functions convert strings to uppercase or lowercase, with a sample query applying upper and lower to a table column.

Explore arithmetic operators in Teradata SQL, including addition, subtraction, multiplication, and division, with real-world salary examples and basic comparison and logical operator usage.

Explore comparison and logical operators in sql, and how the and operator requires all conditions to be true. See examples using salary greater than 10000 and specific names like Alex.

Explore the or operator in Teradata SQL, which returns rows when any condition is true, demonstrated with salary > 70000 or name = Andy.

learn to use the between operator in Teradata to filter numbers, text, and dates by specifying inclusive ranges, with examples for salary, names, and date fields.

Explore how the in operator enables multiple value conditions in SQL queries by matching any of several salaries or names, returning rows that meet at least one value.

Learn how to use the like operator to search strings with percent and underscore wildcards, covering starts with, ends with, contains, and position-specific patterns.

Explore the is null operator in Teradata, checking for null values (represented by a question mark) in a salary column to identify salary is null and salary is not null.

Practice questions explore SQL operators including between, like, in, and not equal to, filtering by salary, position, and name to identify managers and directors.

Explore how aggregate functions like count, sum, average, maximum, and minimum compute a single value from grouped data, ignoring nulls, using the group by clause to summarize salary by designation.

Learn how the where clause filters rows before grouping in Teradata, and how the having clause filters groups after aggregation with group by, with salary and position examples.

Practice aggregate functions with SQL queries to compute max, min, avg, sum, and count across departments, including department seven and IT, using group by.

Master subqueries in Teradata SQL, using inner and outer queries with select statements, and apply them to salaries, averages, and department data analysis.

Explore how to use subqueries with insert, update, and delete commands to manipulate employee data: filter by salary, update names, delete records, and insert results into another table.

Explore correlated subqueries in Teradata, where the inner query depends on the outer query and cannot run independently, such as comparing salaries to the department average.

Explain the difference between non correlated and correlated subqueries: non correlated subqueries run once and are evaluated independently, while correlated subqueries depend on the outer query and re-execute per row.

Explore inner joins, outer joins (left, right, full), cartesian product, and self joins to combine records across tables, using on conditions and handling nulls for unmatched rows.

Explore self join by joining an employee table to itself to map bosses using aliases. See inner self join results, left outer join with nulls, and cross self join counts.

Learn practical sql joins by querying employee, department, and job detail tables to display employees with salaries 10000–20000, plus department names and concatenated full names.

Explore the row_number analytic function in Teradata, showing how order by and optional partition by divide data into groups, assign sequential numbers, and support filtering with qualify.

learn how rank and dense_rank work in teradata, see how rank skips ranks on duplicates while dense_rank preserves consecutive rankings using a salary-based example ordered by salary.

Explore how rank and dense rank handle the six highest salaries, showing duplicates cause gaps with rank, while dense rank yields the correct sixth salary value, especially when duplicates exist.

Teradata fundamentals explain the difference between where, having, and qualify, showing how to use having with aggregate functions to filter groups, and how qualify filters analytic results.

Explore cumulative sales, moving average, and moving count calculations using window functions in Teradata. Compute per store and per month with unbounded preceding and partition by store number and month.