PostgreSQL Training Video - Tutorial CD

This PostgreSQL Training Video puts real world database development skills into your hands. With a thorough exploration of core concepts and techniques, these PSQL tutorials show you how to install, modify and manage your own databases even if you have no prior experience with SQL. The first lessons in the PSQL training focus on core concepts and functionality that inform later chapters and give you a progressive understanding of how modern databases work. You start with basic installation and database connectivity, then move onto major data types, working with constraints, performing queries and subqueries, and go through functions, schemas and indexes. While the subject matter becomes quite complex, the course is targeted toward beginners, and all lessons have complete playback controls that allow users to pause, rewind and review the PSQL tutorials at any time. Because each lesson is under 10 minutes, it's also especially easy to break up learning into manageable chunks that will fit any schedule. To go beyond these free demo tutorials, the complete PostgreSQL Training Video can be ordered to own on CD / DVD or viewed instantly online by members of the unlimited video subscriber plan. This tutorial is the ideal way to Learn PostgreSQL at your own pace.

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

This PostgreSQL Training video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that bring a high degree of visual clarity to even the most complex applications. Being over 8 hours long this PostgreSQL Training on CD / DVD is extremely comprehensive and easy to follow. Video Tutorial taught by Experts - Low Cost

- Easy to Learn
Evaluate the high quality of this Tutorial
try a free demo Below.

Benefits

  • Works on PC or Mac
  • Professional Tutition by Experts
  • Self-Paced Learning Interface
  • Builds Practical Skills Quickly
  • Rapid Learning - High Retention
  • Free Certificate with each Tutorial

Client Testimonials

  • I just joined your Online University, and so far you guys are great! I love the amount of training that I can watch day or night. Tasks that had me baffled in the past are now put in to plain English right before my eyes in my own home. I sure wish I had found you guys before.
    Jake Holt
    Pinecrest Florida

Just Released Training

Topics covered on this Tutorial Video
are Listed Below:

Introduction Installation Data Types

The purchased version of this Training contains all the movies listed below as well as all the featured Movies above. add to cart US$ 99.95

Defining Tables
  • Create / Drop a Table Using Command Line
  • Primary Key Constraint
  • Foreign Key Constraint pt. 1
  • Foreign Key Constraint pt. 2
  • Foreign Key Constraint pt. 3
  • Check Constraints pt. 1
  • Check Constraints pt. 2
  • Not Null Constraint
  • Unique Constraint
  • Create a Table Using pgadmin
  • Creating Constraints Using pgadmin pt. 1
  • Creating Constraints Using pgadmin pt. 2
  • Default Values
  • Drop Table Cascade
Working with Tables
  • Insert pt. 1
  • Insert pt. 2
  • Update
  • Delete
  • Cascade Option
  • Truncate
  • Working with Tables Using pgadmin pt. 1
  • Working with Tables Using pgadmin pt. 2
Queries
  • Simple Query
  • Retrieving a Portion of the Rows
  • Sorting Queries
  • Table and Column Aliases
  • Limit and Offset Options
  • Combining Queries
  • Aggregate Functions
  • Group By and Having pt. 1
  • Group By and Having pt. 2
  • Inner Joins Between Tables pt. 1
  • Inner Joins Between Tables pt. 2
  • Outer Joins Between Tables
  • Cross and Self Joins
  • Subquery Expressions pt. 1
  • Subquery Expressions pt. 2
  • Accessing Data Using pgadmin pt. 1
  • Accessing Data Using pgadmin pt. 2
  • Creating Views Using Command Line
  • Creating Views Using pgadmin
Transactions
  • Starting and Ending a Transaction
  • Savepoints
  • DeadLocks
  • System Columns
Modifying Tables
  • Changing a Column Data Type and Default Value
  • Adding / Removing a Column
  • Adding / Removing a Constraint
  • Renaming a Column / Table
  • Modifying Tables Using pgadmin
Main Operators and Functions
  • Logical Operators
  • Comparison Operators
  • Mathematical Operators
  • Mathematical Functions
  • String Functions pt. 1
  • String Functions pt. 2
  • String Functions pt. 3
  • Pattern Matching pt. 1
  • Pattern Matching pt. 2
  • Date and Time Operators
  • Date and Time Functions
  • Sequences
  • Conditional Expressions
Schemas / Privileges
  • Create / Drop Schemas
  • Grant / Revoke Privileges on Tables
  • Grant / Revoke Privileges on Columns
  • Grant / Revoke Privileges Using pgadmin
Indexes
  • Index Usage and Benefits
  • Index Types
  • Create and Drop an Index
  • Multi-Column Index
  • Indexes on Expressions
  • Unique Index and Partial Index
  • Create and Drop Index Using pgadmin
Conclusion
  • Course Wrap Up
Credits
  • About the Author

When you order this PostgreSQL Training CD you'll receive:-

An effective Tutorial Video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

PostgreSQL Training - VIDEO INFO

PostgreSQL

Dima Kassab

8 hours - 95 Movies

US$ 99.95

Win 7 ,Vista, XP, 2000, 98. Mac OS X

Ground / 2 day / Next Day

34298
196 In Stock
Purchase Orders from Schools, Colleges and Government accepted

Multi User Version Available

This training video is also available in Multi User format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.
$500

Benefits of this Training Video

  • Learn PostgreSQL in the shortest time possible
  • Self paced tutorial, training on video, learn at your own pace
  • Just sit back and watch, no books to read, just easy to follow lessons
  • Training can be viewed from any location, on PC or Mac
  • All training is self-contained; you dont even need the application you are learning loaded on your machine
  • The most affordable way to learn, benefit from a world-leading expert
  • High quality content for a fraction of the cost of a classroom training course
  • The tutorials can be rewound, fast forwarded or stopped at any time
  • Learn PostgreSQL from the comfort of your own desk.

Prove your Skills. Free Certification

  • With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.

Related Tutorial Videos

PostgreSQL Related Videos


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434 878 4158
Fax: 1 207 433 4356
Email: