January 2023

How to Create Auto Incremented Identity Column in SQL Server, MySQL, and Oracle? Example

Automatic incremented ID, Sequence, or Identity columns are those columns in any table whose value is automatically incremented by database based upon predefined rule. Almost all databases e.g. Microsoft SQL Server, MySQL, Oracle or Sybase supports auto-incremented identity columns but in different ways like Oracle provides a SEQUENCE object which can be used to generate automatic numbers, Microsoft SQL Server up to 2008 version provides IDENTITY() functions for a similar purpose. Sybase also has IDENTITY function but little different than SQL Server and MySQL uses auto_incremented keyword to make any numeric column auto-incremented.

Difference between close and deallocate cursor in SQL

Cursor in a database is used to retrieve data from the result set, mostly one row at a time. You can use Cursor to update records and perform an operation a row by row. Given its importance on SQL and Stored procedures, Cursor is also very popular in SQL interviews. One of the popular SQL questions on Cursor is close vs deallocate. Since both of them sounds to close the cursor, once the job is done, What is the real difference between close and deallocate of Cursor in SQL? Well, there is some subtle difference e.g. closing a cursor doesn't change its definition. In Sybase particular, you can reopen a closed cursor and when you reopen it, it creates a new cursor based upon the same SELECT query.

10 Examples of Stream Class in Java 8 [ map + filter+ flatmap + collect + findFirst ]

There is no doubt that Stream class is one of the most important class of Java SE 8 API and a solid knowledge of this class is needed to write modern day Java code. There is no excuse to write the Java code we used to write in imperative style like using loops and not using functional programming idioms. In fact, now it's one of the best practice in Java to favor functional programming and immutable data structure over imperative programming. More and more Technical Leads are enforcing developers to learn Java 8 and write better code leveraging improved API. The Java designers has done a fantastic job to convert any collection to Stream by adding stream() method into Collection interface.

Difference between ByteBuffer vs byte array in Java

There are several differences between a byte array and ByteBuffer class in Java, but the most important of them is that bytes from byte array always reside in Java heap space, but bytes in a ByteBuffer may potentially reside outside of the Java heap in case of direct byte buffer and memory mapped files. Buffer is a byte array like abstraction which was introduced in Java NIO release to read and write data from FileChannel. It is extensively used in Java NIO for transferring data from one place to another and its also an essential Java concepts to know for any backend developer, particularly those who wants to create non-blocking server application using NIO in Java.

Can you declare Abstract Class or Method Final in Java? If not, why?

If you are wondering whether you can use both abstract and final modifier together with a class or method in Java then you are not alone. This is one of the frequently asked, theory based Java questions which is sometime tricky to answer, particularly if you don't have complete knowledge of Java fundamentals. The answer of this question is No, you can not declare abstract class or method final in Java because both abstract and final keywords are mutual exclusive. Anything which is abstract cannot be final and vice-versa. It's like a person cannot be living and dead at the same time.

Difference between var, let, and const in JavaScript? Example Tutorial

Hello guys, there are many ways to declare variables in JavaScript like var, let, and const and many JavaScript developer get confused when to use which keyword for declaring a variable in JavaScript. If you also have same doubt and want to understand the difference between var, let, and const in JavaScript then you have come to the right place. This is one of the popular JavaScript interview questions and frequently asked during telephonic and face-to-face round of web developer interview. Knowing the difference will not only make you answer this question better during interview but also to write better JavaScript code in your day-to-day work. Earlier, I have shared the best books and JavaScript courses for beginners and in this article, I will tell you the difference between var, let, and const and when to use them. They are three different ways to declare variables in JavaScript.

The 2023 Android Developer RoadMap

Hello guys, if you want to learn Android in 2023 or want to become an Android developer and looking for an Android Developer RoadMap then you have come to the right place. Earlier, I have shared best Android Courses and Books and in this article, I am going to share with you one of the most comprehensive Android Developer RoadMap you can find online. I love these Roadmap as they provide a comprehensive picture of what exactly you need to learn to become a professional Android developer and while they give more than what you need, its still better to have more than less as you can always learn remaining skills to become a better Android developer.

Top 15 Java NIO, Socket, and Networking Interview Questions Answers for Experienced Developers

Hello guys, if you are preparing for Java developer interview then you may know that Networking and Socket Programming is one of the important areas of Java programming language, especially for those programmers, who are working in client server-based applications. Knowledge of important protocols like TCP and UDP in detail is very important, especially if you are in the business of writing high-frequency trading applications, which communicate via FIX Protocol or native exchange protocol. In this article, we will some of the frequently asked questions on networking and socket programming, mostly based around TCP IP protocol.

