You need to connect to a database to start with. As a side project for self-improving is admirable, but - as you described yourself - you'll hit the wall on every step. If you want to work with Oracle Database as a developer, I highly recommend to do it the right way: go through basic Oracle SQL training courses, read about it, etc. to the instance via a configured client or other methods (jdbc, etc.), make yourself a work schema, create tables, indexes, etc. Then you can connect with TOAD, sqlplus, SQL Developer, Access/Excel, etc. Also, for practice, you'll need an installed and working database instance for doing anything with Oracle RDBMS and SQL (for home purposes Oracle XE is recommended). You have to learn on their specifics on databases, instances, schemas, database objects, etc., at least a bit of everything (an Oracle database is structurally and logically somewhat different from other RDBMSs, like MS-SQL or MySQL). There're a lot of them, Oracle Database is just one (but it is their flagship product as in common language "Oracle" is often means their RDBMS). After that, you can focus on Oracle products. I think, first you have to learn about the basics of client-server architecture, then about the modern relational-based database systems or RDBMSs (both are Oracle independent thing). It isn't necessary at all for Oracle SQL and/or databases. A powerful (and very expensive) one, but it isn't "Oracle". TOAD is just a tool, an utility software, mainly for database administration tasks, not for programming (can be use to that too, but SQL Developer could be a bit better, for example).
0 kommentar(er)
