> Code Storage: backend.

Code Storage

A Technical blog for those who want to gain knowledge about SQL,MySQL,Data Science and real time query

Responsive Ads Here

Advertisement

Showing posts with label backend.. Show all posts
Showing posts with label backend.. Show all posts

Monday, January 6, 2020

What is SQL.Purpose of SQL.Who should learn

SQL,Purpose,Learn,DBMS,RDBMS
                                                1. What is SQL and Purpose of SQL

Introduction of SQL
  • SQL stands for structured query language. SQL was initially developed at IBM is 1970s.  
  • SQL is the the standard language to communicate with relational database management system  like oracle,MS access,MS SQL server, Mysql,Db2,Sybase etc.SQL is a command based        language.
  •  SQL is domain specific not general purpose,used in design and management of data held in       RDBMS ( Relational database management system).
  •  SQL is a command based language.
  •  SQL lets you access and manipulate databases.
  •  SQL became a standard of the american national standard institute (ANSI) in 1986,and of the    international organization for standardization(ISO) in 1987.
Purpose of SQL 
  • SQL is used to create new database.
  • SQL is used to create new tables in a database.
  • SQL is used to insert records, update records,delete record in a database.
  • SQL is used to retrieve data from database.
  • SQL can set permission on tables procedures and views.
  • SQL is used to create stored procedures in a database.
  • SQL is used to create view in a database.
Who should learn SQL


  • Database Developers.
  • Database Admistrators.(DBA)
  • Database Testers.
Database Developers:
                                      Design and deploy database table structures,forms,reports,and queries.
Database Admistrators:
                                      Keeping database upto data and  managing database access.writing reports documentation and operating manulas.
Database Testers:
  1. Verify data Integrity ( completeness and correctness of data).
  2. Verify data Manipulation (Add,Update,Delete).
  3. Verify data Comparison (two database front end data with back end data).
                             

SEVER TYPE IN SSMS ( Sql Server Managment studio)

When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers ...