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.
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.
Inclus
5 lectures4 éléments d'application
Afficher les informations sur le contenu du module
5 lectures•Total 13 minutes
Navigating Codio Assignments•5 minutes
Intro to SQL and Relational Databases (optional download)•1 minute
Tables and JOINS (optional Download)•1 minute
Data Retrieval and Extra JOINS (optional download)•1 minute
How to Reset an Assignment in Codio•5 minutes
4 éléments d'application•Total 195 minutes
Codio: Coding Exercises•60 minutes
Codio: Intro to SQL and Relational Databases•45 minutes
Codio: Tables and JOINS•45 minutes
Codio: Data Retrieval and Extra JOINS•45 minutes
Access Control
Module 2•3 heures à terminer
Détails du module
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.
Inclus
5 lectures4 éléments d'application
Afficher les informations sur le contenu du module
5 lectures•Total 13 minutes
Navigating Codio Assignments•5 minutes
Users and Roles (optional download)•1 minute
Access Configuration (optional download)•1 minute
Secure Connections and Data Encryption (optional download)•1 minute
How to Reset an Assignment in Codio•5 minutes
4 éléments d'application•Total 195 minutes
Codio: Coding Exercises•60 minutes
Codio: Users and Roles•45 minutes
Codio: Access Configuration•45 minutes
Codio: Secure Connections and Data Encryption•45 minutes
Incident Management
Module 3•3 heures à terminer
Détails du module
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.
Inclus
5 lectures4 éléments d'application
Afficher les informations sur le contenu du module
5 lectures•Total 13 minutes
Navigating Codio Assignments•5 minutes
Threats and Injections (optional download)•1 minute
Codio is the hands-on learning platform supporting better outcomes in computing and tech skills education and is used by some of the world's largest and most prestigious higher education institutions to deliver engaging courses at scale.
OK
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?
Felipe M.
Étudiant(e) depuis 2018
’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’
Jennifer J.
Étudiant(e) depuis 2020
’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’
Larry W.
Étudiant(e) depuis 2021
’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’
Chaitanya A.
’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.