Register Login

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


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 ...

  • How to solve “Column 'user_id' in field list is ambiguous” error?
    While working with tables in SQL and trying to fetch some data, you might have come across the Column 'user_id' in field list is ambiguous” error. In this post, we will take a closer loo ...

  • 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 ...

  • Conversion failed when converting date and/or time from character string
    Data type conversion, in specific cases, is one of the common errors users get while working with any programming language. In SQL Server, they often face the error "Conversion failed when conver ...

×