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.
Overview
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