Many of you may have some concern on Basics of DBMS and about the definitions of R-DBMS, H-DBMS and N-DBMS. Some of you might have studied the concepts little different than the one I have defined on my site, but nevertheless definitions and concepts(DBMS) on my site are simple and easy to understand which are explained at a very basic level. Am collating some links which will provide similar and more detailed definitions and insight on DBMS concepts.
DBMS and its history -- http://en.wikipedia.org/wiki/Database_management_system
Types of DBMS -- http://en.wikipedia.org/wiki/Types_of_DBMS
http://sqlserver-guide.blogspot.com/2009/05/data-base-system-models-or-types-of.html
Notes from Penn State University, USA -- http://www.personal.psu.edu/glh10/ist110/topic/topic07/topic07_06.html
Flat File Database -- http://en.wikipedia.org/wiki/Flat_file_database
Hierarchical DBMS -- http://en.wikipedia.org/wiki/Hierarchical_database_model
Network DBMS -- http://en.wikipedia.org/wiki/Network_model_(database)
Relational DBMS -- http://en.wikipedia.org/wiki/Relational_model
Database(Do not get confused with so much information, treat this link as a reference) -- http://en.wikipedia.org/wiki/Database
Hope this clears the confusion in air.
Comments
If you want you can take do both Manual and QTP together only thing is you have to put in lot of effort and concentrate on both the topics.
It is suggested to take these courses one after the other so you get enough time to study.
Regards,
Mithun
Plz guide me as to which is the best book to refer!
With regards,
Tej G.K
Follow the link below,
http://www.mithunashok.com/2011/04/basics-of-rdbms.html
Mithun
Thank you :)
With regards,
Tej G.K
I have small confusion between ROUND and TRUNC operator's.
Can you tel me the answers for the following qn's are right or wrong .
ROUND( 1742.471,-1) -> 1740
ROUND( 1742.471,-2) -> 1700
ROUND( 1742.471,-3) -> 2000
TRUNC( 1742.471,-1) -> 1740
TRUNC( 1742.471,-2) -> 1700
TRUNC( 1742.471,-3) -> 1000
Let me know if any answers wrong and explanat it plz.
Plz tell us that what would be the initial 5 questions that u yould b asking in an interview on SQL .
Execute these number functions and let me know if you have any queries.
Regards,
Mithun
Will write an article on this gimme some time.
Regards,
Mithun
Use scott as username and tiger as password.
Regards,
Mithun
i wrote the query as:
SELECT ename,hiredate,to_char(hiredate,'DAY')as day
FROM emp
ORDER BY day=to_char(hiredate,'MONDAY');
but im nt getting the desired result. wht changes shld i do sir
What is the difference between trigger and constraint? Give more than five difference
Refer to the article below,
Sorting by day of the week
Regards,
Mithun
Triggers are used to execute some procedure in case of database events.
Constraint are the restrictions that you can have on each column.
Regards,
Mithun