Brown PHP

If you plan to become a MySQL professional, you should really consider obtaining one or more MySQL Certifications. Each certification requires that you pass one or more exams containing about 70 multiple-choice questions. The present cost of each exam is $200 but is sometimes discounted. This exam is available through the Pearson VUE test centers located virtually across the globe.

What do you get for passing these tests? The first answer is professional recognition. While certification is no proof that you can really perform on the job, doing the hard, hard work of certifying can help you prepare for the real world. Let’s be frank. If you only know your stuff on paper, you won’t know what to do on the job. Before long you’ll be pounding the pavement. In a community like certified MySQL professionals the word spreads fast.

In this article we look at your choices for MySQL Certifications. Companion articles will discuss each of these certifications in more detail. The CMA (Certified MySQL Associate) is an entry-level certification, designed for people who are relatively new to using the MySQL database server. This certification covers basic SQL and basic database management system concepts. While this certification is not a prerequisite to the other MySQL certifications many people new to MySQL start with CMA certification before going to the more advanced certifications. It’s up to you.

The CMDEV (Certified MySQL Developer) is targeted at candidates who will be developing applications using MySQL as back-end storage. It is issued to those who pass both the Certified MySQL Developer-I and Certified MySQL Developer-II exams. You may pass either of these two exams first; they cover different but complementary material.

The CMDBA (Certified MySQL Database Administrator) is targeted at database administrators who are responsible for tuning, planning, and optimizing data layout for one or several servers and who do not write many applications. It is issued to those who pass both the Certified MySQL DBA-I and Certified MySQL DBA-II exams. You may pass either of these two exams first; they cover different but complementary material. The CMCDBA (Certified MySQL Cluster Database Administrator) requires first obtaining the CMDBA certification and then passing a single exam associated with a very specific aspect of MySQL technology. You can be a professional MySQL database administrator and never deal with the material covered by this exam.

Several tracks are available to prepare for any and all of these certifications. For example, Sun MySQL offers books and classes at every level. Take my advice, don’t commit to anything more expensive than a book until you download MySQL and spend some serious time trying it out. One thing is sure; if you want to pass the test you must run MySQL hour after hour, day after day. If you don’t like that do something else.

MySQL/PHP Database Applications Bulger Greenspan Wall

US $18.95 End Date: Friday Sep-03-2010 18:30:35 PDT Buy It Now for only: US $18.95 Buy it now | Add to watch list

MySQL is a very powerful open source database which means that it is free to use. One of the many tools that come with MySQL is their MySQL Command Line that will allow you to do pretty much everything from create a database to add and edit entries in the database. This article will help you to begin using MySQL Command Line Successfully.

When you install MySQL you will receive a command line application where you can create new databases, modify current databases, and delete databases.

Once you launch the MySQL Command Line Client you will be prompted for a password assuming you set one up when you installed MySQL. From here you will be given a mysql> prompt and you will be able to enters your commands.

Lets start with creating a database in our system:

mysql> CREATE DATABASE temp;
Query OK, 1 row affected (0.00 sec)

Be sure that when creating databases, tables, and fields that the names are case sensitive and cannot include spaces.
All commands issued through the command line must end with a semi-colon (;) or else you will be promtped for more commands.

In order to edit this new database we have created we need to switch to it and that is where the USE command comes into play.

mysql> USE temp;
Database changed

Now that we have a working database lets create a table in the database to store our relatives

mysql>CREATE TABLE family (name char(25), age integer, relation char(50));
Query OK, 0 rows affected (0.05 sec)

We just created a table that contains three fields so lets go into a little more detail about that command we just ran.

First we used the CREATE TABLE command which does exactly what it says does and it creates the table. Where we typed in family is the name of the table that we just created. Everything else within the parenthasis are fields in the table and what type of information is going to be stored in that field. For example that name char(25) tells SQL to create a field within the table called “name” and the char(25) tells it that it will be a character field meaning you can type any character you want in it and that it is 25 characters long. The age integer tells SQL to create a field in the table called age and that it will be a integer meaning that only whole numbers are stored in this field. You can add a size to the integer field like when using char but it is not nessecary as the default length of an interger field is 11. The last one is just like the first one realtion char(50) except for the fact that we made this field able to hold 50 characters instead of 25.

Now that we have created a database and a table lets look at a coupld show commands to see what we have. The show commands are pretty straight forward in terms of what they do. Lets start with SHOW DATABASES;

mysql> SHOW DATABASES;

