Hi, I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one? Thanks
All sql's are the same, all depends on what you do with your website if you make a "standard" website use sqlite or mysql if you want to work with something very stable and much more secure, use Oracle
SQl is more suitable for a beginner to learn. When you familiar with SQL, you study about Oracle Good luck
Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.
I think oracle is more secure than my sql. because in oracle packages are there and in my sql no packages.in oracle tablespace are there and in sql no tablespace.
Oracle database is more secure than MySql which allows objects to be stored in tables, in a manner similar to numbers and words, but SQl is more suitable for a beginner to learn.
Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system. The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.
SQL is structured query language but oracle is database .If you learn SQL ,Oracle is easy to begin and deploy applications over it So i recommend SQL first
Oracle is a database (a program), SQL is a programming language used to talk to databases, Oracle SQL is an extension to SQL. In order to learn Oracle SQL you learn standard SQL first, then you learn the Oracle extensions. It's not either/or, it's "do you add the Oracle extensions to your knowledge base".
oracle is the best then others database system i can say that oracle is the power and and ms sql is the simple database . thanks
SQL is for the beginners but oracle is better than sql so i recommend you first practise sql and then oracle
SQL is not a database. It stands for Structured Query Language. SQL is used to query data from a Database. Oracle is a database where you store data. Your Friends may be talking of MySQL database when they said SQL database or may be of MS SQL Server database. MySQL and MS SQL Server - both are databases. You can use SQL to retreive data from them. Note: MySQL is FREE and easy to learn. MS SQL Server is NOT FREE and comparatively hard to learn. Oracle is best database but cost a fortune and learning curve depends on what you want to achieve...programming or Administration. If you are just looking to learn just enough to design/maintain website related databases then MySQL is more than enough.