PostgreSQL Database Administration (DBA) for Beginners

Category: Tutorial


Posted on 2018-10-11, by voska89.

Description


PostgreSQL Database Administration (DBA) for Beginners
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 11.5 hours | Size: 3.76 GB


What Will I Learn?

Install PostgreSQL Server
Load sample database
Create a database
Create a table
Insert data into tables
Update existing records inside a table
Delete Records in a table
Remove duplicate records
Query data from a table
Create a subquery
Get data from multiple tables
Create and manage roles
Create a view
Create tablespace
Backup and restore database
Filter and sort data
Use various operators
Use aggregate and analytic functions
Create triggers

Requirements

Internet access is required to download PostgreSQL Server
Basic understanding of database concept would help
Basic understanding of SQL would help

Description

PostgreSQL is commonly known as Postgres and it is also open source database.

PostgreSQL is a powerful, open source object-relational database system.

A database administrator's (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed.

The PostgreSQL administration covers some of the most important PostgreSQL database server administration activities.

Some of the Key Responsibilities of a Database Administrator includes:

Database Management

Database Backup and restore

Tablespace management

Role Management

Managing users

Securing database via proper role management

A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database.

In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.

The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings.

Topics also includes:

Installing PostgreSQL

Loading sample database

Creating database and tables

Performing CRUD operations

Joining Tables

Using aggregate and analytic functions

Creating views and triggers

This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .

Who is the target audience?

Beginner Database Administrators -DBA's
Beginner Data Scientist
Beginner Data Analyst







Download (Uploadgig)
http://uploadgig.com/file/download/Dc9b7b11cA529852/9sou5.PostgreSQL.Database.Administration.DBA.for.Beginners.part1.rar
http://uploadgig.com/file/download/2007Fb564C11a998/9sou5.PostgreSQL.Database.Administration.DBA.for.Beginners.part2.rar

Download ( Rapidgator )
http://rapidgator.net/file/6270e09f7d374c505cf281d60fbdf183/9sou5.PostgreSQL.Database.Administration.DBA.for.Beginners.part1.rar.html
http://rapidgator.net/file/146a03e091454a80244af0377361f77f/9sou5.PostgreSQL.Database.Administration.DBA.for.Beginners.part2.rar.html

Download ( NitroFlare )
http://nitroflare.com/view/E105CF62635405C/9sou5.PostgreSQL.Database.Administration.DBA.for.Beginners.part1.rar
http://nitroflare.com/view/8D8919FCFE91AA3/9sou5.PostgreSQL.Database.Administration.DBA.for.Beginners.part2.rar


Sponsored High Speed Downloads
6647 dl's @ 3835 KB/s
Download Now [Full Version]
7595 dl's @ 2204 KB/s
Download Link 1 - Fast Download
5226 dl's @ 2793 KB/s
Download Mirror - Direct Download



Search More...
PostgreSQL Database Administration (DBA) for Beginners

Search free ebooks in ebookee.com!


Links
Download this book

No active download links here?
Please check the description for download links if any or do a search to find alternative books.


Related Books

  1. Ebooks list page : 37396
  2. 2018-10-11MySQL Database Admin -DBA for Beginners
  3. 2018-09-17MySQL Database Admin -DBA for Beginners
  4. 2018-09-09MySQL Database Admin -DBA for Beginners
  5. 2012-01-13Chomsky For Beginners - David Cogswell
  6. 2011-12-01Chomsky For Beginners
  7. 2018-10-11Oracle DBA 11g 12c - Database Administration for Junior DBA
  8. 2018-07-26Oracle DBA 11g/12c - Database Administration for Junior DBA
  9. 2018-01-27[PDF] DB2 11 for z/OS Database Administration: Certification Study Guide (DB2 DBA Certification)
  10. 2018-01-20[PDF] Oracle DBA Pocket Guide: Quick Reference for Database Administration
  11. 2011-05-23OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques (Oracle In-Focus series)
  12. 2009-05-08OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques (Oracle In-Focus series)
  13. 2018-09-26DB2 10 for zOS Database Administration Certification Study Guide
  14. 2018-09-02ServiceNow Certified Administration For Beginners
  15. 2018-08-31ServiceNow Certified Administration For Beginners
  16. 2018-07-22DB2 10 for zOS Database Administration Certification Study Guide
  17. 2018-06-01JSP, Servlets and JDBC for Beginners Build a Database App (Updated 52018)
  18. 2018-04-16Database Administration The Complete Guide to DBA Practices and Procedures, 2nd Edition
  19. 2018-01-30[PDF] Salesforce Development & Administration for Beginners
  20. 2018-01-29[PDF] DB2 Administration Solution Pack for Z/Os: Streamlining DB2 for Z/Os Database Administration
  21. 2018-01-06[PDF] SQL: Easy SQL Programming & Database Management For Beginners, Your Step-By-Step Guide To Learning The SQL Database (SQL Series)

Comments

No comments for "PostgreSQL Database Administration (DBA) for Beginners".


    Add Your Comments
    1. Download links and password may be in the description section, read description carefully!
    2. Do a search to find mirrors if no download links or dead links.

    required

    required, will not be published

    need login

    required

    Not clear? Click here to refresh.

    Back to Top