Close
Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
« Important Announcement » Contact Us 877-206-0106 | USA Flag
Close
Close
Close
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

Close
photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Snowflake SQL

Price
1,755 USD
3 Days
SFSQ-100
Classroom Training, Online Training
Other

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees (wherever applicable).
Prices reflect a 24% discount for Kyndryl employees (wherever applicable).
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run

Modality

Location

Language

Date

  • Date: 25-Mar-2024 to 27-Mar-2024
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,755 USD
  • Date: 20-May-2024 to 22-May-2024
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,755 USD
View Global Schedule

Course Description

Overview

In this Snowflake SQL course, course, students will learn Snowflake SQL, which is the most comprehensive SQL of any database. Students can improve their SQL enormously through the hundreds of examples using Snowflake SQL commands.

Note: What is so amazing about Snowflake SQL? If you combine the SQL commands that work on all different database vendors combined, you will be pleasantly surprised that almost every SQL command works on Snowflake.
 

Objectives

  • Use the Nexus Chameleon to migrate and move data to Snowflake.
  • Use Nexus to work with the Snowflake database to run SQL statements, retrieve advanced analytics, and create graphs and charts.
  • Learn a wide variety of Snowflake analytics.
  • Use advanced Order By methods to sort the answer sets retrieved.
  • Fully understand and use Joins and Subqueries
  • Interrogate the data using Case, Coalesce, and Decode.
  • Be able to fully use all of the different Snowflake temporary options.
  • Create tables and views on the Snowflake system.
  • Utilize the many different Snowflake date functions.
  • Use Aggregation and advanced Aggregation techniques.
  • Handle and manipulate Strings.
  • Learn and write SQL for advanced Statistical Aggregate Functions.

Audience


 

Prerequisites


     

Topics

Chapter 1 - Basic SQL Functions
  • Introduction
  • Setting Your Default Database and Schema
  • SELECT * (All Columns) in a Table
  • SELECT Specific Columns in a Table
  • Commas in the Front or Back?
  • Place your Commas in front for better Debugging Capabilities
  • Sort the Data with the ORDER BY Keyword
  • Use a Column Name or Number in an ORDER BY Statement
  • Two Examples of ORDER BY using Different Techniques
  • Changing the ORDER BY to Descending Order
  • NULL Values sort Last in Ascending Mode (Default)
  • Using the Nulls First Command
  • NULL Values sort First in Descending Mode (DESC)
  • Using the Nulls Last Command
  • Major Sort vs. Minor Sort
  • Multiple Sort Keys using Names vs. Numbers
  • Sorts are Alphabetical, NOT Logical
  • Using A Valued CASE Statement to Sort Logically
  • Using A Searched CASE Statement to Sort Logically
  • Quiz – Can you Add a Minor Sort?
  • Answer – Can you Add a Minor Sort?
  • Using Decode to Sort Logically
  • Quiz – Can you Add Two Minor Sorts Using Decode?
  • Answer – Can you Add Two Minor Sorts Using Decode?
  • How to ALIAS a Column Name
  • A Missing Comma can by Mistake become an Alias
  • Comments using Double Dashes are Single Line Comments
  • Comments for Multi-Lines
  • Comments for Multi-Lines as Double Dashes per Line
  • Comments are a Great Technique for Finding SQL Errors
  • Popular Snowflake Functions
  • Move Data to the Snowflake Effortlessly
  • Move Data to the Cloud Effortlessly
