Database Tutorials

Learn Database Management Systems, Relational Database Management Systems, Database Administration using Oracle, SQL Server, MySQL and others

Oracle

In Depth Oracle Database Management Tutorials and Oracle Database Administration Articles

SQL Server

SQL Server Database Management Tutorials and Database Administration Articles

MySQL

Comprehensive MySQL Tutorials with examples along with fine tuning tips and tricks for your MySQL Database Server

PostgreSQL

PostgreSQL Database Tutorials with examples

	Title / Author	Replies Views
	What is the Difference between DBMS and RDBMS? ( 1 2 3 ... Last Page) A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.... By shabbir Last Message By samantha1230	39 491,661
	Database interview questions for beginner ( 1 2 3) 1. Explain the difference between a database administrator and a data administrator. Database Administrator :- A person (or group of people) responsible for the maintenance and performance of a database and responsible for the planning, implementation, configuration, and administration of... By shabbir Last Message By aroraaisha	26 201,928
	Difference between Stored procedures and User Defined functions[UDF] ( 1 2) The definition of stored procedure as from WIKIPEDIA Stored procedure A stored procedure is a program (or procedure) which is physically stored within a database. They are usually written in a proprietary database language like PL/SQL for Oracle database or PL/PgSQL for PostgreSQL. The... By shabbir Last Message By khaleek_ahmad	13 135,852
	Relational Algebra Operations in SQL with Examples Relational Algebra A query language is a language in which user requests information from the database. it can be categorized as either procedural or nonprocedural. In a procedural language the user instructs the system to do a sequence of operations on database to compute the desired result.... By techgeek.in Last Message By Swatika	8 83,720
	Calculating Date Differences You have two dates (either in your code or in your database columns). How to calculate the difference between them in years, months, weeks etc! This is one of the most common questions on many forums, and the logic in general is quite simple. Most programming languages give you the ability to... By Janu Last Message By jhonackerman	6 40,510
	Poll: SQL Server, Oracle and MySQL basic questions and answers 1. What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose. 2. What is DBMS? It is a collection of programs that enables user to... By Shree Limbkar Last Message By gsuryaprasath	8 37,602
	Database Normalization ( 1 2) If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you "Is that database normalized?" or "Is that in BCNF?" All too often, the reply is "Yeah." Normalization is often brushed aside as a luxury that only academics have time... By pradeep Last Message By samantha1230	18 34,029
	Difference between Database & Database Management System Database is an organised collection of data or information so that it can be easily accessed, updated or manipulated. Database management system (DBMS) is a software that manages database on a computer. Eg. microsoft access, MySQL, oracle etc. Database are classified according to their... By aryan123 Last Message By xcfrrdvd	8 26,997
	Query Optimization ( 1 2) This is my first article and so please provide comments on it (good or bad). The design of the database is one of the most important factors in the performance of the database and with a good database design you also need optimal queries to perform optimally. Everyone wants the performance of... By coderzone Last Message By samantha1230	16 26,125
	Small Bug tracking utility in C# with access as database Introduction When I was managing a team of five developers I use to distribute the work among the team members and I was using the Excel for making notes of everything but on one day I though of writing a simple program for myself and used one weekend to write the program for my job but I though... By shabbir Last Message By srikes	3 12,964