Skip to main content

DBA - Oracle Fundamental-I lec-1 introduction

Hi, before you read this, first of all you have some knowledge about database if you don't, no problem i will tell you,
the Oracle Database System is a software to manipulate data stores data and a well defined computerized System,
Computer is a Relational to database but not actually a Database,
DATA - is a collection of information.
INFORMATION - is well managed data is called information.   
FUNDAMENTAL - is basic concepts or important things, Rules and regulations
there are two important things you have to know about Database 
1 - Consistency
Consistency of database is to make sure that any data that is written in to the database is according to the rules and regulations of database.
2 - Security
Security of database is to secure your data from the UN-Authenticated sources
e.g hackers, outer peoples.

Note: read about the difference b/w ms access and oracle

Comments

Popular posts from this blog

Numerical Analysis lec-3 False Position Method

Hi, today we'll going to learn the second method of numerical analysis the False Position Method out of 40 methods FALSE POSITION METHOD False Position Method is an alternative method and is more efficient then bisection method, it is the oldest method for finding the real root of an equation F( X ) = 0 and is similar to the bisection method. Consider the equation F( X ) = 0 let [ X0 , X1 ] be two different values of X such that  F( X0 ) - F( X1 ) < 0. OR A simple modification of a secant method produces a method which is usually converges. the new method is called regula falsi (False Position) and also Linear interpolation . it needs two initial approximations X0 and X1 so that F( X0 ) F( X1 ) < 0 i.e the two functions must have the opposite signs. The Modified False Position Method In this method the F( X ) value of a stagnant end point is halved if that point has repeated twice or more. the end point that repeats its called a stagnant point, the excepti...

Software Engineering lec-2 About Software Engineering!

Hi, today we'll going to learn about Software requirements, specifications, applications and lots of more let's start with software engineering definition. Software Engineering -Software engineering is an engineering discipline that is concerned with all aspects of   software production form the early stages of system specification through to maintaining   the system after it has gone into use. -The economies of all developed nations are dependent on software. -More and more systems are software controlled software engineering is concerned with   theories, methods and tools for professional software development. -Expenditure on software represents a significant fraction of GNP in all developed countries. - Engineering discipline:  Using appropriate theories and methods to solve problems bearing in mind organizational   and financial constraints. - All aspects of software productions:  Not just technical process of developmen...

Computer Architecture lec-3 Computer System Organization

Hi, today we'll going to learn about  computer system organization & Processors so, are you ready for it.....................you will be. Computer System Organization A digital computer consists of an interconnected system of processors,  memories, and (I/O) input/output devices, This lecture is an introduction to these three  components and to their interconnection, as background for the detailed examination  of specific levels in the five succeeding lectures. Processors, memories, and (I/O)  input/output are key concepts and will be present at every level, so we'll start  our study of computer architecture by looking at all three in turn. Processors The organization of a simple bus-oriented computer is shown in Picture below. The  CPU (Central Processing Unit) is the ‘‘brain’’ of the computer. Its function is to  execute programs stored in the main memory by fetching their instructions, examining  them, and then executing them on...