Chapter 2 - The WHERE Clause
  • The WHERE Clause limits Returning Rows
  • The WHERE Clause Needs Single-Quotes for Character Data
  • Using a Column ALIAS in the WHERE Clause
  • Numbers Don't Need Single or Double Quotes
  • Searching for NULL Values Using Equality Returns Nothing
  • Use IS NULL or IS NOT NULL when dealing with NULLs
  • Using Greater Than OR Equal To (>=)
  • AND in the WHERE Clause
  • Troubleshooting AND
  • OR in the WHERE Clause
  • Troubleshooting OR
  • WHY OR must utilize the Column Name Each Time
  • Troubleshooting Character Data
  • Using Different Columns in an AND Statement
  • Quiz – How many rows will return?
  • Answer to Quiz – How many rows will return?
  • What is the Order of Precedence?
  • Using Parentheses to change the Order of Precedence
  • Using an IN List in place of OR
  • The IN List is an Excellent Technique
  • IN List vs. OR brings the same Results
  • The IN List Can Use Character Data
  • Using a NOT IN List
  • Null Values in a NOT IN List Return No Rows
  • A Technique for Handling Nulls with a NOT IN List
  • The BETWEEN Statement is Inclusive
  • The NOT BETWEEN Statement is also Inclusive
  • The BETWEEN Statement Works for Character Data
  • LIKE uses Wildcards Percent ‘%’ and Underscore ‘_’
  • LIKE command Underscore is Wildcard for one Character
  • Using Upper and Lower to Handle Case Issues
  • Using ILIKE Handle Case Issues
  • Finding Anyone Who Name End in 'Y'
  • Escape Character in the LIKE Command changes Wildcards
  • Escape Characters Turn off Wildcards in the LIKE Command
Chapter 3 – Distinct, Group By, Top, and Pivot
  • The Distinct Command
  • Distinct vs. GROUP BY
  • Quiz – How many rows come back from the Distinct?
  • Answer – How many rows come back from the Distinct?
  • TOP Command
  • TOP Command is brilliant when ORDER BY is Used!
  • The FETCH Clause
  • Sample and Tablesample
  • TOP vs. Sample
  • The Pivot Command
Chapter 4 – Aggregation
  • Quiz – You calculate the Answer Set in your Mind
  • Answer – You calculate the Answer Set in your Mind
  • Quiz 2 – You calculate the Answer Set in your Mind
  • Answer Quiz 2 – You calculate the Answer Set in your Mind
  • There are Five Aggregates
  • Quiz – How many rows come back?
  • Answer – How many rows come back?
  • Troubleshooting Aggregates
  • GROUP BY when Aggregates and Normal Columns Mix
  • GROUP BY Delivers one row per Group
  • GROUP BY Dept_No or GROUP BY 1 the same thing
  • Limiting Rows and Improving Performance with WHERE
  • WHERE Clause in Aggregation limits unneeded Calculations
  • Keyword HAVING tests Aggregates after they are Totaled
  • Keyword HAVING is like an Extra WHERE Clause for Totals
  • Three types of Advanced Grouping
  • GROUP BY Grouping Sets
  • GROUP BY Grouping Sets Answer Set
  • GROUP BY Rollup
  • GROUP BY Rollup ResultSet
  • GROUP BY Cube
  • GROUP BY Cube ResultSet
  • Quiz - GROUP BY GROUPING SETS Challenge
  • Answer To Quiz - GROUP BY GROUPING SETS Challenge
