Heli Helskyaho

Database developers and administrators will use this book to learn how to deploy machine learning models in Oracle Database and in Oracle’s Autonomous Database cloud offering. The book covers the technologies that make up the Oracle Machine Learning (OML) platform, including OML4SQL, OML Notebooks, OML4R, and OML4Py. The book focuses on Oracle Machine Learning as part of the Oracle Autonomous Database collaborative environment. Also covered are advanced topics such as delivery and automation pipelines.Throughout the book you will find practical details and hand-on examples showing you how to implement machine learning and automate deployment of machine learning. Discussion around the examples helps you gain a conceptual understanding of machine learning. Important concepts discussed include the methods involved, the algorithms to choose from, and mechanisms for process and deployment. Seasoned database professionals looking to make the leap into machine learning as a growth path will find much to like in this book as it helps you step up and use your current knowledge of Oracle Database to transition into providing machine learning solutions.What You Will LearnUse the Oracle Machine Learning (OML) Notebooks for data visualization and machine learning model building and evaluationUnderstand Oracle offerings for machine learningDevelop machine learning with Oracle database using the built-in machine learning packagesDevelop and deploy machine learning models using OML4SQL and OML4RLeverage the Oracle Autonomous Database and its collaborative environment for Oracle Machine LearningDevelop and deploy machine learning projects in Oracle Autonomous DatabaseBuild an automated pipeline that can detect and handle changes in data/model performance Who This Book Is ForDatabase developers and administrators who want to learn about machine learning, developers who want to build models and applications using Oracle Database’s built-in machine learning feature set, and administrators tasked with supporting applications on Oracle Database that make use of the Oracle Machine Learning feature set

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Design Databases with Oracle SQL Developer Data ModelerIn this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler—the powerful, free tool that flawlessly supports Oracle and other database environments, including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual, logical, and physical design, data warehousing, reporting, and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.Configure Oracle SQL Developer Data ModelerPerform requirement analysisTranslate requirements into a formal conceptual data model and process modelsTransform the conceptual (logical) model into a relational modelManage physical database designGenerate data definition language (DDL) scripts to create database objectsDesign a data warehouse databaseUse subversion for version control and to enable a multiuser environmentDocument an existing database Use the reporting tools in Oracle SQL Developer Data ModelerCompare designs and the database

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master the Underutilized Advanced Features of SQL and PL/SQLThis hands-on guide from Oracle Press shows how to fully exploit lesser known but extremely useful SQL and PL/SQL features-and how to effectively use both languages together. Written by a team of Oracle ACE Directors, Real-World SQL and PL/SQL: Advice from the Experts features best practices, detailed examples, and insider tips that clearly demonstrate how to write, troubleshoot, and implement code for a wide variety of practical applications. The book thoroughly explains underutilized SQL and PL/SQL functions and lays out essential development strategies. Data modeling, advanced analytics, database security, secure coding, and administration are covered in complete detail.Learn how to:• Apply advanced SQL and PL/SQL tools and techniques• Understand SQL and PL/SQL functionality and determine when to use which language• Develop accurate data models and implement business logic• Run PL/SQL in SQL and integrate complex datasets• Handle PL/SQL instrumenting and profiling• Use Oracle Advanced Analytics and Oracle R Enterprise• Build and execute predictive queries• Secure your data using encryption, hashing, redaction, and masking• Defend against SQL injection and other code-based attacks• Work with Oracle Virtual Private DatabaseCode examples in the book are available for download at www.MHProfessional.com.TAG: For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

This book shows Oracle Application Express (APEX) developers how to take advantage of Oracle Cloud Infrastructure (OCI) features for APEX that might otherwise go missed. You will learn how to use OCI features for data science tasks such as detecting anomalies in your data, training machine learning models, and much more. The book provides an in-depth look at Oracle Cloud features and demonstrates how they can be easily integrated into an APEX application. While the book focuses on developing for APEX, the approaches covered in the book are also applicable to any other modern web developer framework for applications running on the OCI platform.For many organizations, the database is the heart of operations. Those who opt to invest in the Oracle Database can learn from this book how to maximize their return on investment. The book begins with an introduction to OCI and help on setting up your OCI developer environment. From there you’ll begin with security by learningto provide single sign-on via the Oracle Identity Cloud Service. Subsequent chapters take you through cloud-focused features such as Object Storage, Oracle Function, Oracle Machine Learning REST Services, and Oracle Cloud Anomaly Detection. You’ll even learn to troubleshoot email delivery services.What You Will LearnBe aware of Oracle Cloud Infrastructure features for developersIntegrate with cloud native services such as cloud-based object storage and serverless functionsEnhance APEX applications with machine learning featuresImplement Natural Language Processing and Anomaly Detection AlgorithmsTroubleshoot email delivery services when sending emails using the APEX_MAIL packageDesign and implement an APEX environment that is secureWho This Book Is ForAPEX developers who are looking to extend their application’s capabilities using features and resources available through the Oracle Cloud, and cloud solutions architects who support development teams and help design and implement architectures that benefit business operations