Foundations of PostgreSQL v13

This class was created by Brainscape user Mina Nabil. Visit their profile to learn more about the creator.

Decks in this class (14)

Module1_intro
Postgres is based on what database,
In what language is postgres written,
Postgresql works on which os s
16  cards
Module2_System_architecture
What is the first process that st...,
What are the functions of postmas...,
What 3 items sit in shared memory
38  cards
Module3_Installation
What is the default os user when ...,
What does this commando do sudo y...,
What does this commando do sudo y...
8  cards
Module4_Database_Clusters
What are the 3 default databases,
How to start a cluser not a service,
How to reload not restart a cluster
6  cards
Module5_Configuration
How to change parameter for a sin...,
How to show all parameter in db,
How to see what parameter are set...
29  cards
Module6_Creating_and_managing_databases
What is the order of creation of ...,
What are the 3 ways to create a d...,
Who can by default login in a new...
9  cards
Module7_User_Tools
How to run sql file on psql witho...,
How to save psql output to file,
How to set variables in psql
6  cards
Module8_GUI_Tools
What software is needed to use pg...,
What is a domain in pg,
What can you create with pgadmin
3  cards
Module9_Database_Security
What are the 3 levels of security,
How to accept only ssl connection...,
What is the purpose of setting li...
5  cards
Module10_SQL_Primter
What are the 3 numeric data types,
What are the 3 charcter data types,
What are the 4 date time data types
16  cards
Module11_Backup_PITR
What are these pg_dump options a ...,
What are these pg_dump options a ...,
How to take a logical backup of a...
10  cards
Module12_Routine_Maintenance
What are the 3 maintenance commands,
How to analyze 1 table,
What does vacuum full do
9  cards
Module13_Data_Dictionaries
Where are the data dictonary obje...,
What is stored in pg_file_settings,
What is stored in pg_policy
9  cards
Module14_Moving_Data
How to load flat files to postgre...,
How to copy data from table to file,
How to copy data file table to table
3  cards

More about
Foundations of PostgreSQL v13

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Mina Nabil's Foundations of PostgreSQL v13 flashcards now!

How studying works.

Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.

Add your own flashcards.

Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!

What's Brainscape anyway?

Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.

We use an adaptive study algorithm that is proven to help you learn faster and remember longer....

Looking for something else?

B - PostgreSQL
  • 1 decks
  • 175 flashcards
  • 1 learners
Decks: Postgresql, And more!
Foundations of Medicine
  • 56 decks
  • 2623 flashcards
  • 5 learners
Decks: Anatomy Of A Cell, Anatomical Communication, Cell Cycle, And more!
PostgreSQL
  • 8 decks
  • 25 flashcards
  • 2 learners
Decks: Postgres Intro, Postresql Databases, Sql Select, And more!
Make Flashcards