PostgreSQL: beginner PostgreSQL 9.4.5

https://www.skillsoft.com/channel/postgresql-2f8c0ee0-e19a-11e6-93f3-0242c0a80605?expertiselevel=1994452&technologyandversion=1994453 https://www.skillsoft.com/channel/postgresql-2f8c0ee0-e19a-11e6-93f3-0242c0a80605?expertiselevel=1994452&technologyandversion=69423923
  • 10 Courses | 7h 9m
  • 7 Books | 35h 42m
  • Includes Lab
  • 1 Course | 1h 3m 57s
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
 
PostgreSQL is an object-relational database (ORDBMS) system. Click here to explore the facets and mastery of this powerful tool.

GETTING STARTED

Objects & Retrieving Data

  • 4m 35s
  • 6m 20s

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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 Security
Obtain all the skills you need to configure and manage a PostgreSQL database.
book Duration 2h 13m book Authors By Baji Shaik

Book

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Write 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.
book Duration 4h 6m book Authors By Anna Bailliekova, Boris Novikov, Henrietta Dombrovskaya

Book

Beginning PostgreSQL on the Cloud: Simplifying Database as a Service on Cloud Platforms
Including 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.
book Duration 2h 46m book Authors By Avinash Vallarapu, Baji Shaik

Book

Beginning PHP 5 and PostgreSQL 8: From Novice to Professional
An 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.
book Duration 13h 25m book Authors By Robert H. Treat, W. Jason Gilmore

Book

PostgreSQL 8 for Windows
Filled 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.
book Duration 6h 27m book Authors By Richard Blum

Book

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition
This book helps you write queries that perform fast and deliver results on time.
book Duration 4h 28m book Authors By Anna Bailliekova, Boris Novikov, Henrietta Dombrovskaya

Book

PostgreSQL InstantCode: Creating Web Applications with PostgreSQL
Develop database-driven applications based on PostgreSQL, with different technologies, such as Perl, Visual Basic .NET, ASP, and C, to implement server-side business logic.
book Duration 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

YOU MIGHT ALSO LIKE

Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Rating 4.6 of 28 users Rating 4.6 of 28 users (28)