Menu
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
For faster SQL queries, follow these hints. Know your data:When you know your data, or the structure of where your data is coming from, you will know how to formulate
Use the max() function to determine the value of the maximum number in a list. ages = [56, 34, 22, 35, 56, 89]maximumValue = max(ages) That’s all there is to
Let’s assume that we have a proxy at address proxy.host:8888. We can set up this proxy via the JDK 11 HttpClient as follows: HttpClient client = HttpClient.newBuilder() .proxy(ProxySelector.of(new InetSocketAddress(“proxy.host”, 8888)))
The Formatter class is used to format the output as needed. Here, we are trying to print the current time formatted in more than one format. Please see the output
A short is a 16-bit signed integer. It has a minimum value of -215 (-32,768), and a maximum value of 215 ‘1 (32,767) short example = -32; short myShort =
Learn how to use enum effectively in a switch case block. There are multiple advantages to not making any mistakes since the originals are defined in the enum. public class
Tessaract is a popular OCR software that lets you convert image to text with high accuracy. We can utilize its SDK in .Net and convert image to text very easily.
Just passing the CompTIA Certification Exams can seem like a huge and daunting obstacle. The good news is there are lots of steps you can take to make sure you???re as prepared as possible. As with any exam, preparation is the key to success. Here are some of the top tips for getting ready for the CompTIA certification exams.??? Read it, Read it, Read it All!Even if you???re more of a hands-on learner, it pays to read up on material that???ll be on the exam. Because text books are often prohibitively expensive, it pays to reach out to your local library to see what kind of books they have on the subject. Cruising the thrift shops is another way to find helpful material. Many people pass their books off to one of these shops once they???re done studying for their own exam.??? Write It DownWhether studying on your own, or taking a series of classes, one of the most effective ways to commit something to memory is to write it down. Once you have a good variety of notes, comb through them carefully for the most relevant information and use it to make your own study guide.??? Get Hands-On ExperienceWhile it doesn???t make sense to go out and buy ten of the latest, greatest pieces of hardware so that you can practice your skills, you can cruise yard sales, classified ads, and thrift shops for older pieces of hardware. The older technology isn???t going to be on the exam, most likely, but if you can get an ancient hard drive networked, you???ll probably have a much better chance at figuring out what???s wrong in a newer setup.??? Practice, Practice, PracticeThere are lots of great resources on the internet, including CompTIA practice tests. Take advantage of them! Practice tests can help familiarize you with the style of the test, as well as give you some insight as to what kinds of questions you???ll be answering on the real thing.You also have a good opportunity to better understand networking through your own in-home devices. Look at how your computers link up on your home network. Take apart an old modem and get a better understanding of connections and routing issues, or use these exercises as a refresher before taking the exams. The technology that you use every day can help give you a better practical understanding of networking and security issues and how to deal with them.??? Use Your HeadSome of the questions you???ll encounter on the CompTIA Exams will be multiple choice. Even if you don???t know the right answer, you might be able to use logic and common sense to eliminate some of the incorrect answers. This will give you a better chance of picking the right answer from the remaining options.
The WITH TIES clause can only be used only with TOP and ORDER BY. Both TOP and ORDER BY are required. Now what does the WITH TIES clause actually do?
The StringJoiner class helps in formatting strings when there are multiple values and you want to present them with some delimiter and some pre and post suffixes. The delimiter, pre
The quickest way to create a custom RuntimeException is as follows (simply extend RuntimeException): public class IncorrectFileException extends RuntimeException { public IncorrectFileException(String errorMessage, Throwable err) { super(errorMessage, err); }}
The move method accepts three arguments. The 1st and 2nd being the source and target Path attributes and the 3rd being the replace option. import java.nio.file.*;import static java.nio.file.StandardCopyOption.*;public class FileMove{
The Dictionary class in Python provide an update() function that allows you to merge two dictionaries. For example: employeeScore = { ‘Emp1’:100, ‘Emp2’:98, ‘Emp3’:96}employee2019Score= { ‘Emp1’:101, ‘Emp2’:104} To merge, just
Learn more about how to use three very different SQL statements. ROW_NUMBER?Always generates unique values without any gaps. RANK? Has gaps in its sequence DENSE_RANK? Returns the same rank for
Using the OrderBy operator in conjunction with Take in C#, we can pick a selected number of items based on an order. int n = 3;var firstThreeStates = states.OrderBy(s =
In addition to the string and character escape sequences, Java has a more general Unicode escaping mechanism, as defined in JLS 3.3. Unicode Escapes. A Unicode escape has the following
See how to perform connectionless communication between the producer and the consumer. DatagramSocket – Data producer This class produces data and sends it to the specified IP address and port.
Using the Take operator, we can pick the first few elements of an array with a simple statement like this: int n = 3;var firstThreeStates = states.Take(n);
The process of hiding irrelevant details from a user is called data abstraction. The three levels of Data Abstraction in SQL are: Physical Level Logical Level View Level
Using the transition property on an element, we can do amazing CSS transitions. See below for a example. The div will change color on hover with a transition. HTML: Hover
The JDK 11 HttpClient API is very flexible and intuitive. Here it is a sample of triggering a GET request and printing the response: HttpClient client = HttpClient.newHttpClient();HttpRequest request =
There are abundant resources available in the java.lang package. Learn more about the server/host on which you are working. The Runtime class has numerous functionalities. To learn the number of
Use this extension method in C# to check whether or not an input argument is null, and throw an error if necessary. Extension method: public static void CheckIfParameterIsValid(this T o,
You never know what can happen when you attempt to delete data. Some may argue that it is best to delete data through a client application, some may say it
The audio tag lets you play an audio file on a webpage. Its syntax is very simple. Please note the usage of “autoplay” attribute. It auto plays the music file
Google Guava Preconditions are quite useful for validating arguments of methods. Here it is an example: public void setAge(int age) { Preconditions.checkArgument(assert age = 0, “Age cannot be negative”); …}
See how to use an extension method in C# to update all items in a list. public static IEnumerable ForEach(this IEnumerable collection, Action action){//Loop thru the collectionforeach (T item in
We can check if a given port is free by trying to construct a ServerSocket with the port that needs to be checked: import java.io.*;import java.net.*;public class CheckingIfPortIsFree{ public static
Get a list of the names of all normalization forms in SQL. 1NF 2NF 3NF BCNF Boyce-Codd Normal Form 4NF 5NF ONF: Optimal Normal Form DKNF: Domain-Key Normal Form
A zip file is a compressed file that can hold one or more files. The following code snippet lets us scan the contents of a given zip file. Code snippet:
