SQL

Description

Mind Map on SQL, created by 10jharris on 30/04/2015.
10jharris
Mind Map by 10jharris, updated more than 1 year ago
10jharris
Created by 10jharris over 9 years ago
27
0

Resource summary

SQL
  1. SELECT - get data from a database table
    1. The code usually used in databases
      1. UPDATE - change data in a database table
        1. DELETE - remove data from a database table
          1. INSERT INTO - insert new data in a database table
            1. ORDER BY - order column name in either ascending (ASC) or descending (DESC) order
              1. AND/OR - can join two or more conditions in a WHERE clause
                1. GROUP BY - aggregate functions can return a result grouped by column values
                  Show full summary Hide full summary

                  Similar

                  SQL Quiz
                  R M
                  Midterm 2 (Chapter 5 - 13)
                  Yorria Raine
                  SQL Quiz
                  Chris Cronin
                  Database Final Exam
                  dbm
                  Coding Quiz
                  ryanseaborne
                  Technical Proposal (continued)
                  Rebbecca Stanley
                  Microsoft Virtual Academy - SQL Server Basics
                  chrisburford
                  Chapter 4 Key Terms
                  Stephanie Spearman
                  Tipos de bases de datos
                  Jeffrey Bedoya
                  Databases
                  Alex Baine
                  SQL language
                  Gildardo Cortes Gallo