SQL.. the beginning.

The first time I ever saw a database was in Paradox (database), in 1995. It was a huge learning curve, but I quickly learned what tables, columns and rows were. Then I learned how to build relationships and write SQL queries. (SQL is short for Structured Query Language)

This is how I then figured it was put together.

Every database has collection of one or more tables.
Tables are made up of rows and columns.
The rows contain the data and columns describe the format of the data, namely data type, for that column.

Imagine a telephone directory, information of a person’s first name, surname , address and ph number, this is how the basic table would be constructed:

Table: Phone_Directory

FirstName	LastName	Address	Phone
Jake	Black	123 Round Road, CA	123 321-1234
Sonia	Coke	19 Sailfish Road, WA	232 555-5555
Mel	Brown	32 71st Ave, NY	614 555-5432

Hello world

Welcome to my blog. As you noticed I left the ‘Hello World!’ heading as this is how programmers start their first program! With this blog I hope to help fellow SQL developers, whether Oracle, MsSQL, MySQL. And my new journey of web development in PHP. Starting with wordpress….

My websites

Besides this blog I own and manage the following websites which are also to help others.

http://www.bokaap.co.za
The area of Bo Kaap is from my origin in South Africa, both my parents were born there and gre up in Bo Kaap. It is rich with history, culture and a growing tourist area.

http://www.muslimdirectory.com.au
When arriving in Australia, I was looking for a Halal Butcher and on a journey one day was looking for a mosque to pray in, I googled it and could not find anything, so started this website.


http://www.ozarrivals.com.au
As we are a family that migrated to Australia from South Africa in February 2008, and everyone Kept asking me the same questions about what visa do I need? what to do when arriving in Australia, what to pack, how do I get there? etc.. etc.. I thought I'ld blog them, as these questions are asked. If you have a question don't be shy to ask, I do try and answer the questions in a blogm so that everyone can benefit :)

NB:
All the websites above are free to use and sustains themselves with the adverts placed on them. I hope they are able help you, as just in this blog.

Arrived in Australia

Well at last, we arrived in Brisbane 21 February 2008!