Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Home » SQL

SQL

What is SQL?

SQL full form or stands for Structured Query Language. It is a standard Database language used to create, maintain, retrieve or to deal with rational databases. In 1986 SQL became standard for ANSI (American National Standards Institute) and the next year in 1987 it became standard for ISO (International Organization for Standardization).

Uses of SQL

SQL can be used for the following:

  • Executing queries against a database
  • Retrieve data from a database
  • Insert records in a database
  • Delete and Update records in a database
  • Create  new record, tables or stored procedure in database

Advertisement

Tutorials

  • SQL Environment SetupSQL Environment Setup
    MySQL or Microsoft SQL Server Installation & DownloadThis tutorial explains SQL Environment setup, in order to practice skill commands, database engine is required. Any database engine oracle, MyS ...

  • Difference between ISQL Utility and DBISQL Utility
    ISQL Utility vs DBISQL UtilityISQL Utility Isql utility is command-line Interactive SQL utility which uses the Adaptive Server Enterprise Open Client API. Isql does not provide an option to create a u ...

  • Visual Studio Community Installation and First ProjectVisual Studio Community Installation and First Project
    This tutorial explains how to download, Install and make your first project on Visual Studio Community version.First, go to your Google chrome or any search engine & just enter Visual Studio Commu ...

  • Functionality- Wait Event Analysis For SQL Server
    FunctionalityAll functionality is accessible through report /SDF/RSMSSVSE.Collecting wait Event HistoryBy scheduling a background job, the user can collect SQL Server wait events. The default is conti ...

  • Usage- Wait Event Analysis For SQL Server
    UsageCollecting Wait Event History of the Local DatabaseThe user Runs the report /SDF/RSMSSVSE, by selecting 'Scheduling data collection'. In the upper portion of the screen, the default job c ...

  • Advertisement
Advertisement