aprendeSQL
1.0.0
SQL examples using Oracle as a database manager. Although for some exercises the manager must be taken into account, they can also be implemented in other database managers. The software necessary to work can be downloaded from the official Oracle website, such as: Oracle Express Edition (the lighter database manager, sufficient to practice) and Oracle Sqldeveloper (work environment in case you do not want to use the terminal).
It starts from simple selects and progress is being made in complexity when adding the use of functions, sub -consults, Joins. Then it continues with some DML and DDL exercises.
They contain documentation belonging to Oracle. To obtain the latest versions or others, they can be obtained from the official Oracle website as it facilitates all the documentation of your products. In addition to the software to try it.
Includes three scripts that generate the objects of the Oracle HR scheme. And a script with the instructions for the creation of a user with whom to work.
Examples of files to stop and start the services that are responsible for the database managing system to be operational. The name of the service may be different depending on the database name or the managing system version. If the database is not used, the machine resources are wasted. For example, 1 or 2GB of RAM can be consumed. That is why you can have the RDBMS detained if it is not used.
It is a series of slides that give an introduction to language and summarize it.
