Advanced SQL with Teradata

This course is designed to give delegates a comprehensive understanding of Teradata database Architecture and how to write queries to efficiently process and filter large amounts of data contained in Teradata data warehouses. It will expose delegates to Advanced SQL operations and the technique for processing, importing and exporting
Learn via
Classroom/Virtual
Duration
3 days or
6 evenings
Level
Advance
Type
Course
  • Overview
  • Prerequisites
  • Learning Outcomes
  • What's included
  • Course Outline

This course is designed to give delegates a comprehensive understanding of Teradata database Architecture and how to write queries to efficiently process and filter large amounts of data contained in Teradata data warehouses. It will expose delegates to Advanced SQL operations and the technique for processing, importing and exporting data in Teradata.

You will need to have knowledge and skills of using SQL and Teradata to intermediate level.

After successfully completing this course, you will be able to:
• Understand Teradata Architecture and its components
• Learn the concepts of Primary, Secondary and No Primary Index in Teradata
• Create a Database, User and Profile in Teradata
• Understand Teradata SQL fundamentals; You will learn to create/alter/drop database objects and perform various SQL operations on the data stored in Teradata tables.
• SQL concepts like Aggregate Functions, Joins, Subquery
• See the difference between Rank, Dense_Rank and Row number and Use the ANSI Merge syntax to merge data from source to target Write SQL using the RANK, QUANTILE and WIDTH_
• Understand Cumulative Sum, Moving Average and Moving Count
• Case Statement, Coalesce Function and Partitioning in Teradata
• Understand and use Date, Time and Timestamp

•Interactive training classes in 3 days (daytime timetable) or 6 evenings (evening timetable)
•Hands-on practice after the classes with a work-based assignment in 14-21 days
•Access to support by our mentors during the course period
•Pairview Certification for achieving this competency

Learning Goal:

In this module, you will be reintroduced to the basic relational concepts and overview of Teradata, Comparison with other RDBMS, Architecture, Interaction between components, Storage and Retrieval architecture, Connectivity with Mainframe and advanced architecture.

Curriculums:

  • What is Teradata
  • Basic Relational Concepts
  • Competitive advantages over other RDBMS
  • …and more.

Learning Goal:

In this module, you will be reintroduced to the basic relational concepts and overview of Teradata, Comparison with other RDBMS, Architecture, Interaction between components, Storage and Retrieval architecture, Connectivity with Mainframe and advanced architecture.

Curriculums:

  • What is Teradata
  • Basic Relational Concepts
  • Competitive advantages over other RDBMS
  • …and more.

Learning Goal:

In this module, you will learn about SQL commands used in Teradata. You will learn to create/alter/drop database objects and perform various SQL operations on the data stored in Teradata tables.

Curriculums:

  • Data types
  • DDL Statements (CREATE, ALTER, DROP)
  • DML Statements – Write SQL to modify the database, using the UPDATE, INSERT, and DELETE statements
  • …and more.

Learning Goal:

In this module, You will work with advanced features such as recursive subqueries, scalar subqueries using OLAP functions and temporary tables, rank, Quantile and Width_bucket. Also, you will learn more about SQL Commands in Teradata, understand the Explain statement is also introduced and will be used in analyzing query performance and collect statistics. Additional topics include Global and Volatile Temporary tables.

Curriculums:

  • Subqueries
  • Upsert
  • Case
  • …and more.

Learning Goal:

In this module, you will learn about some of the Application utilities provided by Teradata. How to use FastLoad, BTEQ and MultiLoad are used to import data. Also, you will learn about the FastExport and TPT utilities

Curriculums:

  • What is FastLoad
  • How FastLoad loads data
  • How to restart failed FastLoad jobs
  • …and more.

Learning Goal:

Understand and use Date, Time and Timestamp

Curriculums:

  • Default Date Formatting
  • Setting Date Formatting Defaults
  • Session-Level Formatting
  • …and more.

What You Will Benefit From

Our expert knowledge and job-focused approach sets us apart in our quest to offer excellent services to our delegates and deliver on their career development goals.

Get Real Employable Skills

Our job-focused courses and quality curriculum is designed and taught by industry experts and highly experienced professionals, not academics, so you learn the high-impact skills that top companies want.

Gain Best Real-World Practices

Apply your skills in real time through interactive trainer-led practices during the classes, and after-class assignments. As you do so, you are empowered with the problem-solving skills and job market insights needed to capture most new job opportunities in this field or take your career to the next level.

Achieve Professional Certification

Obtain Pairview Certification for completing this course, recognised by many employers in the industry.

Personalised Support and Career Consultancy

You will have access to tailored support by our dedicated mentors while you learn and practise. Our mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track. They also give you valuable advice on professional and career development.

What They Think

Pairview is an excellent place to start your career if you dream of an Analytics profession. Firstly, you must believe you can make it. Secondly, utilize all the support provided. And thirdly, ensure you complete all the projects. Pairview trainers are very knowledgeable and patient when explaining things over. Thanks to Pairview’s continuous support, I got my current job.

Jonas Nachis

