Beginner's Guide to PostgreSQL
What you'll learn
- Understand why databases are useful
- Understand how relational databases work
- Learn how to install and setup PostgreSQL
- Learn how to create databases and database structures
- Learn how to insert and manipulate data in a PostgreSQL database
- Learn how to write SQL statements for PostgreSQL
Requirements
- Basic computer knowledge (no programming or database knowledge required)
Description
PostgreSQL is an awesome open source relational database, that's fast and easy to use. We've used it here at my company in a few large projects with great performance.
In this beginner level PostgreSQL tutorial course I'll be going over all the basic concepts of relational databases and dive into how to use PostgreSQL. No previous database experience is required for this PostgreSQL tutorial course - all the basic concepts like tables and relations are covered. It's thorough and meant to help anyone starting out with databases.
The PostgreSQL tutorial course covers database concepts, database installation and connection, client software used to connect to and manage the database (pgAdminIII) and also the main SQL statements and how they work with PostgreSQL.
This PostgreSQL tutorial course is currently under construction, with close to 5 hours of material already available. Considering that, I'll be offering it at a discounted price. Once finished, it will be priced at $99.
</p>Who this course is for:
- Database beginners
- Basic database users who want to understand and learn PostgreSQL
Instructor
- 4.2 Instructor Rating
- 353 Reviews
- 1,952 Students
- 1 Course
I am currently running my own web-based software development company (mainly .NET based ) building HRIS (Human Resource Information Systems) software for HR teams. I've also been employed as a teacher to 7th and 8th graders in Tec. Ed. classes, and voluntarily accepting 12th grade internships of IT students through local schools.
I am currently finishing a couple of web based projects for one of Sonae's human resources departments - Sonae being the largest private employer in Portugal, after having concluded a project for a Cape Verdian Bank (in colaboration with G333.Net).
When possible, I work on internal R&D projects, namely our devolpment framework, a DSL for code generation, and product ideas. I also colaborate with various local companies and institutions, both professionaly and voluntarily, namely the Santa Casa da Misericórdia da Murtosa.
My colleagues and I are experienced in developing costumized software, service and database solutions for businesses. We work with .Net, PostrgeSQL databases (or others as needed) , Ajax and Javascript based interfaces and our own internal framework for rapid development and maitenance.