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.
Disclosure: This article may contain affiliate links. When you purchase, we may earn a small commission.
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.
Labels:
Oracle
,
SQL
,
SQL Interview Questions
Top 10 Google Interview Questions for Software Engineer - Books, Resources
Hello guys, if you are preparing for Google's Software Development Engineer roles and looking or Google Software Interview questions then you have come to the right place. Earlier, I have shred Amazon and Microsoft Interview questions and in this article, I am going to share popular questions from Google Interviews. These Google interview questions are some of my favorites collected from different sources. Every Programmer knows that Google is one of the best technology companies and its dream for many software developers to work for Google, but at the same time interview process at Google is very tough and only a few genuine intelligent programmers get through their interview process.
Top 15 Advanced Java ClassLoader Interview Questions and Answers for Experienced Developers
Hello guys, if you are preparing for Java interviews and want to refresh your knowledge of Classloaders in Java then you have come to the right place. Earlier, I have shared Java interview questions on Collections, Multithreading, Serialization, and Generics, and in this article, I am going to share frequently asked Java interview questions about class loaders. If you don't know, a class loader is a program that loads classes in Java programs. The mechanism of class loading is very important to understand how the Java program works. When you run a Java program you give the name of the main class, from their onwards, built-in classloaders like Bootstrap classloader start loading not just the main classes but other Java library classes which is required to run that program.
Labels:
classloader
,
core java
,
core java interview question
,
interview questions
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.
Labels:
HTML and JavaScript
,
Java web tutorial
,
programming
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.
Labels:
app development
,
best of javarevisited
,
JavaScript
,
React Native
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.
Labels:
functional interface
,
Java 8
,
Lambda expression
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.
Labels:
courses
,
online resources
,
spring
,
spring security
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.
Labels:
C++
,
courses
,
online resources
,
programming
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.
Labels:
core java
,
design patterns
,
Enum
,
programming
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.
Labels:
interview questions
,
Scala
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.
Labels:
courses
,
Docker
,
online resources
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.
Labels:
courses
,
Data Science
,
machine learning
,
online resources
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.
Labels:
courses
,
online resources
,
python
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.
Labels:
Angular
,
courses
,
JavaScript
,
online resources
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.
Labels:
courses
,
online resources
,
React JS
,
web development
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.
Labels:
best of javarevisited
,
courses
,
online resources
,
programming
,
web development
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.
Labels:
courses
,
flutter
,
online resources
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.
Labels:
best of javarevisited
,
online resources
,
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.
Labels:
best of javarevisited
,
coursera
,
courses
,
IT Certifications
,
online resources
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.
Labels:
best of javarevisited
,
core java
,
programming
,
tips
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.
Labels:
best of javarevisited
,
online resources
,
python
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.
Labels:
best of javarevisited
,
HTML and JavaScript
,
programming
,
python
Subscribe to:
Posts
(
Atom
)