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

HTML - CSS lec-5 Structures (Elements and attributes)

Hi, today we'll learn about the elements and attributes used in HTML 5 so lets start from Elements: HTML uses Elements to describe the Structure of pages, lets look closer at the code from the last lecture, there are several different Elements. each Element has opening tag and a closing tag. Tags  tags act like containers. they tell you something about the information between their opening and closing tags. *The opening <html> tag indicates that anything between it and a closing </html> tag is HTML code. The <body> tag indicates that anything between it and the closing </body> tag should be shown inside the main browser window. Words between <h1> and </h1> are a main heading. A paragraph of text appears between these <p> and </p> tags. Words between <h2> and </h2> form a sub-heading. Here is another paragraph between opening <p> and closing </p> tags. Another sub-heading inside <h2...
Post a Comment
Read more