This course is designed specifically for SQL Security Specialists with a focus on PostgreSQL. It assumes a solid foundation in SQL and guides learners through advanced topics specific to PostgreSQL. You'll explore crucial concepts, such as complex queries, performance optimization, and database administration tasks unique to PostgreSQL.
To ensure an immersive, self-paced learning experience, this course employs a video-free approach. Instead, assignments feature concise explanations, complemented by visuals and executable SQL code examples. These examples come with suggested modifications, encouraging learners to explore further and deepen their understanding through practical application. Participants will receive immediate feedback through a range of assessment items. These assessments progress from quick comprehension checks (multiple choice, fill in the blank, and unscrambling SQL queries) to small, manageable coding exercises that can be completed in minutes rather than hours.
Overview
Syllabus
- Database Basics
- Welcome to Week 1 of the SQL for Software Developers course. These assignments cover the concepts of various data manipulations, CRUD and data types in PostGreSQL. The module ends with graded coding exercises.
- Access Control
- Welcome to Week 2 of the SQL for Software Developers course. These assignments cover the concepts of database user roles, how to ensure secure connections, and access configurations in PostGreSQL. The module ends with graded coding exercises.
- Incident Management
- Welcome to Week 3 of the SQL for Software Developers course. These assignments cover the concepts of threats and injections, audits and monitoring, and backups and recovery in PostGreSQL. The module ends with graded coding exercises.
Taught by
Kendra Evans and Dmitrii Suchkov