-
Module 1: Introduction to querying Db2
12 Lessons-
StartModule introduction
-
StartWhat is Db2 ?
-
StartWhat SQL does Db2 use ?
-
StartTypes of SQL statements
-
StartWhat are databases?
-
StartDb2 instances and databases
-
StartConnecting to Db2
-
StartConnecting to PopkornKraze with DBeaver
-
StartWhat is the Db2 CLP ?
-
StartDb2-specific help sources
-
StartLab 1: Introduction to querying PostgreSQL
-
StartQuiz 1: Introduction to querying PostgreSQL
-
-
Module 2: Querying a single table
17 Lessons-
StartModule introduction
-
StartWhat are tables ?
-
StartViewing the contents of a table
-
StartWhat are schemas ?
-
StartWhat is PopkornKraze ?
-
StartSELECT statements
-
StartUsing aliases for columns and tables
-
StartQuoting (delimiting) names
-
StartUsing 2-part names
-
StartORDER BY clause
-
StartRestricting output with FETCH
-
StartPaginating with OFFSET
-
StartRemoving duplicates with DISTINCT
-
StartQuerying literals, expressions and functions
-
StartLab 2: Querying a single table
-
StartLab 2: Answers
-
StartQuiz 2: Querying a single table
-
-
Module 3: Filtering the rows to return
12 Lessons-
StartModule introduction
-
StartFiltering output with the WHERE clause
-
StartFinding patterns with LIKE
-
StartLogical operations with AND, OR, and NOT
-
StartLogical values withe boolean data type
-
StartRanges of values with the BETWEEN operator
-
StartChecking lists of values by using the IN operator
-
StartWorking with NULL values (the lack of data)
-
StartWhat are user-defined functions?
-
StartLab 3: Filtering the rows to return
-
StartLab 3: Answers
-
StartQuiz 3: Filtering the rows to return
-
-
Module 4: Working with queries
8 Lessons -
Module 6: Querying strings
16 Lessons-
StartModule introduction
-
StartString data types
-
StartLiteral string values
-
StartString operators
-
StartTrimming strings with LTRIM, RTRIM, and TRIM
-
StartChanging case with UPPER, LOWER
-
StartExtracting parts of strings with LEFT, RIGHT, SUBSTRING
-
StartDetermining the length of strings
-
StartReplacing substrings with REPLACE
-
StartReplace substrings with OVERLAY
-
StartDuplicating strings with LPAD and RPAD
-
StartFinding substrings with POSITION
-
StartReplacing characters with TRANSLATE
-
StartLab 6: Querying strings
-
StartLab 6: Answers
-
StartQuiz 6: Querying strings
-
-
Module 8: Converting between data types
10 Lessons-
StartModule introduction
-
StartReplacing NULL values with COALESCE
-
StartReturning NULL When Equal with NULLIF
-
StartComparing NULL values using IS DISTINCT FROM
-
StartImplicit vs explicit conversions
-
StartConverting data types with CAST function
-
StartOther built-in data types
-
StartLab 8: Converting between data types
-
StartLab 8: Answers
-
StartQuiz 8: Converting between data types
-
Writing SQL Queries for Db2
Creating reports, analytics, or applications? And need to get data out of Db2? Learn to write SQL queries like a pro !
Course Summary
Do you need to learn how to write SQL queries for Db2?
- You know that the information that you need is stored in a Db2 database
- You need to find some data to extract it
- You need to create reports with reporting tools
- You are using analytic tools like Power BI, Tableau, QlikView, Excel, or Access and need to get data from Db2
- You want to learn to write queries properly, using commercial coding standards
- You are new to writing queries, or you are self-taught and want to make sure you are doing it correctly
We encourage you to complete the practical exercises. We have tried to make this as easy as possible.
