0% completed

All LessonsFree Lessons (4)

Getting Started

Introduction to the Course MySQL Shell

Data Types

Introduction to Data Types

Summary for Data Types

Quiz: Data Types

SQL Statements

Introduction to SQL Statements User-Defined Variables Common Table Expressions Transactional Statements Prepared Statements Summary for SQL Statements Quiz: SQL Statements

Flow Control Functions

Introduction to Flow Control Functions Flow Control Statements: IF and CASE Summary for Flow Control Functions Quiz: Flow Control Functions

String Functions

Introduction to String Functions Regular Expressions Full-Text Search Summary for String Functions Quiz: String Functions

Date and Time Functions

Introduction to Date and Time Functions Creating Date/Time Values Accessing Date/Time Values Modifying Date/Time Values Comparing Date/Time Values Summary for Date and Time Functions Quiz: Date and Time Functions

Aggregate Functions

Introduction to Aggregate Functions Using GROUP BY with the WITH ROLLUP Modifier The GROUPING() Function Summary for Aggregate Functions Quiz: Aggregate Functions

Window Functions

Introduction to Window Functions Frame Specification Row Access Inside a Partition Row Access Inside a Frame Ranking Inside a Partition Summary for Window Functions Quiz: Window Functions

Recursion

Introduction to Recursion Recursive Common Table Expressions (CTEs)Recursive CTEs with UNION vs. UNION ALL Optimizations and Limitations of Recursive CTEs Summary for Recursion Quiz: Recursion

JSON and XML

Introduction to JSON and XML Importing Data Creating JSON Values Searching JSON Values Modifying JSON Values Converting JSON Values to a Relational Table Searching XML Values Modifying XML Values Summary for JSON and XML Quiz: JSON and XML

Spatial Data

Introduction to Spatial Data Spatial Data Types and Formats Creating Spatial Entities Spatial Operators Analyzing Properties of Spatial Entities Analyzing Relationships Between Spatial Entities Working with Documents in GeoJSON Summary for Spatial Data Quiz: Spatial Data

Course Assessment

Mastering Advanced SQL Techniques with MySQL

Conclusion

Mastering Advanced SQL Techniques with MySQL/

...

/

Quiz: Data Types

Quiz: Data Types

Test your knowledge of data types in MySQL.

We'll cover the following...

Quiz

1.

(Select all that apply.) What are valid literal syntax formats to specify a DATE?

A.

'YYYY-MM-DD'

B.

'YYYY/MM/DD'

C.

'YY-MM-DD'

D.

YYYYMMDD

1 / 7

...