Module 6 provides optional advanced material on query formulation for learners who seek expert level knowledge and skills. Advanced query formulation can help learners gain an edge in the workplace for expert status and high value to an organization. Module 6 covers original material for advanced query formulation skills that prepare learners to collaborate with data scientists on data mining tasks. The instructor developed material in Module 6 from his long experience using SQL for data mining projects. The SQL coding skills also transfer to other advanced query formulation tasks. Module 6 provides these specific knowledge areas and skills.• Examples and practice with data lakes and data warehouses as data mining projects can involve both types of data sources• SQL coding skills for two prominent data mining tasks, association rule mining and classification algorithms using training data with limited event history• New SQL elements for managing complex SQL coding, array results, independent subqueries with the IN comparison operator, a new analytic function, and conditional assignment of column values• New SQL coding skills for atypical join patterns• Unique pedagogy with statement patterns to write template SELECT statements as an initial step to a complete a SELECT statementDue to advanced material, Module 6 provides Lesson 9 as honors with problems, concept quiz, assignment, and self-evaluation. The concept quiz provides an assessment of learner understanding of the video lessons and associated notes. Learners should complete the concept quiz before starting practice problems and the graded assignment to ensure conceptual understanding of the material.