• Basics for freshers

    SQL server basics for beginners

      In this article, I am going to discuss about the basics of SQL server which is helpful for newbies. SQL–Structured Query Language (pronounced as SEQUEL) is a Database, computer language designed for managing data in relational database management system (RDBMS). Most of the people have to know SQL server query has designed for set based (declarative) . The SQL commands are   DQL (Select) DML (Insert, Update, Delete) DDL (Create, Alter, Drop, Truncate) DCL (Grant, Revoke, Deny) TCL (Commit, Rollback)   Database A Database stores all the data information (like objects) and has the default data file and log file. The data file is called mdf, ndf…. (One-mdf,more than one…