PostgreSQL: beginner PostgreSQL 9.4.5
Expertise:
Technology:
- 10 Courses | 7h 9m
- 7 Books | 35h 42m
- Includes Lab
- 1 Course | 1h 3m 57s
PostgreSQL is an object-relational database (ORDBMS) system. Click here to explore the facets and mastery of this powerful tool.
GETTING STARTED
Connecting a Node.js and Express.js Backend with a PostgreSQL Database
-
1m 21s
-
3m 35s
COURSES INCLUDED
Objects & Retrieving Data
PostgreSQL is an open-source DBMS that supports most SQL constructs. Learn about downloading, installing and configuring the PostgreSQL RDBMS, as well as creating a database, using database objects, and retrieving data.
12 videos |
1h 27m
Assessment
Badge
DDL, DML, & Constraints
Data definition and data manipulation languages allow you to work with data in meaningful ways. Discover how to work with SQL DML commands, constraints, and datatypes in PostgreSQL.
14 videos |
1h 28m
Assessment
Badge
Data Retrieval
Make your data work for you. Learn to ensure data integrity using constraints and analyze data using the SELECT command and WHERE, GROUP BY, DISTINCT, and ORDER BY clauses. And explore how to speed up searches using indexes and views.
11 videos |
1h 23m
Assessment
Badge
Security & Administration
Managing data and users are important tasks for a database administrator. Learn about administrative tasks like securing objects, managing groups, as well as command line management options, scripting, and reporting.
13 videos |
1h 14m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Connecting a Node.js and Express.js Backend with a PostgreSQL Database
Node.js has become a popular platform for creating web applications. It is now possible to connect a node application to databases using special software. This course is designed to equip learners with the knowledge and skills required to connect a Node.js backend with a PostgreSQL database using Express.js. Through a combination of theory and practical demonstrations, learners will discover how to establish a seamless connection, perform create, read, update, and delete (CRUD) operations, create RESTful API endpoints, implement error handling and validation, optimize performance, ensure security, and conduct testing. By the end of this course, learners will have a solid understanding of the integration between Node.js and PostgreSQL using Express.js and will be able to confidently build robust and scalable applications that interact with a PostgreSQL database.
15 videos |
1h 3m
Assessment
Badge
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
PostgreSQL Configuration: Best Practices for Performance and SecurityObtain all the skills you need to configure and manage a PostgreSQL database.
2h 13m
By Baji Shaik
Book
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient QueriesWrite optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers.
4h 6m
By Anna Bailliekova, Boris Novikov, Henrietta Dombrovskaya
Book
Beginning PostgreSQL on the Cloud: Simplifying Database as a Service on Cloud PlatformsIncluding tips on securing and encrypting your cloud data, this book will get you started with PostgreSQL on the cloud and teach you the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Google, and Azure.
2h 46m
By Avinash Vallarapu, Baji Shaik
Book
Beginning PHP 5 and PostgreSQL 8: From Novice to ProfessionalAn ideal read for a web designer, programmer, hobbyist, or novice who wants to create applications with PHP 5 and PostgreSQL 8, this book delves into open source web development technologies, the PostgreSQL 8 database server and PHP 5 scripting language.
13h 25m
By Robert H. Treat, W. Jason Gilmore
Book
PostgreSQL 8 for WindowsFilled with real-world examples and step-by-step instructions, this hands-on guide gives you detailed advice on installing, configuring, and using PostgreSQL 8 on Windows platforms.
6h 27m
By Richard Blum
Book
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second EditionThis book helps you write queries that perform fast and deliver results on time.
4h 28m
By Anna Bailliekova, Boris Novikov, Henrietta Dombrovskaya
Book
PostgreSQL InstantCode: Creating Web Applications with PostgreSQLDevelop database-driven applications based on PostgreSQL, with different technologies, such as Perl, Visual Basic .NET, ASP, and C, to implement server-side business logic.
2h 17m
SHOW MORE
FREE ACCESS
SKILL BENCHMARKS INCLUDED
PostgreSQL Competency (Intermediate Level)
The Postgre SQL Competency (Intermediate Level) benchmark assesses your recognition of core Postgre SQL concepts. You will be evaluated on your skills in recognizing high-level elements of Postgre SQL commands and techniques. Learners who score high on this benchmark demonstrate that they have a solid understanding of intermediate-level Postgre SQL concepts.
20m
| 12 questions