Chapter 5 - Join Functions
  • A two-table join using Non-ANSI Syntax
  • A two-table join using Non-ANSI Syntax with Table Alias
  • You Can Fully Qualify All Columns
  • A two-table join using ANSI Syntax
  • Both Queries have the same Results and Performance
  • Quiz – Can You Finish the Join Syntax?
  • Answer to Quiz – Can You Finish the Join Syntax?
  • Quiz – Can You Find the Error?
  • Answer to Quiz – Can You Find the Error?
  • Super Quiz – Can You Find the Difficult Error?
  • Answer to Super Quiz – Can You Find the Difficult Error?
  • Quiz – Which rows from both tables Won’t Return?
  • Answer to Quiz – Which rows from both tables Won’t Return?
  • Left Outer Join
  • Left Outer Join Results
  • LEFT OUTER JOIN Using (+)
  • RIGHT OUTER JOIN
  • Right Outer Join Example and Results
  • RIGHT OUTER JOIN Using (+)
  • Full Outer Join
  • Full Outer Join Results
  • Which Tables are the Left, and which are the Right?
  • Answer - Which Tables are the Left and which are the Right?
  • INNER JOIN with Additional AND Clause
  • ANSI INNER JOIN with Additional AND Clause
  • ANSI INNER JOIN with Additional WHERE Clause
  • OUTER JOIN with Additional WHERE Clause
  • OUTER JOIN with Additional AND Clause
  • The DREADED Product Join
  • The DREADED Product Join Results
  • Cartesian Product Join with Traditional Syntax
  • Cartesian Product Join with ANSI Syntax
  • The CROSS JOIN
  • The CROSS JOIN Answer Set
  • The Self Join
  • An Associative Table is a Bridge that Joins Two Tables
  • Quiz – Can you Write the 3-Table Join with Traditional Join Syntax?
  • Answer to Quiz – Can you Write the 3-Table Join with Traditional Join Syntax?
  • Quiz – Can you Write the 3-Table Join Using ANSI Syntax?
  • Answer – Can you Write the 3-Table Join to ANSI Syntax?
  • Quiz – Can you Place the ON Clauses at the End?
  • Answer – Can you Place the ON Clauses at the End?
  • The 5-Table Join – Logical Insurance Model
  • Quiz - Write a Five Table Join Using ANSI Syntax
  • Answer - Write a Five Table Join Using ANSI Syntax
  • Quiz - Write a Five Table Join Using Traditional Syntax
  • Answer - Write a Five Table Join Using ANSI Syntax
  • Quiz –Re-Write this putting the ON clauses at the END
  • Answer –Re-Write this putting the ON clauses at the END
Chapter 6 - Date Functions
  • Current Date
  • Current_Date, Current_Time, and Current_Timestamp
  • Current_Time vs. LocalTime With Precision
  • Local_Time and Local_Timestamp With Precision
  • Add or Subtract Days from a date
  • The ADD_MONTHS Command
  • Using the ADD_MONTHS Command to Add 1 Year
  • Using the ADD_MONTHS Command to Add 5 Years
  • Formatting a Date Using the To_Char Command
  • Formatting Date and Time With To_Char
  • The To_Char command to format Dollar Signs
  • The To_Char Command for Formatting Numbers
  • The EXTRACT Command
  • EXTRACT from DATES and TIME
  • Using Extract
  • EXTRACT from DATES and TIME Optional Syntax
  • Another Option for Extracting Portions of Dates and Times
  • Using Date_Part to Extract
  • Implied Extract of Day, Month and Year using to_char
  • The Date_Part Function Using a Date
  • Great Date Functions to Know
  • DAYOFWEEK and a CASE Statement
  • Year and Days for the First/Last Weeks of the Year
  • First Day and Last Day Functions
  • Incrementing Date Values Using the Dateadd Function
  • Incrementing Time Values Using Dateadd
  • The Datediff command
  • The Datediff Function on Column Data
  • Calculating Days Between using the DATEDIFF Function
  • Changing the Date to a Timestamp
  • Find the First Day of the Current Month
  • Using Intervals
  • Using Day, Month, and Year Intervals
  • Complex Interval
