VTC com PostgreSQL Tutorials | 3818D3325EC0C8C3E3BA0AA34034F8FAB41A1C55

VTC com PostgreSQL Tutorials

Name	VTC.com - PostgreSQL Tutorials	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	549.7 MB
Total Files	102
Hash	3818D3325EC0C8C3E3BA0AA34034F8FAB41A1C55

/00 Introduction/
0003 Resources.mov	10.9 MB
0002 About PostgreSQL.mov	5.6 MB
0001 About the Course.mov	3.6 MB
/01 Installation/
0106 Psql Help.mov	9.9 MB
0101 Installing Locally.mov	9.3 MB
0104 Create Drop Connect to a Database pt 1.mov	8.4 MB
0102 Regarding Installation on a Server.mov	5.5 MB
0103 Stop and Start the Service Locally.mov	5.5 MB
0107 Keywords and Identifiers.mov	4.1 MB
0105 Create Drop Connect to a Database pt 2.mov	3.0 MB
0108 Comments.mov	2.8 MB
/02 Data Types/
0201 Numeric Types.mov	7.9 MB
0203 Date Time Types pt 1.mov	7.7 MB
0207 Geometric Types.mov	6.5 MB
0204 Date Time Types pt 2.mov	6.1 MB
0202 Character Types.mov	4.7 MB
0208 Arrays.mov	4.0 MB
0205 Boolean Types.mov	3.7 MB
0206 Enumerated Types.mov	2.8 MB
/03 Defining Tables/
0311 Creating Constraints Using pgadmin pt 1.mov	9.1 MB
0305 Foreign Key Constraint pt 3.mov	7.7 MB
0310 Create a Table Using pgadmin.mov	7.2 MB
0312 Creating Constraints Using pgadmin pt 2.mov	7.0 MB
0313 Default Values.mov	6.6 MB
0306 Check Constraints pt 1.mov	6.0 MB
0314 Drop Table Cascade.mov	5.5 MB
0302 Primary Key Constraint.mov	5.4 MB
0303 Foreign Key Constraint pt 1.mov	4.7 MB
0304 Foreign Key Constraint pt 2.mov	4.0 MB
0301 Create Drop a Table Using Command Line.mov	3.9 MB
0307 Check Constraints pt 2.mov	3.8 MB
0309 Unique Constraint.mov	3.6 MB
0308 Not Null Constraint.mov	3.6 MB
/04 Working with Tables/
0407 Working with Tables Using pgadmin pt 1.mov	11.2 MB
0408 Working with Tables Using pgadmin pt 2.mov	9.5 MB
0405 Cascade Option.mov	7.6 MB
0402 Insert pt 2.mov	7.1 MB
0403 Update.mov	4.7 MB
0401 Insert pt 1.mov	4.6 MB
0404 Delete.mov	4.5 MB
0406 Truncate.mov	2.8 MB
/05 Queries/
0511 Inner Joins Between Tables pt 2.mov	7.9 MB
0516 Accessing Data Using pgadmin pt 1.mov	7.8 MB
0510 Inner Joins Between Tables pt 1.mov	7.5 MB
0517 Accessing Data Using pgadmin pt 2.mov	6.8 MB
0508 Group By and Having pt 1.mov	6.8 MB
0506 Combining Queries.mov	6.4 MB
0515 Subquery Expressions pt 2.mov	6.3 MB
0513 Cross and Self Joins.mov	6.0 MB
0503 Sorting Queries.mov	5.5 MB
0519 Creating Views Using pgadmin.mov	5.4 MB
0512 Outer Joins Between Tables.mov	5.0 MB
0507 Aggregate Functions.mov	4.9 MB
0504 Table and Column Aliases.mov	4.8 MB
0505 Limit and Offset Options.mov	4.3 MB
0518 Creating Views Using Command Line.mov	3.9 MB
0514 Subquery Expressions pt 1.mov	3.7 MB
0509 Group By and Having pt 2.mov	3.4 MB
0502 Retrieving a Portion of the Rows.mov	3.4 MB
0501 Simple Query.mov	2.7 MB
/06 Transactions/
0604 System Columns.mov	5.5 MB
0602 Savepoints.mov	5.2 MB
0603 DeadLocks.mov	5.0 MB
0601 Starting and Ending a Transaction.mov	4.9 MB
/07 Modifying Tables/
0705 Modifying Tables Using pgadmin.mov	10.1 MB
0703 Adding Removing a Constraint.mov	7.6 MB
0701 Changing a Column Data Type and Default Value.mov	6.6 MB
0704 Renaming a Column Table.mov	4.6 MB
0702 Adding Removing a Column.mov	4.6 MB
/08 Main Operators and Functions/
0802 Comparison Operators.mov	8.4 MB
0808 Pattern Matching pt 1.mov	7.7 MB
0812 Sequences.mov	7.5 MB
0811 Date and Time Functions.mov	7.0 MB
0804 Mathematical Functions.mov	6.7 MB
0809 Pattern Matching pt 2.mov	6.6 MB
0805 String Functions pt 1.mov	6.6 MB
0813 Conditional Expressions.mov	6.2 MB
0807 String Functions pt 3.mov	5.8 MB
0810 Date and Time Operators.mov	5.0 MB
0801 Logical Operators.mov	4.9 MB
0803 Mathematical Operators.mov	2.9 MB
0806 String Functions pt 2.mov	2.9 MB
/09 Schemas Privileges/
0904 Grant Revoke Privileges Using pgadmin.mov	8.2 MB
0901 Create Drop Schemas.mov	7.9 MB
0903 Grant Revoke Privileges on Columns.mov	6.4 MB
0902 Grant Revoke Privileges on Tables.mov	6.3 MB
/10 Indexes/
1007 Create and Drop Index Using pgadmin.mov	6.5 MB
1003 Create and Drop an Index.mov	5.3 MB
1005 Indexes on Expressions.mov	4.6 MB
1001 Index Usage and Benefits.mov	4.3 MB
1002 Index Types.mov	4.1 MB
1004 Multi Column Index.mov	4.1 MB
1006 Unique Index and Partial Index.mov	2.6 MB
/11 Conclusion/
1101 Course Wrap Up.mov	8.9 MB
/12 Credits/
1201 About the Author.mov	3.4 MB
/Work Files/
database example #5.txt	1.4 KB
database example #4.txt	0.9 KB
database example #7.txt	0.9 KB
database example #6.txt	0.9 KB
database example #3.txt	0.7 KB
database example #1.txt	0.3 KB
database example #2.txt	0.1 KB
Total files 102