Webucator's Blog

|

How to choose between a procedure and a function in PL/SQL?

TL;DR

Only use a procedure when a function won’t do the job.


Oracle has been around so long and so many questions have been asked and answered in so many different ways that it can be difficult to find a definitive answer, especially to a best-practices type question like this one.

There are dozens of pages and blog posts explaining the basic differences between PL/SQL functions and procedures:

  1. Functions return a value. Procedures don’t.
  2. Functions are callable (with some restrictions) from within standard SQL statements. Procedures aren’t.

Continue Reading »

|

How to Learn Microsoft Word: 12 Free and Paid Word Training Resources

Microsoft Word Training options include a live instructor, videos, books, and more. Source: yanalya – freepik

As an account manager at a Microsoft Certified training company, I’ve seen how Microsoft Word is an essential business tool. I’ve helped coordinate Word training for legal professionals, technical writers, executive assistants, policy analysts, and many others.

From talking with hundreds of clients, I’ve discovered that learning Microsoft Word is an ongoing process. Even experienced users can learn new tricks and save time with powerful tools like advanced styles and templates.

When it comes to Microsoft Office software like Word, Excel, PowerPoint, many of us are self-taught. While that might work to a degree, consider how much time can be saved when you learn the productivity tools in Microsoft Word. Think about how your documents would look far more professional by learning the Microsoft Word advanced formatting tools.

In addition to learning new tools and features of Microsoft Word, learning Microsoft Word keyboard shortcuts can also be a fantastic way to claim back time in your work day.

After talking with hundreds of Word users and expert Word trainers, I compiled a list of the best resources that have been shared over the years.

Continue Reading »

|

Top Role-Based IT Certifications

The average IT professional has 3 certifications and most IT professionals plan to gain more.

With a fast-changing technology landscape, relevant certifications ensure you are ready to adopt new technologies and integrate new strategies.

Many blogs have reported on the top paying certifications, which is helpful if you are just starting your IT career, or are considering a career change.

Getting more into the specifics, we can also explore certifications based on role. For example, which certifications are best if you are focused on big data? Which are relevant for demonstrating your cloud expertise?

Here are the top certifications for each IT skill set.

Continue Reading »

|

Role-based Microsoft 365 Courses

Webucator is offering official Microsoft role-based 365 courses that prepare students for the following exams:

  1. Managing Modern Desktops (MD-101)
  2. Planning and Configuring a Messaging Platform (MS-200)
  3. Deploying Microsoft 365 Teamwork (MS-300)
  4. Deploying SharePoint Server Hybrid (MS-301)
  5. Microsoft 365 Security Administration (MS-500)
  6. Microsoft 365 Fundamentals (MS-900)

You can learn more about the individual courses on our Microsoft 365 page.

|

Webucator Awards 2019-2020 Computer Science Scholarship

Webucator has been offering a scholarship for Computer Science students who show potential for leadership in the field of Computer Science since 2015. We receive numerous applications every year and it is always hard to choose just one winner. But we have to. The winner for the 2019-2020 academic year is Abou Diomande.

Abou finds the field of Computer Science rewarding because he gets “to solve problems that are going to help people and better our world” and because it is a field in which he “will never be bored”. After college Abou hopes to work as a software application developer. In a letter of reference, one of Abou’s professors said “Along with persistence, Abou has demonstrated curiosity in learning more about computer science and related fields, and seems to enjoy the challenge of building software applications. He also shows respect for others in his interactions with faculty and other students. These positive character traits are good indicators that he can achieve success in his continued studies and make a significant contribution in his future professional work.”

Congratulations Abou! You are the 2019-2020 recipient of Webucator’s Computer Science Scholarship! We are happy to award you $1,000 to be used to help pay for your education.

|

New Microsoft Official DevOps Courses

Webucator is offering new Microsoft official courses for preparing for the Microsoft Azure DevOps Solutions certification exam. These seven 1-day courses prepare students for specific DevOps skills.

  1. AZ-400T01 – Implementing DevOps Development Processes
  2. AZ-400T02 – Implementing Continuous Integration
  3. AZ-400T03 – Implementing Continuous Delivery
  4. AZ-400T04 – Implementing Dependency Management
  5. AZ-400T05 – Implementing Application Infrastructure
  6. AZ-400T06 – Implementing Continuous Feedback
  7. AZ-400T07 – Designing a DevOps Strategy
|

Does your Website Meet Accessibility Standards?

In the United States, twenty percent of adults have a disability, according to the Centers for Disease Control and Prevention. Disabilities that may impede a person’s ability to use a website include:

  • Deafness and loss of auditory capacity
  • Limited visual acuity and blindness
  • Cognitive medical conditions
  • Learning disabilities
  • Speech disabilities
  • Movement-based limitations
  • Photosensitivity
  • Other types of disabilities which impede content consumption.

The World Wide Web consortium (W3C) defines accessibility as the practice of insuring that people with disabilities can perceive, understand, navigate, and interact with websites and tools, and that they can contribute equally without barriers.

In spite of the emphasis given to accessibility issues in every web standard, actual implementation of accessibility best practices is still sub-par in many websites and web applications. In this blog post, I’ll discuss some of these best practices, explore the current state of accessibility tools, and give you a few pointers on things that you can do today to improve the accessibility of your website or applications.

Need more help? Click to learn Web Accessibility best practices from a live instructor. 

Continue Reading »

|

Microsoft 365 Security Administrator training courses

Webucator is offering four new Microsoft official Microsoft 365 Security Administrator training courses MZ-500T01-MZ-500T04:

  1. MS-500T01 – Managing Microsoft 365 Identity and Access
  2. MS-500T02 – Implementing Microsoft 365 Threat Protection
  3. MS-500T03 – Microsoft 365 Identity Management
  4. MS-500T04 – Administering Microsoft 365 Built-in Compliance

These courses help students prepare for Microsoft 365 Certified: Security Administrator Associate exam (MS-500).

|

CSS Maintenance Best Practices

If you’ve ever worked on a large website as part of a team, or even if you’ve ever worked on a small website with a long history, you know that one of the first things that can get out of control and cause maintenance nightmares is the site’s CSS. After a while of people making one-time changes and additions, it often seems like every additional change breaks something else.

For this reason, various people have come up with strategies and best practices for keeping CSS under control. In this article, I’ll discuss a few of these best practices and then show how using a CSS framework such as Bootstrap 4 can make doing the right thing almost effortless.

Continue Reading »

|

How to Start Using Power BI

Have you been hearing that Power BI is the best and easiest way to analyze and visualize your company’s data?

power bi classes

Are you interested in learning how Power BI can benefit your organization?

Keep reading to find out how to start using Power BI.

Continue Reading »