Posts

What is SQL?(Structured Query Language)

Image
  Sql is a programming language use for storing data, information and records. SQl is like a creating a table which put record in that and select waht data types etc. You can also use SQL commands like this is the basic Command in Sql: The INSERT,DELETE,UPDATE,DROP,SELECT,WHERE etc. You can also use SQL to maintain and optimize database performance. This is SQL DATABASE Tables Lookslike in Software Application called Microsoft Access: Why SQL is important? Structured query language (SQL) is a popular query language that is frequently used in all types of applications. Data analysts and developers learn and use SQL because it integrates well with different programming languages. For example, they can embed SQL queries with the Java programming language to build high-performing data processing applications with major SQL database systems such as Oracle or MS SQL Server. SQL is also fairly easy to learn as it uses common English keywords in its statements. So how can you create databa...
Post a Comment
Read more

Functions, Advantages, and Disadvantages of Database Management System(DBMS)

Image
     1.Data Dictionary Management, Data Dictionary Management is the one of the most important function of database management system. DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary. 2.Data Storage Management,      Data storage management is also important for database performance tuning.              Performance tuning relates to the activities that make the database perform more         efficiently in terms of storage and access speed. So, the data storage                             management is another important function of Database Management                             System. 3.Data Transformation and Presentation, The DBMS transforms entered data in to required dat...
Post a Comment
Read more