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 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 executed with the “SELECT” statement. An SQL query can be more specific, with the help of several clauses like FROM – … 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

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, Databases, Table, and Records. Types of Database Management Systems, and Relational Database Management System. Overview of Oracle RDBMS, MS SQL Server, … 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