Author: Michael McLaughlin Publisher: ISBN: Category : Languages : en Pages : 464
Book Description
Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11 g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories.
Author: Michael Mclaughlin Publisher: ISBN: Category : Database management Languages : en Pages : 508
Book Description
Presenting programming strategies and best practices for seamlessly operating between Oracle and MySQL platforms; this Oracle Press guide will show you how to migrate databases; port SQL dialects; work with Oracle MySQL databases; and configure effective queries. --
Author: Michael McLaughlin Publisher: McGraw-Hill Prof Med/Tech ISBN: 0071768858 Category : Computers Languages : en Pages : 610
Book Description
Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories
Author: Michael McLaughlin Publisher: McGraw Hill Professional ISBN: 0071768866 Category : Computers Languages : en Pages : 609
Book Description
Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories
Author: Michael McLaughlin Publisher: McGraw Hill Professional ISBN: 0071791892 Category : Computers Languages : en Pages : 481
Book Description
The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances
Author: Dan Hotka Publisher: McGraw Hill Professional ISBN: 0071484744 Category : Computers Languages : en Pages : 256
Book Description
Enhance productivity and simplify database development tasks using Oracle SQL Developer and the detailed instructions in this Oracle Press guide. Written by experienced Oracle instructor Dan Hotka, Oracle SQL Developer Handbook shows you, step-by-step, how to put every feature of this new and exciting deployment tool to work for you. Inside, you'll learn to set up Oracle SQL Developer, establish database connections, and manage SQL, SQL*Plus, and PL/SQL scripts. Detailed code examples and screenshots illustrate each point along the way.
Author: Bob Bryla Publisher: McGraw Hill Professional ISBN: 0071595791 Category : Computers Languages : en Pages : 698
Book Description
The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more
Author: Sheeri K. Cabral Publisher: John Wiley & Sons ISBN: 1118080580 Category : Computers Languages : en Pages : 890
Book Description
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
Author: Steve O'Hearn Publisher: McGraw-Hill Education ISBN: 9780071775786 Category : Computers Languages : en Pages : 816
Book Description
The only Oracle Press exam guide for Oracle OCP MySQL certification OCP MySQL 5.6 Database Administrator Exam Guide covers all of the exam objectives on the OCP level exam for MySQL DBAs in detail. You can become MySQL certified by passing OCP Exam 1Z0-883. This book prepares you for this highly technical exam and focuses on practitioner-level skills, covering a broad set of topics, including security, backup, replication, and optimization. Ideal as both an exam guide and on-the-job reference, each chapter of this Oracle Press book includes examples, practice questions, lab questions, and a chapter summary. An Exam Readiness Checklist appears at the front of the book—you’re ready for the exam when all objectives on the list are checked off. Two-minute drills at the end of the chapter reinforce knowledge. Inside the Exam sections in each chapter highlight key exam topics covered. 150+ exam questions match the format, topics, and difficulty of the real exam. Covers the single exam required to achieve OCP certification for Oracle MySQL—Exam 1Z0-883 Electronic content includes two interactive practice exams and a PDF copy of the book The electronic exams also feature an open-book mode with hints, references to the book, and detailed answers and explanations
Author: Michael McLaughlin
Author: Michael Mclaughlin
Author: Michael McLaughlin
Author: Michael McLaughlin
Author: Michael McLaughlin
Author: Dan Hotka
Author: Bob Bryla
Author: Steven Feuerstein
Author: Sheeri K. Cabral
Author: Steve O'Hearn