By Steve Ries
This e-book is choked with genuine note examples. each one significant certification subject is roofed in a separate bankruptcy, which is helping to make realizing of ideas more uncomplicated. on the finish of every bankruptcy, you'll find quite a few perform inquiries to advance and attempt your studying. you'll get a think for the particular SQL basics I examination via fixing perform papers modeled on it. This ebook is for a person who wishes the basic abilities to go the Oracle Database SQL basics I examination and use these talents in way of life as an SQL developer or database administrator.
Read or Download OCA Oracle database 11g : SQL fundamentals I : a real world certification guide PDF
Best oracle books
This e-book lias been written for the subsequent audiences:■ Management-You could have bought Oracle9i for purposes except Java improvement in the database. despite the fact that, a good way to comprehend extra approximately Oracle9i Java positive aspects, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration standpoint.
There are few books out that care for Oracle textual content and XSQL. making use of the methodologies, practices, and so forth. i discovered no use to look for one more reference.
Oracle functionality Survival consultant a scientific method of Database Optimization the short, whole, start-to-finish consultant to optimizing Oracle functionality Oracle functionality Survival consultant deals a established, systematic, start-to-finish technique for optimizing Oracle functionality as successfully as attainable.
This self-study examination instruction consultant for the Oracle Database 10g Database Administrator OCP certification examination comprises every little thing you want to try out your self and cross the examination. All examination issues are coated and insider secrets and techniques, entire factors of all Oracle Database 10g Database Administrator OCP matters, attempt methods and assistance, a variety of hugely real looking pattern questions, and workouts designed to bolster figuring out of Oracle Database 10g Database Administrator OCP ideas and get ready you for examination luck at the first test are supplied.
- Oracle GoldenGate 11g Implementer's guide
- Oracle Database 11g - New Features for Administrators
- Oracle User Productivity Kit 3.5
- Java Oracle Database Development
- Java Oracle Database Development
Extra info for OCA Oracle database 11g : SQL fundamentals I : a real world certification guide
Following are some commonly-used SQL tools: SQL in the real world While your choice of SQL tool is an important one, in the industry it is one that is sometimes dictated by the toolset standards of your employer. It's important that you don't completely dedicate yourself to one tool. If you become an expert at one and then transfer to a different employer whose standards don't allow for the use of your tool, you may find yourself with an initial learning curve. SQL*Plus SQL*Plus is the de facto standard of SQL tools to connect to an Oracle database.
With this statement, we can retrieve data from an Oracle database and, by the end of the chapter, will begin to do transformations of the data as well. Beginning with this chapter, we also make note of the Certification objectives covered. This is a guide for us to match our subject matter with the objectives of the certification exam. In this chapter, we shall: • Understand the purpose of SELECT statements • Explore the syntax and usage of SELECT statements • Use SELECT for single-column data retrieval • Use SELECT for multi-column data retrieval • Use SELECT to retrieve all the columns in a table • Display table structure using DESCRIBE • Examine aliases and their uses • Utilize SQL with arithmetic operators to execute mathematical computations • Understand the concept of NULL values • Retrieve unique values using DISTINCT • Display concatenated values SQL SELECT Statements The purpose and syntax of SQL In the beginning of the previous chapter, we discussed the importance of data in our everyday lives and gave examples of the kinds of data stored in databases.
Each one can use any variation of different login names, servers, or database names. SQL in the real world In the real world, DBAs and developers run SQL Developer from their desktops and use it to connect to remote databases. Thus, their working environments can run locally, but the databases they connect to can be anywhere in the world! [ 28 ] Chapter 1 Before we can use SQL, we need to connect to a database. To do that, we need to create a database connection. Any connection to an Oracle database consists of three pieces of information: 1.