Operators: Part 2 Let’s look at a few more operators. This is the post and pre increment operator, where you see the plus. If you saw a minus, that would be the decrement operator. And what it does is it either increases for the increment or decreases for the decrement the current value of a variable. But whether it’s to the right side of the variable or the left side of the variable doesn’t does make a difference. And here’s what I mean. Whenever we have this operator, it’s going…

Section Overview This next section is going to focus on Java syntax. So all the things that we’re going to use when we build classes and use objects, we’re going to talk about conditionals for branching, our logic. We’re going to talk about loops for iterating through logic. We’ll talk about some other constructs such as enums. And then we’ll look at all the different operators that are available to us. Condtionals – If / Else If / Else All right, we’re going to start by looking at conditionals. In…

Section Overview In this section, we’re going to focus on strings. And you’ve been working with strings, so you know that that’s just text. But strings are very unique in the Java programming language. They’re objects. But we can do things to strings that we normally can only do with primitives. We’re also going to COVID the subject of immutability in this section. String Objects I’m willing to bet that as you code more and more in Java and you take a look at your applications, that the number one…

Overloading Methods Now we know that whenever we instantiate an object that we have not only the methods that were defined in that class available to us, but we also have the methods available that were defined in any of the ancestors, anything that it inherits from, provided that the access modifiers allow us to call those methods. And because of that, Java enforces a few rules. Java wants to make sure that when we try to call a method that it’s able to pick the exact method and only…

Section Overview In the beginning of this course, we mentioned that objectoriented programming languages are very extensible, easily extensible. And so that’s one of the things that we’re going to see in this particular section called Inheritance. So we’re going to see how we can take an existing class and then add stuff and change stuff to create a more specialized version of it. Inheritance: Part 1 When we look at the classes that we build for our applications, we often find that there’s a lot of similar structures, a…

Section Overview We’re now going to turn our focus to the concept of object-oriented programming. Now, of course, we’ve been doing object-oriented programming all along, but we’re going to really focus on the pillars of object oriented programming. In this section, we’re going to focus on Encapsulation, and we’re going to see specifically what is Encapsulation, why do we want to do Encapsulation, and how do we apply it to the Java programming language. Encapsulation and Data Hiding The term encapsulation is often used a little differently depending on who…

Use the ORDER BY clause to sort SQL query results We can sort the results using order by class. For example, this SQL will bring the result as it is from the table. Now, let us sort it by first name. Select first Name last Name salary commission percentage from employees order by first name. This will sort the results in the ascending order of the column. First name ascending order is the default. This is equivalent to specifying the keyword ASC in the end. Okay, the keyword DESC will…

NULL Values It is possible to have no data. At certain places, they are represented by null values. Null means no data tables can have null columns. It depends on the design of our application. Let us look at some examples in HR Schema. If I look at Employees table, I see some columns are nullable represented by yes values here, meaning that they allow null values and some are not nullable, represented by no here, meaning that they do not allow null values. In a glance, we can understand…

Exception for Inner Single Quotes What if there is already a single quote present in the string? It will fail because this single quote will interfere with the actual single quotes encompassing the whole string. This can be avoided by adding one more single quote. As an exception to the inner single quote. I’m going to run this SQL select. Today’s state is Systole from dual. Today’s already has a single quote inside. If I run this, it will fail because this single quote is interfering with the encompassing single…

It has been known for a long time that for specialists of different levels, whether they are beginners trying to start a successful career, or pros with many years of experience, it is useful to have an official certificate confirming their competence. This is a kind of stepping-stone leading you to your cherished career goal, where you will be offered everything you dream about – decent pay, weekend conditions, interesting tasks. But when it comes to project management, how can certification be useful here? Firstly, it is the recognition in…