The 2023 Data Scientist and Data Engineering RoadMap

Hello guys, if you want to become a Data Scientist or Data Engineer in 2023 and looking for guidance like how to become a Data Scientist and Data Engineer in 2023 then you have come to the right place. In the past, I have shared best Data Science courses, tools, and best websites to learn Data Science and in this article, I am going to share the complete Data Scientist and Data Engineering RoadMap. This roadmap include all the skills, tools, and technologies you need to become a professional Data Scientist in 2023. While this roadmap is very comprehensive and contains tens of skills, tools, libraries, framework and programming language, they are divided into different categories like mandatory, good to know and other choices.

Difference between IsNull and Coalesce in Microsoft SQL Server (with Examples)

Even though both ISNULL and COALESCE is used to provide default values for NULLs there are some key differences between them like ISNULL() is a T-SQL or Microsoft SQL Server-specific function or operator, and datatype and length of the result depends upon a parameter, but COALESCE is a SQL ANSI standard, it can accept more than one parameter and unlike ISNULL, the result doesn't directly depend upon a parameter, it is always the type and length of the value returned. Also, what is the difference between COALESCE and ISNULL is one of the frequently asked Microsoft SQL Server interview questions, and knowing these differences can help in both your day-to-day SQL development works and during job interviews.

The 2023 Golang Developer RoadMap

Hello guys, if you want to become a Golang Developer in 2023 or want to learn Golang in depth then you have come to the right place. Earlier, I have shared best online courses to learn Golang and Golang projects for beginners and in this article, I am going to share the complete Golang Developer RoadMap which you can follow to become a Golang Developer you always wanted to be. This is one of the most comprehensive Golang Developer RoadMap you can find on internet. It not only list all the mandatory tech skills you need to learn for Golang Backend development but also all the options and extra skills which can truly make you a competent Golang Developer in 2023. If you are wondering where to learn those skills then don't worry, I have also shared both free and best online resources to learn those skill in 2023.

What is Generator Function in JavaScript? Example Tutorial

Hello guys, Functions are an essential part of JavaScript programming. Basically, a function is a piece of code that can take inputs and return outputs. Moreover, a function can be executed at any time and any number of times. When a regular function is called, it executes from top to bottom. Its execution ends when the function body ends or a return statement is encountered. But JavaScript provides a special kind of function that works in a different. These functions are called generator functions and they were introduced in ES6. In this article, we will discuss what are generator functions and how to use them with the help of an example. It's also a popular JavaScript interview questions, commonly asked to experienced developers.

What is state in React.js? useState Hook Example Tutorial

Hello guys, I have just started a new series, React for Java developers and I am going to publish React tutorials and examples to teach React.js, one of the most popular frontend libraries to Java developers. Since most full-stack Java development is happening on React and Spring Boot, it makes sense for Java developers to learn React.js. In the past, I have also shared both best React courses and books, as well as The React Developer RoadMap, which provides all the tools, libraries, and resources you need to become a proficient React Developer.

React Project Example - How to create a React application using Redux hooks?

Redux is the most popular state management library. It is often used with React apps that are huge in size and state are shared among multiple components. Redux is a complex library to understand and even more complex to implement. It was even more complex and complicated before the introduction of react-redux hooks. Earlier, the connect method provided by Redux was used to connect React with the Redux store. Using connect method with other methods such as mapstatetoprops was complicated. But with the introduction of react-redux hooks, it is easy to use redux with redux. In this article, we will discuss what are react-redux hooks and how to use them with React.

The 2023 Blockchain Developer RoadMap

Hello guys, if you want to become a Blockchain Developer in 2023 and looking for guidance then you have come to the right place. Earlier, I have shared best Blockchain courses, books, and best websites to learn Blockchain technology and today, I am going to share how you can become a Blockchain Developer in 2023. Blockchain solutions are one of the most talked-about examples of technological innovation in recent times. Decentralization, transparency, and security in blockchain-based systems and applications can offer new routes for digital transformation. Amidst the growing hype around blockchain technologies, the role of a blockchain developer has become crucial for the emerging ecosystem.

Difference between SubStr vs SubString function in JavaScript - Tutorial Example

Hello guys, if you are wondering what is difference between SubStr() and SubString() function in JavaScript then you have come to the right place. JavaScript provides two similar-looking String manipulation functions, substr and substring, though both are used to get a substring from a String, there is a subtle difference between substring and substr method in JavaScript. If you look at their signature, both substr(to, length) and substring(to, from) both take two parameters, but substr takes the length of the substring to be returned, while substring takes end index (excluding) for substring. This main difference will be more clear when we will see a couple of examples of using substr and substring in JavaScript code.

