Complete IT Professional

Subscribe to Complete IT Professional feed Complete IT Professional
Practical advice for database developers
Updated: 3 hours 36 min ago

Oracle MEDIAN Function with Examples

Fri, 2016-12-23 05:00
In this article, I’ll explain what the Oracle MEDIAN function is, and show you some examples. Purpose of the Oracle MEDIAN Function The MEDIAN function returns the median of the set of provided values. The MEDIAN is the middle value in a set of values. So, for example, you had these five values: 10, 15, […]
Categories: Development

Oracle SINH, COSH, and TANH Functions with Examples

Thu, 2016-12-22 05:00
In this article, I’ll cover what the Oracle SINH, COSH, and TANH functions are, and show you some examples. Purpose of the Oracle SINH, COSH, and TANH Functions These three functions are used to calculate the hyperbolic sine, cosine, or tangent of a number: SINH: Calculate the hyperbolic sine of a number COSH: Calculate the […]
Categories: Development

What Is Professional Networking and Why Should I Do It

Wed, 2016-12-21 05:00
Networking is a common term in the IT industry. It can have two meanings – the process of linking computers and other devices together so they can communicate, and the process of meeting and talking to other people to help your IT career. This article is about speaking to people – professional networking. What Is […]
Categories: Development

A Guide to the Oracle UPDATE Statement

Mon, 2016-12-19 05:00
Have you ever needed to update data that was already in a table in Oracle? Learn how to do this with the Oracle UPDATE Statement. What Is the Oracle UPDATE Statement? The Oracle SQL UPDATE statement allows you to change data that is already in a table in SQL. The INSERT statement lets you add […]
Categories: Development

Oracle SQRT Function with Examples

Fri, 2016-12-16 05:00
In this article, I’ll explain the Oracle SQRT function and show you some examples. Purpose of the Oracle SQRT Function The purpose of the Oracle SQRT function is to find and return the square root of a provided number. The square root of a particular number answers this question: “Which number, when multiplied by itself, […]
Categories: Development

Oracle LNNVL Function with Examples

Thu, 2016-12-15 05:00
In this article, I’ll explain what the Oracle LNNVL function does and show you some examples. Purpose of the Oracle LNNVL Function The purpose of the LNNVL is to perform a “logical not null” on the expression that has been provided. It allows you to evaluate data that contains a NULL value, which is something […]
Categories: Development

Why You Need a Long Term Career Plan and How to Create One

Mon, 2016-12-12 19:57
Why should you have a career plan? Do you even need to know what your job will be in the long term? Learn why and how to create a career plan in this article. The answer is “yes”. You need to know what your career will look like, long term. Or at least have an […]
Categories: Development

A Guide to the Oracle ALTER TABLE SQL Statement

Mon, 2016-12-12 05:00
The Oracle ALTER TABLE statement allows you to make changes to an existing table. Learn how to use it and see some examples in this guide. What Is The Oracle ALTER TABLE Statement? The ALTER TABLE SQL statement lets you change a table that has already been created. Using the CREATE TABLE statement lets you create […]
Categories: Development

Oracle LN Function with Examples

Fri, 2016-12-09 05:00
In this article, I’ll explain what the Oracle LN function is, and show you some examples. Purpose of the Oracle LN Function The purpose of the Oracle LN function is to calculate the natural logarithm of a number. if you’re not sure what the natural logarithm means, you can read more here. I’m not a […]
Categories: Development

Oracle TAN Function with Examples

Thu, 2016-12-08 05:00
In this article, I’ll explain the Oracle TAN function, what it is, and show you some examples. Purpose of the Oracle TAN Function The purpose of the Oracle TAN function is to calculate the tangent of a number. The tangent is ratio of the length of the side opposite the angle to the length of the […]
Categories: Development

Oracle Certification Dumps Can Ruin Your Career

Mon, 2016-12-05 05:00
Are you looking to get certified? Want to get your hands on some Oracle certification dumps for an exam to help you pass? That’s a bad idea. I’ll explain why in this article. What Is a Brain Dump? So what is a brain dump, when you talk about IT certifications? A brain dump is a […]
Categories: Development

Oracle SIN Function with Examples

Fri, 2016-12-02 05:00
In this article, I’ll explain what the Oracle SIN function is and show you some examples. Purpose of the Oracle SIN Function The purpose of the SIN function is to calculate the sine of a number. The sine is the ratio of the length of the side of the triangle opposite the angle to the […]
Categories: Development

Oracle COS Function with Examples

Thu, 2016-12-01 05:00
In this article, we look at the Oracle COS function and see some examples. Purpose of the Oracle COS Function The COS function will return the cosine of a number. If your knowledge of cosine is a bit rusty (like mine), then you might find this definition helpful.   Syntax The syntax of the COS […]
Categories: Development

11 Tips to Improve Focus and Concentration at Work

Mon, 2016-11-28 05:00
Do you often find yourself not focusing at work? Or, you try to focus, but something else comes along and distracts you? I know how this feels. I’ve listed eleven ways to remove distractions and increase focus in this article. I’ve been able to improve my focus by removing some of the distractions I have […]
Categories: Development

A Guide to the Oracle DROP TABLE Statement to Delete Tables in SQL

Mon, 2016-11-28 05:00
How can you delete a table in SQL? Learn how to do this by using the DROP TABLE statement in this article. How Can I Delete a Table in Oracle SQL? To delete a table in Oracle SQL (or any SQL for that matter), you run a statement called DROP TABLE. It’s called DROP because […]
Categories: Development

Oracle VARIANCE Function with Examples

Thu, 2016-11-24 05:00
In this article, I’ll explain what the Oracle VARIANCE function is, and show you some examples. Purpose of the Oracle VARIANCE Function The purpose of the VARIANCE function is to, well, return the variance of a set of numbers. A variance is a mathematical concept, which represents how different the values are in a set […]
Categories: Development

Oracle CORR Function with Examples

Tue, 2016-11-22 05:00
In this article, I’ll explain what the Oracle CORR function does and show you some examples. Purpose of the Oracle CORR Function The Oracle CORR function returns the “coefficient of correlation” of a set of number pairs. What is a coefficient of correlation? Here’s an definition of what it means. This function can be used […]
Categories: Development

12 Great Tips on How To Be More Professional At Work

Mon, 2016-11-21 13:00
Professionalism in the IT world is desirable. Some people have it, some don’t. The ones that do have it, the ones that are professional, are treated with more respect and are usually better at their jobs. Below, I share five tips that you can use to be more professional in your workplace. Dress Code Wherever […]
Categories: Development

Oracle DELETE SQL Statement – The Complete Guide

Mon, 2016-11-21 05:00
The DELETE SQL statement allows you to delete records from a table. I’ll explain more about the Oracle DELETE SQL statement in this article. What Is The Oracle DELETE SQL Statement? The Oracle DELETE SQL statement is a statement you can run to delete records from a table. There are statements to INSERT and UPDATE […]
Categories: Development

Oracle BIN_TO_NUM Function with Examples

Fri, 2016-11-18 05:00
In this article, I explain what the Oracle BIN_TO_NUM function does and show you some examples. Purpose of the Oracle BIN_TO_NUM Function The BIN_TO_NUM function converts a bit vector to a number. A bit vector is a combination of values to make up a binary number. For example, the binary value of 1 is equal […]
Categories: Development

Pages