Chapter 7 - Analytics
  • The Row_Number Command
  • Quiz – How did the Row_Number Reset?
  • Answer – How did the Row_Number Reset?
  • Find the Top Two Students Per Class_Code using Qualify
  • Find the Top Two Students using a Derived Table
  • The RANK Command
  • Getting RANK to Sort in DESC Order
  • RANK () OVER and PARTITION BY
  • RANK() OVER and a Qualify Statement
  • RANK() OVER and a WITH Derived Table
  • RANK vs. DENSE_RANK
  • DENSE_RANK() OVER and PARTITION BY
  • DENSE_RANK() OVER and QUALIFY
  • PERCENT_RANK () OVER with 14 rows in Calculation
  • PERCENT_RANK () OVER with 21 rows in Calculation
  • PERCENT_RANK() OVER and PARTITION BY
  • CSUM
  • CSUM – The Sort Explained
  • CSUM – Rows Unbounded Preceding Explained
  • The CSUM – Making Sense of the Data
  • CSUM – The Major and Minor Sort Key(s)
  • The ANSI OLAP – Reset with a PARTITION BY Statement
  • Totals and Subtotals through Partition BY
  • Moving SUM
  • Moving SUM every 3-rows Vs. a Continuous Average
  • Partition By Resets the Calculations
  • Moving Average
  • How the Moving Average Calculates
  • How the Sort works for Moving Average (MAVG)
  • Quiz – How is that Total Calculated?
  • Answer to Quiz – How is that Total Calculated?
  • Quiz – How is that 4th Row Calculated?
  • Answer to Quiz – How is that 4th Row Calculated?
  • Moving Average every 3-rows Vs. a Continuous Average
  • Partition BY Resets an ANSI OLAP
  • Moving Difference using ANSI Syntax
  • Moving Difference using ANSI Syntax with Partition By
  • Finding a Value of a Column in the Next Row with MIN
  • Finding a Value of a Column in the Next Row with PARTITION BY
  • Finding Multiple Values of a Column in Upcoming Rows
  • Finding The Next Date using MAX
  • COUNT OVER for a Sequential Number
  • COUNT OVER using ROWS UNBOUNDED PRECEDING
  • The MAX OVER Command
  • MAX OVER with PARTITION BY Reset
  • The MIN OVER Command
  • The MIN OVER Command with PARTITION BY
  • Finding Gaps Between Dates
  • The CSUM For Each Product_Id For The First 3 Days
  • Using FIRST_VALUE
  • FIRST_VALUE
  • FIRST_VALUE with Partitioning
  • FIRST_VALUE Combined with Row_Number and Qualify
  • FIRST_VALUE and Row_Number with a Derived Table
  • Using LEAD
  • Using LEAD with a PARTITION Statement
  • Using LEAD With an Offset of 2
  • Using LEAD With an Offset of 2 and a PARTITION
  • Using LAG
  • Using LAG with a PARTITION Statement
  • Using LAG With an Offset of 2
  • Using LAG With an Offset of 2 and a PARTITION
  • CUME_DIST
  • CUME_DIST With a Partition
  • CURRENT ROW AND UNBOUNDED FOLLOWING
  • Different Windowing Options
  • LISTAGG Basic Example
  • Another Example of LISTAGG
  • LISTAGG With a Pipe-Separated List
  • LISTAGG With a Comma-Separated List in Groups
  • MEDIAN Function
  • MEDIAN Example
  • MEDIAN with Partitioning and a WHERE Clause
  • MEDIAN with Partitioning
  • NTILE Function
  • How Ntile Works
  • Ntile
  • Ntile Continued
  • Ntile Percentile
  • Another Ntile Example
  • Using Quantiles (Partitions of Four)
  • NTILE Using a Value of 10
  • NTILE With a Partition
  • NTH_VALUE Function and Syntax
  • NTH_VALUE Arguments
  • NTH_VALUE
  • NTH_VALUE With Partition
  • NTH_VALUE With Partition and Ignore Nulls
  • PERCENTILE_CONT Function Description and Syntax
  • Final Result Information About PERCENTILE_CONT
  • PERCENTILE_CONT Function Arguments
  • PERCENTILE_CONT Example
  • PERCENTILE_CONT Example with Percentage Change
  • PERCENTILE_CONT With PARTITION Example
  • PERCENTILE_CONT With PARTITION and (0.4)
  • PERCENTILE_DISC Function Description and Syntax
  • PERCENTILE_DISC Function Arguments
  • PERCENTILE_DISC Example
  • PERCENTILE_DISC Example with Percentage Change
  • PERCENTILE_DISC With PARTITION Example
  • PERCENTILE_DISC With PARTITION and (0.4)
  • RATIO_TO_REPORT Function
  • RATIO_TO_REPORT Example
  • RATIO_TO_REPORT Example with Partitioning
  • SUM(SUM(n))