Top 25 Vue.js Interview Questions and Answers for Web Developers

Hello guys, if you are preparing for Vue.js interviews and looking for some frequently asked Vue.js questions from interviews then you have come to the correct place. Earlier, I have shared React.js Interview questions and JavaScript questions and in this article, I am going to share common Vue.js Interview questions for 1 to 2 years experienced web developers. With the success of libraries like React.js, developers around the globe are leaning more towards such flexible technologies. Though full-fledged frameworks like Angular are also popular and widely used, developers want flexibility.

10 Tools Cyber Security Professional and Pen Tester Should Learn in 2023

Hello guys, if you want to become a Pen Tester, Cyber Security Engineer or Ethical Hacker in 2023 and looking for the best tools then you have come to the right place. Earlier, I have shared best Cyber Security courses, free Pen Testing Courses, and Ethical Hacking courses and in this article, I am going to share best tools every Cyber Security Engineer and Pen Tester should learn in 2023 to do their job effectively. Suppose you become a penetration tester and learn the cyber security field. In that case, you need to know many tools that will help you scan the networks and system for vulnerabilities and other tools for exploring them. This article will provide you with the most used tools for finding these vulnerabilities and how to exploit them.

How to use useDispatch and useSelector? React Hooks Example Tutorial

Hello guys, if you are learning about React hooks and wondering how to use useDispatch and useSelector hooks in React application then you have come to the right place. Earlier,, I have shared the best React courses, websites, and books and in this article, I am going to show you how React hooks make coding and statement management easier than it was before. The introduction of React hooks changed a lot in the react application development. Developers moved from complicated and length class-based components to simpler functional components that can do the same work in fewer lines of code.

Top 35 React.js Interview Questions Answers for Fullstack Java Developers

Hello guys, if you are preparing for React developer interviews and looking for frequently asked React.js interview questions then you have come to the right place. Earlier, I have shared the best courses, books, and websites to learn React.js and in this article, I am going to share 35 frequently asked React.js interview questions, suitable for 1 to 2 years experience developers. ReactJS is one of the most recently built open-source front-end programming languages. It came directly from Facebook's headquarter back in 2011. Earlier Recat.js was only limited to Facebook but now, it is one of the most extensively used programming languages all across the world.

The 2023 Machine Learning Engineer RoadMap

Hello guys, if you want to become a Machine Learning Engineer in 2023 and looking for Machine Learning RoadMap then you have come to the right place. I love roadmaps and in the past, I have shared Java Developer RoadMap, Python Developer RoadMap, and Machine Learning courses and today, I am going to share with you The 2023 Machine Learning Engineer RoadMap. Machine learning is a good career nowadays since most companies implement them into their services to deliver a better user experience. Data scientists also use them to make predictions for better decision-making and other things. If you want to become a machine learning engineer and feel confused about starting, complete reading this article.

Top 15 Node.js Interview Questions Answers for Fullstack Developers

Hello guys, if you are preparing for full stack web developer interviews then you should prepare for Node.js as well, particularly if you are a JavaScript developer. Node.js is one of the most popular terms in the web development community. It is heavily used in server-side development. It can be used with different databases such as MongoDB and SQL. There is a huge demand for Node.js developers in the job market. The interview can be tough because Node.js is wide and a person needs a considerable amount of practical experience to crack it. In the past, I have shared JavaScript interview questions, Angular interview questions as well as React Questions, and in this article, we will discuss the top 15 important and commonly asked Node.js questions with answers.

10 Reasons to Learn React Native for App Development in 2023

Hello guys, if you want to get into App development in 2023 then you have a couple of choices. For example, you can learn Flutter and React Native to develop cross platform apps, or you can learn Android or iOS to develop native apps. Android has been my favorite because you can use Java programming language to code Android application and being a Java developer, that was the easiest way to get into App development but if you are coming form JavaScript background then learning Java or Swift (which is required for iOS app development) could be difficult. You can either learn Dart to use Flutter or you can stick with JavaScript and learn React Native, which I think the best way for a JavaScript developer to get into App development in 2023 but if you are still not convinced, In this article, I am going to share 10 reasons to learn React Native, which can help you make a decision on which technology you should learn for app development in 2023.

What is a Functional interface in Java 8? @FunctionalInterface Annotation Examples Tutorial

Hello Java programmers, if you are wondering what is a functional interface and what is the role of @Functional annotation in Java then you have come to the right place. Earlier, I have shared the best Lambda and Stream courses and books, and in this article, I will explain and teach you how to create a functional interface in Java. A functional interface is nothing but an interface with just one abstract method like Runnable, Callable, Supplier, Predicate, etc. You can use @Functional annotation to mark that this is a functional interface. If a function expects a functional interface then you can also pass a lambda expression to it and that's the main benefit of a Functional interface in Java. This is also a popular Lambda Expression Interview question so, knowing this topic in depth is also better for interviews.

