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

Numerical Analysis lec-4 Newton Raphson method

Hi, Today we'll learn about  Newton-Raphson Method  " Newton's Method ". this method is for finding successively better approximate solutions to the roots of a function (real valued). so are you ready for this............you will. Newton's Method: The Newton's method is one of the most powerful and well known method used for finding a root of f(X) = 0 there are many ways to derive Newton-Raphson method . the simplest way to derive this formula is by using the first two terms in the Taylor series expansion of the form.  Instead of working with the chord joining points on the graph of y= f(X) as in bisection method and false position method s. Newton's method uses the tangent at one point on the graph of y= f(X) therefor it requires only one instead of two initial guesses. Suppose X is an initial guesses draw the tangent line at X= X0 and procedure it to meet the X - axis at X = X1 Newton's Method which shows in picture above. now from righ...
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