SQL Functions

SQL Functions

SQL Functions, Structured Query Language Fundamentals, Aggregate Functions, String Functions, Date & Time Functions, and SQL Scalar functions. SQL Built-in Functions A function is a database object in Sql Server. Basically, it is a set of SQL statements that accepts only input parameters, performs actions and returns the result. The function can return only a … Read more

Introduction to Databases

Introduction to Databases

Introduction to Databases, DBMS, RDBMS, Database Engine, Database Records & Tables, SQL Database Management Systems, and NoSQL Databases. Introduction to Databases What is a Database? : A database is a systematic collection of data. Databases support the storage and manipulation of data. Databases make data management easy. They do so through the use of tables. … Read more

Database Testing Fundamentals

Database Testing Fundamentals

Database Testing Fundamentals, Introduction to SQL, DBMS, RDBMS, Data, Database, Record, Data Integrity, and SQL & NOSQL Database Testing. Database Testing Fundamentals 1) What is Data? Collection of Information or collection of raw facts 2) What is Database? It is a collection of related data 3) What is DBMS? Database Management System, It has different … Read more

Database Fundamentals

Database Fundamentals

Relational Database Fundamentals, Database Object, What is Database?, Database server, Database Management System, and Types of Databases. SQL or Relational Database Fundamentals for Database Developers, Database Administrators, and Database Testers. Database Fundamentals 1. What is Data? In computing, data is information that has been translated into a form that is efficient for movement or processing. … Read more

SQL Queries for Software Testers

SQL Queries for Software Testers

SQL Queries for Software Testers, Database Fundamentals, Database Engine Installation, SQL Language Elements, Data Definition Language, Data Manipulation Language, and Data Control Language. SQL Views, SQL Keys, SQL Indexes, and Database Normalization. SQL Queries for Software Testers Create the following Tables: LOCATION Location_ID Regional_Group 122 NEW YORK 123 DALLAS 124 CHICAGO 167 BOSTON   DEPARTMENT … Read more

SQL Operators

SQL Operators

SQL Tutorial, SQL Language Elements, Arithmetic operators, Comparison operators, Logical operators, and usage of operators in SQL statements. SQL Operators An operator is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform an operation(s), such as arithmetic, comparisons, and Logical operations. Operators are used to specifying conditions in … Read more

Data Manipulation Language

Data Manipulation Language

SQL – Data Manipulation Language Data Manipulation Language (DML) is one of the Subsets of SQL, others are, i. Data Definition Language ii. Data Control Language etc… Database Engine is required to practice/execute SQL Commands, We can use Database Engine from Oracle or MS SQL Server or MySQL etc, I installed MS SQL Server Express … Read more

Data Definition Language

Data Definition Language

Data Definition Language, SQL Fundamentals, Subsets of SQL, Create a Database, Use Database, Drop Database, Create a Table, and Drop a Table. Data Definition Language (DDL) SQL (Structured Query Language) is for Database Developers, Database Administrators, and Database testers. Three main subsets of SQL: i) Data Definition Language ii) Data Manipulation Language iii) Data Control … Read more

SQL Overview

SQL Overview

SQL Overview, SQL Environment Setup, Subsets of SQL, SQL Syntax, Data Types, Operators, Functions, SQL SELECT, SQL Joins, and SQL Statements, SQL Overview SQL Overview, SQL (Structured Query Language) is a standard language for accessing databases. All Relational Database Management Systems like MS Access, MS SQL Server, Oracle, Sybase, MySQL, DB2 use SQL as standard … Read more