Murach's Oracle SQL and PL/SQL (3rd Edition): Training and Reference
If you’re developing applications that access Oracle databases, you can save time and effort by having the database do more work for you. That’s where this book comes in.

This book teaches you how to write SQL statements to efficiently retrieve and update the data in an Oracle database. It teaches you how to design and create a database because that provides insight into performance and security issues. It teaches you how to use Oracle’s procedural language (PL/SQL) to take advantage of powerful features like transactions, stored procedures, functions, and triggers. And it teaches you how to host an Oracle database in the cloud and use SQL Developer to run SQL statements against that database.

The result? You’ll learn how to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer or analyst.

1145975140
Murach's Oracle SQL and PL/SQL (3rd Edition): Training and Reference
If you’re developing applications that access Oracle databases, you can save time and effort by having the database do more work for you. That’s where this book comes in.

This book teaches you how to write SQL statements to efficiently retrieve and update the data in an Oracle database. It teaches you how to design and create a database because that provides insight into performance and security issues. It teaches you how to use Oracle’s procedural language (PL/SQL) to take advantage of powerful features like transactions, stored procedures, functions, and triggers. And it teaches you how to host an Oracle database in the cloud and use SQL Developer to run SQL statements against that database.

The result? You’ll learn how to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer or analyst.

59.5 In Stock
Murach's Oracle SQL and PL/SQL (3rd Edition): Training and Reference

Murach's Oracle SQL and PL/SQL (3rd Edition): Training and Reference

by Joel Murach
Murach's Oracle SQL and PL/SQL (3rd Edition): Training and Reference

Murach's Oracle SQL and PL/SQL (3rd Edition): Training and Reference

by Joel Murach

Overview

If you’re developing applications that access Oracle databases, you can save time and effort by having the database do more work for you. That’s where this book comes in.

This book teaches you how to write SQL statements to efficiently retrieve and update the data in an Oracle database. It teaches you how to design and create a database because that provides insight into performance and security issues. It teaches you how to use Oracle’s procedural language (PL/SQL) to take advantage of powerful features like transactions, stored procedures, functions, and triggers. And it teaches you how to host an Oracle database in the cloud and use SQL Developer to run SQL statements against that database.

The result? You’ll learn how to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer or analyst.

Product Details

ISBN-13: 9781943873197
Publisher: Mike Murach and Associates, Inc.
Publication date: 09/09/2024
Edition description: 3rd ed.
Pages: 576
Product dimensions: 7.90(w) x 9.90(h) x 1.30(d)

Table of Contents

(hfour)Section 1 An introduction to SQL (/hfour)

Chapter 1 An introduction to relational databases and SQL

Chapter 2 How to use SQL Developer and other tools

(hfour)Section 2 The essential SQL skills (/hfour)

Chapter 3 How to retrieve data from a single table

Chapter 4 How to retrieve data from two or more tables

Chapter 5 How to code summary queries

Chapter 6 How to code subqueries

Chapter 7 How to insert, update, and delete data

Chapter 8 How to work with data types and functions

(hfour)Section 3 Database design and implementation(/hfour)

Chapter 9 How to design a database

Chapter 10 How to create tables, indexes, and sequences

Chapter 11 How to create views

Chapter 12 How to manage database security

Chapter 13 How to host a database in the cloud

(hfour)Section 4 The essential PL/SQL skills (/hfour)

Chapter 14 How to write PL/SQL code

Chapter 15 How to manage transactions and locking

Chapter 16 How to create stored procedures and functions

Chapter 17 How to create triggers

(hfour)Appendices(/hfour)

Appendix A How to set up Windows for this book

Appendix B How to set up macOS for this book

From the B&N Reads Blog
Page 1 of

Customer Reviews