This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
new:data_tools [2016/08/25 14:43] ca |
new:data_tools [2016/08/25 15:01] (current) ca |
||
---|---|---|---|
Line 1: | Line 1: | ||
=====Data Tools===== | =====Data Tools===== | ||
* wherein the process of analyzing data from different perspectives and summarizing it into useful information take place. | * wherein the process of analyzing data from different perspectives and summarizing it into useful information take place. | ||
+ | * Uploading of **Master File** take place. | ||
* Data Tools" is a vast domain, yet there are a fairly small number of foundational requirements when developing with or managing data-centric systems. Data management, whether by a developer working on an application, or an administrator maintaining or monitoring a production system, should provide a consistent, highly usable environment that works well with associated technologies. | * Data Tools" is a vast domain, yet there are a fairly small number of foundational requirements when developing with or managing data-centric systems. Data management, whether by a developer working on an application, or an administrator maintaining or monitoring a production system, should provide a consistent, highly usable environment that works well with associated technologies. | ||
Line 6: | Line 7: | ||
* //**Graphical User Interface (GUI)**, is a type of user interface that allows users to interact with electronic devices through graphical icons and visual indicators such as secondary notation, instead of text-based user interfaces, typed command labels or text navigation. GUIs were introduced in reaction to the perceived steep learning curve of command-line interfaces (CLIs),[1][2][3] which require commands to be typed on a computer keyboard.The actions in a GUI are usually performed through direct manipulation of the graphical elements// | * //**Graphical User Interface (GUI)**, is a type of user interface that allows users to interact with electronic devices through graphical icons and visual indicators such as secondary notation, instead of text-based user interfaces, typed command labels or text navigation. GUIs were introduced in reaction to the perceived steep learning curve of command-line interfaces (CLIs),[1][2][3] which require commands to be typed on a computer keyboard.The actions in a GUI are usually performed through direct manipulation of the graphical elements// | ||
* //**Structured Query Language (SQL)** consists of a data definition language, data manipulation language, and Data Control Language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements.// | * //**Structured Query Language (SQL)** consists of a data definition language, data manipulation language, and Data Control Language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements.// | ||
+ | * //** CSV Files** is a **Comma Separated Values File**, which allows data to be saved in a table structured format. CSVs look like a garden-variety spreadsheet but with a **.csv** extension (Traditionally they take the form of a text file containing information separated by commas, hence the name). CSV files can be used with any spreadsheet program, such as Microsoft Excel, Open Office Calc, or Google Spreadsheets. They differ from other spreadsheet file types in that you can only have a single sheet in a file, they can not save cell, column, or row styling, and can not save formulas.// | ||
+ | ***__What can I use CSVs for?__**//In e-commerce, CSVs are used primarily for importing and exporting product, customer, and order information to and from your store.// |