Android apps to use in appium android test examples

Breaking

Wednesday, June 20, 2018

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 Types
• Operators
• Functions
• Clauses
• Expressions
• Queries
• Statements 

6) SQL Data Types
• Exact Numeric Data Types
• Approximate Numeric Data Types
• Data & Time Data Types
• Character String Data Types
• Binary Data Types
• Other Data Types

7) SQL Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Operators used to negate conditions

8) SQL Functions
• Aggregate Functions
• String Functions
• Date Functions

9) Subsets of SQL
• Data definition Language
• Data Manipulation Language
• Data Control Language
for these ii scenarios SQL Knowledge is mandatory SQL Brochure
10) Data definition Language
• Create Databases, Tables
• Alter Databases, Tables
• Drop
• Truncate
• Comment
• Rename

11) Data Manipulation Language
• Select
• Insert
• Update
• Delete

12) Data Control Language
• Grant
• Revoke
• Deny

13) SQL Keys
• Super Key
• Primary Key
• Foreign Key
• Composite Key
• Unique Key
• Alternate Key

13) SQL Queries
• Expressions
• Clauses
• Sub Queries

14) SQL Joins
• Self Join
• Inner Join
• Outer Join
• Cross Join

15) SQL Views
• Create Views
• Modify Views
• Drop Views
• Advantages & Disadvantages of Views

16) Normalization
• First Normal Form
• Second Normal Form
• Third Normal Form
• Boyce in addition to Codd Normal Form (BCNF)

17) SQL Security

18) Database Development

19) Database Testing

20) Database Administration (DBA)
---------------------------------------------------------
Note: SQL is for Database Developers, Database Testers, in addition to Database Administrators.

Database Testing tin strength out survive done inwards ways,
1) Manual Testing
2) Automated Testing,
for these ii scenarios SQL Knowledge is mandatory. 
---------------------------------------------------------------
Also Read:

SQL Interview Questions in addition to Answers

SQL Tutorials

Sumber http://www.gcreddy.com/

No comments:

Post a Comment