Author: Admin

This author has written 36 articles

JDBC Java

JDBC stands for Java Database Connectivity. It is an application programming interface, API for short.To fully understand the functions of the JDBC, we must first delve into what an API actually is. API, or…

Continue Reading JDBC Java

Collections in Java

Almost all programming languages have its own set of collections for making data storage more organized. Python has its own set of collections and C++ has its own STL library. Similarly, Java also has…

Continue Reading Collections in Java

Exception in Java

An exception is an issue that comes up during program execution. If an Anomaly happens, the program's usual flow is interrupted and the program terminates abnormally, which is not recommended, and such exceptions should…

Continue Reading Exception in Java

How to install SQL Server?

Download and Install Microsoft SQL Server Microsoft SQL Server is a Microsoft-developed, relational database management system. The primary function of the product is to store and recall the data as requested by the user…

Continue Reading How to install SQL Server?

Delete and Truncate Query in SQL

The Delete query in SQL only deletes records from the table, and does not allow any description changes, i.e. it just manipulates them. Therefore, it is DML (Data Language Manipulation). The Truncate command in…

Continue Reading Delete and Truncate Query in SQL

WHERE Clause in SQL

'Where' as a term is used to define a location or position and this is exactly what the clause does in the SQL Where. Where in SQL a condition is defined while the data…

Continue Reading WHERE Clause in SQL

INSERT INTO Query in SQL

The statement INSERT is used to insert the records into a table. The table chosen for inserting data has to have the same number of columns and values. In this tutorial segment, we'll discuss…

Continue Reading INSERT INTO Query in SQL

SQL Data Types

There are various types of data available for the letters in the alphabet, such as the character data type, or the Boolean data type for true or false values. What Is SQL Data Types?…

Continue Reading SQL Data Types

SQL Database Queries

A database includes records, and SQL queries are used to construct, alter, or remove those records. An SQL query may be either a delete or build action query, or a select query such as…

Continue Reading SQL Database Queries

Select Query in SQL

The statement Select in SQL is the most commonly used statement in SQL for queries. It is either used to collect data according to a given rule, or to display a whole table. The…

Continue Reading Select Query in SQL

Tables in SQL

Tables are the basic level in which data is stored in a relational database management system. It contains a header row at the top of the table which lists the names of the columns,…

Continue Reading Tables in SQL

Features Of SQL

SQL is one of the most popular and used technologies in today's world. A large data is collected every day.So to easily communicate with databases one should learn sql programming language.Some sql features make…

Continue Reading Features Of SQL

What Is SQL?

SQL full form is a structured query language, and it allows you to interact through commands with the database. Here are some of the SQL Database functions: This allows users to retrieve information from…

Continue Reading What Is SQL?