Concise Oracle Database For People Who Has No Time
()
About this ebook
Concise Oracle database terms , concepts with examples for busy managers , frustrated developers and everyone else who are constantly befuddled by the oracle database terminologies
Billy Aung Myint
My love affair with all things Linux/Open Source started since Secondary 2 or so when my friend introduced me to Slackware. Since then I have been active in IT groups such as Linux Users Group Singapore , Ngee Ann Poly Linux Users Group , Team Ubuntu Singapore and many more. Other than that I am also my own web/domain/server/network administrator for the website you are looking at :P Aside from "boring" system administration. Also , I am widening my knowledge with Oracle DBA certifications and learning how to read Oracle trace files :)
Related to Concise Oracle Database For People Who Has No Time
Related ebooks
Oracle Database 12c Quickstart Rating: 5 out of 5 stars5/5Oracle SQL In 10 Minutes Rating: 5 out of 5 stars5/5Introduction to Oracle Database Administration Rating: 5 out of 5 stars5/5Starting Database Administration: Oracle DBA Rating: 3 out of 5 stars3/5Oracle Quick Guides: Part 1 - Oracle Basics: Database and Tools Rating: 0 out of 5 stars0 ratingsDBA's Guide to NoSQL Rating: 5 out of 5 stars5/5Oracle Quick Guides: Part 3 - Coding in Oracle: SQL and PL/SQL Rating: 0 out of 5 stars0 ratingsData Structures I Essentials Rating: 0 out of 5 stars0 ratingsOracle 10g Data Warehousing Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5Modern Oracle Enterprise Architecture: Discover Oracle's Hidden Gems for Next Generation Database and Application Migrations Rating: 0 out of 5 stars0 ratingsOracle Quick Guides: Part 2 - Oracle Database Design Rating: 0 out of 5 stars0 ratingsLearn Data Warehousing in 24 Hours Rating: 0 out of 5 stars0 ratingsSQL Tutorial For Beginners Rating: 0 out of 5 stars0 ratingsLearn Hadoop in 24 Hours Rating: 0 out of 5 stars0 ratingsInstant Oracle GoldenGate Rating: 0 out of 5 stars0 ratingsSQL CODING FOR BEGINNERS: Step-by-Step Beginner's Guide to Mastering SQL Programming and Coding (2022 Crash Course for Newbies) Rating: 0 out of 5 stars0 ratingsRelational Database Design and Implementation: Clearly Explained Rating: 0 out of 5 stars0 ratingsSQL Interview Questions: A complete question bank to crack your ANN SQL interview with real-time examples Rating: 0 out of 5 stars0 ratingsPractical Oracle Cloud Infrastructure: Infrastructure as a Service, Autonomous Database, Managed Kubernetes, and Serverless Rating: 0 out of 5 stars0 ratingsLearn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease Rating: 0 out of 5 stars0 ratingsOracle APEX Tips and Tricks Rating: 0 out of 5 stars0 ratingsOracle Information Integration, Migration, and Consolidation Rating: 0 out of 5 stars0 ratingsAccounting Database Design Rating: 5 out of 5 stars5/5Oracle 11g Streams Implementer's Guide Rating: 0 out of 5 stars0 ratings
Databases For You
CompTIA DataSys+ Study Guide: Exam DS0-001 Rating: 0 out of 5 stars0 ratingsSpring in Action, Sixth Edition Rating: 5 out of 5 stars5/5COBOL Basic Training Using VSAM, IMS and DB2 Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Practical Data Analysis Rating: 4 out of 5 stars4/5Business Intelligence Strategy and Big Data Analytics: A General Management Perspective Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5HTML, CSS, Bootstrap, Php, Javascript and MySql: All you need to know to create a dynamic site Rating: 4 out of 5 stars4/5COMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5SQL Clearly Explained Rating: 5 out of 5 stars5/5Building a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Serverless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5Data Mining: Concepts and Techniques Rating: 4 out of 5 stars4/5Oracle DBA Mentor: Succeeding as an Oracle Database Administrator Rating: 0 out of 5 stars0 ratingsAccess 2019 For Dummies Rating: 0 out of 5 stars0 ratingsRelational Database Design and Implementation Rating: 5 out of 5 stars5/5Learn SQL Server Administration in a Month of Lunches Rating: 0 out of 5 stars0 ratingsBlockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 5 out of 5 stars5/5Getting Started with SQL Server 2014 Administration Rating: 0 out of 5 stars0 ratingsData Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5The SQL Workshop: Learn to create, manipulate and secure data and manage relational databases with SQL Rating: 0 out of 5 stars0 ratingsA Concise Guide to Object Orientated Programming Rating: 0 out of 5 stars0 ratingsAccess 2010 All-in-One For Dummies Rating: 4 out of 5 stars4/5Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics Rating: 0 out of 5 stars0 ratingsGo in Action Rating: 5 out of 5 stars5/5Python and SQLite Development Rating: 0 out of 5 stars0 ratingsThe Visual Imperative: Creating a Visual Culture of Data Discovery Rating: 4 out of 5 stars4/5
Reviews for Concise Oracle Database For People Who Has No Time
0 ratings0 reviews
Book preview
Concise Oracle Database For People Who Has No Time - Billy Aung Myint
Chapter 1- Introduction
A database is a collection of data/information. A Database Management System (DBMS) is a collection of programs that have been written to manage a database. A DBMS acts as an interface between a user and a database. A DBMS that works based on the relational model is referred to as a Relational Database Management System (RDBMS).
Oracle is an Object-Relational DBMS and the leading vendor in the world. Almost half of all RDBMS available worldwide are owned by Oracle. The Oracle database is produced and marketed by the Oracle Corporation. It is the largest software company in the database business field.
Every Oracle Database is made up of Logical and Physical Structures. The Logical Structures are the tablespaces, extents, schema objects and segments. The Physical Structures are the Datafiles, Control File and Redo Log Files.
A databases is divided into tablespaces, which are logical storage units. The purpose of tablespaces is to group logically-related structures together. Each tablespace has one of more datafiles.
The Oracle Database can run on the major platforms, including UNIX, Windows, Linux and Mac OS. The database comes in different versions. You should choose the version you need based on your requirements and budget. The Oracle Database editions are hierarchically organized as follows:
Enterprise Edition
This edition provides all the features, including superior security and performance, and it is the most robust Oracle Database Edition.
Standard Edition
It provides users with base functionality. It is suitable for users who do not need the robust features provided by the Enterprise Edition.
Express Edition (XE)
This is a free, lightweight and limited Linux and Windows edition. It is easy and fast to install.
Oracle Lite
This edition runs on mobile devices.
As stated earlier, the architecture is split between Logical Structure and Physical Structure. For grid computing/large-scale distributed computing, the location of data is irrelevant and transparent to the user. This allows for a more modular physical structure that can be modified without affecting the database activity, users or the data. This way of resource sharing allows for flexible data networks whose capacity can be scaled up or down to suit demand, with no degradation of service. It also means that there is no single point whose failure can bring the database down.
Chapter 2- Who is it for?
First and foremost, this book is dedicated to the managers who have no background in database technologies yet have to manage the DBAs. Due to explosion in the data-related technologies such as Big Data, Data Mining etc., managers are finding that they are increasingly getting closer to the DBAs and vice versa. Without fully understanding the database technology, they are bound to make mistakes.
Secondly, this book is also dedicated to the developers who may not be fully trained in the Oracle Database technology but have to develop applications with it. As above, without fully understanding the technology, the application will end up in a disaster.
Finally, this book is dedicated to DBAs who have to communicate or work with everyone else on a daily basis. The DBAs have to explain to them every words that they speak and yet knowing full well that the colleagues may not fully understand everything that has been explained to them.
This is the best book for you that will help you grasp every aspect of Oracle 12c database. The author has written the book in a step-by-step approach while adding explanations to every step. Enjoy reading!
Chapter 3- Introduction to Database Technology in General
A database is stored in a database management system (DBMS). The DBMS is a system software that facilitates the creation and management of databases. It provides programmers and users with a systematic way to create, update, retrieve and manage data.
With a DBMS, end users are able to create, update, read and delete data from a database. The DBMS acts as an interface between the database