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.

Top 10 Oracle Interview Question and Answer - Database and SQL

These are some interview questions and answers asked during my recent interview. Oracle interview questions are very important during any programming job interview. The interviewer always wants to check how comfortable we are with any database either we go for the Java developer position or C, C++  programmer position. So here I have discussed some basic questions related to the oracle database. Apart from these questions which are very specific to the Oracle database, you may find some general questions related to database fundamentals and SQL like Difference between correlated and noncorrelated subquery in database or truncate vs delete in SQL, etc.

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.

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. 

Top 5 Online Courses to Learn C Programming in 2024 - 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.

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 10 Angular Tutorials and Courses for Web Developers in 2024 - Best of Lot

Hello guys, if you are interested in learning the Angular framework in 2024, one of the best and most popular JavaScript frameworks for developing component-based Web GUI, and looking for some awesome courses, books, and tutorials then you have come to the right place. Earlier, I have shared the best Angular courses and In this article, I am going to share some of the best resources like books, tutorials, and courses to learn the Angular framework, formerly known as Angular, and now famous as Angular 2. It's backed by Google; hence you should not worry about it being outdated and losing relevance in a couple of years. Any investment you made in learning Angular will pay you rich dividends in the coming years.

Top 10 Frameworks to become a Full Stack Developer in 2024 - 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.

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

Hello guys, we are now one week into 2024, and I am sure all of you have already made your goals about what to learn in 2024 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 2024, 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.

10 Tips to Become a Better Java Developer in 2024 [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.

Top 6 Programming Languages to Learn in 2024 - Best of Lot

Hello guys, If you are thinking about which programming languages to learn in 2024 to get a job in a startup or do some freelance work online as a developer, then you have come to the right place. In the past, I have shared the best technical jobs for programmers and in this article, I am going to list down some of the best programming languages for freelancers and programmers looking to get a Software developer job in startups. I have compiled this list on my own experience as a freelancer and also about reading many stories and recommendations of freelancers. These are also some of the best programming languages to get a job in startups where a quick turnaround is expected, and eventually on companies like Google, Facebook, and Microsoft.