AllExperts > Experts 
Search      

Data Management & Storage

Volunteer
Answers to thousands of questions
 Home · More Questions · Answer Library  · Encyclopedia ·
More Data Management & Storage Answers
Question Library

Ask a question about Data Management & Storage
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Krishna Prasad
Expertise
Data Warehousing and Data Modelling, Cube Building, Data Migration Strategies and Middleware aspects

Experience
Several large scale data warehousing and data migration projects. Built a data warehouse of 7 Terrabytes for an organization. Was involved in cradle-to-grave (data architecture to implementation and testing) of a large scale data warehouse effort, in a control position.

Education/Credentials
Bachelor of Technology and MBA

 
   

You are here:  Experts > Computing/Technology > Oracle > Data Management & Storage > need for a solution

Topic: Data Management & Storage



Expert: Krishna Prasad
Date: 11/4/2007
Subject: need for a solution

Question
QUESTION: respected sir
my question is that ,how i create a database,what are the steps are thers for create a database..
2)please send me a webside where i will get the number of sql and pl/sql example

ANSWER: To create a database, you first need to select the database program you want to use. Depending on your volume of data and other factors, you may want to use differnet database engines.

 After that, you need to determine your table and field layouts. What do you want to store? How will you query it? What search criteria will you use?

 Define the tables and fields, and create the table. Using a program or an interactive interface that comes with the database itself, you create your data. Then you start using it through query, reports, etc.

 Detailed information on some of these can be found at http://www.geekgirls.com/menu_databases.htm

 SQL can be learned from websites such as http://www.1keydata.com/sql/sql.html

Hope this helps.

---------- FOLLOW-UP ----------

QUESTION: respected sir,
i need some example of pl/sql

Answer
Aniban,

 If you are looking for the absolute basic material, you can find some here http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html
For some more advanced concepts you can try http://www.java2s.com/Tutorial/Oracle/0480__PL-SQL-Programming/Catalog0480__PL-S...

-- Krishna

Add to this Answer    Ask a Question



  Rate this Answer
   Was this answer helpful?
Not at allDefinitely              
   12345  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.