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.
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.
涵盖的内容
5篇阅读材料4个应用程序项目
显示有关单元内容的信息
5篇阅读材料•总计13分钟
Navigating Codio Assignments•5分钟
Intro to SQL and Relational Databases (Optional Download)•1分钟
New Reading•1分钟
CRUD and Data Types (Optional Download)•1分钟
How to Reset an Assignment in Codio•5分钟
4个应用程序项目•总计195分钟
Codio: Coding Exercises•60分钟
Codio: Intro to SQL and Relational Databases•45分钟
Codio: Data Manipulations from Python•45分钟
Codio: CRUD and Data Types•45分钟
Tables Relations
第 2 单元•小时 后完成
单元详情
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.
涵盖的内容
5篇阅读材料4个应用程序项目
显示有关单元内容的信息
5篇阅读材料•总计13分钟
Navigating Codio Assignments•5分钟
Table Relations and Joins (optional download)•1分钟
Diving into SELECT (optional download)•1分钟
Extra JOIN types (optional download)•1分钟
How to Reset an Assignment in Codio•5分钟
4个应用程序项目•总计195分钟
Codio: Coding Exercises•60分钟
Codio: Tables Relations and Joins•45分钟
Codio: Diving into SELECT•45分钟
Codio: Extra JOIN types•45分钟
Tables structure
第 3 单元•小时 后完成
单元详情
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.
涵盖的内容
5篇阅读材料4个应用程序项目
显示有关单元内容的信息
5篇阅读材料•总计13分钟
Copy of Navigating Codio Assignments•5分钟
Creating Tables Structure (optional download)•1分钟
New Reading•1分钟
Indexes, transactions and triggers (optional download)•1分钟
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.
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.