Let’s Explore Databases


Good Morning!
I Have Been Thinking

Let’s Explore Databases

Our tutorial this month will help you get started with databases. We explore together the process using OO Base database software, importing spreadsheets into databases, using the Structured Query Language and more.

The Structured Query Language (SQL) makes up one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms.

At first glance, the language may seem intimidating and complex but it’s really not all that bad. In a series of articles over the next few weeks we’ll explore the inner workings of SQL together. By the time we’re through, you’ll have the fundamental knowledge you need to go out there and start working with databases!

OO Base comes loaded with several databases so rather than start from scratch we are going to get the feel for it by creating a rolodex using a premade database and then learn how to adjust what is premade into something that will serve your purpose.

Opportunity is never lost
It goes To Those Ready to Accept It!

Carolyn

Ice Breakers

Talented Dog

A salesman dropped in to see a business customer.
Not a soul was in the office except a big dog emptying
wastebaskets. The salesman stared at the animal,
wondering if his imagination could be playing tricks
on him.

The dog looked up and said, “Don’t be surprised.
This is just part of my job.”

“Incredible!” exclaimed the man. “I can’t believe it!

Does your boss know what a prize he has in you?
An animal that can talk!”

“No, no,” pleaded the dog. “Please don’t! If that man
finds out I can talk, he’ll make me answer the phone
as well!”

“Thought for Today: What the world really needs is more love and less paperwork. ”

-Pearl Bailey

Tips and Techniques

Why does an S.Q.L. database mean so much to you? When you work on the Internet any time you add interactivity to a website it can’t be done with plain ol’ HTML. It needs something more. That something more is scripting of one kind or another. Two of the most widely used are cgi and S.Q.L.

If you are hosting with a company that uses the c-panel interface, adding PHP scripts with S.Q.L. is such an easy thing to do. As a matter of fact it is done in three easy steps. If you hosting company also supports Fantastico, PHP scripts like the word press blog, a shopping cart, help desk and many other scripts can be added with two, count them two only clicks of the mouse.

Happy designing!

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.