Great company with thorough professionals that will ensure the process you are taken through is seamless as they will work around the clock to cater to your needs. Highly recommend Pairview for those wishing to make a career change or enter the world of Analytics.

RT

The trainers were very helpful in ensuring the essentials of the modules were well understood and were always there to provide guidance and a helping hand whenever necessary. Prior to my Pairview programme, I wasn’t able to land a job, but after completing it, I generated a lot of interests and received multiple offers. I would recommend Pairview to

NKT

The interview preps were actually built on my project experiences, where I was coached on how to showcase my strengths and skills with the project experiences as evidence. Pairview went extra miles to support me before my interviews. Sometimes I asked them for help with a next-day interview, the consultant tried his best to prep me that night.

EK

The course delivery was very well-paced, and there were loads of practical examples which helped drive in the knowledge and provided a solid foundation. Really pleased with the service I received, and I will definitely recommend Pairview. I have many colleagues who also trained here and are doing very well in Data and MI analytics.

Ani Madu

Management Information Analyst

Great Training. Highly Recommended! The training I received helped build and equip me with the foundation I needed for a great career path in the field of Data Science.

OJO

Data Science Specialist

You’ll never get it wrong when you make the right choice of choosing Pairview programmes for individual and corporate training needs. They are fantastic and supportive, and they know the market, which makes them think ahead. I enjoyed their supportive training, real-time projects, and extra development and have remained a high-flyer.

David Mba

Analytics Specialist

After completing my Masters’s programme, I struggled to secure a job and I was frustrated. The training with Pairview gave me a direction to my career. Since I completed the training, it was easy for me to get the first analytics job and progress to senior positions. Hence, it was a complete value for money.

Ubong

Senior Data Analyst

Personalised Career Development Add-ons

We provide Add-on Services customised for your needs at every step of your learning journey to ensure your success.

  • Project-based Work Experience
  • CV Surgery
  • Placement Support
  • Recruitment Coaching

Gain indispensable experience with our projects

Gain work experience by undertaking real-world projects deriving from our consultancy work with global corporate clients. You will work on some of the most popular problems faced by businesses across industry sectors.

Learn by doing leads to real skills mastery and business acumen competency.

 

PROJECTS BY THE NUMBERS

92%+   of delegates completed their projects with Merit or Distinction

4.6+   service ratings

 

PROJECT SERVICES

  • 2 months of work experience
  • Assigned Project Manager for supervision and support
  • Weekly support sessions
  • Project presentation and personalised feedback
  • Unlimited submissions and feedback loops
  • Practical tips and industry best practices

Perfect your CV with our bespoke CV Surgery

Marketing yourself effectively to employers is critical so you can get the job you want for the best pay possible.

We will work with you personally on a one-to-one basis to perfect your CV. We will ensure it is a clear and accurate picture of your capabilities, is professionally written, and can capture interest of most recruiters and bring maximum opportunities of job interviews for your relevant roles.

 

CV SURGERY BY THE NUMBERS

100%   of final CVs captured job opportunities in the first few days

4.9+   service ratings

 

CV SURGERY SERVICES

  • One personalised review and edit
  • Various templates sourced from successful job placements
  • Resume optimisation tips

Have access to our extensive recruitment network

We help our corporate clients solve skill shortage challenges and provide talent security in the hardest to find skill sets on the market. Gain access to the best job opportunities within our extensive recruitment network and channels.

 

PLACEMENT SUPPORT BY THE NUMBERS

98%+   of delegates got jobs or progressed their career upon completion

4.7+   service ratings

 

PLACEMENT SUPPORT SERVICES

  • Personal assistance in your job search
  • Job opportunities from our corporate partners
  • 1-on-1 calls
  • Helps expand your professional network

Maximise your job opportunities and salary negotiation

Our Recruitment Consultant will help you target the most potential, relevant job opportunities across all available channels for job interviews and provide you with all the necessary interview preparation and techniques to enable you to successfully manage interviews and salary negotiations.

The Consultant will cover responses to those awkward or sensitive questions you may be asked and work with you to increase your level of personal impact and credibility at referral meetings and interviews through role play and practice. You will learn to project what you have to offer calmly and with confidence.

 

RECRUITMENT COACHING BY THE NUMBERS

98%+   of delegates got jobs or progressed their career upon completion

4.7+   service ratings

 

RECRUITMENT COACHING SERVICES

  • Weekly recruitment consultancy sessions
  • Personalized feedback and career guidance
  • Demystifying the hiring process for you
  • Advice on recruitment tests
  • Advice on interview questions and techniques
  • Advice on negotiating job offers
priscilla-du-preez-XkKCui44iM0-unsplash

Advanced SQL with Teradata

Choose a learning option and start date to view further information and payment details below.
We are just a click away if you need any assistance

This product is currently out of stock and unavailable.

Contact Us!

Have enquiries of a course/programme? Want a career consultation? Or look for bespoke training?

Let’s start a conversation!

All Rights Reserved © 2020

Welcome Back, We Missed You!

Download Now

Please fill out this form to view the brochure