Learn the Basics in No Time, the first volume of the SQL and PL/SQL in Practice series, is for Oracle database programmers. If you have no prior or limited skill of SQL and PL/SQL, and you want to learn to use the two individually or together, then this book is perfect for you. SQL (Structured Query Language) is the standard database language. PL/SQL (Procedural Language/SQL) is the procedural language extension of SQL. PL/SQL is integrated within the Oracle database. When you install an Oracle database, PL/SQL is included in the installation. A PL/SQL program can have both SQL statements and...
Learn the Basics in No Time, the first volume of the SQL and PL/SQL in Practice series, is for Oracle database programmers. If you have no prior or li...
Windowing for Analytics, the 2nd volume of the SQL and PL/SQL in Practice series, is for those who want to learn how to use the Oracle analytic functions. The analytic functions make it easier for us to write analytic queries. This book is about the Oracle analytic functions that have windowing capabilities. You will learn analytic window, its clauses and options, by way of examples.
Windowing for Analytics, the 2nd volume of the SQL and PL/SQL in Practice series, is for those who want to learn how to use the Oracle analytic functi...
Ranking and Such for Analytics, the 3rd volume of the SQL and PL/SQL in Practice series, is for those who need to learn how to use the Oracle ranking and ranking related analytic functions. The analytic functions make it easier for us to write analytic queries.
Ranking and Such for Analytics, the 3rd volume of the SQL and PL/SQL in Practice series, is for those who need to learn how to use the Oracle ranking ...
Using Oracle Data Modeler: Creating Data Model from Scratch to Generating the Database is for those who want to learn how to create data models using the Oracle Data Modeler. The book is a tutorial for beginners. You will learn step-by-step and by-examples how to create a new data model and to generate the database from the model. The data model you will learn in this book is ER (Entity Relationship) data model. - An ER data model is made up of entities and their relationships. - An entity is something about the business that the application/system needs to keep its data (data about the...
Using Oracle Data Modeler: Creating Data Model from Scratch to Generating the Database is for those who want to learn how to create data models using ...
Seemingly plain, subquery has options that beginners often overlook their opportunities to solve the requirements for queries and data maintenance. Knowing where and which way to apply, you will enjoy having subquery in your armory. This book, by way of examples, shows you the variety of ways you can apply subqueries.
Seemingly plain, subquery has options that beginners often overlook their opportunities to solve the requirements for queries and data maintenance. Kn...
This book shows you how to use SQL within R using the sqldf package. You will learn the many facets of SQL and their use as the argument of the sqldf function. In addition to the default SQLite database, you will also learn how to use Oracle database to execute SQL statements specifically supported by Oracle SQL.
This book shows you how to use SQL within R using the sqldf package. You will learn the many facets of SQL and their use as the argument of the sqldf ...
