What is SQL?
SQL (Structured Query Language) is the primary language responsible for manipulating data within a relational database management system. There are four basic operations that SQL can perform, these are sometimes referred to as CRUD operations - create, read, update, delete). SQL is a bit like other programming languages in that you have to learn the ‘code’ to make use of it much like other popular languages you may of heard of such as Ruby, C, Python etc. Day to day, SQL is used to retrieve data from different tables in databases, and then combine it together to create reports. It has a pretty simple syntax, and, almost anyone can start using SQL to create reports within a few minutes.
Learn SQL right now, with SQL tutorial app which provide freely by Kiwi Lab!
What are some database concepts?
A database, in simplest terms, is an organized collection of data. A database is comprised of many tables, and a table stores rows of data in a structured format defined by the table's columns. This represents the basic hierarchy of a database. When writing SQL queries, you are interacting with rows of data stored in tables contained within a database.
This SQL tutorial covers SQL-related topics, such as:
• Database Basics
• Key SQL Statements
• Retrieving, Updating, and Filtering Data
• Functions and Sub-queries
• Creating, Updating, and Deleting Tables
• Joining Multiple Tables
Audience
This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages.
Practice your SQL knowledge with SQL quiz of this app.
Become a SQL expert by learning with Kiwi Lab.