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

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

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 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 • Hierarchical Model • Network Model • Relational Model 4) SQL Syntax 5) Overview of SQL Language Elements • Identifiers • Data … Read more

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 Address City State 512687458 Joe Smith 83 First Street Howard Ohio 758420012 Mary Scott 842 Vine Ave. Losantiville Ohio 102254896 Sam … Read more

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 the efficiency, performance and storage requirements of your database. SQL data type is an attribute that specifies type of data of … Read more

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 language. You can also use them to query the database for specific set of data. Syntax: Consider the basic syntax of … Read more

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 environment. Only Database Administrator’s of the database object can provide/remove privileges on a database object. Different DCL statements are • Grant … Read more