Difference between char, varchar, nchar and nvarchar data types in SQL Server? Example

What is the difference between char and varchar in SQL, followed by nchar and nvarchar, is one of the popular SQL interview questions, and surprisingly not every programmer knows this basic difference. If you go with the name, which you should, then you can figure out that char is a fixed-length data type while varchar should be a variable-length data type. Though all char, varchar, nchar, and nvarchar are used to store text or String data there are subtle differences between them. As I said char is fixed length, which means a variable or a column like Zipcode char(10) will take only 10 bytes to store data, including space.

3 Best Spring Security Online Training Courses for Java Developers in 2023 [UPDATED]

Spring Security is one of the leading open-source, security frameworks that allow you to implement security in Java-based web applications. It provides several security features like authentication, authorization, the remember me functionality out-of-the-box, which means you can directly use them without adding code or changing your class. Yes, Spring Security implements security at the application level i.e. you can even secure your non-secure resource without modifying them. It is also the leading framework to secure RESTful Web Services. Because of all these, the demand for Java developers with good knowledge of Spring Security is very high.

Top 5 Online Courses to Learn C Programming in 2023 - Best of Lot

Hello guys, today, I will talk about one of the oldest, reliable, powerful programming languages that have survived for 50 years. Yes, that's right, 50 years. It's a great achievement for any technology to remain relevant for such a long period. If you don't know, the C Programming language is one of the first general-purpose programming languages, invented by Dennis Ritchie and Ken Thomson around 1969. Ken was writing UNIX, another accessible technology that has survived for 50 years around the same time and needed a programming language that can do all kinds of tasks; the result was a C programming language.

3 Ways to Learn React.js for web development in 2023 - Best of Lot

Hello guys, if you want to learn React.js in 2023 and looking for best way to learn React.js in quick time then you have come to the right place. Earlier, I have shared React.js Developer RoadMap as well best React courses, books, websites, and React projects for you and in this article, I am going to share what is the best way to learn React.js in quick time and also in depth. But, before that, let's find out what is React.js and why every web developer should learn React.js in 2023. According to the Stack Overflow developer’s survey, React.js surpassed jQuery to become the most popular web framework in the world. Today, React is the most widely used technology for frontend development. Basically, React is a JavaScript library created and maintained by Facebook. It is used to create interactive and dynamic web components.

10 Reasons to Learn SQL for Programmers and Software Developers in 2023

Hello guys, if you are on the fence whether to learn SQL or not, or want to learn SQL but not sure whether learning SQL is worth your time and effort then you have come to the right place. Earlier, I have shared best SQL books and courses to learn SQL for Beginners and in this article, I am going to share 10 Reasons to learn SQL. From my 18 years of experience as Software developer and 12 years as a blogger I can safely say that you should learn SQL. In all of these times, I have constantly worked with SQL in my projects and job. While database changes form Oracle to MySQL, to SQL Server, and now PostgreSQL but the knowledge of SQL still pays off.

5 Examples of GROUP BY Clause in SQL with Aggregate Functions

There is no doubt that SQL is an essential skill and every programmer, developer, DevOps, and Business analyst should know SQL. If you want to learn SQL from scratch then you have come to the right place. Earlier, I have shared many SQL interview questions and the best SQL courses for beginners, and today, I am going to share some GROPU By examples in SQL to write aggregation queries. THE GROUP BY clause in SQL is another important command to master for any programmer. We often use the GROUP BY command along with a select clause for reporting purposes, since the GROUP BY clause is mainly used to group related data together it's one of the most important SQL commands for reporting purposes.

Strategy Design Pattern in Java using Enum - Tutorial Example

Hello guys, how are you doing? I hope you all are fine and doing good in your life and career. Today, I am going to talk about the Strategy pattern, one of the useful design and coding pattern which will help you to write flexible code. The code which can withstand the test of time in Production. I'll also teach you how you can use Enum to implement the Strategy design pattern and Open Closed design principle better in Java. I have said this before that Java Enum is very versatile and can do a lot more than you normally expect from it. We have seen a lot of examples of Enum in my earlier posts like writing thread-safe Singleton using Enum and 10 ways to use Enum in Java.

Top 30 Scala and Functional Programming Interview Questions and Answers

