Digital Owl's Prose

SQL and Back-end Developer Diaries.
Skip to content
  • About
  • Accomplishments
  • Contact Me
  • WHERE Blog_Post IN (‘Digital Owl’s Prose Best Of’)
  • Portfolio – Projects

Accomplishments

M102: MongoDB for DBA’s Course Completion

m102mongodb-for-dbas-completion-cert

SQL_certificate

vertabelo_completion

cert_sql_data_manip

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • Email
  • More
  • Pinterest
  • Skype
  • Reddit
  • WhatsApp

Like this:

Like Loading...

Subscribe to Digital Owl's Prose

Enter your email address to subscribe to Digital Owl's Prose and receive notifications (No Spam!!) of new blog posts by email when they are published.

Email List

Want to be a part of my weekly email list? Great! Sign-up here!

Get a weekly rundown of the content I publish, what I am reading, things I'm working on, and up and coming blog posts related to SQL/PHP.

Recent Posts

  • How to use the LEAD() Window Function and discover gaps in Dates August 4, 2021
  • Two SQL Queries to find rows present in one table but not another. July 28, 2021
  • How to re-order a comma-separated list in Oracle SQL July 21, 2021
  • RECURSIVE CTE Fun with SUBSTRING() in MySQL July 14, 2021
  • How to use the NVL and NVL2 functions in Oracle SQL July 7, 2021

Donate

Consider making a small donation on my behalf as I continue to provide useful and valuable content.

Social

  • View j2112o’s profile on Twitter
  • View j2112o’s profile on Instagram
  • View joshua-otwell-twentyonetwelve’s profile on LinkedIn
  • View J2112O’s profile on GitHub

Search by Topic

Instagram

The SQL Analytic functions are one of the more powerful features of the language. In this week's post, I'm solidifying learning about the LEAD() window function by writing about it in context with some data I monitor for exercise. Check the link in my bio and subscribe to my weekly email about SQL/PHP related content 🙏👏🤘👍 #database #databasedeveloper #sqldeveloper #blogging #technicalwriting #data #technicalblogs #programming #code #rdbms #backenddeveloper #oracledatabase #oraclesql #sql
I use the MySQL SUBSTRING_INDEX() function quite often when parsing file names that are named in a specific way. Here are the 3 parameters for SUBSTRING_INDEX(). Check the link in my profile and subscribe for more posts and other SQL/PHP related content. 👍🤘👏🙏 #sql #mysql #database #databasedeveloper #sqldeveloper #blogging #technicalwriting #data #technicalblogs #programming #code #rdbms #backenddeveloper
The optinal SQL AS keyword allows you to give your column names a more meaningful output/name. #sql #database #databasedeveloper #sqldeveloper #blogging #technicalwriting #data #technicalblogs #programming #code #rdbms #backenddeveloper #mysql
Working on an in-depth blog post today about SQL Joins. Should be publishing this one in a couple of weeks. Subscribe to my weekly email (link in bio) for SQL/PHP content like this and more. 🤘🙏👍👏 #sql #database #databasedeveloper #sqldeveloper #blogging #technicalwriting #data #technicalblogs #programming #code #rdbms #backenddeveloper #webdevelopment #programming #writing

Suggestions

    Provide Suggestions

    * Required

    Thank you for being a dedicated reader. Please let me know what topics you would like to see more content on here on Digital Owl's Prose.

    • Digital Owl’s Prose Privacy-Policy
    • Simple Pipe Tally Privacy Policy
    • Portfolio – Projects

    Blog at WordPress.com.

     

    Loading Comments...
     

      loading Cancel
      Post was not sent - check your email addresses!
      Email check failed, please try again
      Sorry, your blog cannot share posts by email.
      %d bloggers like this:

        On this website we use first or third-party tools that store small files (<i>cookie</i>) on your device. Cookies are normally used to allow the site to run properly (<i>technical cookies</i>), to generate navigation usage reports (<i>statistics cookies</i>) and to suitable advertise our services/products (<i>profiling cookies</i>). We can directly use technical cookies, but <u>you have the right to choose whether or not to enable statistical and profiling cookies</u>. <b>Enabling these cookies, you help us to offer you a better experience</b>.