What you should know

- [Instructor] What should you know before taking this course? There are a few highly desirable prerequisites before taking this course, although this is a basic Oracle Database 19c SQL course. It's helpful to know what a relational database is, although we'll go over some relational database concepts in this course. If you've used SQL, also pronounced S-Q-L, both pronunciations are interchangeable, many of the concepts and commands introduced in this course will seem very familiar. You'll need a basic understanding of what makes up a transaction, such as when a change to the database needs to be made permanent or rolled back. 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, Unix, or Windows, so you can try out some of the SQL*Plus and SQLcl command line examples. For your learning environment, you'll need to have these prerequisites in place. You'll need access to an Enterprise edition of Oracle Database 19c, whether you install it yourself in 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. Your OS can be Windows, Linux, Solaris, or any operating system that is supported by Oracle Database 19c. Oracle Database runs on all major OS platforms. 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. 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 SQL*Plus and SQLcl examples. Let's start learning the basics of Oracle Database 19c.