SQL Data -data can be facts related to any objects in consideration. Eg- age, video, other data, tweets, messages, posts, photos Database -database is systematic collection of data which support storage and manipulation of data in easy way. Eg- telephone directory, power generation, contacts in our phone, social media Why we need a database? Managing large data is a hassle. Accuracy of the data. Difficult to track accuracy in spreadsheet. Ease of data upload. Data security. Data Integrity. Introduction to DBMS Collection of programs that enables enables its users to access database, manipulate data, reporting/ representation of data. SQL -one of the standard language for dealing with relational databases which can be used to create, read, update and delete database records. What is a relational database? A relational database is a type of database that stores and provides access to data points that are related to one another. Data organised in tables. We map data so...
Comments
Post a Comment