VTC com PostgreSQL Tutorials | 093F30DBF8CB16C683213B82C9EA5ADF50BECAD0

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
Last Seen
Hash	093F30DBF8CB16C683213B82C9EA5ADF50BECAD0

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