Skill

Understanding Windows in MySQL SELECT Statements

September 2021 with Trevor Sullivan

Join Trevor Sullivan as he explains how to use data windows in the MySQL database engine!

Gain an understanding of how you can run MySQL yourself.

Recommended Experience

Six months of hands-on experience using MySQL is recommended.

Related Job Functions

IT Professional
Database Administrator
Database Developer

Trevor Sullivan has been a CBT Nuggets trainer since 2020 and has received a variety of AWS certifications. His areas of expertise include Amazon Web Services, Docker, Microsoft Azure, and PowerShell automation.

Get started

Videos in this skill

1. Intro to MySQL Windows (14:14)
2. Build Sample Database for MySQL Windows (8:33)
3. Use OVER Clause to Ask Deeper Questions (7:51)
4. Create Named WINDOWs in MySQL SELECT Statements (13:34)
5. Use Outer and Sub-queries to Filter Windows (8:31)

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Get started

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews