Tag Archives | SQL

MySQL Command Types MySql Tutorial for Beginners Part 2

Few Days ago we started MySQL for beginners tutorial. That was a quick intro about What is a database, What is Database table , What is SQL and Why do we use SQL? Today we will cover What are the types of MySQL database commands. Some readers asked why we are writing on MySQL Basics? We have readers learning MySQL for school or Job, We are Starting from Scratch on MySQL tutorial for beginners.You can Follow us on twitter to get latest updates on MySQL tutorial for beginners. Here is our Twitter


Types Of SQL Commands / Statements

SQL commands / statements are divided into few categories. Such as Data definition language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Commands.

1. Data Definition Language (DDL):  This SQL statements are used to define database schema such as the creation or deletion of a table. Here are some examples:

  • CREATE : This statement is used for creating objects in Database.
  • DROP: This statement is used for deleting objects from Database.
  • RENAME : This statement is used for renaming objects from Database.
  • ALTER : This statement is used for altering structure of the Database.
  • TRUNCATE : This statement removes all record from a table.TRUNCATE removes all rows from a table immediately after execution .

2. Data Manipulation Language (DML): This statement are used for manipulating data from objects in a Relational Database system. Here are some Examples bellow:

  • SELECT : SELECT is one of the most Used Command in SQL. To Retrieve from Data from Database we use SELECT statement.
  • INSERT : INSERT statement is used for inserting data into Database.
  • DELETE : This statement is used to remove rows from a table. You need to be extra with this command.After using a DELETE operation you need to COMMIT the transaction to make the change permanent.
  • UPDATE : This statement updates existing data within a table.

Continue Reading →

Continue Reading >>

BitNami Application Stacks for MAC OS X web development made easy !!

BitNami Application Stacks for MAC OS X is one of the best web development App in MAC OS X App store. If you use a MAC and looking for a solution like WampServer or Xampp. BitNami Application Stacks is one of the best web development environment out there. It allows you to develope web applications using PhpMyAdmin ,Apache2, PHP and a MySQL database. BitNami Application Stacks is available for different web applications such as bitnami wordpress, bitnami Drupal, Joomla and lots more. I use BitNami WordPress for my WordPress theme development.


Mac Users only need to install MAMP Stack from Mac App store. And that’s all.. no configuration needed. After that you can use it as a web server.Take a look at the pic below:

BitNami MAMP Stack makes the web development and deployment of PHP applications easy. It includes ready-to-run versions of Apache, MySQL, PHP and phpMyAdmin and required dependencies. And best of all BitNami MAMP Stack is distributed for free.

To get more details on BitNami Application Stacks go to link below:

BitNami Application Stacks :http://bitnami.org/stacks

For BitNami MAMP Stack : https://itunes.apple.com/us/app/mamp-stack/id571310406?mt=12

Continue Reading >>

MySQL Beginners Tutorial Introduction Part 1

Hello everyone!! today i am going to start a Mysql Beginners tutorial. In this tutorial, I will cover topics such as What is a database, What is Database table , What is SQL and Why do we use SQL?

1. What is a database and Database Management Systems?

Database is collection of organized information or data that can  easily be accessed managed and updated whenever is needed.

Database Management System (DBMS) is a system software There are many kinds of database management systems out there. Here are some example of popular Database Manage systems :
a. SQL
b. Sybase
c. Oracle
d. Microsoft Access
e. DB2

Database Management systems can be classified according to its structure. such as
a. Relational database :-In Relational Database Management systems(RDBMSs) database data are defined in such ways that it can be reorganized and accessed in a number of different ways. This kind of Database Management systems stores data in tables which has relationships to other tables.
b. Object oriented programming database :- In this database management system, the data is defined as object classes and sub classes.
c. Distributed database :- In this database management system, distributed database can be dispersed or replicated among different point in a network.

Continue Reading →

Continue Reading >>