Home / Training / Introduction to Database and Programming

Introduction to Database and Programming

elephant3

Object-relational database systems are the backbone of present IT infrastructures. This series give practical skills on PostgreSQL, the world's most advanced open source database and MySQL the world's most popular open source database. In addition, you are going to be introduced to PHP, perhaps the most utilized language for dynamic web content, and Python, a powerful, yet clean, object-oriented programing language, used to power scalable solutions, yet suitable for newcomers in programming.

Database 101 Practical Relational Database Management System - PostgreSQL and MySQL

ScriptProgramming 101 - Introduction to PHP Web Development

OO Programing 101 Introduction to Python

Database 101 Practical Relational Database Management System - PostgreSQL and MySQL

The backbone of any IT infrastructure rests on a database. PostgreSQL is the most powerful open source database, while MySQL is most ubiquituous. This course is intended for people with minimal GNU/Linux background (Linux 101, Linux 102, WebServer 101) and want to learn to install, configure and connect to a PostgreSQL or MySQL database through  CLI (command line interface) and SQL language(PSQL), Web, or GUI (e.g. PgadminIII).

This is a 10 hour hands-on course is intended to give you basic, yet  useful and functional skills.

The tasks are as following:

1. Install  and configure PostgreSQL dabase on Debian  GNU/Linux machine

2. Create and Manage users

3. Create and Manage Database

4.Create and modify tables and content

Price $100.00

(price ex. vat 100)

ScriptProgramming 101 - Introduction to PHP Web Development

Twenty million webservers insure dynamic web serving through PHP scripting language. This is the simplest functional course, designed for non-programmers who want to learn the basics of the PHP language as applied in specific projects. The basic concepts on syntax, quotes, comments data types, variable basics, control and function basics are going to be taught from a functional, hands-on project perspective.

This course is 4 hours long and it assumes that the students have fulffiled prerequisites such as basic apache HTTP webserver understanding (WebServer 101), GNU/Linux navigation skills (Linux 101),  and basic handle on text editing using Nano.

Price $25.00

(price ex. vat 25)

OO Programing 101 Introduction to Python

Python is a high level scripting language which can be used both, for web development and system and application development. Famous institutions where python is used includes NASA, yahoo.com, google.com and android.

This course is 5 hours in length is intended for newcomers in programming. The hands-on lab will enable the students to learn python by doing simple, yet practical projects, such as controling a stepper motor, or creating simple web applications.

The prerequisites are Debian GNU/Linux navigation, apache HTTP webserver basics,  and text editing with nano and gedit.

Price $0.00

(price ex. vat 0)