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

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