Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

SQL for Security Specialist

Codio via Coursera

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

Reviews

Start your review of SQL for Security Specialist

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.