Definition of Perl In Web development

Welcome to the certified internet webmasters CIW Perl fundamentals. My previous posts are mostly on database administration and CISCO networking. In my effort to get you acquainted with virtually everything concerning IT certification, today I am going dive into web development. This post will cover the fundamentals of Perl in four subheadings.

 (1) Definition and meaning of Perl

 (2) Common Perl Applications

(3) Key Perl websites

(4) Perl Pros.

Read More

CCNA CONCEPT AND HARDWARES

In this post, I am going to cover the CCNA concept and objectives that is designed by CISCO for CCNA exam with supportive information. This post will take you through CCNA terms and definition, the benefits and the hardware you will encounter in the course of CCNA training programme.

Read More

How to connect to SQL Plus in oracle database

Here, I am going to show you how to use sql plus to tap into your database n oracle database. Sql plus is one the user interface in oracle database which also include enterprise manager. One advantage of Sql plus is that it corresponds with every version of oracle database.

Read More

How to create tables in oracle database using enterprise manager

The last post was on how to create tables in oracle database using sql plus platform. Today we’ll create a table using another platform which enterprise Manger.

Creating a table using enterprise manager seems to be a lot easier than writing the sql codes. Another advantage of using enterprise manager is that after creating tables you can still get the sql codes if you wish to learn it.

First log in to your database using enterprise manager. Remember that enterprise manager is a web based platform use to manager oracle database administration.

From the home page of the enterprise manager select schema as you can see encircled in red

Read More

Datatypes used in oracle database administration

Datatypes are the structural or the physical attributes of a table. I would say that the kind of table you create is determine by the data you are bringing into the table.  Datatypes helps determine the kind of data entered into a table. For example Column for phone numbers will not have the same kind of dataype with column for names.

Types of Datatypes

In oracle database, there a lot of datatypes used but I am going to filter it to the most commonly used in your day to day tasks as an administrator in creating your schema objects.

Here they are

Read More

How to create a table in oracle database administration using sql plus

Like i said in earlier post oracle database is relational database with markup and extensive language (xml). Data is stored in two dimensional tables consisting of rows and columns. oracle database enables you to store, update and efficiently retrieve it with high degree of performance and reliability.
Every thing is tables. having a database means having a pools of tables containing information that are related. Linked together keys and constraints, like foreign keys and primary keys.

Read More

How to Create a database using oracle database configuration assistant (ODCA)

Ordinarily oracle universal installer (OUI) automatically runs oracle database configuration assistant (ODBCA) during installation unless otherwise stated that only software should be installed.

Note that when you create a new database, the new database typically use the same oracle home directory as the first database but stores database data-files separately from the first one.

Read More

How to Install Oracle 11g Software

During Installation; you are given the option or opportunity to to create a database. If u wish to the OUI (oracle universal installer) automatically starts oracle database configuration assistant (ODCA) to guide you through the process of creating a database.

Before installation process; you must

Read More

ROLES OF AN ORACLE DATABASE ADMINISTRATOR

Oracle database is relational database with markup and extensive language (xml). Data is stored in two dimensional tables consisting of rows and columns. oracle database enables you to store, update and efficiently retrieve it with high degree of performance and reliability. In case you are wondering why I chose to write on oracle database. This is one the many reasons why Database administration is best with oracle database. If you have not read my post, you can take a glance here. I chose it also because its where I specialize.

Read More

Overview of Database Administration

Database Administration is a very interesting yet tedious work to do. It can be very interesting if its something you have passion for and loves doing it everyday of your life aside being a job for you. Hear me, there is a lot of money in there  for grabs as a database administrator but don't rush into it because of the money, but for the love of it else you will get tired and bored with all the jagons. Just like I advice people, "Always go for a job you have passion for and loves doing  everyday of your life. I am not trying to scare you. Don't get me wrong database administration can be very fun and interesting.

Read More