- Chapter 1: Database
MySQL database
is the world most popular open source database because of its fast
performance, high reliability, ease of use, and dramatic cost sav...
more>>
- Chapter 2: Retrieving and Sorting
To access our
information in the database we need to query the database with the
SELECT command. SELECT will do exactly as the name describes and s...
- Chapter 3: Restricting Data
By using LIMIT
clause in SELECT statement we can limit no of record fetching. In limit
clause you have to pass two parameters first one starting po...
- Chapter 4: MySQL Functions
SQL has many
built-in functions for performing calculations on data. SQL aggregate
functions return a single value, calculated from values in a col...
- Chapter 5: Displaying Data from Multiple Table (Joining)
Thus far we have
only been getting data from one table at a time. This is fine for
simple takes, but in most real world MySQL usage you will often ...
- Chapter 6: Aggregate Functions and Aggregation Using GROUP BY Clause (Grouping)
By definition,
aggregate functions allow us to perform a calculation on a set of
records and return a single returned value. Aggregate functions ig...
- Chapter 7: Subquery
A subquery is a
SELECT statement that is embedded in another SQL statement. The outer
statement uses the result returned by the inner statement.
- Chapter 8: Manipulating table
Data
Manipulation Language (DML) statements are used for managing data within
tables. Some commands of DML are: SELECT - retrieve data from the a
d...
- Chapter 9: Creating and Managing Table
In MySQL and
other database systems, the goal is to store information in an orderly
fashion. The table gets this done by making the table up of col...
- Chapter 10: Indexing & Engine
Tables in MySQL
can grow very large, but as a table gets bigger, retrievals from it
become slower. To keep your queries performing well, it is esse...