Hello guys, if you are preparing for Scala Developer interview and looking for frequently asked Scala questions for practice then you have come to the right place. Earlier, I have shared best Scala courses, Scala books, and best Scala Frameworks and in this article, I am going to share 30 Scala Questions from past interviews. Scala is a programming language which aims to provide best of both object-oriented programming and functional programming world. It not only allows you to construct elegant class hierarchies for maximum code reuse and extensibility but also allows you to implement their behavior using higher-order functions and other functional programming technique. It is touted as one of the languages which can probably take over Java, though it didn't happen especially after Java 8 release which also provides some functional programming tools to Java e.g. lambda expression and stream.

Top 10 Free Courses to Learn Docker in 2023 - Best of Lot [UPDATED]

I have been answering a lot of questions about what programmers should learn in 2023, and Docker Container is one such skill. Docker and containers are a whole new way of developing and delivering applications and IT infrastructure. In this post, I'll talk about what Docker is and why a programmer should learn Docker. In today's world of massive scalability, where every single mobile app and web application needs to support billions of users (think of YouTube, WhatsApp, Uber), software application development and deployment have become increasingly complex. Gone are the days when the software is developed by a small team of onshore people.

Top 10 Data Science Certification Courses for Python and R Developers in 2023 - Best of Lot

Hello guys, Data Science, Machine Learning, Deep Learning, and Artificial intelligence are really hot at this moment and offering a lucrative career to programmers with high pay and exciting work. It's an excellent opportunity for programmers who are willing to learn these new skills and upgrade themselves. It's also important from the job perspective because Robots and chatbots are getting smarter day by day, thanks to these technologies, and most likely will take over some of the jobs which many programmers do today. Hence, it's essential for software engineers and developers to upgrade themselves with these skills.

Top 35 T-SQL and Microsoft SQL Server Interview Questions and Answers for 2 to 5 Years Experienced

Hello guys, if you are preparing for Java developer interview where Microsoft SQL Server is listed as mandatory and required skill or you preparing for a junior DBA role for Microsoft SQL Server and looking for common SQL Server interview questions for practice then you have come to the right place. Earlier, I have not only shared SQL Server courses for beginners but also 50+ SQL and Database Questions for programmers and DBA. You an also check them to get yourself familiar with generic SQL concepts like normalization, joins, aggregation, partitioning, indexing, and transaction along with these SQL Server specific questions which focuses mainly on T-SQL and SQL Server functionalities and how general SQL commands behave in Microsoft SQL Server.

12 Examples of Kubectl command in Kubernetes in Windows and Linux

Hello guys, if you are working with Kubernetes pods like deploying your application, starting and stopping them by scaling to zero instances, while you just want to see logs or want to login into the Kubernetes pods itself, you must know how to use kubectl commands to do all these task. Since most of the companies, both big and small are using Kubernetes to deploy services on cloud, its imperative for Java developers and other Software developers to get familiar with the kubectl command. We deploy our Java Microservices on Kubernetes mainly because Kubernetes can start the services automatically when it goes down. We have different Kubernetes clusters for different environments like DEV, UAT, and PRODUCTION and I often switch between those cluster using kubectl commands to check the status of our Java services or interact with them.

Template Method Design Pattern in Java? Example Tutorial

Template Method Pattern defines a sequence of steps of an algorithm but let you free to implement those steps on your way. You cannot change the algorithm but you can define how those steps should behave. To make sure that you cannot change the algorithm, template methods are usually made final in Java, which is also a good use case of when to make a method final in Java. The subclasses are still allowed to override the steps but as I said, they are not allowed to change the sequence. It can also be provided a default implementation for one or more steps. Let us look at the following example to understand Template Method Pattern. A Template method pattern provides a skeleton for performing any sort of algorithm or an operation, and it allows the sub-classes to re-define part of the logic.

How to check if a String has all unique characters in Java? [Solved]

Hello guys, its been long time since I shared any interesting coding problem but the wait is over. Today, I am going to share one interesting and popular String based coding problem which you would love to solve. Today's coding challenge is to find out if a given string has all unique characters or not, for example, if given String is "Java" then your function should return false because all styles from this String are not unique. On the other hand, if the given String is "Python," then your function should return true because all characters are unique in this String. Btw, don't just jump on the solution if this is ever asked to you on Interview; instead, you should ask a couple of good questions to demonstrate your requirement gathering skill and attention for details.

Top 10 Free Courses to Learn Python in 2023 - Best of Lot

There is no doubt that Python is currently the world's #1 programming language and the biggest advantage of that is it's bringing more and more people into the programming world. In recent years, I have seen more people learning Python than any other language, yes, not even JavaScript. Many of them learning Python to explore some awesome Data Science and Machine learning libraries provided by Python. Some people are also learning Python for web development and there are still many developers who are learning Python for scripting and automating trivial tasks. It doesn't matter why you are learning Python at this moment, it's a great thing in itself that you have decided to learn Python.

