Skill

Learn Advanced SQLite3

February 2024 with Shaun Wassell

Join Shaun Wassell as we learn how to write refined database queries and organize the results. We'll get first-hand practice with SQLite filtering techniques like WHERE and JOIN and clauses like GROUP BY.

Recommended Experience

Basic understanding of SQL syntax and concepts
Familiarity with database structures
Some experience writing SQL queries

Related certifications

Certified Professional Python Programmer Level 1 (PCPP1)

Related Job Functions

Database analyst
Python developer
Data analyst

A former full-stack developer, Shaun Wassell brings a wealth of web development and programming experience to his training.

Get started

Skill Outline

1. Narrowing Queries (12:02)
2. Grouping and Manipulating Query Results (14:25)
3. Narrowing Queries Practice (13:41)
4. Grouping and Manipulating Queries Practice (14:40)
5. Challenge & Solution: More Complex Query Practice (13:57)

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.

Free Flashcards

Flashcards help you reinforce what you’ve learned before exam day.

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