+—————-+
| Database   |
+—————-+
| temp          |
| mysql        |
| mikenetpc  |
+—————+

3 rows in set (0.01 sec)

You can see that the SHOW DATABASES command will print you a list of all the databases on the system so can you guess what the SHOW TABLES command will do once you have used the USE temp command. Yep you guessed it, it will show you a list of all the tables in the database temp.

mysql> SHOW TABLES;

+———————-+
| Tables in temp  |
+———————-+
| family               |
+———————-+
1 row in set (0.01 sec)

Lets keep going deeper with the SHOW commands and lets look at the table itself and see all of the fields we have. We will simply use the SHOW COLUMNS FROM family command.

mysql> SHOW COLUMNS FROM family;

+———-+————-+——-+——–+————+———+
| Field    | Type      | Null  | Key   | Default  | Extra |
+———-+————-+——-+——–+————+———+
| name   | char(25) | YES |         | NULL    |           |
| age      | int(11)    | YES |         | NULL   |           |
| relation | char(50) | YES |         | NULL   |           |
+———-+————-+——-+——–+———–+———-+
3 rows in set (0.07 sec)

Now that we have create a database and a table and confirmed that they are there and setup the way we would like, lets add some information to the table because a database is not good without information. If you have every done any MySQL and PHP programming these next 2 commands should look very familiar. Lets start by adding in some people into the table by using the INSERT INTO table command. We are going to add Derek who is 22 and my cousin, Chelsie who is 21 and my cousin, and Leslie who is 27 and my sister.

mysql>INSERT INTO family (name, age, relation) VALUES (‘Derek’, 22, ‘Cousin’);
Query OK, 1 row affected (0.03 sec)

mysql>INSERT INTO family (name, age, relation) VALUES (‘Chelsie’, 21, ‘Cousin’);
Query OK, 1 row affected (0.03 sec)

mysql>INSERT INTO family (name, age, relation) VALUES (‘Leslie’, 27, ‘Sister’);
Query OK, 1 row affected (0.03 sec)

Now that we have added our information lets take a look at it and confirm it is all there. We will be using the SELECT command to view content in the table.

mysql> SELECT * FROM family;

+———–+——+————-+
| Name   | Age | Relation |
+———–+——+————-+
| Derek   | 22   | Cousin   |
| Chelsie | 21   | Cousin   |
| Leslie   | 27   | Sister     |
+———-+——-+————-+
3 rows in set (0.01 sec)

We can also use the SELECT command to order our list or to only pick a specific person.

mysql> SELECT * FROM family ORDER BY name;

+———–+——+————-+
| Name   | Age | Relation |
+———–+——+————-+
| Chelsie | 21 | Cousin     |
| Derek   | 22 | Cousin     |
| Leslie   | 27 | Sister       |
+———+——+—————+
3 rows in set (0.01 sec)

As you can see by simple adding ORDER BY name we were able to resort the information in the table by name. Now lets pull a specific person from the table

mysql> SELECT * FROM family WHERE name=’Leslie’;

+———+——+————-+
| Name | Age | Relation |
+———+——+————-+
| Leslie | 27   | Sister     |
+———+——+————-+
1 rows in set (0.01 sec)

By qualifying what we want name to be equal to we can pull specific records out of the table.

MySQL/PHP Database Applications Bulger Greenspan Wall

US $18.95 End Date: Friday Sep-03-2010 18:30:35 PDT Buy It Now for only: US $18.95 Buy it now | Add to watch list

MySQL/PHP Database Applications Bulger Greenspan Wall

US $18.95 End Date: Friday Sep-03-2010 18:30:35 PDT Buy It Now for only: US $18.95 Buy it now | Add to watch list

Google TechTalks April 28, 2006 Jay Pipes Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his name on articles appearing in Linux Magazine and can read more articles about MySQL at his website. ABSTRACT Learn where to best focus your …

Creating a database with MySQL Administrator
Web Database Applications with PHP & MySQL David Lane

US $18.95 End Date: Friday Sep-03-2010 18:31:57 PDT Buy It Now for only: US $18.95 Buy it now | Add to watch list

Ghacks: “But there are better tools for managing your MySQL databases. One of those tools, MySQL Administrator, is actually released by the MySQL developers. This tool will work with any MySQL installation = 4.0 and makes the daunting task of administrating MySQL databases far easier than any other desktop GUI tool.”

Read more on Linux Today

Product Description
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.   PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive… More >>

PHP and MySQL Web Development