VTS

Agile methodology is Iterative and incremental method of software development

VTS Technocrats

Query to delete duplicate records from department column of emp table

delete from emp where rowid not in ( select max( rowid) from emp group by deptno);

VTS Technocrats

What is text mining?

It is getting the useful text and removing other text.

ex: Ram is going to Mumbai.

After Text mining-Ram going Mumbai—here is to is removed.

So any adjective, punctuation of words, etc Words which are not required without them also meaning is clear those words are removed and are called as text mining.

VTS Technocrats

What would be the first validate while doing ETL testing?

1. The first thing would be to structure the table.(column name ,index,constraint and data type etc)

2. Then data of table and Business logic associated.

VTS Technocrats

ETl Testing

ETL Testing is all about extracting the data from the source system(like flat file, excel,xml and DB, etc), transforming the data as per business logic, and then loading the data into the target. And then testing the data from source and target is matching or not.

VTS Technocrats

SQl Syllabus

Constraint-pk,fk,unique,check and null

Data Type-Number,charater,date

Operator-arithmatical,logical,relational,pattern matching,range operator

SQL Statements-Dml,ddl,tcl,dcl,dql/drl

Select-group by,having ,where ,order by

Subquery-single row subquey,multi row subquery

Corelate Query

Joins-self,equi/inner,non-equi, outer join-left outer join, right outer join and full outer join, natural join, zig-zag join

Normalization-1st,2nd,3 rd normal form

Functions-number function,character function,date function,special function

Rownum

Rowid

Rank and Dense rank function

Views and Indexes

Difference between Stored procedure and Function

Learnings

VTS

VTS Technocrats

Query to delete duplicate records from department column of emp table

VTS Technocrats

What is text mining?

VTS Technocrats

What would be the first validate while doing ETL testing?

VTS Technocrats

ETl Testing

VTS Technocrats

SQl Syllabus

VTS Technocrats