Chapter 8 - Temporary Tables
  • CREATING A Derived Table
  • Naming the Derived Table
  • Aliasing the Column Names in the Derived Table
  • CREATING A Derived Table using the WITH Command
  • Derived Query Examples with Three Different Techniques
  • Most Derived Tables Are Used To Join To Other Tables
  • The Three Components of a Derived Table
  • Visualize This Derived Table
  • Our Join Example With the WITH Syntax
  • An Example of Two Derived Tables in a Single Query
  • MULTIPLE Derived Tables using the WITH Command
  • WITH RECURSIVE Derived Table Hierarchy
  • WITH RECURSIVE Derived Table Query
  • WITH RECURSIVE Derived Table Definition
  • WITH RECURSIVE Derived Table Seeding
  • WITH RECURSIVE Derived Table Looping
  • WITH RECURSIVE Derived Table Looping in Slow Motion
  • WITH RECURSIVE Derived Table Looping Continued
  • WITH RECURSIVE Derived Table Ends the Looping
  • WITH RECURSIVE Derived Table Final Report
  • Creating a Temporary Table
  • Creating a Temporary Table using a CTAS
  • Dropping a Temporary Table
Chapter 9 - Sub-query Functions
  • An IN List is much like a Subquery
  • An IN List Never has Duplicates – Just like a Subquery
  • An IN List Ignores Duplicates
  • The Subquery
  • How a Basic Subquery Works
  • These are Equivalent Queries
  • The Final Answer Set from the Subquery
  • Quiz- Answer the Difficult Question
  • Answer to Quiz- Answer the Difficult Question
  • Should you use a Subquery of a Join?
  • Quiz - Write the Subquery
  • Answer to Quiz - Write the Subquery
  • Quiz - Write the More Difficult Subquery
  • Answer to Quiz - Write the More Difficult Subquery
  • Quiz – Write the Extreme Subquery
  • Answer To Quiz – Write the Extreme Subquery
  • Quiz - Write the Subquery with an Aggregate
  • Answer to Quiz - Write the Subquery with an Aggregate
  • Quiz - Write the Correlated Subquery
  • Answer to Quiz - Write the Correlated Subquery
  • The Basics of a Correlated Subquery
  • The Top Query always runs first in a Correlated Subquery
  • Correlated Subquery Example vs. a Join with a Derived Table
  • Quiz- A Second Chance to Write a Correlated Subquery
  • Answer - A Second Chance to Write a Correlated Subquery
  • Quiz- A Third Chance to Write a Correlated Subquery
  • Answer - A Third Chance to Write a Correlated Subquery
  • Quiz- Last Chance to Write a Correlated Subquery
  • Answer – Last Chance to Write a Correlated Subquery
  • Quiz – Write the Extreme Correlated Subquery
  • Answer – Write the Extreme Correlated Subquery
  • NOT IN Subquery Returns Nothing when NULLs are Present
  • Fixing a NOT IN Subquery with Null Values
  • Quiz- Write the NOT Subquery
  • Answer to Quiz- Write the NOT Subquery
  • Quiz - Write the Subquery using a WHERE Clause
  • Answer - Write the Subquery using a WHERE Clause
  • Quiz- Write the Subquery with Two Parameters
  • Answer to Quiz- Write the Subquery with Two Parameters
  • How the Double Parameter Subquery Works
  • More on how the Double Parameter Subquery Works
  • Quiz – Write the Triple Subquery
  • Answer to Quiz – Write the Triple Subquery
  • IN is equivalent to =ANY
  • Using a Correlated Exists
  • How a Correlated Exists matches up
  • The Correlated NOT Exists
