Hello. Thank you for stopping by my site and this page. I have assembled here for you, some of my favorite blog posts. They range from personal favorites to those that my readers visited and enjoyed. I hope you enjoy reading them and please, share them along with others who may value them as well… Joshua Otwell
MySQL
- MySQL Window Function Compilation
- Example uses of MySQL SHOW syntax.
- MySQL Shell get_auto_increment_value() method – Python mode
- CREATE Database, User, and Table – Easy examples with MySQL.
- MySQL IFNULL() function usage in SELECT queries
- MySQL String Data Type Dive: CHAR and VARCHAR – Differences.
- SELECT clause queries – MySQL Beginner Basics Series
- Monitor data in MySQL with Cursors and Stored Procedures
- MySQL Transactions and User-defined session variables.
- Basic Data Analysis with MySQL Shell Python mode
- Handy MySQL Date functions with examples.
- CASE Expression with Derived Table: Alternative combo for multiple row UPDATE
- Aggregate Functions Part 1: COUNT() – With examples in MySQL
- Aggregate Functions part 2: SUM() and AVG() in MySQL with examples.
- Aggregate Functions Part 3: MIN() and MAX() in MySQL with examples.
- INNER JOIN in MySQL with examples.
- What’s missing? Find out using OUTER JOIN’s in MySQL with examples.
- ON vs USING: Nuances between clauses with LEFT JOIN’s – An observation.
PHP
- PHP date() function for common date formats
- PHP trim functions: trim, rtrim, and ltrim
- PHP empty() function use with MySQL NULL
- PHP MySQL BLOB PDF: Display in Browser
- Use MySQL BLOB column with PHP to store .pdf file
- PHP PDO lastInsertId() method with examples in MySQL
- Beginning Perspective on PHP Arrays
- Sorting associative arrays in PHP with array_multisort() – New learning
PostgreSQL
- More of my Favorite PostgreSQL Queries – and Why They Also Matter (More info on this blog post on my Portfolio-Projects Page)
- PostgreSQL Streaming Replication vs Logical Replication (More info on this blog post on my Portfolio-Projects Page)
- Using pg_dump and pg_dumpall to Backup PostgreSQL (More info on this blog post on my Portfolio-Projects Page)
- Top PostgreSQL Security Threats (More info on this blog post on my Portfolio-Projects Page)
- My Favorite PostgreSQL Queries and Why They Matter (More info on this blog post on my Portfolio-Projects Page)
- PostgreSQL Privileges & User Management – What You Should Know (More info on this blog post on my Portfolio-Projects Page)
- UNION and UNION ALL queries in PostgreSQL with examples.
- Exploring subqueries in PostgreSQL – Column names and expressions.
- Shell excitement with the \! psql meta-command
- Utility psql command for saving query output to a file.
- Wholesale inserts with Python, Psycopg2, and PostgreSQL.
- Data prepping with Sed for bulk uploads using the PostgreSQL COPY command.
- Inserting rows using Select query results in PostgreSQL.
- Quick searches using the LIKE operator in PostgreSQL.
- Two handy examples of the psql \copy meta-command.
Feel free to contact me for collaboration if you like these blog posts and are interested in a similar type of work for your site and content creation needs. I am also interested in contributors for my site for similar types of posts as those published here (e.g., SQL, Back-end Web Development, Data Analysis, etc…)
To receive email notifications (Never spam) from this blog (“Digital Owl’s Prose”) for the latest blog posts as they are published, please subscribe (of your own volition) by clicking the ‘Click To Subscribe!’ button in the sidebar on the homepage! (Feel free at any time to review the Digital Owl’s Prose Privacy Policy Page for any questions you may have about: email updates, opt-in, opt-out, contact forms, etc…)