LinuxCBT PostgreSQL Edition Free CBT Download

LinuxCBT PostgreSQL Edition Free CBT Download

LinuxCBT DBMS Edition feat. PostgreSQL focuses on the implementation of PostgreSQL DBMS.

PostgreSQL is a widely used open source ORDBMS engine due to its: non-commercial implications, flexible license, long academic development history @ UC Berkeley, object-oriented and relational nature, cross-platform prowess and considerable scalability.

If you are/will be responsible for PostgreSQL and/or an environment of SQL flavors (MS SQL, Oracle, MySQL, etc.), broaden your knowledge of SQL implementations by exploring PostgreSQL. The benefits will be realized in any SQL arena.

Let LinuxCBT DBMS Edition feat. PostgreSQL cost-effectively strengthen your SQL skills.

Course Objective

PostgreSQL - DBMS

    Introduction - Topology - Features

        Identify key systems to be used

        Discuss key PostgreSQL features

Read more ►

Installing and Configuring PhpMyAdmin-3.5.1

Installing and Configuring PhpMyAdmin-3.5.1

PhpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the World Wide Web. Most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, while you still have the ability to directly execute any SQL statement. It comes with an intuitive web interface, support for most MySQL features.

Install phpMyAdmin

Type the following command:

# yum search phpmyadmin

# yum -y install phpmyadmin

Read more ►

Installation of MySQL on Linux

MySQL

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest and greatest version 5.5.28 on CentOS 6 and Red Hat (RHEL) 6.

Install MySQL Database 5.5.28 on CentOS 6/5, Red Hat (RHEL) 6/5

1. Change root user

su -

CentOS and Red Hat (RHEL)

Run the following command defined with your Operating system

Read more ►

Installing PostgreSQL9.2 on Redhat (RHEL5 & 6)

Installing PostgreSQL9.2 on Redhat (RHEL)

the same installation you can use for CentOS

1. Install PostgreSQL 9.2.1 Database Server on CentOS/Red Hat (RHEL)

1.1 Change root user or login as a root

su –

Example: su - root

1.2 Red Hat (RHEL)

Add exclude to /etc/yum/pluginconf.d/rhnplugin.conf file [main] section:

[main]

...

exclude=postgresql*

Read more ►