Chapter 6
Understanding the Language of Databases: SQL
In This Chapter
Learning the basics of SQL
Using the data dictionary
Programming with PL/SQL
Communicating with most relational databases is done with Structured Query Language, or just SQL for short. SQL can be used against many types of relational databases, not just Oracle. However, most databases have their own little differences with SQL. As a budding Oracle database administrator (DBA), you should have a good grasp on the SQL language.
SQL can be very simple to learn. In fact, some people say that it’s one of the easiest programming languages. You will see in this chapter that to begin functioning as an Oracle DBA, the basic commands aren’t difficult. With that said, keep in mind that this chapter is meant only as a high-level introduction to the fundamentals of SQL. The SQL language is very large and powerful. And although most of your DBA tasks won’t require you to know the more advanced SQL features, you should continue your learning beyond what this chapter offers.
The second part of this chapter focuses on the data dictionary, which is the key component to understanding how your database is organized and how it runs. ...
Get Oracle® 12c For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
