Posts

    SQL--Standard Query Language.       It is standard language for relational database management system developed by Microsoft. It is standard language for storing,manipulating and retrieving the data in database. Some common relational database management systems that uses SQL are:  Oracle,My SQL, Access,etc.  Database- It is compiler for all SQL object like tables,stored procedures,triggers,functions,etc. Two types of Database- 1. System Database   2. User Defined Database. System Databases are -   Master   ( in which predefined objects which can be used to achieve some functionalities )   , Msdb ( report services like Email ) ,  Model ( structure which we get or table or any other objects ) , Tempdb ( it is temporary tables ).    User defined Database - which we created in our application. To work in SQL we have two different ways: Graphical Way-  In SQL Sever Graph database to  help simplify the process of modeling data that contain complex many-to-many and hierarchical relations
Recent posts