PostgreSQL: Beginner PostgreSQL 9.4.5

  • 4 Courses | 5h 57m 9s
  • 5 Books | 27h 8m
Likes 36 Likes 36
 
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

  • Playable
    1. 
    What is PostgreSQL?
    4m 35s
    NOW PLAYING
  • Playable
    2. 
    Downloading and Installing
    6m 20s
    UP NEXT

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 33m
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 35m
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 27m
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 20m
has Assessment available Badge
SHOW MORE
FREE ACCESS

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

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 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

YOU MIGHT ALSO LIKE

CHANNEL NoSQL
Likes 24 Likes 24  
Likes 125 Likes 125  
CHANNEL MariaDB
Likes 7 Likes 7