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

Coursera

SQL for Software Developers

Codio via Coursera

Overview

This course is designed specifically for SQL Developers 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

  • Basic SQL Statements
    • 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.
  • Tables Relations
    • Welcome to Week 2 of the SQL for Software Developers course. These assignments cover the concepts of various table relations and Join Types, and Using SELECT. The module ends with graded coding exercises.
  • Tables structure
    • Welcome to Week 3 of the SQL for Software Developers course. These assignments cover the concepts of creating table structures and changing table structures, and creating triggers. The module ends with graded coding exercises.

Taught by

Kendra Evans and Dmitrii Suchkov

Reviews

Start your review of SQL for Software Developers

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.