5 Examples of df command in Linux

The df command is used to find the amount of disk space used and available on different partitions and file systems. The simplest example of df command is just typing df on console with out any arguments and it will show you the space used and available on all currently mounted file systems of all types e.g NFS, ext3 and both local and remote. Alternatively you can ask df command to print the size and space available and used for a particular partition. Normally the disk space is printed in units of 1024 bytes, but this can be overridden. I commonly use df -h option to print the size and disk usage in human readable format e.g. G for giga bytes, M for mega bytes and so on.

Top 5 React and Redux Courses to Learn Online in 2023 - Best of Lot

If you are a Web developer or someone passionate about web development and looking for some awesome courses to learn React or React JS, a popular JavaScript framework to develop a component-based user interface then you have come to the right place. Facebook's React library has taken the front-end development world by storm. More and more people have started using React even in favor of Google's Angular, another popular front-end development framework. Well, I am not going into the classic debate of Angular vs React as both the framework has their own advantage and disadvantage but if you have chosen to learn React, you have made the right decision.

3 ways to parse JSON String to Object in Java [Jackson, Gson, and json-simple Example]

One of the common task in Java web application, particularly the ones which deals with RESTful web services are parsing JSON messages. Many times you need to parse JSON to create a Java object like parsing a JSON message to create a POJO, for example, an Order or a Book. Representing JSON in Java is easy, it's like a String value but unfortunately, JDK doesn't provide any standard API to parse JSON in Java. There were talks to add JSON parsing API in JDK 9 but that didn't materialize, but you don't need to worry. There are many good open-source JSON parsing libraries you can use to parse any kind of JSON in your Java program.

How Long Does It Take To Learn Cyber Security?

Hello guys, if you want to become a Cyber Security Engineer or a Cyber Security Analyst and wondering how long it take to learn all essential Cyber Security concepts then you have come to the right place. Earlier, I have shared best Cyber Security online courses, Pen testing certification courses, and Ethical Hacking online courses to become a Security specialist in 2023 and in this article, I am going to share how you can learn Cyber Security and how much time it take to learn Cyber Security concepts, tools, and practices. Cyber security is a massive industry that involves protecting data from unauthorized access either locally on your devices such as a laptop, computer, phone, router, local network, or the data on the server that holds the companies data such as users information and their credit card. This article will help you estimate the time needed for learning cyber security and which skills are essential.

Top 5 SQL Server Management Studio Tips for Programmers and DBAs

Hello guys, If you use SQL Server database and use SQL Server Management Studio in your day to day work and looking for tips to improve productivity and work fast and efficiently then you have come to the right place. Earlier, I have shared SQL Server online courses, SQL Server Interview questions and SQL Server Management Studio keyboard shortcuts and today, I am going to share amazing tips to make most of SSMS. These are the tips I learned hard way after working close to 8 years on SQL Server backend. Anyway, we all love tips? isn't it? Well, I certainly do, they not only make life easier on work but also gives us a joy of discovery. Every time I discover a not-so-trivial tip I feel happy and become more productive and that's why I am always in hunt of useful tips which can help me in my work.

Area and Perimeter of Square in Java Program? Example Tutorial

Hello guys, if you are looking for Java program to calculate area of Square or program to calculate perimeter of square or just learning Java and looking for programming exercises then you have come to the right place. I have share many programming exercises and homework in this blog and today, I am going to share another simple programming assignment for beginners. Yes, we ae going to write a program which will calculate the area and perimeter of a square in Java. If you don't remember, area of a square is nothing but the multiplication of side with itself or square of side, while perimeter of a square is 4 times of its side because in case of square, each side is equal.

Why use Date as YYYYMMDD in SQL Server?

When you enter a Date in SQL SERVER for inserting data or filtering data in WHERE clause, what you enter is String. SQL Server infernally converts that formatted String to different date and time data types in Java e.g. DATETIME, DATE, TIME, DATETIME2 and SMALLDATETIME. This conversion is subject to language setting in SQL SERVER, for example, the same date 03/07/2015 can be interpreted as 3rd March 2015 if language setting is US English (MMDDYYYY) and 3rd July 2015 if language is set to British English(DDMMYYYY). To avoid this, you can enter date as YYYYMMDD format, which is considered language neutral and always interpreted correctly by Microsoft SQL Server.

How Long Does it Take to Learn Machine Learning in 2023?

