Here you will get the material for computer IT and Database related courses and tutorials. The materials for which you will get the PDF, DOC, PPT, RAR and ZIP files are MS Access, SQL language, MySQL, Oracle, PostgreSQL, SQL server, SQL DBMS, NoSQL, NewSQL, SQLite,Design and modeling, Administration, Backup and Restore and many others. As these tutorials are included in many of the academic schedules, you will need to get detailed information on them. As it will not possible for you to browse the web for every small topic, you can go for downloading the PDFfiles for having easy access to the information. Also tutorials, corrected exercises and practical work will make it easy for you to have a clear understanding of every topic.

Beginner Courses:


  • PHP / MySQL Tutorial
  • MySQL Setup Guide
  • MySQL Admin
  • MySQL Syntax
  • MySQL Database
  • MySQL Connect
  • MySQL Tables
  • MySQL Insert
  • MySQL Query
  • MySQL Fetch Array
  • MySQL Select
  • MySQL Where
  • MySQL Order By
  • MySQL Joins
  • MySQL Update
  • MySQL Delete
  • MySQL Database Backups
  • MySQL GROUP BY – Aggregate Functions
  • MySQL Aggregate Functions – COUNT()
  • MySQL Aggregate Functions – SUM()
  • MySQL Aggregate Functions – AVG()
  • MySQL Aggregate Functions – MIN()
  • MySQL Aggregate Functions – MAX()
  • MySQL – SQL Injection Prevention
  • MySQL Date – Formats
  • MySQL Time – Formats
  • MySQL Index – Overclock Your Tables

sqlserver   SQL: Triggers – Views – Indexes


    • “Active” data
    • Triggers, Trigger options, Transition variables
    • Statement-level trigger example
    • BEFORE trigger example
    • Statement- vs. row-level triggers
    • System issues, Views, Creating and dropping views
    • Using views in queries, Why use views?
    • Modifying views, A simple case
    • An impossible case, A case with too many possibilities
    • INSTEAD OF triggers for views
    • Indexes, Examples of using indexes
    • Creating and dropping indexes in SQL
    • Choosing indexes to create
    • SQL features covered so far

oracle_database   Oracle 11g Express installation guide

A step by step to install Oracle 11g database Express edition guide

ORACLE logo   Oracle/SQL Tutorial


  • SQL Structured Query Language
  • SQL*Plus (Minimal User Guide, Editor Commands, Help System)
  • Oracle Data Dictionary
  • Application Programming
  • Integrity Constraints and Triggers
  • System Architecture

Oracle11g   Oracle Database 11g: SQL Fundamentals


  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects

………..webpage is under construction



Leave a comment

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s