- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Amrendra Patel has Published 36 Articles
Amrendra Patel
1K+ Views
Data Definition Language(DDL) is used for describing data and its relationship in a database. It is also used to define the database schema. The commands only affect the database structure and not the data. The main DDL commands are create, alter, drop and truncate. Create Statement It is used to ... Read More
Amrendra Patel
598 Views
DCL(Data Control Language) work is to deal with sql commands that are used to permit a user to access, modify and work on a database. it is used to access stored data. It gives access, revoke access and change the permission to the owner of the database as per the ... Read More
Amrendra Patel
578 Views
Data replication means copying the data at multiple locations to improve the availability of data. It is used to remove the inconsistency between the same data which results in a distributed database so that users can do their own task without interrupting the work of other users. There are various ... Read More
Amrendra Patel
11K+ Views
Data preprocessing is an important process of data mining. In this process, raw data is converted into an understandable format and made ready for further analysis. The motive is to improve data quality and make it up to mark for specific tasks. Tasks in Data Preprocessing Data cleaning Data ... Read More
Amrendra Patel
590 Views
Data Objects Data objects refers to a collection of various attributes which are combined to make it understandable. Data object values have their own unique id, attribute and data types. The most common type is the data table. Data objects are mostly represented in data models, which resolve with the ... Read More
Amrendra Patel
403 Views
Data modeling refers to the process of handling and designing the data model within a data warehouse platform. It consists of making an appropriate database schema so as to transfer the data that can be stored and of useful to user. Data warehouse modeling is used for two reasons, first ... Read More
Amrendra Patel
3K+ Views
Data Mining The process of extracting the data from a huge dataset that can be used for analysis and benefit of the organisation. This process helps in identifying patterns and managing relationship among the data to predict business problems. Data attributes An attribute can be defined as characteristics or property ... Read More
Amrendra Patel
2K+ Views
The process of extracting the data from a huge dataset that can be used for analysis and benefit of the organization. Data mining process generally involves the following steps − Business understanding Business understanding and client objective is necessary. Clients needs are to be defined and then using the scenario, ... Read More
Amrendra Patel
3K+ Views
Association rule mining helps us to find relationships among large dataset. In Multidimensional association, Multidimensional association rule comprises of more than one aspect Numeric attributes should be discretized. Attributes can be unmitigated or quantitative. Quantitative characteristics are numeric and consolidate pecking order. Three approaches in mining multidimensional association ... Read More
Amrendra Patel
121 Views
Data mart is a storage component and only cares about some specific functional area of an organisation which are then taken care by a single department like marketing, sales, finance etc. Data Mart and Data Warehouse are both storage components of HDFS. Data Mart contains a subset of the data ... Read More
To Continue Learning Please Login
Login with Google