SQLite is a small, compact, a self-contained, embedded and high reliable database. SQLite is not client-server database. Unlike other SQL databases, SQLite does not have a separate server process. SQLite is cross platform and supports various platforms like Windows, Linux, Android etc. Getting started You can download it for the popular OS platforms at: https://sqlite.org/download.html […]
MySQL Community Server is the world’s most popular open source database. It is licensed and provided under the GPL License.In this article, we will learn the steps to download and install MySQL Communityserver on Windows 10 operating system. Download Steps Download url: https://dev.mysql.com/downloads Browse the download url and click on the download button. […]
In this tutorial, we will learn basic steps involved working with MySQL command line. The most basic way to work with MySQL is connecting to the database from the command prompt. You need to connect to a database to create tables ,view data etc. Let’s see how to connect to MySQL and run a sample […]
Sub query also called as inner query is used to return a value to the outer or the main query. There are two types of sub queries. Nested Sub-query Nested sub-query is executed first and its results are inserted in the WHERE clause of the outer main query. Subqueries can be single row or multiple […]
In this post, I will walk through some basic MySQL commands used in database testing. Create Table To create a table, you must use the CREATE TABLE command and specify the table name and fields. The following command creates the department: CREATE TABLE department ( dept_name char(20) NOT NULL, dept_number numeric(1) NOT NULL, mgrSSN numeric(9) […]
SQL(Structured Query Language) pronounced either as sequel or S.Q.L is a query language used to communicate and interact with a relational database like Oracle, MySQL etc. SQL has rules of grammar and syntax like normal English and can be easily understood. Features of SQL SQL is not merely a query language. It can also be […]
In this post, We would setup sample schema with samples tables in Oracle database. You will learn how to create an Oracle DB user, tables and insert data into tables. SCOTT is a database user whose schema is used for Oracle demo.
In this post, we will discuss about different types of SQL statements and SQL Questions for Beginners frequently asked during testing interviews. What is SQL? SQL is an acronym for Structured Query Language. It is a structured query language for Relational Database Management Systems (RDBMS). It is a data language for creating/manipulating/processing data & metadata […]