This free online PostgreSQL course equips you with the essential skills to set up and work with a relational database. You’ll learn database fundamentals, PostgreSQL features, extensibility, indexing, and data-handling capabilities. The course also provides step-by-step installation guidance to help you create a functional PostgreSQL environment across supported platforms.Through hands-on exercises, you’ll use CREATE commands to build databases, tables, schemas, and other objects. You’ll also apply SELECT, WHERE, JOIN, and GROUP BY clauses to retrieve, filter, combine, and aggregate data. By the end, you’ll be equipped to structure PostgreSQL databases, write essential queries, and build a foundation for database development, administration, and data analysis.
This module provides an overview of the fundamental concepts and importance of Database and PostgreSQL. This module provides a foundational understanding of PostgreSQL, a powerful open-source relational database management system.
This module provides a comprehensive understanding of PostgreSQL's extensibility, indexing, and data handling capabilities.
This module provides step-by-step guidance on installing PostgreSQL on various platforms, enabling learners to set up a functional PostgreSQL database environment with ease.
This hands-on module immerses participants in the practical application of PostgreSQL's CREATE commands, allowing them to proficiently create databases, tables, schemas, and various objects within a PostgreSQL environment.
This hands-on module offers practical experience in using essential PostgreSQL clauses such as SELECT, WHERE, JOIN, and GROUP BY, empowering participants to master data retrieval, filtering, and aggregation in PostgreSQL databases.
Some points apply to every course of this kind; see how we rank.
Great Learning is in Tier 4: commercial training companies and platform-made courses of our institution ranking (58/100).
Instructor: Prof. Gary Gensler View the complete course: https://ocw.mit.edu/15-S12F18 This course is for students wishing to explore blockchain technology’s potential use - by entrepreneurs & incumbents - to change the world of money and finance. License: Creative Commons BY-NC-SA More information…
This course provides an introduction to mathematical modeling of computational problems. It covers the common algorithms, algorithmic paradigms, and data structures used to solve these problems. The course emphasizes the relationship between algorithms and programming, and introduces basic performa…
This is CS50P, CS50's Introduction to Programming with Python. Register for free at https://cs50.edx.org/python. Slides and source code at https://cs50.harvard.edu/python. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T3817j24-GogXmWqO5Q5vYy0V. An introduction to programming using a la…
This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming, for concentrators and non-concentrators alike, with or without prior programming experience. (Two thirds of CS50 students have never taken CS before.) This course teaches…
Instructor: Ana Bell View the complete course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/ *Note: Lectures 6, 10 have been updated! This subject is aimed at students with little to no programming experience. It aims to provide students with an under…
Get more information about the courses and programs we offer. In this playlist you can learn more about course content, pricing, credentials and more!
