Data Small set of information becomes data, this set of information helps make decision. Data is always some useful information. Database Place where you store the data. Database represents some aspect of the real world called "miniworld". A database is designed, built and populated with data for a specific purpose. It has intended group of users and some preconceived applications in which these users are interested. In other words, a database has some source from which data is derived, some degree of interaction with events in the real world and an audience that is actively interested in the contents of the database. Database can also be defined as collection of one or more tables. Ex: Mobile, human brain etc DBMS (Database Management System ) Is a program that stores retrieves and modifies data in the database on request. Study of different techniques of design, development and maintenance of the database Types of DBMS These types are based upon their m
Mithun Ashok's Experience, Summary, Trainings and Knowledge Sharing on Oracle Database, Oracle Applications, Fusion Middleware, SQL, PL/SQL and Database Testing
Comments
Now SQL online reference is not worrking ....what is the reason?
Hi, Chandrasehar Here, Now SQL online reference is not worrking ....what is the reason?
Please check the link again, it works fine.
Regards,
Mithun
PL/SQL Procedure:
1. Doesn't need to return values but can return value.
2.Stored as a pseudo-code in database i.e. compiled form.
3.Can affect the state of database using commit etc.
4.Cannnot be invoked from SQL statements e.g. SELECT.
5.Procedures are mainly used to process the tasks.
Triggers:
Triggers provide a way of executing PL/SQL code on the occurrence of specific database events.
Oracle enables triggers to be invoked by many events other than table insert, update and delete operations.
Mithun
No, it is not possible to download the slides.
Mithun
Whatever applications either it is MS word / Notepad / C, C++, Java, Perl, .Net / whatever it is... they need to have some database to function right? These don't come under any type of DBMS coz they don't belong to any of the structure (Tree, N/W, Table, Object) right? But still y dont we call them as a DBMS? (even when they don't belong to any type of DBMS). Can u explain in detail?
You need to understand the definition first, Database is a place where data is stored in an organized format.
DBMS is a program or a software which will give you access to any database.
Word, Excel are File based programs which stores data in files and do not require any language to manipulate the data.
C/C++/.Net etc are purely programing languages used to create programs/softwares/Applications etc. Infact some of the DBMS softwares are built using C/C++. These languages do not require DBMS rather they can only be executed using a compiler.
Hope this is clear.
Mithun
Pls explain the definition of identifying relationship and Derived attributes with an example? In given slides example is bit difficult to understand for me. So pls give an simple example……..
Any relationship between a Strong entity and a Week entity is classified as Identifying relationship.
Derived attributes are logical attributes of an entity which can be derived by some means.
Regards,
Mithun
Thanks a lot for such wonderful comments.
Mithun
Mithun
I am also sending out a mail to your yahoo id of the screen shot what i am seeing....
There was some problem with the presentations and I have fixed it now.
Pls check.
Mithun
How its working sir
'm ur student pleas tell me sir
You should login as user SCOTT and use the default password tiger. This will work if you have installed enterprise edition of 10g or 11g.
Regards,
Mithun
Acer is working fine and it has not given me any problem for last 1 year.
If you are planning to install database on your laptop then I would suggest you go for a laptop with DUAL Core CPU and minimum 2GB or 4GB RAM.
Regards,
Mithun
mgr=NULL will not work, you should use mgr is NULL. In oracle NULL <> NULL.
Use the following statement,
select * from emp where mgr is null;
Regards,
Mithun
please go bit slow in the class..
thank you.....
pinji here...
sir,i have a doubt,not related to SQL.Actualy,i have been done engineering from chemical branch 2011 batch,so wlil i get opportunity in software field if i will learn this software testing coach nicely.
thnking you.
You will if you work hard.
Regards,
Mithun
your teaching is awesome
Thank you,
Mithun
may i know the difference between data model and schema?
please go bit slow in the class..
couldnot understand tuesday(6.3.2012) class.because i am basically b.com stundent
am a new student in Q-spiders morning batch...
m following u very well ur teaching is very good
u hv mistaken me as Rajnikant as i sit in d last once wen i came late
i was able to download the oracle 10 g client, got the SQL tool too...couldn't log in though!. it wasn't authenticating the "scott "and "tiger "as the user name and password.I'm not sure if that's the enterprise edition.
How do I download the PPTs on your blog?
I dont see an option like that here.
Kindly help.
Thanks,
Swetha
sir first of all i want to thank to u for---that u teaches Sql very well.Being a ECE student I am able to understand all 3 to 4 classes u have taken.
My question to is that............u told server is that machine on which server program is installed(e.g in the context of DB u told DBMS server programs) but in genral there are a lot of softares avialble on each PC which can modify or access date(for example....word can modify dat,media softwares can be used to editing video data.) so is that machine also severs.
or is there any restrictions on softwares to be called a server programs......which programs only called server programs?
thanks
regards
rahul kumar(evening 40'clock batch)