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.

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. 

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.

Top 5 Courses to Crack AWS Solutions Architect - Associate Exam (SAA-C03 and C02) in 2023 - Best of Lot

Hello guys, are you preparing for AWS Solutions Architect - Associate Exam?  or Do you want to become Amazon Web Services (AWS) Certified Developer to give your Cloud Computing career a push? and looking for some useful resources to prepare well for your exam then you have come to the right place. In the past, I have shared some free courses to learn AWS for beginner and in this article, I will share some of the best online courses to pass the AWS Solutions Architect - Associate Exam and become Amazon Web Services Certified Associate - a certification which will not only add value into your resume but also help you to get the high-paying job you always wanted.

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

Hello guys, if you are interested in learning the Angular framework in 2023, 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 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.

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.

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.

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.

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

Hello guys, If you are thinking about which programming languages to learn in 2023 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.