Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional by Ben

Description: Beginning Oracle SQL for Oracle Database 18c by Ben Brumm IOUG Press FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. Youll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download.A marquee feature of Beginning Oracle SQL for Oracle Database 18c is 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.AuthorBen 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 LearnCreate, update, and delete tables in an Oracle databaseAdd, update, delete data from those database tablesQuery and view data stored in your databaseManipulate and transform data using in-built database functions and featuresCorrectly choose when to use Oracle-specific syntax and featuresWho This Book Is ForThose 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. Back Cover Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. Youll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download. A marquee feature of Beginning Oracle SQL for Oracle Database 18c is 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 Author Biography Ben Brumm is a software developer and business analyst with over 11 years of experience. Based in Melbourne, Australia, he has been working with databases and SQL both during his full-time job, and as the founder of the DatabaseStar dot com site where he teaches Oracle database topics. His passion for software and databases began when he started computer classes in high school in the late 1990s and it has only grown since then. Table of Contents Introduction.- Part I. Setting Up.- 1. What Is A Database?.- 2. Setting Up.- .- Part II. Viewing Data.- 3. Retrieving Data.- 4. Selecting Specific Columns.- 5. Restricting the Results.- 6. Comparing Data.- 7. Applying Multiple Filters.- 8. Working with NULLs.- 9. Removing Duplicate Results.- 10. Applying Filters on Lists and Ranges of Values.- 11. Ordering Your Data.- 12. Applying Table and Column Aliases.- Part III. Adding, Updating, Deleting Data.- 13. Understanding the Data Types.- 14. Creating A Table.- 15. Adding Data to A Table.- 16. Updating and Removing Data.- 17. Updating or Deleting a Table.- Part IV. Joining Tables.- 18. Inner Join.- 19. Outer Join.- 20. Other Join Types.- 21. Joining Many Tables.- Part V. Functions.- 22. Using Functions in SQL.- 23. Writing Conditional Logic.- 24. Understanding Aggregate Functions.- 25. Grouping Your Results.- 26. What Are Indexes?.- Part VI. Command Line.- 27. Using the Command Line.- Part VII. Appendixes.- 28. Appendix. How to Find and Navigate the Oracle SQL Reference. Feature Makes use of Oracle Live SQL, a freely accessible online sandbox for practicing SQL, and Oracle Express Edition, a free version of Oracle Database that is available for download Divides the topic into small chunks that can be read and practiced during small breaks during a busy professionals work day Gives attention to tricky issues like nulls, use of aliases, natural joins, and the various join types and syntaxes that are available Details ISBN148424429X Author Ben Brumm Language English Year 2019 ISBN-10 148424429X ISBN-13 9781484244296 Format Paperback Edition 1st Imprint APress Subtitle From Novice to Professional Place of Publication Berkley Country of Publication United States Pages 431 DEWEY 005.7585 Publication Date 2019-08-06 Short Title Beginning Oracle SQL for Oracle Database 18c DOI 10.1007/978-1-4842-4430-2 UK Release Date 2019-08-06 AU Release Date 2019-08-06 NZ Release Date 2019-08-06 US Release Date 2019-08-06 Illustrations 138 Illustrations, black and white; XXVI, 431 p. 138 illus. Publisher APress Edition Description 1st ed. Alternative 9781484275153 Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:137967587;

Price: 90.48 AUD

Location: Melbourne

End Time: 2024-10-28T03:32:23.000Z

Shipping Cost: 0 AUD