Michael McLaughlin

Faculty


Phone Number   208-496-3772
Email Address   mclaughlinm@byui.edu
Address   330N STC

Education

  • D.CS., 1999, Colorado Technical University
  • M. B. A., 1996, Keller Graduate School of Management
  • B. A. in Political Science, 1980, San Jose State University

Teaching Experience

  • BYU-Idaho (2004 - present)
  • Regis University (2001 - 2003)
  • Colorado Technical University (1999 - 2001)

Industry Experience

  • Consulting, Development and Support, Oracle Corporation
  • System and Process Engineering, APL Corporation
  • Finance, Operations, Project and Systems Management, First Interstate Bank

Patents

  • Asynchronous Transaction Object Management System (ATOMS), US Patent #7,206,805
  • Monitoring Latency of a Network to Manage Distributed Transaction Terminations, US Patent 7,290,056

Publications - Books

  • Oracle Database 12c PL/SQL Programming Advanced Techniques, 2014, McGraw-Hill Osborne Media
  • Oracle Database 12c PL/SQL Programming, 2014, McGraw-Hill Osborne Media
  • MySQL Workbench: Data Modeling & Development, 2013, McGraw-Hill Osborne Media
  • Oracle Database 11g & MySQL 5.6 Developer's Handbook (Oracle Press), 2011, McGraw-Hill Osborne Media
  • Oracle Database 11g PL/SQL Programming Workbook (Oracle Press), 2010, McGraw-Hill Osborne Media
  • Oracle Database 11g PL/SQL Programming (Oracle Press), 2008, McGraw-Hill Osborne Media
  • Oracle Database AJAX & PHP Web Application Development (Oracle Press), 2008, McGraw-Hill Osborne Media
  • Oracle Database 10g Express Edition PHP Web Programming (Oracle Press), 2006, McGraw-Hill Osborne Media
  • Expert Oracle PL/SQL (Oracle Press), 2005, McGraw-Hill Osborne Media
  • Oracle Database 10g PL/SQL Programming (Oracle Press), 2004, McGraw-Hill Osborne Media

Publications - Articles

  • How to Update Nested Object and Table Columns, Part 1, April 27, 2017 
  • How to Update Nested Object and Table Columns, Part 2, May 30, 2017 
  • Tips & Techniques - PL/SQL Object Table Function, January 18, 2017 
  • Using Python and cx_Oracle, Part 3, Toad World, December 30, 2016 
  • Using Python and cx_Oracle, Part 2, Toad World, December 26, 2016 
  • Using Python and cx_Oracle, Part 1, Toad World, October 31, 2016 
  • How to Compare Stored Objects, Toad World, October 3, 2016
  • How to Write a Check Sum for Stored Programs, Toad World, August 31, 2016
  • How to Deploy Web Apps with Lookups, Toad World, August 3, 2016
  • Database Design Patterns: The Lookup Table, Toad World, July 1, 2016
  • How to Create Dynamic PL/SQL Web Pages, May 19, 2016 
  • How to use DBMS_CRYPTO for Web Apps, May 3, 2016 
  • External Tables with Preprocessing, April 1, 2016 
  • Configure Oracle's XDB Server for Web Applications, February 29, 2016 
  • Writing Internal Java Libraries and PL/SQL Wrappers, February 4, 2016 
  • Striping Tables with DBMS_APPLICATION_INFO, December 23, 2015 
  • Creating a PL/SQL Authentication Function, November 30, 2015 
  • Using DBMS_JAVA to Read External Files, November 2, 2015 
  • Using DBMS_LOB to Load Large Objects, September 28, 2015 
  • Using DBMS_COMPARISON to Synchronize Data, August 24, 2015 
  • Effectively Using the UTL_FILE Package, August 3, 2015 
  • Managing SQL Test Cases, June 29, 2015 
  • Logging Trigger Results, June 1 2015 
  • Opportunities of the Information Age: Maximizing database/data warehouse performance with Dell Oracle Database Acelleration, May 20, 2015 
  • Critical and Non-critical Triggers, May 4, 2015 
  • DML Trigger Basics, April 2, 2015 
  • Overloading Functions & Procedures, February 26, 2015 
  • Oracle Type Collections, February 6, 2015 
  • Object Types and Column Sustainability, December 20, 2014 
  • Database Design Patterns: The Lookup Table 
  • Object types and Subtypes, December 19, 2014 
  • Object Types & Bodies Basics, September 24, 2014 
  • Pipelined Table Functions, September 5, 2014 
  • Identity Columns, July 18, 2014 
  • External Tables, July 1, 2014 
  • Collections and Nested Tables, June 5, 2014 
  • Database Authentication for PHP Applications, Part 1, 2007 
  • Database Authentication ofr PHP Applications, Part 2, Oracle Technical Network, 2007

