Richard Peterson

Latest Author Post

  • SQL Tutorial PDF: Basics PDF for Beginners (Download Now)
    $20.20 $9.99 for today 4.5 (125 ratings) Key Highlights of SQL Tutorial PDF 220+ pages eBook Designed for beginners Beautifully annotated screenshots You will get lifetime download access of this SQL notes PDF Databases can be found in almost all software applications. SQL is the standard language to query a…
  • Top 50 SQL Interview Questions and Answers for Experienced & Freshers (2021 Update)
    SQL stands for Structured Query Language is a domain specific programming language for managing the data in Database Management Systems. SQL programming skills are highly desirable and required in the market, as there is a massive use of Database Management Systems (DBMS) in almost every software application. In order to…
  • SQL Cheat Sheet with Commands & Description [Nov 2021]
    In this SQL Query cheat sheet you will learn Create Database SQL Data Types Cheat Sheet MySQL SELECT statement command MySQL WHERE clause commands MySQL Command INSERT INTO Table MySQL DELETE command MySQL Update Command ORDER BY in MySQL: DESC & ASC command MySQL GROUP BY and HAVING Clause command…
  • 14 BEST SQL Books in 2021
    We are reader supported and may earn a commission when you buy through links on our site SQL stands for Structured Query language, pronounced as “S-Q-L” or sometimes as “See-Quel.” SQL is the standard language for dealing with Relational Databases. SQL can be used to insert, search, update, and delete…
  • 10 Best SQL Query Builders & Editor (Nov 2021 Update)
    SQL Query Builder tools are used to easily create SQL queries that help you to get fast and accurate results without any knowledge of SQL or coding. They offer drag-and-drop or point-and-click interfaces that allow even non-technical users to build SQL queries quickly. It also provides a charting environment that…
  • 25 Best SQL Tools | Database Software & IDE (2021 Update)
    There are many SQL management tools available in the market, and therefore it is challenging to select the best tool for your SQL project management. The following is a curated list of best SQL tools with key features, and download links. The list contains both open-source (FREE) and commercial (Paid)…
  • SQL vs MySQL: What’s the Difference Between SQL and MySQL?
    In this tutorial, we will discuss the key difference between SQL and MySQL. Before discussing SQL and MYSQL differences, let’s first look at them individually, what SQL is and what MySQL is to understand them better. What is SQL? SQL is a language which is used to operate your database….
  • Oracle MySQL 5.6 Certification with Study Guide
    What is MySQL 5.6 Certification? The new release of MySQL 5.6 is designed for professionals involved in writing applications with the MySQL database server. The new version of MySQL is focused on increased speed, security, replication, and optimization. Skills Required for Certification To appear for this Certification, a candidate must…
  • Your First PHP Web Application using MySQL and PHP with Examples
    Now that Myflixdb, what’s next? Congratulations for your success completion of the SQL tutorial series. We looked at how we can design a database from scratch, the relational database management system model among others, MySQL as a database management system and how it implements the SQL language, what tools are…
  • MySQL Index Tutorial – Create, Add & Drop
    What is an Index? Indexes in MySQL sort data in an organized sequential way. They are created on the column(s) that will be used to filter the data. Think of an index as an alphabetically sorted list. It is easier to lookup names that have been sorted in alphabetical order…
  • PL/SQL Tutorial PDF: Oracle SQL for Beginners (Download Now)
    $20.20 $9.99 for today 4.5 (108 ratings) Key Highlights of PL/SQL Tutorial PDF 188+ pages eBook Designed for beginners Beautifully annotated screenshots You will get lifetime download access of this PL/SQL Tutorial PDF Oracle PL/SQL is an extension of SQL language, designed for seamless processing of SQL statements enhancing the…
  • Top 50 Database (DBMS) Interview Questions & Answers (2021)
    1) Define Database. A prearranged collection of figures known as data is called database. 2) What is DBMS? Database Management Systems (DBMS) are applications designed especially which enable user interaction with other applications. 3) What are the various kinds of interactions catered by DBMS? The various kind of interactions catered…
  • MySQL Views: How to Create View from Tables with Examples
    What are Views in MySQL? VIEWS are virtual tables that do not store any data of their own but display data stored in other tables. In other words, VIEWS are nothing but SQL Queries. A view can contain all or a few rows from a table. A MySQL view can…
  • 15 Best Database Design Tools | ER Diagram Tool [Free/Paid]
    Database Design is a collection of processes that facilitate the design, development, implementation, and maintenance of database management systems (DBMS). Properly designed databases help you to improve data consistency for disk storage. There are a wide range of software that helps you to design your database diagrams with ease. These…
  • MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
    What are JOINS? Joins help retrieving data from two or more database tables.  The tables are mutually related using primary and foreign keys. Note: JOIN is the most misunderstood topic amongst SQL leaners. For sake of simplicity and ease of understanding , we will be using a new Database to…
  • Top 65 PL/SQL Interview Questions & Answers (2021 Update)
    1) What is PL SQL ? PL SQL is a procedural language which has interactive SQL, as well as procedural programming language constructs like conditional branching and iteration. 2) Differentiate between % ROWTYPE and TYPE RECORD. % ROWTYPE is used when a query returns an entire row of a table…
  • MySQL UNION – Complete Tutorial
    What is a Union? Unions combine the results from multiple SELECT queries into a consolidated result set. The only requirements for this to work is that the number of columns should be the same from all the SELECT queries which needs to be combined . Suppose we have two tables…
  • PL/SQL Variable Scope & Inner Outer Block: Nested Structure
    What is Nested Blocks Oracle? In PL/SQL, each block can be nested into another block. They are referred as a nested block. Nested blocks are very common when we want to perform the certain process, and at the same time, the code for these process should be kept in a…
  • 13 BEST Free Database Software (SQL Databases List) in 2021
    A Database is a systematic collection of data which supports storage and manipulation of information. It is usually managed by a Database Management System (DBMS). Data within a database is typically modeled in rows and columns in tables to make data querying and processing more efficient. Following is the best…
  • Top 50 Azure Interview Questions and Answers (2021 Update)
    Following are frequently asked questions in interviews for freshers as well as experienced Azure professionals. 1. What is Cloud Computing? Cloud computing is a term referred to storing and accessing data over the internet. It doesn’t store any data on the hard disk of your personal computer. In cloud computing,…
  • Difference Between DDL and DML Command in DBMS: What is?
    What is DDL? Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently. The full form of DDL is…
  • MySQL SubQuery Tutorial with Examples
    What are sub queries? A sub query is a select query that is contained inside another query. The inner select query is usually used to determine the results of the outer select query. Let’s look into the sub query syntax – A common customer complaint at the MyFlix Video Library…
  • Oracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL
    What is Dynamic SQL? Dynamic SQL is a programming methodology for generating and running statements at run-time. It is mainly used to write the general-purpose and flexible programs where the SQL statements will be created and executed at run-time based on the requirement. In this tutorial, you will learn- Ways…
  • SQL Server Tutorial PDF for Beginners (Download Now)
    $20.20 $9.99 for today 4.6 (115 ratings) Key Highlights of SQL Server Tutorial PDF 204+ pages eBook Designed for beginners Beautifully annotated screenshots You will get lifetime download access of this SQL Server PDF SQL Server is a leading Relational Database Management System by Microsoft. This SQL server tutorial for…
  • MySQL LIMIT & OFFSET with Examples
    What is the LIMIT keyword? The limit keyword is used to limit the number of rows returned in a query result. It can be used in conjunction with the SELECT, UPDATE OR DELETE commands LIMIT keyword syntax The syntax for the LIMIT keyword is as follows SELECT {fieldname(s) | *}…
  • Oracle PL/SQL Object Types Tutorial with EXAMPLES
    What is Object Type in PL/SQL? Object-Oriented Programming is especially suited for building reusable components and complex applications. They are organized around “objects” rather than “actions” i.e. the programs are designed to work and interact with the entire object rather than the single action. This concept allows the programmer to…
  • Top 50 SQL Server Interview Questions & Answers for 2021
    1. What are the two authentication modes in SQL Server? There are two authentication modes – Windows Mode Mixed Mode Modes can be changed by selecting the tools menu of SQL Server configuration properties and choose security page. 2. What Is SQL Profiler? SQL Profiler is a tool which allows…
  • Row vs Column: What’s the Difference?
    What is Row? A row is a series of data placed out horizontally in a table or spreadsheet. It is a horizontal arrangement of the objects, words, numbers, and data. In Row, data objects are arranged face-to-face with lying next to each other on the straight line. What is Column?…
  • Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]
    What is Trigger in PL/SQL? TRIGGERS are stored programs that are fired by Oracle engine automatically when DML Statements like insert, update, delete are executed on the table or some events occur. The code to be excecuted in case of a trigger can be defined as per the requirement. You…
  • MYSQL – ALTER, DROP, RENAME, MODIFY
    What is the ALTER Command? As the saying goes Change is the only constant With time business requirements change as well. As business requirements change, Database designs need changing as well. MySQL provides the ALTER function that helps us incorporate the changes to the already existing database design. The alter…
  • SSAS Tutorial: What is SSAS Cube, Architecture & Types
    What is SSAS? SQL Server Analysis Services (SSAS) is a multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data. It is part of Microsoft SQL Server and helps perform analysis using various dimensions. It has 2 variants Multidimensional and…
  • PostgreSQL vs MySQL: What is the Difference?
    What is MySQL? MYSQL is a popular and widely used DBMS system. The name is taken from the girl name My who is the daughter of the co-founder Michael Widenius. The source code of MYSQL is available under the GNU GPL. The project is owned and maintained by Oracle Corporation….
  • Primary Key vs Unique Key: What’s the Difference?
    What is Primary Key? A primary key constrain is a column or group of columns in a table that uniquely identifies every row in that table. The Primary key can’t be a duplicate, meaning the same value can’t appear more than once in the table. A table can have only…
  • Primary Key vs Foreign Key: What’s the Difference?
    Before learning the difference between primary key and foreign key, let’s learn: What are Keys? Keys are attribute that helps you to identify a row(tuple) in a relation(table). They allow you to find the relationship between two tables. Keys help you uniquely identify a row in a table by a…
  • PostgreSQL Triggers: Create, List & Drop with Example
    What is Trigger in PostgreSQL? A PostgreSQL Trigger is a function that is triggered automatically when a database event occurs on a database object. For example, a table. Examples of database events that can activate a trigger include INSERT, UPDATE, DELETE, etc. Moreover, when you create a trigger for a…
  • Oracle PL/SQL Package: Type, Specification, Body [Example]
    What is Package in Oracle? PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A Package is compiled and stored as a database object that can be used later. In this tutorial, you will learn- Components of Packages Package Specification Package Body Referring Package…
  • Top 20 SSRS Interview Questions & Answers (2021 Update)
    1) Mention what is SSRS? SSRS or SQL Server Reporting Services is a server-based reporting platform that gives detailed reporting functionality for a variety of data sources. Reporting services include a complete set of tools to manage, create and deliver reports and APIs that allows developers to synchronize data and…
  • MySQL AUTO_INCREMENT with Examples
    What is auto increment? Auto Increment is a function that operates on numeric data types. It automatically generates sequential numeric values every time that a record is inserted into a table for a field defined as auto increment. When use auto increment? In the lesson on database normalization, we looked…
  • PostgreSQL Create View with Example
    What is PostgreSQL View? In PostgreSQL, a view is a pseudo-table. This means that a view is not a real table. However, we can SELECT it as an ordinary table. A view can have all or some of the table columns. A view can also be a representation of more…
  • Autonomous Transaction in Oracle PL/SQL: Commit, Rollback
    What are TCL Statements in PL/SQL? TCL stands for Transaction Control Statements. It will either save the pending transactions or roll back the pending transaction. These statements play the vital role because unless the transaction is saved the changes through DML statements will not be saved in the database. Below…
  • SQL Server Reporting Services (SSRS) Tutorial for Beginners
    What is SSRS? SQL Server Reporting Services (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It…
  • Clustered vs Non-clustered Index: Key Differences with Example
    What is an Index? An Index is a key built from one or more columns in the database that speeds up fetching rows from the table or view. This key helps a Database like Oracle, SQL Server, MySQL, etc. to find the row associated with key values quickly. Two types…
  • MySQL IS NULL & IS NOT NULL Tutorial with EXAMPLES
    In SQL Null is both a value as well as a keyword. Let’s look into NULL value first – Null as a Value In simple terms, NULL is simply a place holder for data that does not exist. When performing insert operations on tables, they will be times when some…
  • Top 40 SSIS Interview Questions and Answers (2021 Update)
    Following are frequently asked SSIS Interview questions for freshers as well as experienced Database managers. 1) What is SSIS? SSIS or SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server, which can be used to accomplish a broad range of data transformation and migration tasks. 2) What…
  • Oracle PL/SQL BULK COLLECT: FORALL Example
    What is BULK COLLECT? BULK COLLECT reduces context switches between SQL and PL/SQL engine and allows SQL engine to fetch the records at once. Oracle PL/SQL provides the functionality of fetching the records in bulk rather than fetching one-by-one. This BULK COLLECT can be used in ‘SELECT’ statement to populate…
  • PostgreSQL Join Types with Examples: Inner, Outer, Left, Right
    What are Joins in PostgreSQL? PostgreSQL Joins are used for retrieving data from more than one tables. With Joins, it is possible for us to combine the SELECT and JOIN statements into a single statement. A JOIN condition is added to the statement, and all rows that meet the conditions…
  • SQL vs NoSQL: What’s the Difference Between SQL and NoSQL
    This tutorial of the difference between SQL and NoSQL databases will discuss key SQL and NoSQL differences. But before discussing NoSQL and SQL difference, let us first look at them individually. Let’s start with SQL: What is SQL? Structured Query language (SQL) pronounced as “S-Q-L” or sometimes as “See-Quel” is…
  • MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT
    Aggregate Functions are all about Performing calculations on multiple rows Of a single column of a table And returning a single value. The ISO standard defines five (5) aggregate functions namely; 1) COUNT 2) SUM 3) AVG 4) MIN 5) MAX Why use aggregate functions. From a business perspective, different…
  • File System vs DBMS: Key Differences
    What is a File system? A file system is a technique of arranging the files in a storage medium like a hard disk, pen drive, DVD, etc. It helps you to organizes the data and allows easy retrieval of files when they are required. It mostly consists of different types…
  • PostgreSQL Union, Union ALL with Examples
    What is PostgreSQL Union? The PostgreSQL UNION operator is used for combining result sets from more than one SELECT statement into one result set. Any duplicate rows from the results of the SELECT statements are eliminated. The UNION operator works under two conditions: The SELECT queries MUST return a similar…
  • MySQL Functions: String, Numeric, User-Defined, Stored
    What are functions? MySQL can do much more than just store and retrieve data. We can also perform manipulations on the data before retrieving or saving it. That’s where MySQL Functions come in. Functions are simply pieces of code that perform some operations and then return a result. Some functions…
  • Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example]
    What is CURSOR in PL/SQL? A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement which contains all information about the statement. PL/SQL allows the programmer to control the context area through the cursor. A cursor holds the rows returned by the…
  • SSIS Tutorial for Beginners: What is, Architecture, Packages
    What is SSIS? SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating,…
  • Top 16 Microsoft Access Database Interview Questions & Answers (2021)
    1) Explain how you can import data from other sources into Access database? To import data into Access data-base In the main menu, click on EXTERNAL DATA, in the Import and Link group Choose the type of the file you want to import To know which type of file can…
  • DBMS vs RDBMS: Difference between DBMS and RDBMS
    In this RDBMS vs DBMS tutorial, we will learn about main RDBMS and DBMS difference. But before that, let’s learn: What is DBMS? A DBMS is a software used to store and manage data. The DBMS was introduced during 1960’s to store any data. It also offers manipulation of the…
  • Oracle Vs. SQL Server: Key Differences
    What is Microsoft SQL server? MS SQL server is a database product of Microsoft. It allows users to SQL queries and execute them. It is among the most stable, secure and reliable database solutions. It supports wide variety of transaction processing, analytics, and business intelligence applications in corporate IT environments….
  • Oracle PL/SQL Insert, Update, Delete & Select Into [Example]
    In this tutorial, we are going to learn how to use SQL in PL/SQL. SQL is the actual component that takes care of fetching and updating of data in the database whereas PL/SQL is the component that processes these data. Further, in this article, we will also discuss how to…
  • MYSQL Regular Expressions (REGEXP) with Syntax & Examples
    What are regular expressions? Regular Expressions help search data matching complex criteria. We looked at wildcards in the previous tutorial. If you have worked with wildcards before, you may be asking why learn regular expressions when you can get similar results using the wildcards. Because, compared to wildcards, regular expressions…
  • PostgreSQL SUBSTRING() Function with Regex Example
    What is PostgreSQL Substring? The PostgreSQL substring function helps you to extract and return part of a string. Instead of returning the whole string, it only returns a part of it. In this PostgreSQL tutorial, you will learn: What is Postgresql Substring? Syntax Examples Matching Substrings with SQL Regular Expression…
  • Top 40 Cloud Computing Interview Questions & Answers (2021)
    1) What are the advantages of using cloud computing? The advantages of using cloud computing are Data backup and storage of data Powerful server capabilities SaaS ( Software as a service) Information technology sandboxing capabilities Increase in productivity Cost effective & Time saving 2) Mention platforms which are used for…
  • Oracle PL/SQL Exception Handling: Examples to Raise User-defined Exception
    What is Exception Handling in PL/SQL? An exception occurs when the PL/SQL engine encounters an instruction which it cannot execute due to an error that occurs at run-time. These errors will not be captured at the time of compilation and hence these needed to handle only at the run-time. For…
  • Indexing in DBMS: What is, Types of Indexes with EXAMPLES
    What is Indexing? Indexing is a data structure technique which allows you to quickly retrieve records from a database file. An Index is a small table having only two columns. The first column comprises a copy of the primary or candidate key of a table. Its second column contains a…
  • PostgreSQL ALTER Table: ADD Column, Rename Column/Table Examples
    The ALTER TABLE command is used to alter the structure of a PostgreSQL table. It is the command used to change the table columns or the name of the table. In this tutorial, you will learn: Syntax Description Modifying a column Adding a New column Renaming a Table Column Setting…
  • MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ )
    What are MySQL Wildcards? MySQL Wildcards are characters that help search data matching complex criteria. Wildcards are used in conjunction with the LIKE comparison operator or with the NOT LIKE comparison operator. Why use WildCards ? If you are familiar with using the SQL, you may think that you can…
  • How to Create Login, User & Assign Permissions in SQL Server
    In this tutorial, you will learn How to Create New Login in SQL Server How to Create a User How to Create User in SQL Server Management Studio Create User using T-SQL Assigning Permission to a User in SQL Server Assigning Permissions in SQL Server Management Studio Grant Permissions using…
  • PostgreSQL Delete Query | Delete Rows from Select in Postgres
    Delete Query in PostgreSQL The Delete Statement in PostgreSQL is used to delete either one or more records from a table. If you want to delete select rows from a table PostgreSQL allows you to combine the DELETE statement with the WHERE clause else it will delete all records. In…
  • SQL SERVER JOINS Tutorial with Examples: INNER, LEFT, RIGHT, OUTER
    We can retrieve data from more than one tables using the JOIN statement. There are mainly 4 different types of JOINS in SQL server. We will learn all JOINS in SQL server with examples: INNER JOIN/simple join LEFT OUTER JOIN/LEFT JOIN RIGHT OUTER JOIN/RIGHT JOIN FULL OUTER JOIN INNER JOIN…
  • SQL GROUP BY and HAVING Clause with Examples
    What is the SQL Group by Clause? The GROUP BY clause is a SQL command that is used to group rows that have the same values. The GROUP BY clause is used in the SELECT statement. Optionally it is used in conjunction with aggregate functions to produce summary reports from…
  • DBMS Joins: Inner, THETA, Outer, Equi Types of Join Operations
    What is Join in DBMS? Join in DBMS is a binary operation which allows you to combine join product and selection in one single statement. The goal of creating a join condition is that it helps you to combine the data from two or more DBMS tables. The tables in…
  • Oracle PL/SQL Stored Procedure & Functions with Examples
    In this tutorial, you are going to see the detailed description on how to create and execute the named blocks (procedures and functions). Procedures and Functions are the subprograms which can be created and saved in the database as database objects. They can be called or referred inside the other…
  • SQL Commands: DML, DDL, DCL, TCL, DQL with Query Example
    What is SQL? SQL is a database language designed for the retrieval and management of data in a relational database. SQL is the standard language for database management. All the RDBMS systems like MySQL, MS Access, Oracle, Sybase, Postgres, and SQL Server use SQL as their standard database language. SQL…
  • ORDER BY in MySQL: DESC & ASC Query with EXAMPLE
    Sorting Results Using the SELECT command, results were returned in the same order the records were added into the database. This is the default sort order. In this section, we will be looking at how we can sort our query results. Sorting is simply re-arranging our query results in a…
  • Substring() in SQL Server: How to use Function with Example
    What is Substring()? Substring() is a function in SQL which allows the user to derive substring from any given string set as per user need. Substring() extracts a string with a specified length, starting from a given location in an input string. The purpose of Substring() in SQL is to…
  • PostgreSQL Exists with Select, Insert, Update & Delete Example
    What is Exists in PostgreSQL? The PostgreSQL EXISTS operator tests whether a row(s) exists in a subquery. This means that the operator is used together with a subquery. The Exists operator is said to have been met when at least one row is found in the subquery. You can use…
  • While Loop in Oracle PL/SQL with Example
    What is PL/SQL While Loop? While Loop in PL/SQL works similar to the basic loop statement, except the EXIT condition is at the very beginning of the loop. It works like an entry-checking loop where the execution block will only execute if the condition is satisfied, as the exit condition…
  • MySQL UPDATE Query with Example
    What is the UPDATE Query? UPDATE MySQL command is used to modify rows in a table. The update command can be used to update a single field or multiple fields at the same time. It can also be used to update a MySQL table with values from another table. MySQL…
  • Hashing in DBMS: Static & Dynamic with Examples
    What is Hashing in DBMS? In DBMS, hashing is a technique to directly search the location of desired data on the disk without using index structure. Hashing method is used to index and retrieve items in a database as it is faster to search that specific item using the shorter…
  • SQLite Tutorial PDF: (Download) SQLite Documentation
    $20.20 $9.99 for today 4.6 (119 ratings) Key Highlights of SQLite PDF 159+ pages eBook Designed for beginners Beautifully annotated screenshots You will get lifetime download access of this SQLite Tutorial PDF SQLite is an open-source, embedded, relational database management system, designed circa 2000. It is a lightweight database, with…
  • CASE Statement & Nested Case in SQL Server: T-SQL Example
    Overview of Case in real life! Again, in real life, we perform different actions depending upon the outcome of different conditions. To elaborate more, consider below example: If flight tickets are less than $100, then I will visit Los Angeles. If flight tickets are between $100 to $200, then I…
  • PostgreSQL LIKE, Not Like, Wildcards (%, _ ) Examples
    The PostgreSQL LIKE operator helps us to match text values against patterns using wildcards. It is possible to match the search expression to the pattern expression. If a match occurs, the LIKE operator returns true. With the help of LIKE operator, it is possible to use wildcards in the WHERE…
  • Oracle PL/SQL FOR LOOP with Example
    What is For Loop? “FOR LOOP” statement is best suitable when you want to execute a code for a known number of times rather than based on some other conditions. In this loop, the lower limit and the higher limit will be specified and as long as the loop variable…
  • MySQL DELETE Query: How to Delete a Row from Table
    What is the DELETE Query? MySQL Delete command is used to delete rows that are no longer required from the database tables. It deletes the whole row from the table and returns count of deleted rows. Delete command comes in handy to delete temporary or obsolete data from your database….
  • PostgreSQL IN, Not IN with Examples
    What is PostgreSQL In ? The IN operator is used in a WHERE clause that allows checking whether a value is present in a list of other values. In Operation helps to reduce the need for multiple OR conditions in SELECT, UPDATE, INSERT, or DELETE statements. In this PostgreSQL Tutorial,…
  • Oracle PL/SQL LOOP with Example
    What are Loops? Loops allows a certain part of the code in a program to get executed for the desired number of times. In this tutorial, we are going to see the loop concept in PL/SQL and flow of control in loops. You will learn- Introduction to Loops Concept Loop…
  • SQL Server IF…ELSE Condition Statement: T-SQL Select Query Example
    Why do you need Conditional Statements? Conditional statements in the SQL server help you to define different logics and actions for different conditions. It allows you to perform different actions based on conditions defined within the statement. In real life, you perform many actions dependent on the outcome of some…
  • Data Independence in DBMS: Physical & Logical with Examples
    What is Data Independence of DBMS? Data Independence is defined as a property of DBMS that helps you to change the Database schema at one level of a database system without requiring to change the schema at the next higher level. Data independence helps you to keep data separated from…
  • Top 20 SQLite Interview Questions & Answers (2021 Update)
    1) Explain what is SQLite? SQLite is a mostly ACID compliant relational database management system contained in a relatively small C programming library. 2) List out the standard SQLite commands? The standard SQLite commands interact with relational databases are similar to SQL. They are SELECT CREATE INSERT UPDATE DROP DELETE…
  • 25 BEST File Sharing Websites in 2021 (Free/Paid)
    File sharing sites provide services to access digital media like photos, videos, documents, etc., from anywhere to its users. These apps will help you to transfer large files easily. Some file-sharing services provide advanced link sharing features like password protection, link expiration, authorization to view, edit, download a file. Following…
  • Functional Dependency in DBMS: What is, Types and Examples
    What is Functional Dependency? Functional Dependency (FD) is a constraint that determines the relation of one attribute to another attribute in a Database Management System (DBMS). Functional Dependency helps to maintain the quality of data in the database. It plays a vital role to find the difference between good and bad…
  • PostgreSQL BETWEEN Query with Example
    BETWEEN Operator in PostgreSQL The PostgreSQL BETWEEN Operator helps in retrieving values within a range in SELECT, UPDATE, INSERT, or DELETE statement. With the BETWEEN operator, it is possible to match a value against a range of values. In this PostgreSQL Between Operator tutorial, you will learn: PostgreSQL Between Query…
  • SQLite String Functions: REPLACE, SUBSTR, TRIM, ROUND
    SQLite is by default equipped with a list of built-in functions within the SQLite library. You can also add some other custom functions using the C language to extend the core functions. In this tutorial, you will learn- Finding LENGTH of a String in SQLite UPPER Function and LOWER Function…
  • SQL FOREIGN KEY: How to Create in SQL Server with Example
    What is a FOREIGN KEY? A Foreign Key provides a way of enforcing referential integrity within SQL Server. In simple words, foreign key ensures values in one table must be present in another table. Rules for FOREIGN KEY NULL is allowed in SQL Foreign key. The table being referenced is…
  • How to Send Large Video Files from iPhone | Android | Email
    Sending a large file to other people is difficult since most of the email service providers have put restrictions on the size of the attachment. Most of the email providers allow you to send only a 25MB file in the attachment. Therefore, if you want to send large size video…
  • CASE Statement in Oracle PL/SQL with Examples
    What is CASE Statement? A CASE statement is similar to IF-THEN-ELSIF statement that selects one alternative based on the condition from the available options. CASE statement uses “selector” rather than a Boolean expression to choose the sequence. The value of the expression in the CASE statement will be treated as…
  • MySQL INSERT INTO Query: How to add Row in Table (Example)
    What is INSERT INTO? INSERT INTO is used to store data in the tables. The INSERT command creates a new row in the table to store data. The data is usually supplied by application programs that run on top of the database. Basic syntax Let’s look at the basic syntax…
  • Oracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF
    What are Decision-Making Statements? Decision making statements are those who will decide the flow-control of SQL statements based on the conditions. It gives the programmer a better control of preventing a particular code from executing (diagram 1) or choosing a desired code based on the condition (diagram 2). Below is…
  • SQL PRIMARY KEY: How to Create & Add to Existing Table
    What is Primary Key in SQL? Primary Key is a field or a combination of fields that identify a record uniquely. The Primary key is a column or set of columns that are unique. In other words, every value is unique for Primary Key. Rules for Primary Key Each table…
  • DBMS Keys: Candidate, Super, Primary, Foreign Key Types with Example
    What are Keys in DBMS? KEYS in DBMS is an attribute or set of attributes which helps you to identify a row(tuple) in a relation(table). They allow you to find the relation between two tables. Keys help you uniquely identify a row in a table by a combination of one…
  • SQLite Trigger, Views & Index with Example
    In the daily use of SQLite, you will need some administrative tools over your database. You can also use them to make querying the database more efficiently by creating indexes, or more reusable by creating views. In this tutorial, you will learn – View Index Trigger SQLite View Views are…
  • MySQL WHERE Clause: AND, OR, IN, NOT IN Query Example
    What is WHERE Clause in MySQL? WHERE Clause in MySQL is a keyword used to specify the exact criteria of data or rows that will be affected by the specified SQL statement. The WHERE clause can be used with SQL statements like INSERT, UPDATE, SELECT, and DELETE to filter records…