Structured Query Language
The Structured Query Language is one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex, but it's not all that difficult.
SQL comes in many flavors. Oracle databases use its proprietary PL/SQL. Microsoft SQL Server makes use of Transact-SQL. All of the variations are based upon the industry standard ANSI SQL. This introduction uses ANSI-compliant SQL commands that work on any modern relational database system.
DDL and DML SQL commands can be divided into two main sub-languages. The Data Definition Language (DDL) contains the commands used to create and destroy databases and database objects. After the database structure is defined with DDL, database administrators and users can use the Data Manipulation Language (DML) to insert, retrieve and modify the data contained within it.
Common Tasks of a Database Administrator: The organizations need professionals (DBA’s) who can keep their data is very secure, always available to the applications, generating the backup time to time and well-managed. With this being said, here are the most common tasks that DBA will perform.
- Install and Upgrade/Migrate the SQL Server
- Understand the Functioning of Databases
- Security Administration in SQL Server
- Database Backup’s and Recovery
- Automation of Regular Tasks
- Query Performance Tuning
- High Availability Technologies: Log shipping, Database Mirroring, Replication, Clustering and AlwaysOn Availability Groups
- Resource Monitoring on SQL Server.