Tagged: sql guide

SQL Brochure

SQL Brochure

Software Testing Videos (Manual, Selenium, UFT, SQL, and Java) SQL Brochure 1) SQL Introduction • History • Purpose 2) Database Fundamentals • Data • Database • Table • Record 3) Database Management Systems •...

SQL Tutorial 5: Data Definition Language

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

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

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

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

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

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

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

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

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,...