Browsing articles by " Jorge Reis"
Jan
4
2012

What is a Database Query?

Database Query Example

People create a database because they want to organize the data in such a way that they can glean useful information from it. These data can be accessed by using a query. A query, if properly stated, will extract data from the database. For example, a businessman creates a database which contains the list of his products, their prices, and the number of people who bought them. If he wants to find out which products are most expensive, he can input a query into the [...]

Dec
29
2011

Where to Get a DBA Certification?

DBA Certification

It’s always important to keep yourself updated. In the fast-paced world of the internet, new technologies are always being developed, and it’s a must for IT professionals to keep up. DBA Certification Certification programs are available online for different IT jobs. Certificates are given to individuals who pass the test, which signify that they are qualified and capable to perform the tasks and duties of database administration. Certification programs are given by well-known system softwares such as IBM, Microsoft and Oracle. These programs are optional [...]

Dec
29
2011

Where to Get Database Training?

Database Training

If you are a web owner or want to join the fast-paced world of the internet, database training is important. Beginners need it to learn the basics, and experts have to update their knowledge. To get ahead or keep your lead in the World Wide Web, you have to keep your site updated, and this entails database management and automation if you want to get your website published, but this is just the tip of the iceberg though. There are different ways to acquire database [...]

Dec
28
2011

What is a Database Schema?

Database Schema Example

Database schema refers to the layout of the database, which shows how each data is organized into structures or tables. It is also referred to as the language used by database management systems. The schema in a relational database refers to the tables, fields and also the existing relationship between the fields and tables. Schemas are stored in a data dictionary, and although it is usually in database language, it is considered as the graphic model of a database. Simply put, it is the representation [...]

Dec
19
2011

What is a Database?

Traditional Paper Database

Have you ever wondered how your files, documents and other important data are always available when you input a certain command on your computer to access them? Who organizes them in such a way that whatever you need at any given time is readily available with literally just one click? The advancement of the computer technology has brought many different benefits to users, whether individual or a network of multiple users. Data storage is one of those benefits. What used to be a working filing [...]

Dec
9
2011

Installing your first WordPress script

Wordpress Logo

Now that we’ve created the database and added an user to it, we can actually get going and install the script (wordpress). Understanding the basics Right, first of all we will explain the basic format of a database and username, as this is confusing to a lot of newbies, it took me a while to get used to it. useraccount_databasename Your hosting account username ALWAYS comes before the databasename followed by the underscore “_” to avoid confusion you could always call the name the database [...]

Dec
9
2011

Create your first Mysql database

Logo Mysql / Sun

Installing a script (like wordpress for example) can seem a daunting task to newbies, with all those different fields you have to fill in and to which you don’t have a clue about. Don’t fret, we will guide you through the process of creating a new database and installing that script. Step 1 This much you should have already figured out by now, log into cpanel and select MySQL Databases there are other types of databases but we dont need those for now. Step 2 [...]

Pages:«12345