Skip to main content

DBA - Oracle Fundamental lec-2 Basic concept of Database

Hi, today we'll clear our concept about database, what is it and how it works.

 Database:
- A computerized system which is capable to store or manipulate data.

 - A system which provides to manage and convert the data into the information, normalized the data into sequence.

 - Keeps the data consistent and secure from the unauthorized access of the data, provides privileges for administrator and user. 

 there are so many applications and frameworks being used globally.

 Ex: 
1- Oracle apps
2- Mysql database
3- Ms access 
4- SAP
5- People Soft
and so on....

 But Oracle is the one of most powerful and strong databases.........WHY?

 Languages Support
many procedural and object oriented/ based languages support the Oracle Database in its performance and designing.
- PL/SQL
- SQL
- JAVA

 Instance
It is a system which contains the memory as well as processes of manipulation.
Memory
It is a part of the system which holds the data or information.
Process
Process is the part of an instance which performs the actions on the query and retrieve the response to the user or admin with the help of several languages.
e.g  "SQL"(Structured Query Language)

 SQL Fundamentals
SQL (Structured Query Language) provides statements to the admin for the variety of the task. in the oracle databases.
Ex:
Creating, Inserting, Updating, Deleting, Altering, Replacing, Dropping etc.

 SQL categories in several languages and statements.
e.g 
DML (Data Manipulation Language)
DDL (Data Definition Languages)
TCS (Transaction Control Statement)
SCS (Session Control Statement)
SCS (System Control Statement)
ESS (Embedded SQL Statement)

 Note: (In the next lecture we will learn about how to install oracle 11g on windows)

Comments

Post a Comment

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...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more