Teradata SQL for Data Science and Data Analytics
What you’ll learn
Learn most commonly used SQL statements for data analytics
Learn main SQL concepts (JOINs, Aggregation, Set Operations, DDL, etc.)
Learn Teradata Studio and overview of Teradata’s main applications
Build a Real Life Database with Chess Data
Become proficient with SQL Data Types (VARCHAR, DATE, TIMESTAMP, INT, etc.)
Build different Database Objects like Volatile and Permanent Tables
Requirements
An average computer (Windows or Mac) with 8GB RAM or above.
Description
Learn SQL using a Teradata! Teradata SQL has many additional extensions that make it feel a few years ahead of the industry. Combined with its speed, performance, and integration capabilities, Teradata is the number one rated Data Warehousing product in 2020 by Gartner. Most of the biggest companies in the world use Teradata, including all 17 top communication companies.In this course you learn SQL using Teradata, which is an ANSI-compliant vendor of SQL is a future-focused way of learning SQL. The Teradata SQL skill set is easily transferable to other SQL platforms such as Amazon Redshift, MySQL, Microsoft SQL Server, and others.This course can help you if you relate with any of these descriptions:1. Are you totally new to SQL?Learning Teradata SQL is a great way to learn SQL, especially to distinguish you from the big pack of SQL developers. In my experience in interviewing many SQL candidates and in working with many interviewers, a candidate who knows Teradata SQL shines like a diamond!A candidate who knows Teradata SQL, most likely has worked with huge datasets which is already a big plus! It indicates that the candidate has gone beyond the bare minimum SQL. So join this course to upgrade your resume, and stand above the crowd!2. Do you have a background in other SQL platforms (MySQL, SQL Server, Oracle, etc.) and you need to learn Teradata SQL?This is how I started to learn Teradata myself. Teradata is one of the best relational databases and data warehouses on the planet, but the lack of reliable instructions and tutorials on the internet may drive you crazy!This course is the most complete course on Teradata SQL on the internet! It gives you an overview of the main products of Teradata in data warehousing. Then it focuses on the Teradata Database, the core of the data warehouse. That’s where the core of our course also begins by installing our relational database, and starting to talk to it by its language, Teradata SQL.3. If your role is- A Business User or Analyst in finance, marketing, healthcare (you name it) and you don’t feel confident using the data you get yourself.- A Data Scientist and your pet peeve is data cleansing! Before everything is ready for your cutting-edge ML knockout blow, you need that solid communication with your data warehouse.- A Data or BI Analyst, and your fluency in SQL is key in providing reliable meaningful results.- A SQL Developer, Data Engineer, or Data Architect and you need to interact with your databases more easily so that you can focus on other core parts of your role in development and design.I have created this course with your role in mind! I have put my experience with relational databases in these roles for over 10 years, so that you can get good at what constitutes over 80% of the practical SQL needed in the roles above.Teradata is the number one solution in Data Warehousing, and Data Warehousing is what enabled this booming era of data; be it in Data Science, Business Intelligence, or even in the growth and practicality of the internet.In this journey, we will:o Overview the main data warehousing products of Teradatao Install a fully functional database and Teradata Studio to write SQL witho Have a crash course on Teradata Studio to use it easily and benefit from its advance featureso Learn SQL statement categories of DCL, DDL, and DMLo Create different types of tables and database objectso Learn data types, logical expressions, joins, aggregation, SET operators, string functions, and many more topicso Learn by creating a chess database with data about players, chess tournaments and games, and more.Feel free to check out the free preview videos.If you are ready for this journey together, I will see you inside in the course!
Overview
Section 1: Why Teradata SQL
Lecture 1 Why to learn Teradata SQL
Section 2: Teradata Products
Lecture 2 Section Intro
Lecture 3 Teradata Corporation
Lecture 4 Teradata Vantage
Lecture 5 Query Submitting Tools
Lecture 6 Load and Unload Utilities
Lecture 7 Viewpoint and other Administrative Tools
Section 3: Installation and Getting Started
Lecture 8 The Teradata Database Setup
Lecture 9 Installing Teradata on Windows
Lecture 10 Installing Teradata on Mac
Lecture 11 A Note for Installation Issues
Section 4: Teradata Studio Crash Course
Lecture 12 Section Intro
Lecture 13 Intro for Mac Users
Lecture 14 Initial Setup of Teradata Studio and Connection Types
Lecture 15 Overview of Teradata Studio Modules
Lecture 16 Customizing the Interface and Result Set Viewer
Lecture 17 History View
Lecture 18 Data Source Explorer
Lecture 19 Files and Project Explorer
Lecture 20 Additional Features of Teradata Studio
Section 5: Introduction to SQL and RDBMS
Lecture 21 Relational Model
Lecture 22 Role of Intelligence
Lecture 23 Types of SQL Statements
Lecture 24 OLTP and OLAP
Lecture 25 Facts and Dimensions, Star and Snowflake
Lecture 26 Structured and Unstructured Data
Section 6: DDL Statements in SQL
Lecture 27 Section Intro
Lecture 28 Database Objects
Lecture 29 Challenge – Database Objects
Lecture 30 Answer – Database Objects
Lecture 31 CREATE TABLE – Using Existing Tables
Lecture 32 CREATE TABLE -Table and Column Attributes
Lecture 33 Data Types
Lecture 34 Column Attributes and Indices
Lecture 35 Temporary Tables – Derived, Volatile, and Global Temporary Tables
Lecture 36 Challenge, CREATE TABLE
Lecture 37 Answer – CREATE TABLE
Section 7: DML & DQL Statements in SQL
Lecture 38 Section Intro
Lecture 39 INSERT UPDATE & DELETE Statements
Lecture 40 INSERT Statements – Assignment
Lecture 41 INSERT Statements – Answer
Lecture 42 SELECT Statements
Lecture 43 Logical Expressions and Filters
Lecture 44 Pattern Matching with Escape Characters
Lecture 45 SAMPLE and TOP
Lecture 46 JOINs – INNER JOIN, OUTER JOINS, CROSS JOIN
Lecture 47 Aggregation
Lecture 48 Ordered Analytical Functions
Lecture 49 SET Operators
Lecture 50 String Functions
Lecture 51 Conditional Processing
Lecture 52 Data Type Conversions
Lecture 53 DATE Functions
Lecture 54 TIME Functions
Lecture 55 TIMESTAMP Functions
Section 8: Macros
Lecture 56 Macros Part 1
Lecture 57 Macros Part 2
Section 9: Final Project
Lecture 58 Final Project Assignment
Lecture 59 Final Project Solution
Section 10: Conclusion
Lecture 60 Conclusion
Anyone interested in learning SQL,SQL Developers,Data Scientists,Data Analysts,IT Professionals,Business Analysts
Course Information:
Udemy | English | 6h 28m | 3.18 GB
Created by: Mahyar Peysepar
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com