Category: SQL
Total: 28 Posts
Posts of Category: SQL
  1. Backing up and Restoring PostgreSQL Databases

    Backing up and Restoring PostgreSQL Databases Introduction Making regular database backups is an essential maintenance task and fail point recovery strategy for anyone who is responsible for a database. A commo...Learn More
    SQLDatabasePostgreSQLdevops
  2. Running SQL on CSV Data: Data Conversion and Extraction

    Running SQL on CSV Data: Data Conversion and Extraction A lot of tools output data as comma-separated values (CSV). It is a simple but common tabular data format of plaintext that can easily be processed. Each ...Learn More
    SQLUnixCSV
  3. Using SQLAlchemy with Flask and PostgreSQL

    Using SQLAlchemy with Flask and PostgreSQL Introduction Databases are a crucial part of modern applications since they store the data used to power them. Generally, we use the Structured Query Language (SQL) to...Learn More
    PythonSQLPostgreSQLflask
  4. Integrating Elasticsearch with MS SQL, Logstash, and Kibana

    Integrating Elasticsearch with MS SQL, Logstash, and Kibana Introduction MS SQL Server holds the data in relational form or even multi-dimensional form (through SSAS) and proffers several out-of-the-box search ...Learn More
    SQLlogstashkibana
  5. Bookshelf.js: A Node.js ORM

    Bookshelf.js: A Node.js ORM One of the most common resources you'll interact with in a language like Node.js (primarily a web-focused language) are databases. And with SQL being the most common of all the diffe...Learn More
    JavaScriptSQLNodejsORM
  6. Difference between varchar and varchar2

    **Difference between varchar and varchar2** In this tutorial you will learn about difference between varchar and varchar2. Varchar stands for variable length character string. Both Varchar and Varchar2 are data...Learn More
    SQL
  7. Normalization in DBMS – 1NF, 2NF, 3NF and BCNF

    **Normalization in DBMS – 1NF, 2NF, 3NF and BCNF** Here you will learn about normalization in dbms with examples. What is Normalization in Database? Most of the projects and websites contain lot of information....Learn More
    SQLDBMS
  8. How to Backup or Restore MySql Database Using SQLyog

    **How to Backup or Restore MySql Database Using SQLyog** This tutorial will guide you how to backup or restore mysql database using sqlyog. It is really important to create regular backups of database on which ...Learn More
    SQLDatabaseMySql
  9. MongoDB vs SQLite – Difference between MongoDB and SQLite

    **MongoDB vs SQLite – Difference between MongoDB and SQLite** In this article, you will learn about difference between MongoDB and SQLite. MongoDB MongoDB first version was released in 2009. It is the most reli...Learn More
    SQLmongodbSQLite
  10. Why Do You Need to Listen to Your Developer When Choosing Web Hosting?

    **Why Do You Need to Listen to Your Developer When Choosing Web Hosting?** A web developer is a person who’s responsible for a visual appeal of a website and performs tasks related to the website’s layout, deve...Learn More
    HostingSQL
  11. Joins in SQL – Inner, Outer, Left and Right Join

    **Joins in SQL – Inner, Outer, Left and Right Join** Here you will get detailed information about joins in SQL. Join is a very basic concept in SQL which can be confusing at times. The joins are used when we ne...Learn More
    SQL
  12. dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

    **dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart** dbForge Studio for SQL Server is an integrated environment for managing, administering, accessing, configuring, and developing SQ...Learn More
    ReviewSQLSQL Server