Hello guys, if you want to learn Machine Learning in 2023 and wondering how long does it take to learn Machine Learning and become a Machine Learning Engineer then you have come to the right place. Earlier, I have shared best free Machine Learning courses and books and in this article, I will share how much time it take to learn Machine Learning and how you can quickly learn essential ML concepts and become a Machine Learning Engineer in 2023 but before that let's see what does Machine Learning means? Machine learning is the science of making the machine predict the result of something based on previous data.

Top 10 Frameworks to become a Full Stack Developer in 2023 - Best of Lot

The Technical world changes as fast the technology changes, and so are the technical jobs. Gone are the days where you can land a job by just knowing one technology or programming language, and somehow survive in the position for many years without learning new things. Many of us get into the programming and web development world by knowing just one or two technology like Java, C++, or JavaScript, but that won't cut the ice anymore. There were teams of tens of people doing specialized jobs like front-end development is done by a separate set of developers and back-end is written by other sets of programmers, commonly known as server-side developers.

Top 5 Online Courses to Learn Flutter in 2023 - Best of Lot

If you are like me, who thinks Flutter is the future of mobile development and looking for some excellent online courses to learn Flutter, then you have come to the right place. In this article, I am going to share some of the best online courses to learn Flutter in 2023 from Udemy, Pluralsight, and Coursera, but before going into that, let's see what Flutter is and why everyone is so excited about it. Well, in general, whenever something comes from Google, it makes a lot of developers excited like Angular, Dart, and now Flutter. I have got my hand dirty in both Android and iOS using Java and Objective-C in the past, but after working for some time, I decided to move on.

10 Reasons to learn MongoDB NoSQL Database in 2023

Hello guys, If you are in web development or Software development then you may know that databases are an important part of modern development. Be it web or mobile application development, you will always find some kind of database in it. Modern development is not complete without databases because data is required to be stored somewhere. As a Java developer I have worked across many projects and most of them have relational database but things are changing nowadays and more and more project are using NoSQL Databases like MongoDB, Redis, Cassandra etc which can really improve performance in many specialized cases.

10 Tools Java Developers Can Learn in 2023 - Beginner to Advanced [UPDATED]

Hello guys, we are now one week into 2023, and I am sure all of you have already made your goals about what to learn in 2023 and how to achieve them. I have been writing a series of articles to give you some ideas about the things you can learn and improve to become a better, all-around developer in 2023, like learning new programming languages, frameworks, and libraries. These three things are extremely important and help you to become a better Java developer but as some wise person said, "you are only as good as your tools", you should also look to upgrade your tools, learn new tools and improve your understanding of old tolls which are still going well.

How to remove objects from ArrayList using Iterator in Java? Example Tutorial

It's tricky to remove objects from ArrayList in Java while you are not iterating over it, especially if you are new to Java programming. Altought, you can use any of the overloaded remove(object obc) and remove (int index) method to remove objects directly or at any index. But, things get tricky, when you are iterating over ArrayList. If you use the remove() method from ArrayList then it will throw ConcurrentModficationException, even if you are running your code from single thread. The reason is that, Iterator checks for any modification during iteration using modCount and if it sees a modification e.g. add or remove which happens outside Iterator, it throws ConcurrentMdoficationException. Hence, the right way to remove objects from ArrayList is to use the Iterator's remove method, instead of remove() methods from ArrayList. It will help you to avoid ConcurrentModficiationException.

Database Per Microservice Pattern in Java - Example Tutorial

Hello guys, in the last article, I share with your 10 essential Microservice design patterns and principles and best Microservices courses for Java developers which many of you appreciated. At the same time, a lot of you asked me to go deep down into each of those patterns and explain them with examples. So I decided to create this new series of Microservice Pattern tutorials where I will explain each of those essential Microservice pattern with example every week. In this article, let's have a look at what is database per microservice. Microservice architecture is a combination of a set of loosely coupled microservices and each service can be developed independently in an agile manner. We can use this pattern and practices when designing microservices. So let's go deep into what is database per microservice is and why we use it in our programming.

12 Best Coursera Professional Certificates for IT Professionals in 2023 [UPDATED]

Hello guys, If you are thinking of a career in Information Technology and Software Development in 2023 but lack a Computer Science degree or a Professional degree then you don't need to disappoint. Coursera's professional certificates can give you all the knowledge and credential to start a career in Information Technology. If you don't know, Coursera launched Professional Certificates recently which can help you get job-ready for an in-demand career field in less than a year. You can earn a career credential, apply your knowledge to hands-on projects that showcase your skills for employers and get access to career support resources.

[Solved] How to check if given point is inside Triangle or not in Java? Example