Chapter 10 - Strings
  • UPPER and lower Functions
  • The Length Command Counts Characters
  • LENGTH Works on Fixed Length Columns
  • LENGTH and OCTET_LENGTH
  • The TRIM Command trims both Leading and Trailing Spaces
  • The RTRIM and LTRIM Command trims Spaces
  • Concatenation
  • Concatenation and SUBSTRING
  • Four Concatenations Together
  • LPAD and RPAD
  • The SUBSTR and SUBSTRING Command
  • How SUBSTR Works with NO ENDING POSITION
  • Using SUBSTR and LENGTH Together
  • The LEFT and RIGHT Functions
  • The POSITION Command finds a Letters Position
  • The POSITION Command is brilliant with SUBSTR
  • CHARINDEX Finds a Letter(s) Position in a String
  • The CHARINDEX Command is brilliant with SUBSTRING
  • The CHARINDEX Command Using a Literal
  • The REPLACE Function
  • REGEXP_REPLACE
  • REGEXP_INSTR
  • SOUNDEX Function to Find a Sound
  • The ASCII Function
  • The CHAR Function
  • The UNICODE Function
  • The Reverse String Function
  • The RIGHT Function
Chapter 11 - Interrogating the Data
  • Numeric Manipulation Functions
  • Finding the Cube Root
  • Ceiling Gets the Smallest Integer Not Smaller Than X
  • Floor Finds the Largest Integer Not Greater Than X
  • The Round Function and Precision
  • Quiz – Fill in the Answers for the NULLIF Command
  • Answer – Fill in the Answers for the NULLIF Command
  • The COALESCE Command
  • COALESCE is Equivalent to this CASE Statement
  • A Rounding Example Using CAST
  • CAST will Round Values up or Down
  • Valued Case vs. Searched Case
  • Combining Searched Case and Valued Case
  • Nested Case
  • The CASE Challenge
  • The CASE Challenge Answer
  • The Decode Command
  • A Trick for getting a Horizontal Case
  • Put a CASE in the ORDER BY
  • Using Decode to Sort Logically
Chapter 12 - View Functions
  • The Fundamentals of Views
  • Creating a Simple View to Restrict Sensitive Columns
  • Creating a Simple View to Restrict Rows
  • Creating a View to Join Tables Together
  • Join Views Allow Users to Merely Select Columns
  • Sometimes we Create Views for Formatting
  • Basic Rules for Views
  • How to Modify a View
  • The Exception to the ORDER BY Rule inside a View
  • Derived Columns in a View Should Contain a Column Alias
  • The Standard Way Most Aliasing is Done
  • Another Way to Alias Columns in a View CREATE
  • What Happens When a View Column gets Aliased Twice?
  • Aggregates on View Aggregates
Chapter 13 – UNION Set Operator
  • Rules of Set Operators
  • INTERSECT Explained Logically
  • INTERSECT Explained Logically
  • UNION Explained Logically
  • UNION Explained Logically
  • UNION ALL Explained Logically
  • UNION ALL Explained Logically
  • EXCEPT Explained Logically
  • EXCEPT Explained Logically
  • Minus Explained Logically
  • Minus Explained Logically
  • Testing Your Knowledge
  • Answer Testing Your Knowledge
  • Testing Your Knowledge
  • Answer Testing Your Knowledge
  • An Equal Number of Columns in both SELECT Lists
  • Columns in the SELECT list should be from the same Domain
  • The Top Query handles all Aliases
  • The Bottom Query does the ORDER BY
  • Great Trick: Place your Set Operator in a Derived Table
  • UNION vs. UNION ALL
  • Using UNION ALL and Literals
  • A Great Example of how EXCEPT works
  • USING Multiple SET Operators in a Single Request
  • Changing the Order of Precedence with Parentheses
  • Using UNION ALL for speed in Merging Data Sets
  • Using UNION to be same as GROUP BY GROUPING SETS
Chapter 14 – Creating Tables
  • Show Databases and Table DDL Commands
  • Finding Constraints
  • Create Table Syntax
  • Creating A Table in Snowflake
  • Creating Temporary and Transient Tables
  • Comparing Table Types
  • Data Types for Numeric, String, and Binary
  • Data Types for Date, Time, and Unstructured
  • Creating Tables with a Clustering Key
  • Joining Tables Can Have the Same Clustering Keys for Speed
  • Creating Tables with a Primary Key/Foreign Key Relationship
  • A Table with a NOT NULL Constraint
  • CREATE TABLE LIKE
  • CREATE a Temporary TABLE using LIKE
  • CREATE TABLE AS (CTAS) Populates the Table With Data
  • CREATE TABLE AS (CTAS) Can Choose Certain Columns
  • CREATE a Temporary Table AS (CTAS)
  • CREATE a Temporary Table AS (CTAS) Using a Join
