Basic SQL Tutorials

Tutorials Shared by the Internet Community

Advertisements
  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 46 Tutorials

gap line

Most Recent Tutorials


  • How to find duplicate rows in a table in MySQL and Orac

    Many times, we need to find out duplicate records in a table. This article shares couple of SQL queries, which we can use to find duplicate rows. thes
    http://javarevisited.blogspot.com/2012/12/how-to-find-duplicate-records-in-table-mysql-que...
  • Inner Join of three tables in SQL MySQL Oracle Server

    INNER JOIN is used to fetch data from multiple tables in one query, it helps to save database round trips, but getting data from more than two tables
    http://javarevisited.blogspot.com/2012/11/how-to-join-three-tables-in-sql-query-mysql-sqls...
  • Attach MDF file to the SQL database without LDF file

    Attaching .mdf file to the SQL database without .ldf file is a easy task but need attention. No matter SQL server shutdown properly or not.
    http://sqldbfriend.blogspot.in/2013/02/need-to-attach-mdf-file-without.html
    • 34196 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • Correlated vs Noncorrelated Subquery example in SQL

    Main difference between Correlated and Noncorrelated subquery is that, Correlated subquery depends upon Outer query and can not execute by its own whi
    http://javarevisited.blogspot.com/2012/07/subquery-example-in-sql-correlated-vs.html
  • Dont delete truncate your tables in SQL

    Dont Delete , truncate it. If you are working in a huge table you need to be very very careful while executing any query because due to large data an
    http://javarevisited.blogspot.com/2011/10/how-to-use-truncate-and-delete-command.html
  • SQL Select Statement

    Learn the fundamental commands of SQL: Select From.
    http://www.1keydata.com/sql/sqlselect.html
    • 32524 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • SQL Exercises

    Tutorial mainly uses syntax constructions of SQL-92 standard. It will help you to master in wide and varied possibilities for formulating queries.
    http://www.sql-ex.ru/
    • 32665 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to Join Tables

    Learn how to join 2 tables together and display information from both tables as needed.
    http://www.sqltutorials.net/sql-joins/joining-tables.html
    • 32531 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • Inserting Data into SQL Tables

    Inserting data is at the heart of a database. Learn how to easily use the insert operator in SQL.
    http://www.sqltutorials.net/insert-into/inserting-data-into-sql-tables.html
    • 32513 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to Create Tables in SQL

    Creating tables is essential in SQL. Learn how to do this with step by step instructions.
    http://www.sqltutorials.net/sql-tables/sql-create-tables.html
    • 32531 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to Update, Change, and Delete in SQL

    Managing database requires three major things-update, change , and delete. Learn the steps to do this in SQL.
    http://www.sqltutorials.net/update-delete-data/updatechange-delete-data-query.html
    • 33721 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to Concantenate Strings

    Often times you have to combine output data in SQL, concatenation can be used for this.
    http://www.sqltutorials.net/concantenate/how-to-concantenate-strings.html
    • 32554 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to Use sql Aggregate Functions

    Want to find out the minimum or average on a given data? Learn to use SQLs aggregate function for this.
    http://www.sqltutorials.net/aggregate/how-to-use-sql-aggregate-functions.html
    • 32999 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to Use the Trim Function

    Sometimes with outputted data, comes unwanted white space. The trim function is used for this in SQL.
    http://www.sqltutorials.net/concantenate/how-to-use-the-trim-function.html
    • 32584 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc



Advertisements