Links to all the Presentations on SQL BASICS.
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...
Comments
I really like the way you teaching and way you intract with us.
Mithun
You learn SQL for SQL Testing.
Regards,
Mithun
a good looking teacher arrived in our midst 1 day
the sleeping class suddenly came alive
his teaching was remarkable
your teaching has impressed every body's heart
your teaching is like burning flame is scattering fiery sparks
thank you mithun ashok
In SQL * Plus, the default user name
and password are "scott" and tiger" right? What's the default "Host String"? I and my friend had tried to use SQL * Plus in one of the systems at Qspiders today but we couldn't as we didn't know the host string. And neither did the guest faculty ! :)
Regards,
Brijesh
You dont need to use a Host string, let me know the error that you see. If it still does not work then please show me the system today.
Regards,
Mithun
can you post any articals related to correlated queries that contains theoritical explanation........its confusing between subqueries and correlated queries.......please help me out...
I registered myself in oracle online tools. And I work on it., it's very easy and simple.. Thank you sir., for your information........
i have successfully installed d oracle 10g but wen i m starting d progarm in sql plus blank window is coming n dat login popup is also coming but after entering all pas n username it dissappears.
shulu
Sure will try to write an article on subqueries and co-related subqueries.
Regards,
Mithun
If this is Windows 7, then right click on SQL*Plus and choose "Run as Administrator".
Now try to login and your SQL window will not close.
Regards,
Mithun
please tel how to create an online database account once again in morn batch..
Sir, please excuse me, I'm damn sure I will not be able to completely do the subqueries assignment given by u today, because I should complete my module coding scheduled before my deadline,else you know the consequences @ work :-) , I will make sure I will do my assignment definitely very soon ...
We n my friends will miss your awesome teaching for sure after sunday...
Sir, please excuse me, I'm damn sure I will not be able to completely do the subqueries assignment given by u today, because I should complete my module coding scheduled before my deadline,else you know the consequences @ work :-) , I will make sure I will do my assignment definitely very soon ...
Me n my friends will miss your awesome teaching for sure after sunday...
I am thankful to say u I learnt so many new things from you.
The way u teach is so impressive and make me to explore SQL in depth.
Really we are missing Your superb teaching sir!!!
Rather than people insisting go and check your site and press "like" button if you concentrate on teaching in classroom itself would be more helpful for student.
SQL made easy by MA. Slow please. Assignments and ur stories are good :). Total SQL dictionary=M.A.
Thanks
The TALL Guy :D
Thanks
Thnks again for the assignments and the Knowledge sharing :)
Sincerely
The TALL Guy :)
I was extremely nervous when you called out my name today in class :). I am still not ready for presentations :D. I dunt want to spam ur comments section so let me ask a valid question and die like an anonymous legend :)
I have windows 7 OS and have installed mysql. Please let me know the command to clear screen. I tried everywhere and couldn't find a solution for this.
Cheers and sincerely signing off
The TALL Guy :)
mysql> help
This will display most of mysql commands.
To clear the screen,
--> clear (\c) Clear command.
mysql> clear or \c
Truncate: DDL statement. Truncate will delete all the rows and release the space back to DB. Does not require commit/rollback.
Delete: DML statement. Can delete all the rows or row by row. Requires commit/rollback.
i hav attended your class this year january..and i was searching for an testing job with sql data base...but nw am in to sonata software as DBA for SQL data baee.is t a good carrer path?please advise..thy asked me abt sql and gav me designation as system aanaalyssst...and the role is for sql data base.
Please help
i am having trouble in creating view.
as i write this below statement.It say insufficient privileges!
SQL>Create View MyFirstView as Select ename,empno from emp;
u said Synonyms provide 'Data independence & location transparency'. How's that sir???
how to find the numbr of working days only (leaving sat and sun)from hiredate of an employee from a particular date
Thanking You
Abhinish Kumar Singh
Student of JSpiders...
how we make use of sql in data analysis......
There is a link "Introduction to RDBMS" on the top of this page. In this link spelling of "Introduction" is wrong. Please correct it.
Could you please post articles about Subqueries,Co -related, Joins. I am confused and not able to understand. If you have docs on these topics.Could you please mail me to this mail id shreesh.kr@gmail.com
Could you plz tell me how to download SQL reference book from the site... Actually I am not able to find the reference book only... plz help me......
Thank you
how to delete duplicate records? without deleting the original ex: id:1,2,3,4 ename:nethra,nethra,nethra,nethra
(assume emp table has 2 columns id & ename) i want to delete all duplicated enames and i should have only original with out hard coding how to delete??? plz reply
Can please give a detailed explanation regarding MangoDB, Redis, MySQL, nodejs and angularjs.
or share me a web link or ppt which clear explains each topic.
Looking forward for your reply.
Warm regards,
vivek
i like the way u teach and make us easy to understand the sql ur lively human beings and always smiley face in u sir :) :)