Conference Presentations

  • Tricks and Techniques with Oracle User Defined Types, UTOUG Training Days 2018, Salt Lake City, Utah
  • External Tables - Ground Zero to Expert, UTOUG Training Days 2018, Salt Lake City, Utah
  • Automate Database Deployment with Python, UTOUG Training Days 2018, Salt Lake City, Utah
  • Soup to Nuts: Writing DML Triggers, UTOUG Training Days 2018, Salt Lake City, Utah
  • A Step-by-step Tour of Native Dynamic SQL (NDS), East Coast User Conference, November 2017, Raleigh, North Carolina
  • Python & Oracle, UTOUG Training Days 2017 Salt Lake City, Utah
  • Step-by-step Oracle Native Dynamic SQL (NDS), UTOUG Training Days 2017, Salt Lake City, Utah
  • Development Panel, UTOUG Training Days 2017, Salt Lake City, Utah
  • Keynote, 6th International Conference on Information Systems and Technologies, 2016, Barcelona, Spain
  • Writing Java I/O Inside Oracle Database 12c, UTOUG Fall Symposium 2014, Salt Lake City, Utah
  • Writing PL/SQL Programs in Oracle 12c, UTOUG Training Days 2014, Salt Lake City, Utah
  • Oracle Database 12c SQL & PL/SQL New Features, UTOUG Fall Symposium 2013, Salt Lake City, Utah
  • Writing Database Triggers, UTOUG Training Days 2013, Salt Lake City, Utah
  • Implementing PHP/MySQL Striped Views, UTOUG Training Days 2013, Salt Lake City 2013, Salt Lake City Utah
  • A Framework for Managing Imports through External Tables, Oracle OpenWorld 2012, San Francisco, California
  • Portable SQL between Oracle and MySQL, UTOUG Fall Symposium 2012
  • Portable SQL between Oracle and MySQL, Collaborate 12, Las Vegas, Nevada
  • A Framework for Managing Imports through External Tables, UTOUG Training Days 2012, Salt Lake City, Utah
  • Using Collections, PL/SQL, and Java, UTOUG Training Days 2012, Salt Lake City, Utah
  • Migrating PL/SQL to MySQL Stored Procedures, UTOUG Training Days 2012, Salt Lake City, Utah
  • Integrating MySQL Subroutines for Integrity, O'Reilly MySQL Conference & Expo 2011, San Jose, California
  • PL/SQL Web Programming Case Study, UTOUG Training Days 2011, Salt Lake City, Utah
  • How Coupling Effects PL/SQL Functions and Procedures, UTOUG Training Days 2011, Salt Lake City, Utah
  • Virtual Private Databases, UTOUG Training Days 2010, Salt Lake City, Utah
  • Using an Apprenticeship Model in the Classroom, BYU-Idaho Faculty Conference on Learning and Teaching, September 2010
  • PL/SQL Functions and Procedures in Depth, UTOUG Training Days 2009, Salt Lake City, Utah
  • Implementing Java inside the Databases, UTOUG Training Days 2009, Salt Lake City, Utah
  • Oracle Database 11g New Features, UTOUG Training Days 2008, Salt Lake City, Utah
  • Oracle LOBs: An In-Depth View, UTOUG Training Days 2008, Salt Lake City, Utah
  • Using OCI8 to Build OPAL Web Applications, UTOUG Training Days 2007, Salt Lake City, Utah
  • Developing Oracle 10g PL/SQL Object Layers over Table Data, UTOUG Training Days 2005, Salt Lake City, Utah
  • Using Oracle 10g Object Types Instead of Record and Collection Types, UTOUG Training Days 2005, Salt Lake City, Utah