Brumm - Beginning Oracle SQL for Oracle database 18c: from novice to professional
Here you can read online Brumm - Beginning Oracle SQL for Oracle database 18c: from novice to professional full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. City: Berkeley;California, year: 2019, publisher: Apress, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
Beginning Oracle SQL for Oracle database 18c: from novice to professional: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Beginning Oracle SQL for Oracle database 18c: from novice to professional" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
A marquee feature ofBeginning Oracle SQL for Oracle Database 18cis the small chapter size. Content is divided into easily digestible chunks that can be read and practiced in very short intervals of time, making this the ideal book for a busy professional to learn from. Even just a 15-20 minute block of free time can be put to good use.
Author Ben Brumm begins by helping you understand what a database is, and getting you set up with a sandbox in which to practice the SQL that you are learning. From there, easily digestible chapters cover, point-by-point, the different aspects of writing queries to get data out of a database. Youll also learn about creating tables and getting data into the database. Crucial topics such as working with nulls and writing analytic queries are given the attention they deserve, helping you to avoid pitfalls when writing queries for production use.
What Youll Learn
Create, update, and delete tables in an Oracle database
Add, update, delete data from those database tables
Query and view data stored in your database
Manipulate and transform data using in-built database functions and features
Correctly choose when to use Oracle-specific syntax and features
Who This Book Is For
Those new to Oracle who are planning to develop software using Oracle as the back-end data store. The book is also for those who are getting started in software development and realize they need to learn some kind of database language. Those who are learning software development on the side of their normal job, or learning it as a college student, who are ready to learn what a database is and how to use it also will find this book useful.
Brumm: author's other books
Who wrote Beginning Oracle SQL for Oracle database 18c: from novice to professional? Find out the surname, the name of the author of the book and a list of all author's works by series.
Beginning Oracle SQL for Oracle database 18c: from novice to professional — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Beginning Oracle SQL for Oracle database 18c: from novice to professional" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484244296 . For more detailed information, please visit www.apress.com/source-code .
Welcome to Beginning SQL for Oracle Database 18C! Thanks for picking up this book. Its safe to say youre interested in learning about Oracle database, as thats what this book is about. Why Oracle database, and why this book?
Oracle Database is one of the most popular database management systems in the world. The website db-engines.com , which ranks the popularity of databases based on several factors, has Oracle at #1 as of late 2018. Its used in many large organizations, and the main competitor is Microsofts SQL Server. Learning Oracle SQL will put you in a good position when looking for a job with any company using an Oracle database.
Why this book? This book will help you get started with learning SQL on the latest version of Oracles database: 18c. Version 18c was announced in late 2017 by Oracle and released in mid-late 2018 for the developer community. Learning how to use the latest version of Oracle will be very helpful for your career, because when organizations upgrade their version of Oracle to version 18c, youll know how to work with it.
This book is also targeted toward beginners. Youll start by learning what a database is, how to install the tools you need, and all of the commands of SQL (Structured Query Language) to get you up and running with Oracle database. No experience with databases is needed at all. If you have worked with other databases such as SQL Server or MySQL, you might pick up the concepts easier because there are some common areas.
This book is broken up into several different parts, and many different chapters. Heres a summary of what youll learn.
Chapter: What is a Database? This chapter explains what a database is. It explains some of the common terms such as table, row, and what SQL is. It also mentions who the different vendors are, such as Oracle.
Chapter: Setting Up . In this chapter youll learn how to set up your very own Oracle database. Youll learn how to download the required software from the Oracle website, which includes Oracles free version of their database called Oracle Express, and a development tool called Oracle SQL Developer. There are step-by-step instructions along with screenshots.
Chapter: Retrieving Data . This chapter introduces the SELECT statement, which you can use to retrieve data from the database and view it.
Chapter: Selecting Specific Columns . This chapter expands on the previous chapter and shows you how to view individual columns using the SELECT statement.
Chapter: Restricting the Results . Youll learn how to use the WHERE clause to see only some of the records in a table, because there are times you dont want to see every record.
Chapter: Comparing Data . Sometimes you may want to filter on a partial match, and youll learn how to do that in this chapter.
Chapter: Applying Multiple Filters . SQL allows you to filter the records on multiple criteria. In this chapter, youll learn how to do that.
Chapter: Working with Nulls . Databases have a concept called NULL, which represents an unknown value. Youll learn more about what this means and how to handle it in your queries.
Chapter: Removing Duplicate Results . Youll occasionally get duplicate results when writing queries. This chapter will explain how to remove the duplicates and just see the unique results.
Chapter: Applying Filters on Lists and Ranges of Values . This chapter will explain how to filter your results using multiple values more efficiently by using lists of values.
Chapter: Ordering Your Data . If you ever need to show your data in a specific order, youll know how to do that after reading this chapter.
Chapter: Applying Table and Column Aliases . Youll learn what table aliases and column aliases are, and their advantages, in this chapter.
Chapter: Understanding the Data Types . Oracle supports many different types of data, each of which have their own purpose. In this chapter, youll learn about a few of the main data types.
Chapter: Creating a Table . Data is stored in tables in a database, and this chapter will show you how you can create a table.
Chapter: Adding Data to a Table . To view data in a table, it first needs to be added to a table. This chapter explains how to do that in SQL.
Chapter: Updating and Removing Data
Font size:
Interval:
Bookmark:
Similar books «Beginning Oracle SQL for Oracle database 18c: from novice to professional»
Look at similar books to Beginning Oracle SQL for Oracle database 18c: from novice to professional. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Beginning Oracle SQL for Oracle database 18c: from novice to professional and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.