Steven Feuerstein – författare
598 kr
Skickas inom 5-8 vardagar
251 kr
Läs direkt efter köp
In this compact book, Steven Feuerstein, widely recognized as one of the world''s leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11gR2, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other.This book offers practical answers to some of the hardest questions faced by PL/SQL developers, including:
What is the best way to write the SQL logic in my application code?How should I write my packages so they can be leveraged by my entire team of developers?How can I make sure that all my team''s programs handle and record errors consistently?Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance.This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications."This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals."--Dwayne King, President, KRIDAN Consulting421 kr
Läs direkt efter köp
PL/SQL, Oracle''s programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server.Knowing where to start with Oracle''s procedural language is not always obvious to a newcomer, especially considering the language''s feature set and the sheer size of the official documentation (not to mention Oracle''s ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials.Topics include:
PL/SQL--what is it, and why use it? Why use PL/SQL instead of Java?Syntax and examples of all core language constructsCreating, using, and reusing stored procedures, functions, and packagesBuilding web-based applications using PL/SQL features available "out of the box" (such as PL/SQL Server Pages)Securing PL/SQL programs against attackBenefits of third-party developer tools and integrated development environmentsConnecting PL/SQL to email, Java, and the InternetMeticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i.Learning Oracle PL/SQL was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O''Reilly books (such as the bestselling Oracle PL/SQL Programming) very popular among Oracle developers worldwide. Learning Oracle PL/SQL is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein.229 kr
Skickas inom 5-8 vardagar
148 kr
Läs direkt efter köp
In this book, Steven Feuerstein, widely recognized as one of the world''s experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues'' ability) to maintain that code over time.Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein''s recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code:
How should I format my code?What naming conventions, if any, should I use?How can I write my packages so they can be more easily maintained?What is the most efficient way to query information from the database?How can I get all the developers on my team to handle errors the same way?The book contains 120 best practices, divided by topic area. It''s full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O''Reilly web site.Oracle PL/SQL Best Practices is intended as a companion to O''Reilly''s larger Oracle PL/SQL books. It''s a compact, readable reference that you''ll turn to again and again--a book that no serious developer can afford to be without.376 kr
Läs direkt efter köp
The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without.
In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use.
MySQL''s new procedural language has a straightforward syntax, making iteasy to write simple programs. But it''s not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise.
In MySQL Stored Procedure Programming, they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections:
MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handlingBuilding MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggersMySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET)Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practicesA companion web site contains many thousands of lines of code, that youcan put to use immediately.
Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.
376 kr
Läs direkt efter köp
PL/SQL, Oracle''s powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.
Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:
A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and runningExtensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle''s new Transparent Data Encryption, TDE); Row-Level Security(RLS), Fine-Grained Auditing (FGA); and random value generationMethods for DBAs to improve query and database performance with cursors and table functionsCoverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular executionUsing Oracle''s built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world''s foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.
DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you''ll find the detailed coverage in this book to be an invaluable resource.
465 kr
Läs direkt efter köp
However excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer''s Workbook is a different kind of animal! It''s designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you''ve learned about PL/SQL--and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you''ll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts.The Oracle PL/SQL Developer''s Workbook is a companion to Steven Feuerstein''s bestselling Oracle PL/SQL Programming and his other PL/SQL books from O''Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer--both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds).You''ll find chapters on:
Basic language elements--variables, naming, loops, conditional and sequential control, exception handling, and records.Data structures--index-by tables, nested tables, variables arrays (VARRAYs), and object technology.Database interaction--cursors, DML and transaction management, cursor variables, and native dynamic SQLProgram construction--procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL.Built-in functionality--the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages.Miscellaneous topics--using Java with PL/SQL, external programs, PL/SQL web development, tuning PL/SQL, and PL/SQL for DBAs.546 kr
Läs direkt efter köp
For the past ten years, O''Reilly''s Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle''s powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.
The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.
Co-authored by the world''s foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
74 kr
Läs direkt efter köp
While it''s good to have a book with all the answers--like your trusty copy of Oracle PL/SQL Programming-- how often do you need all the answers? More likely, you just need a reminder, a quick answer to a problem you''re up against. For these times, nothing''s handier than the new edition of the Oracle PL/SQL Language Pocket Reference by PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes. Newly updated for Oracle10g, this little book is always at the ready for the quick problem solving you need.The 3rd edition of this popular mini-reference boils down the most vital information from Oracle PL/SQL Programming into a handy guide to PL/SQL basics. The book includes fundamental language elements, such as block structure, identifiers, variables, datatypes, ad declarations; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL.And there''s more. This concise guide also covers Oracle objects, collections, external procedures, Java integration, and new Oracle 10g elements like regular expressions, compile-time warnings, more implicit conversion, FORALL support for non-consecutive indexes, and more. The amount of valuable information packed into this slim volume--intelligently arranged for quick accessibility--make this an indispensable reference for new and seasoned Oracle database developers alike.O''Reilly''s Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you''ve reached a sticking point in your work and need to get to a solution quickly, the 3rd edition of Oracle PL/SQL Language Pocket Reference is the book you''ll want to have.
236 kr
Läs direkt efter köp
In this compact book, Steven Feuerstein, widely recognized as one of the world''s leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11gR2, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other.This book offers practical answers to some of the hardest questions faced by PL/SQL developers, including:
What is the best way to write the SQL logic in my application code?How should I write my packages so they can be leveraged by my entire team of developers?How can I make sure that all my team''s programs handle and record errors consistently?Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance.This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications."This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals."--Dwayne King, President, KRIDAN Consulting546 kr
Läs direkt efter köp
For the past ten years, O''Reilly''s Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle''s powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.
The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.
Co-authored by the world''s foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
664 kr
Läs direkt efter köp
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.
Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing codeUnderstand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directivesTake advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilitiesOptimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profilerBuild modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers664 kr
Läs direkt efter köp
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.
Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing codeUnderstand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directivesTake advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilitiesOptimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profilerBuild modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers141 kr
Läs direkt efter köp
In this book, Steven Feuerstein, widely recognized as one of the world''s experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues'' ability) to maintain that code over time.Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein''s recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code:
How should I format my code?What naming conventions, if any, should I use?How can I write my packages so they can be more easily maintained?What is the most efficient way to query information from the database?How can I get all the developers on my team to handle errors the same way?The book contains 120 best practices, divided by topic area. It''s full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O''Reilly web site.Oracle PL/SQL Best Practices is intended as a companion to O''Reilly''s larger Oracle PL/SQL books. It''s a compact, readable reference that you''ll turn to again and again--a book that no serious developer can afford to be without.354 kr
Läs direkt efter köp
PL/SQL, Oracle''s powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.
Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:
A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and runningExtensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle''s new Transparent Data Encryption, TDE); Row-Level Security(RLS), Fine-Grained Auditing (FGA); and random value generationMethods for DBAs to improve query and database performance with cursors and table functionsCoverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular executionUsing Oracle''s built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world''s foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.
DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you''ll find the detailed coverage in this book to be an invaluable resource.
354 kr
Läs direkt efter köp
The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without.
In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use.
MySQL''s new procedural language has a straightforward syntax, making iteasy to write simple programs. But it''s not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise.
In MySQL Stored Procedure Programming, they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections:
MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handlingBuilding MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggersMySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET)Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practicesA companion web site contains many thousands of lines of code, that youcan put to use immediately.
Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.
155 kr
Läs direkt efter köp
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.
Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of:
Fundamental language elements, such as block structure, datatypes, and declarationsStatements for program control, cursor management, and exception handlingRecords, procedures, functions, triggers, and packagesExecution of PL/SQL functions in SQLCompilation options, object-oriented features, collections, and Java integrationThis handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming.
155 kr
Läs direkt efter köp
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.
Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of:
Fundamental language elements, such as block structure, datatypes, and declarationsStatements for program control, cursor management, and exception handlingRecords, procedures, functions, triggers, and packagesExecution of PL/SQL functions in SQLCompilation options, object-oriented features, collections, and Java integrationThis handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming.
413 kr
Skickas inom 5-8 vardagar