SQL

a skill ( something you can learn how to do using Skillpedia ) by lxpk Thu, 2008-09-18 14:51

I can: Add to my skills I'll learn: Add to my skills wishlist Create Open Mission Create Learning Mission

People with this skill

People with this skill:

	User	Category	Title	Experience	Comments	Comment
	lxpk	Skill	SQL	Skill Group: SQL Skill Category: Skill The single largest PHP project I ever wrote was a Views Module-like SQL/HTML interactive data API that generated interactive tables with dynamically editable data like a spreadsheet or form and handled record editing, creation and deletion plus sorting and hierarchy. Although I wrote it not because I loved SQL but to avoid writing it, I learned a lot in the process.	0

All Skill Factors

Required Skills:

Programming

Missions Requiring this Skill

Open Missions Using This Skill:

Mission	Author	Skills	Priority	Edit
Install and test a basic Drupal installation	Agent0x45	Drupal Development SQL Web Development	normal

SQL database management is essential for building web apps that store data.

The most common web app SQL database is MySQL. iPhone and many other modern platforms provide SQLite for data storage.

Database Administration

The most common administrative interface for MySQL is called phpMyAdmin and it allows you to do most SQL database mangement tasks without learning how to us mySQL's command-line.

Your first step is to learn how to create a test database for the app you are building.
Next you'll create a mySQL user and password with permission to manipulate that database.
Now you're ready to use the database.
You can install a ready-made web app like Drupal and point it at your new database to have it do all the work of populating the things it needs in the database for you, or you can write your own code in a language like PHP and learn how to manipulate your database yourself with structured query language.