SQL for Security Specialist
Offered By: Codio via Coursera
Course Description
Overview
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.
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
Related Courses
Emergency Management: Risk, Incidents and LeadershipCoventry University via FutureLearn Security Operations
Coventry University via FutureLearn Planificación y Coordinación en Logística Humanitaria
Acción contra el Hambre via Miríadax Preparing for Google Cloud Certification: Cloud DevOps Engineer
Google Cloud via Coursera Managing Cybersecurity
University System of Georgia via Coursera