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

Related Courses

MS Office

Upcoming Courses

Course curriculum

Tabular Format

  1. Tabular introduction
  2. Table architecture: rows and tables
  3. Constraints
    1. Data type
    2. Primary key
    3. Unique
  4. Relationship between tables
    1. Using primary key
    2. Using foreign key

Comma Separated Value(CSV)

  1. CSV and Storage
  2. CSV architecture
    1. Each Object is one line
    2. Fields are separated with comma
    3. Files might be enclosed in double quotes
    4. Front and back end white spaces will be ignored
  3. CSV with leading zeros on numeric field
  4. CSV Mime type
  5. CSV field embedded with space, comma and quote

Extensible Markup Language (XML)

  1. XML and its usage
  2. XML Element
    1. Tags
    2. Tag name
    3. Attributes and values
    4. Text
  3. XML tree
    1. Root element
    2. Parent element
    3. Siblings
    4. Element
    5. Child
  4. XML syntax and rules
    1. First line must show xml prolog
    2. Must have root element
    3. Each element must have closing tag
    4. Tags are case sensitive
    5. Must be properly nested
    6. Element values must be coated
    7. Entity references: $lt; is for “<”
    8. Comment
    9. White space is preserved
  5. XML Namespaces
    1. Name conflict
    2. Using Prefix
    3. Using xmlns Attribute
    4. URI for xmlns
  6. XML Display
    1. On different browsers
    2. Uses "+" and "-" signs
    3. Valid and invalid xml displays
  7. XML XSLT, XPath, XLink
  8. XML Validator: DTD and Schema
  9. XML with PHP, ASP and Database
  10. XML Applications

JavaScript Object Notation(JSON) Tutorial

  1. JSON and JSON Structure
    1. Data name: value pair
    2. Data separated by comma
    3. Curly braces handle objects
  2. JSON object notation
  3. With String, int, boolean and Array
  4. 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.