Lynda PostgreSQL Essential Training-APoLLo

  RELEASE  Lynda.PostgreSQL.Essential.Training-APoLLo
      URL  https://www.lynda.com/PostgreSQL-tutorials/PostgreSQL-Essential-Training/2828018-2.html
   SOURCE  Lynda
  UPDATED  
     DATE  5/22/2020
 ex.FiLES  Yes
                GROUP  NOTES  
                                             xS2k19

26M	01 Introduction
24M	01 Introduction/001 Manage relational data with PostgreSQL.mp4
1.7M	01 Introduction/002 Using the exercise files.mp4
78M	02 Getting Started with PostgreSQL
7.0M	02 Getting Started with PostgreSQL/001 What is PostgreSQL_.mp4
14M	02 Getting Started with PostgreSQL/002 Download and install PostgreSQL.mp4
15M	02 Getting Started with PostgreSQL/003 Connect to the server with psql.mp4
11M	02 Getting Started with PostgreSQL/004 Browse the server with a graphical interface.mp4
20M	02 Getting Started with PostgreSQL/005 Create objects with pgAdmin.mp4
1.2M	02 Getting Started with PostgreSQL/006 Challenge_ Create a table.mp4
13M	02 Getting Started with PostgreSQL/007 Solution_ Create a table.mp4
21M	03 An Introduction to Relational Databases
6.0M	03 An Introduction to Relational Databases/001 The structure of a database table.mp4
9.4M	03 An Introduction to Relational Databases/002 PostgreSQL native data types.mp4
4.9M	03 An Introduction to Relational Databases/003 Join tables together with relationships.mp4
81M	04 Building a Database
14M	04 Building a Database/001 Organize tables with schemas.mp4
21M	04 Building a Database/002 Create a table with pgAdmin.mp4
16M	04 Building a Database/003 Link primary and foreign keys.mp4
15M	04 Building a Database/004 Enforce referential integrity on related records.mp4
1.9M	04 Building a Database/005 Challenge_ Execute a command on the Postgres server.mp4
16M	04 Building a Database/006 Solution_ Execute a command on the Postgres server.mp4
62M	05 Retrieve Information with Queries
10M	05 Retrieve Information with Queries/001 Import data from a CSV.mp4
9.3M	05 Retrieve Information with Queries/002 Retrieve information with a SELECT query.mp4
5.6M	05 Retrieve Information with Queries/003 Helpful pgAdmin Query Tool interface elements.mp4
12M	05 Retrieve Information with Queries/004 Join tables for additional information.mp4
8.0M	05 Retrieve Information with Queries/005 Save a query as a database view.mp4
1.7M	05 Retrieve Information with Queries/006 Challenge_ Import data and write queries.mp4
16M	05 Retrieve Information with Queries/007 Solution_ Import data and write queries.mp4
60M	06 Managing Data
14M	06 Managing Data/001 Add indexes to a table.mp4
8.9M	06 Managing Data/002 Automatically fill in default values.mp4
13M	06 Managing Data/003 Constrain acceptable input values.mp4
1.9M	06 Managing Data/004 Challenge_ Add data constraints.mp4
23M	06 Managing Data/005 Solution_ Add data constraints.mp4
37M	07 Database Administration in PostgreSQL
9.3M	07 Database Administration in PostgreSQL/001 User accounts and roles.mp4
15M	07 Database Administration in PostgreSQL/002 Grant privileges to a role.mp4
12M	07 Database Administration in PostgreSQL/003 Back up and restore a database.mp4
1.7M	07 Database Administration in PostgreSQL/004 Start and stop the server.mp4
2.8M	08 Conclusion
2.8M	08 Conclusion/001 Additional resources.mp4
8.0K	Ex_Files_PostgreSQL_EssT.zip
364M	total