One of the interesting problem from Java Programming interviews is, "write a program to check if given point lies inside a triangle or not?". You will be given co-ordinates of vertices and the point as part of problem and you need to write a function e.g. isInside() which return true if point is within the triangle and false if it is not. For example, in the triangle specified by vertices (11, 31), (21, 1), and (1, 1) the point (11, 16) are inside the triangle and point (30,17) are outside of the triangle. It's a good coding interview question if you have not heard before, just think about how do you prove if the point lies inside the triangle or not? It's not a difficult algorithm and you can think of it by just trial and error.

10 Tips to Become a Better Java Developer in 2023 [UPDATED]

I often receive emails from my readers about how they can become better Java developers, what things they should learn, and which areas they can work on to become a Rockstar Java developer. After answering them individually over the last few years, I thought to jot down a couple of points, which I think will make you a better Java Programmer and Application developer. But, before going into that, I would like to stress that a better programmer is always a better Java developer, and that's why all the tips I have shared before to improve your programming skill and become a better programmer still hold true. If you haven't read them yet, you can understand them after this article; they will help you to improve your programming and coding skills, which is essential to becoming a better Java developer.

How to choose Collection in Java? List, Set, Map, and Queue Example

The Java collection framework offers implementation of different data structure like an array, list, set, map, queue, tree, etc and the choice really depends upon the situation and properties of the different data structure. For example, if your requirement is fast search with index then you can use ArrayList and if you want to store key-value pairs then you would consider using hash table data structure and there are a couple of implementation of hash table data structure in Java, like HashMap, Hashtable, LinkedHashMap, TreeMap, and ConcurrentHashMap. Now, which one will you choose? If you don't know or confused don't worry, I will give you a set of rules and use cases which will help you choose the right Collection type in Java depending upon scenario.

How to drop a column from an existing table in SQL Server? Example Tutorial

Hello guys, In the last article, I have shown you how to add a new column to an existing table in Microsoft SQL Server and today, I'll teach you how to remove or drop a column from an existing table in SQL server. Dropping a column is a trivial task from a new table e.g. you can just use ALTER TABLE table_name DROP COLUMN column_name to drop a column but when it comes to removing a column from existing table, you need to be more careful because it may contain data or it may be referenced from other tables. If a column is associated with another table using foreign key constraint then you cannot remove it until you remove the foreign key constraints.

Top 5 Websites to Learn Python Coding for FREE - Best of Lot

Believe it or not, but Python has inspired many people to learn to code, and it's continually inspiring them. I know a handful of people who are learning Python for different reasons, starting from web development to machine learning. I have seen new people learning Python to write web apps using Django, create a Machine learning Model using Python, and just write some handy scripts to automate the boring stuff. Python is currently the world's #1 programming language and its popularity is growing every passing day, thanks to Data Science and Machine learning and awesome Python libraries like Pandas, PyTorch, NumPy, and TensorFlow.

How to declare a method which takes a lambda expression in Java 8? Example Tutorial

You may have seen lot of examples of how to use lambda expression in Java 8 e.g. to replace anonymous class, to implement Runnable or to implement Comparator but there are hardly any examples of teaching you to how to declare your own user defined method which can accept lambda expression. In this tutorial, I will try to bridge that gap. Actually, a method doesn't know whether you are passing an instance or a lambda expression to it, all you need to remember is that lambda expression is of SAM type in Java 8. Which means, you can pass lambda expression in place of an interface which has just one abstract method.

3 Ways to Remove Duplicates from a table in SQL - Query Example

There are a couple of ways to remove duplicate rows from a table in SQL e.g. you can use temp tables or a window function like row_number() to generate artificial ranking and remove the duplicates. By using a temp table, you can first copy all unique records into a temp table and then delete all data from the original table and then copy unique records again to the original table. This way, all duplicate rows will be removed, but with large tables, this solution will require additional space of the same magnitude as the original table. The second approach doesn't require extra space as it removes duplicate rows directly from the table. It uses a ranking function like row_number() to assign a row number to each row.

Difference between Filter and Listener in Servlet - Java JEE

One of the frequently asked Servlet Interview question is what is the real difference between a Filter and a Listener? What is the role they play in a Java web application? In this article, I'll try to answer these question by explain what is Servlet Filter and Servlet Listener and what are their use in Java web application. A filter is used for pre-processing and post-processing. It can intercept the request before it hits to the servlet and can modify both header and body of Servlet, hence it is used to perform login, authentication, authorization and other security aspect which is require before client can access the resource e.g. a Servlet or JSP.

Subscribe to: Posts ( Atom )

Topics and Categories

Search This Blog

Subscribe for Discounts and Updates

Interview Questions

Best of Javarevisited

Java Tutorials

Get New Blog Posts on Your Email

Get new posts by email:

Followers

Categories

Blog Archive

Translate This Blog

References

Pages