Introduction to SQL

duyenntm7

37013 students

4.3 (241 votes)

This course will help programmers to understand the principles, syntax and how SQL (Structured Query Language) works .

Time 20 hours

Number of tasks 91

Reward Certificate

Free

Please login to continue

Introduction to the database

1 2 3 4 5 6 7 8 9 10

Initialization of the table

11 12 13 14 15 16 17 18 19

Knowing the constraints

20 21 22 23 24 25 26

Modification of the data

27 28 29 30 31 32 33 34 35 36

Database normalization

37 38 39 40 41 42 43

Query of the data

44 45 46 47 48 49 50 51 52 53 54

Filtering data

55 56 57 58 59 60 61 62 63 64 65

Joining multiple tables

66 67 68 69 70 71 72 73 74 75

Grouping data

76 77 78 79 80 81 82 83 84 85 86 87

Subquery

88 89 90 91

SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.

Why to Learn SQL?

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.

Prerequisites

Before you start practicing with various types of examples given in this tutorial, I am assuming that you are already aware about what a database is, especially the RDBMS and what is a computer programming language.

Web Tour