Tagged: sql guide

SQL Tutorial 5: Data Definition Language 0

SQL Tutorial 5: Data Definition Language

SQL Tutorial 5: Data Definition Language 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...

SQL Tutorial 4: Database Fundamentals 0

SQL Tutorial 4: Database Fundamentals

SQL Tutorial 4: Database Fundamentals and SQL Language Elements i) Database Fundamentals ii) SQL Language Elements ————————- i) Database Fundamentals • Database Server instance contains multiple databases • Database contains multiple Tables • Table contains...

SQL Knowledge For Software Testers 0

SQL Knowledge For Software Testers

SQL Knowledge For Software Testers Basics of the SELECT Statement  In a relational database, data is stored in tables. An example table would relate Social Security Number, Name, and Address: EmployeeAddressTable SSN FirstName LastName...

SQL Queries and Sub Queries 0

SQL Queries and Sub Queries

SQL Queries and Sub Queries SQL Queries: The SQL queries are the most common and essential SQL operations. Via an SQL query, one can search the database for the information needed. SQL queries are...

SQL Functions 0

SQL Functions

SQL Functions Function is a database object in Sql Server. Basically it is a set of sql statements that accepts only input parameters, perform actions and return the result. Function can return only single...

SQL Operators 0

SQL Operators

SQL Operators An operator is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform operation(s), such as comparisons and arithmetic operations. Operators are used to specify conditions...

SQL Data Types 0

SQL Data Types

SQL Data Types Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase may have a significant impact on...

SQL Queries 0

SQL Queries

SQL Queries SQL Expressions: An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. SQL EXPRESSIONs are like formulas and they are written in query...

SQL Guide 0

SQL Guide

SQL Step Step Guide SQL Introduction (SQL History, Purpose of SQL, SQL Language Elements, and Subsets of SQL, Data Definition Language, Data Manipulation Language, and Data Control Language) Overview on Databases (Introduction to Data,...

Data Control Language 0

Data Control Language

Data Control Language (DCL): These SQL commands are used to implement security on database objects like table, view, stored procedure etc. DCL commands are used to enforce database security in a multiple user database...