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 Pro...
Tuesday, 15 November 2016
Monday, 14 November 2016
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 programm...
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.
...
Wednesday, 10 February 2016
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...
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....
Tuesday, 2 February 2016
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 key...
Saturday, 30 January 2016
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....
Monday, 25 January 2016
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...
Wednesday, 20 January 2016
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...
Tuesday, 12 January 2016
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...
