SQL Server Blog
In this article, there are 8 concepts to understand if you want to become an advanced programmer faster. The list is not complete, but it can be a good starting point for self-education in...
PreambleWorking with the database is often the weakest point in the performance of many web applications. And you can often see how the same rake comes the developers in the design of the...
What is the cause of the vulnerability?According to the WordPress command, the WordPress kernel is not in immediate danger, but the new version will add additional protection in case plugins or...
In this article, we will learn how to connect to a MySQL database from Java code and execute simple queries to retrieve and update data. In order to access the database, we will use the JDBC...
In this article, you will learn how to display NULL values in other meaningful values.Dr.EFCodd, who is the creator of the relational model for the database, introduced this concept of NULL...
There are many PostgreSQL manuals on the network that describe the basic commands. But as you dive deeper into the work, you'll encounter practical issues that require advanced commands.Such...
Previously, SQL as a tool was enough for research analysis: quick data search and preliminary report on data.Nowadays, data come in different forms and do not always refer to them as...
Many developers, even those who have long been familiar with SQL, do not understand window functions, considering them some kind of special magic for the chosen ones. And although the...
PreambleExternal keys may be set in relational databases when fields from one table refer to fields in another table. You can also set links in MongoDB.Manual link settingThe manual setting of...
PreambleWhen searching for documents in small collections, we won’t have any special problems. However, when collections contain millions of documents, and we need to sample them by a certain...
PreambleIn the previous topics, the collection was created implicitly automatically when the first data were added to it. But we can also create it explicitly by using the db.createCollection(name,...
PreambleThe MongoClient class is used to connect to the mongodb database. It allows you to connect to mongodb (connect method) and disconnect (close method), as well as select the database (selectDB...
PreambleSQL or Structured Query Language (Structured Query Language) is intended for data management in a relational database system (RDBMS). In this article, you will learn about frequently...
PreambleWhen you need to select a DBMS, the main question is usually to select a relational (SQL) or non-relational (NoSQL) structure. Both options have their advantages, as well as several key...
While there are different types of SQL tools available on the market, you need to evaluate and find out which one is best suited for which circumstances.Some tools offer high performance with...
Like other database management systems, MongoDB provides an opportunity to update data. The easiest to use method is to save. This method accepts a document as a parameter. Method of saving The...