My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
Advertisements
|
MySQL and SQL Corner
Posted Date: 16 Jun 2007 Resource Type: Articles/Knowledge Sharing Category: Education
|
Posted By: vediyappan Member Level: Bronze
Rating:  Points: 5
|
|
|
This articles will gives you detailed working knowledge in SQL and MySQL.
MySQL and SQL Corner
MySQL – Database
SQL – Language
MySQL Beginners – Reading Materials
1. Basics of MySQL
1.1. Definition:-
MySQL is what is known as a Database Management System (DBMS).
The management system decides how the data is stored, sorted and retrieved, as well as controlling user access to it.
Every time the DBMS deals with the request from a user retrieves data, deletes data, or adds more data.
1.2. Features
1. MySQL is a really popular, Relational DataBase Management System (RDBMS).
2. MySQL works in perfect with PHP, Perl, Python and Pascal languages.
3. MySQL Benefits:-
i.With MySQL there are no memory leakages.
ii.Lower hardware expenditure.
iii.It is reduction in Administration and Engineering support costs.
ix. It’s handles large database – more than 50,000,000 records.
x. MySQL can control several databases at once.
xi.The MySQL website describes MySQL as the “world’s most popular Open Source database.
4. Its popularity is no doubt encouraged by the fact that if you need MySQL for non-commercial use, you can download a copy free from the website.
5. MySQL has been ported for use to a variety of different platforms. Due to its bundling with PHP, MySQL is most often used as a database back end to a web server.
1.3. Relational Database Management System (RDBMS)
In a relational structured database there are tables that store data. Each table is made up of columns and rows. A table's columns define what kind of information is going to be stored. You need an individual column for each type of information you wished to store (i.e. Age, Weight, and Height). Databases are most useful when it comes to storing information that fits into logical categories.
1.4. MySQL DB Storage Engines
MySQL has built in support for multiple data storage engines that handle different table types. These MySQL data storage engines automatically include those that handle transactions-safe table as well as those that handle non-transactions-safe tables.
1.5. ISAM Storage Engine
ISAM was the original MySQL data storage engine. ISAM manages non-transactional tables.
Each ISAM table is stored on the disk in form of three individual files.
One file holds the table definitions i.e. .frm, another file holds table data i.e. .isd and the index file is .ism.
|
Responses
|
| Author: Muthuramalingam 16 Jun 2007 | Member Level: Bronze Points : 1 | Hi Vediyappan the material is good.. Post additional informations about sql
|
|
|