Chapter 15 - Data Manipulation Language (DML)
  • INSERT Syntax # 1
  • INSERT Syntax # 2
  • INSERT Example with Multiple Rows
  • Inserting Null Values into a Table
  • INSERT/SELECT Command
  • INSERT/SELECT to Build a Data Mart
  • UPDATE Examples
  • Subquery UPDATE Command Syntax
  • Example of Subquery UPDATE Command
  • Deleting Rows in a Table
Chapter 16 - Statistical Aggregate Functions
  • The Stats Table
  • The KURTOSIS Function
  • A Kurtosis Example
  • The SKEW Function
  • A SKEW Example
  • The STDDEV_POP Function
  • A STDDEV_POP Example
  • The STDDEV_SAMP Function
  • A STDDEV_SAMP Example
  • The VAR_POP Function
  • A VAR_POP Example
  • The VAR_SAMP Function
  • A VAR_SAMP Example
  • The CORR Function
  • A CORR Example
  • Another CORR Example so you can Compare
  • The COVAR_POP Function
  • A COVAR_POP Example
  • Another COVAR_POP Example so you can Compare
  • The REGR_INTERCEPT Function
  • A REGR_INTERCEPT Example
  • Another REGR_INTERCEPT Example so you can Compare
  • The REGR_SLOPE Function
  • A REGR_SLOPE Example
  • Another REGR_SLOPE Example so you can Compare
  • The REGR_AVGX Function
  • A REGR_AVGX Example
  • Another REGR_AVGX Example so you can Compare
  • The REGR_AVGY Function
  • A REGR_AVGY Example
  • Another REGR_AVGY Example so you can Compare
  • The REGR_COUNT Function
  • A REGR_COUNT Example
  • The REGR_R2 Function
  • A REGR_R2 Example
  • The REGR_SXX Function
  • A REGR_SXX Example
  • The REGR_SXY Function
  • A REGR_SXY Example
  • The REGR_SYY Function
  • A REGR_SYY Example
  • Using GROUP BY
2023 Top 20 Training Industry Company - IT Training

Need Help?

Call us at 877-206-0106 or e-mail us at info@learnquest.com

Personalized Solutions

Need a personalized solution for your Training? Contact us, and one of our training advisors will help you find the best solution.

Contact Us

Need Help?

Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you? We are here to help!

Talk to us

20% Off All Mainframe Training Courses

Become the mainframe expert your organization needs.

PROMO CODE: MAINFRAME20
VALID THROUGH MARCH 31, 2024

20% Off All Mainframe Training Courses

Self-Paced Training Info

Learn at your own pace with anytime, anywhere training

  • Same in-demand topics as instructor-led public and private classes.
  • Standalone learning or supplemental reinforcement.
  • e-Learning content varies by course and technology.
  • View the Self-Paced version of this outline and what is included in the SPVC course.
  • Learn more about e-Learning

Course Added To Shopping Cart

bla

bla

bla

bla

bla

bla

Self-Paced Training Terms & Conditions

??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??

Sorry, there are no classes that meet your criteria.

Please contact us to schedule a class.
Close

self-paced
STOP! Before You Leave

Save 0% on this course!

Take advantage of our online-only offer & save 0% on any course !

Promo Code skip0 will be applied to your registration

Close
Nothing yet
here's the message from the cart

To view the cart, you can click "View Cart" on the right side of the heading on each page
Add to cart clicker.

Purchase Information

??elearning-coursenumber?? ??coursename??
View Cart

Need more Information?

Speak with our training specialists to continue your learning journey.

 

Delivery Formats

Close

By submitting this form, I agree to LearnQuest's Terms and Conditions

heres the new schedule
This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.