About the program
What will I learn?
In this lesson you will learn Tabular, CSV, JSON and XML formats, and their applications:
- Why and how to present data in object format
- Architecture and syntax of Tabular, CSV, JSON, XML
- Their difference and strength in different applications
- To convert data from one format to another
Audience:
Manager, BA, Tester or anyone who is interested to use XML/JSON/CSV for data storage and transfer.
Contact US
Call us : +1-800-543-5571
Mail us : training@infotek-solutions.com
Course curriculum
Tabular Format
- Tabular introduction
- Table architecture: rows and tables
- Constraints
- Data type
- Primary key
- Unique
- Relationship between tables
- Using primary key
- Using foreign key
Comma Separated Value(CSV)
- CSV and Storage
- CSV architecture
- Each Object is one line
- Fields are separated with comma
- Files might be enclosed in double quotes
- Front and back end white spaces will be ignored
- CSV with leading zeros on numeric field
- CSV Mime type
- CSV field embedded with space, comma and quote
Extensible Markup Language (XML)
- XML and its usage
- XML Element
- Tags
- Tag name
- Attributes and values
- Text
- XML tree
- Root element
- Parent element
- Siblings
- Element
- Child
- XML syntax and rules
- First line must show xml prolog
- Must have root element
- Each element must have closing tag
- Tags are case sensitive
- Must be properly nested
- Element values must be coated
- Entity references: $lt; is for “<”
- Comment
- White space is preserved
- XML Namespaces
- Name conflict
- Using Prefix
- Using xmlns Attribute
- URI for xmlns
- XML Display
- On different browsers
- Uses "+" and "-" signs
- Valid and invalid xml displays
- XML XSLT, XPath, XLink
- XML Validator: DTD and Schema
- XML with PHP, ASP and Database
- XML Applications
JavaScript Object Notation(JSON) Tutorial
- JSON and JSON Structure
- Data name: value pair
- Data separated by comma
- Curly braces handle objects
- JSON object notation
- With String, int, boolean and Array
- JSON with http, php, java, ajax
Meet your mentor
About Trainer Rahul:
- 7 years of IT experience in software testing, quality assurance and quality management, web apps development.
- Experienced in leading and managing medium to large testing teams.
- Have extensively trained participants in the areas of Software Testing Concepts, Quality Assurance, Quality Center, QTP, LoadRunner, Bugzilla, JIRA and Selenium.
- Testing process owner at the organization I have worked.
- Have mentored resources and helped set a career path and achieve testing certifications.
