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:

Contents

  • 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 LEFT JOIN
  • 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

oracle_database   Oracle 11g Express installation guide

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

ORACLE logo   Oracle/SQL Tutorial

Contants

  • 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

Contants

  • 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

underconstruction

Leave a comment

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s