This course is designed to help you build a strong foundation in SQL and database management, with a focus on the powerful MySQL environment. 

You’ll begin an immersive dive into the essentials of databases and SQL, where you'll grasp the fundamental concepts and roles of databases in managing and manipulating data. From there, you’ll progress through a series of skill-building sprints that guide you from setting up your MySQL environment to mastering sophisticated data retrieval techniques. 

Through hands-on practice, you’ll create and manage databases, write powerful SQL queries, and apply your knowledge to real-world scenarios. Each sprint is designed to build your confidence and expertise incrementally, ensuring you gain both theoretical understanding and practical experience.

Note: Retired members eligible to receive free PD should be aware that this course does not qualify.

Unlock learning anytime, anywhere with the Blackboard Learn app

Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.

Upon completion of this course, learners will:

• Understand the core principles of databases and SQL and how they power data management in modern applications. 
• Learn to insert, manage, and query data using commands like SELECT, WHERE, and operators for filtering and sorting.
• Master grouping, aggregation, and functions to perform complex data analysis.
• Understand and implement JOINs to combine data across multiple tables effectively.
• Explore indexes and optimization strategies to improve query efficiency and database performance.