Join Bob Bryla for an in-depth discussion in this video Prerequisites, part of Oracle Database 19c: PL/SQL.
- [Instructor] What should you know, before taking this course? There are a few highly desirable prerequisites. It's helpful to know what a relational database is. Although we'll go over some relational database concepts in this course. You'll have to know the basics of Oracle SQL, such as taking the Oracle database 19c basic and advanced SQL course. You'll need a basic understanding of what makes up a transaction such as when a change to the database needs to be rolled back. Experience with another modern procedural language such as C plus, plus, or Java is extremely useful. You'll also want to know how client server environments work and how a cloud architecture extends that environment transparently. Finally, you'll need familiarity with the OS command prompt either for Linux or Windows. So you can try out some of the SQL plus and SQLcl command-line examples when running stored or anonymous procedures. For your learning environment, you'll need to have these items in place. You'll need access to an enterprise edition of Oracle database 19c, whether you install it yourself on a Linux VM, or whether your local DBA creates one for you. The sample schemas need to be installed, and at a minimum, the HR schema. The most important of all is a GUI environment so you can run SQL developer. For windows, you'll automatically have that. And if your Oracle database runs on Linux, your PC or workstation will need an X Windows server installed. And SQL developer is key to taking all of the Oracle PL SQL lessons and using SQL developers rich development and debugging environment for code development. Finally, you'll need access to an OS command-line either on your workstation or on the database server itself, so you can run the SQLcl examples.