• Home
  • Services
    • HR Services
      • HR Advisory Services
      • Contract Staffing
      • HR Outsourcing Services
      • Manpower Supply Services
      • Payroll Processing
      • Permanent Placement
      • Recruitment and Placement Services
      • Recruitment Process Outsourcing
      • Staffing Agency Services
    • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
    • Website Maintenance
    • Company Registration Services
    • Virtual Office Space Address
  • Company
    • FAQs
    • About Us
    • Contact
  • Locations
  • Blogs
    • Blog
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum

    Greenplum

    $1,500.00
    Read More
    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    Login
    RayaFeeL
    • Home
    • Services
      • HR Services
        • HR Advisory Services
        • Contract Staffing
        • HR Outsourcing Services
        • Manpower Supply Services
        • Payroll Processing
        • Permanent Placement
        • Recruitment and Placement Services
        • Recruitment Process Outsourcing
        • Staffing Agency Services
      • DBA Support
        • DBA Consultancy Services
        • PostgreSQL Support
      • Website Maintenance
      • Company Registration Services
      • Virtual Office Space Address
    • Company
      • FAQs
      • About Us
      • Contact
    • Locations
    • Blogs
      • Blog
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum

      Greenplum

      $1,500.00
      Read More

      Blog

      • Home
      • Blog
      • Blog
      • We Are Conducting PostgreSQL Corporate and Individual Training

      We Are Conducting PostgreSQL Corporate and Individual Training

      • Posted by 2ndnijam
      • Categories Blog
      • Date March 14, 2021
      • Comments 0 comment

      Rayafeel academy brings you a virtual, hands on PostgreSQL training, by the end of which you will learn the fundamental concepts of this open source database. With in-depth tutorials and a practical, hands on workshop, you will learn about the basics and advanced features of PostgreSQL and how to develop applications with PostgreSQL as the back-end.

      You will be led by our team of expert trainers who will hand hold you through the concepts of database installation and connection, writing queries to manage the database, and SQL statements to operate PostgreSQL. You will also get the PostgreSQL certification on successful completion of the course..

      YOU WILL LEARN TO –

      • How relational databases work and how are they relevant in today’s times
      • What sort of a database management system is PostgreSQL
      • How to install and setup PostgreSQL and run queries on it
      • How to create applications with PostgreSQL as a back end database management system

      WHY Rayafeel:

      • Get Mentored by Industry Practitioners: Rayafeel not only provides trainers for professional courses, we provide you with Industry Experts who are currently working in the field.
      • Immersive Hands-on Trainings: All our training sessions are based on Learn by-doing method and hence every trainee learns by being immersed in projects that they develop along with their mentor. Every session is a combination of practical exercises, theoretical learning, hands-on exercises, group discussions, simulations and intensive Q & A sessions.
      • Build a Portfolio of Projects: Rayafeel professionals help your employees to not only learn new concepts but also how to apply the theory to practice.
      • Mentoring Sessions: Rayafeel professionals can also be retained even after the training session to help incorporate the learned concepts in a particular project and further mentoring.

      Rayafeel’S TRAINING DELIVERY METHOD:

      • Hands-on Training with immersive, interactive and practice sessions.
      • Administered Classroom Assignments, Group Discussions, Simulation based learning and Q & A Sessions
      • Learning the concepts through examples and Build a project through the course of training
      • Post Training Sessions from Industry Experts(2 – 4 Hours Online sessions)
      • Mentors evaluate / review the Project (or)
      • Deep dive into specific concepts (or)
      • Assistance provided in implementing the technology in existing / new projects
      • Exclusive Mentor Support provided via email up to 3 Months.

      Course Contents :

      Curriculum 1:

      1. Introduction and Overview of PostgreSQL
      2. PostgreSQL System Architecture
      3. Architectural Summary
      4. Process Architecture
      5. Database Clusters
      6. PostgreSQL Terminology
      7. Physical Database Architecture
      8. Data File Architecture
      9. Database Server
      10. Installation Using PostgreSQL Binary Windows
      11. Installation from Source
      12. Creating a database cluster
      13. Starting and Stopping the Server (Other)
      14. Lab Exercise – Installation
      15. Install PostgreSQL from source
      16. Create a database cluster
      17. Start the database server
      18. Connect to the server using psql
      19. Stop the database server

      Curriculum 2 :

      1. Configuration
      2. Setting PostgreSQL Parameters
      3. Access Control
      4. Connection Settings
      5. Security and Authentication Settings
      6. Configure client/server connectivity
      7. Memory Settings
      8. Free Space Settings
      9. Kernel Resource Settings
      10. Log Management
      11. Background Writer Settings
      12. Vacuum Cost Settings

      Curriculum 3:

      1. Create and Managing PostgreSQL Database and Security
      2. USERS
      3. GROUPS
      4. ROLES
      5. Object Ownership
      6. Schemas and Search Paths
      7. Lab to create USERS, SCHEMAS, ROLES, Alter SEARCH_PATH
      8. GRANT and REVOKE privileges
      9. Levels of security: pg_hba.conf, schemas and users and table level
      10. pg_hba.conf

      Curriculum 4

      1. Moving Data with PostgreSQL and Backup and Recovery
      2. COPY
      3. Perform a Logical Backup Using PG_DUMP
      4. Perfomr Entire Cluster Backup using PG_DUMPALL
      5. Filesystem Level Backup (Hot and Cold)
      6. Server To Server Backup Using BART and PG_ADMIN Tools
      7. PITR – Point in Time Recovery
      8. pg_start_backup and pg_stop_backup
      9. Creating a base backup
      10. Archive Backup Local and Standby
      11. Recovery file parameters
      12. Lab to test PITR

      Curriculum 5:

      1. Routine Database Maintenance Tasks
      2. Routine Vacuuming
      3. Recovering Disk Space
      4. Vacuum Full
      5. Updating Planner Statistics
      6. Preventing Transaction ID Wraparound Failures
      7. Routine Reindexing

      Curriculum 6:

      1. Performance Tuning
      2. Explain and Explain Analyze
      3. Forcing Query Plan Selection
      4. Indexing
      5. Log Management
      6. Clustering

      Curriculum 7:

      1. PostgreSQL Partitioning and Table spaces
      2. Partition Methods
      3. Partition Setup
      4. Partition Table Explain Plan
      5. Table space Management

      Curriculum 8

      1. High Availability and Replication
      2. Hot Standby / Warm Standby
      3. Why Use Replication?
      4. Hot Streaming Replication
      5. Replication Limitations and Monitoring log shipping
      6. Replication Configuration and check Logs

      Curriculum 09

      1. Connection Pooling
      2. Why Connection Pooling?
      3. Pgpool-II setup
      4. Pgbouncer setup

      Curriculum 10

      1. Advance Monitoring Techniques
      2. Importance of Monitoring
      3. PGFouine/pg_badger – Log Analyzer

      Curriculum11

      1. Advance Monitering Tools(community and EDB)
      2. Monitering the Database using Pg_admin and pgbadger
      3. Pem server(Enterprise Manager). Handle more than 10 server one window
      4. pg_client, pg_agent
      5. Ora2pg(migration)-oracle to postgres Migration
      6. Edb Migration Tool Kit

      Note : To access the full course content Please enroll  the course or reach out to below contact if you are facing issue when the enrolling the course.

      PostgreSQL Training Contents

       

      LinkedIn Profile: LinkedIn
      Skype ID: Nijamutheenjobs
      WhatsApp chat: link

       

      • Share:
      2ndnijam

      Previous post

      PostgreSQL Patching version 9, 10,11
      March 14, 2021

      Next post

      Urgent Job opening for React Native developer
      March 27, 2021

      Leave A Reply

      You must be logged in to post a comment.

      Connect with



      Search

      ADVERTISEMENT

      Latest Posts

      Tips to Choose the Best Serviced Office for Your Business
      24May2022
      What key considerations do you need to keep in mind when choosing a new serviced office to house your business?
      24May2022
      The Benefits of Coworking
      24May2022
      The Long-Term Impact of Coworking
      24May2022
      Are you spending more money than you earn? Outsource with Ease and Move When You’re Ready
      24May2022
      PostgreSQL

      PostgreSQL

      $800.00 $500.00
      Greenplum

      Greenplum

      $1,500.00
      Oracle Database

      Oracle Database

      $350.00
      2ndquadrant.in

      (+91) 8838953252

      ITsupport@rayafeel.com

      Company

      • About Us
      • Our Team

      COURSES

      • List Of Course
      • Become An Instructor

      Support

      • DBA Support
      • Consultancy Services

      Recommend

      • Login
      • Contact Us

      IT Services by rayafeel.com. Powered by Rayafeel Technologies Pvt Ltd.

      • Privacy
      • Terms

      Become An Instructor?

      Join thousand of instructors and earn money hassle free!

      Get Started Now

      Connect with

      Login with Google Login with Twitter Login with Linkedin Login with Windowslive Login with Yahoo

      Login with your site account

      Connect with



      Lost your password?