What you'll learn

You will learn about the basics of SQL, the data types and basic SQL statements.
You will learn about basic SQL queries, such as how to select, insert, update, and delete data in databases.
You will learn about advanced SQL queries, such as how to use Joins, Constraints, Triggers, Stored Procedures and Functions
By the end of this training, you will be able to manage databases, writing queries and generate reports.

Course content

16 sections • 49 lectures • 3h 4m total length

Introduction of the Instructor6:16
Who is Sanem Aydın Yayla? What is her profession and expertise?

SELECT Command3:47
In this lesson, you are going to learn how to use SELECT command which is used to fetch data from a table.
How to create a table by using management console interface5:18
In this lesson, you are going to learn how to create a table by using functionalities of management console interface.
INSERT Command7:31
In this lesson, you are going to learn how to use INSERT command which is used to insert new data in a table.
UPDATE Command2:52
In this lesson, you are going to learn how to use UPDATE command which is used to update the value of a column in a table.
DELETE Command1:33
In this lesson, you are going to learn how to use DELETE command which is used to delete one or more rows from a table.
WHERE Command3:27
In this lesson, you are going to learn how to use WHERE command which is used to retrieve selected data based on some conditions which are described using the WHERE clause.
AND Command4:04
In this lesson, you are going to learn how to use AND command. AND command is used in queries where there is more than one condition. In conditional propositions containing the AND command, both conditions must be satisfied for the proposition to be true.
OR Command2:50
In this lesson, you are going to learn how to use OR command. OR command is used in queries where there is more than one condition. In conditional propositions containing OR operator, at least one of the conditions should be met for the proposition to be true.
AS Command2:45
In this lesson, you are going to learn how to use AS command. AS is the abbreviation of ALIAS. It is used to give nicknames to the column in a table.
IN Command2:43
In this lesson, you are going to learn how to use IN command.
LIKE Command3:30
In this lesson, you are going to use how to learn LIKE command. After learning this command, writing queries will have more fun.
BETWEEN Command2:45
In this lesson, you are going to learn how to use BETWEEN command.
DISTINCT Command2:49
In this lesson, you are going to learn how to use the DISTINCT command. When the Distinct command is used, the data becomes free from duplicate records and includes only the unique values.
ORDER BY Command2:41
In this lesson, you are going to learn how to use the ORDER BY command. By using this command, you will be able to sort your results in ascending or descending order.

NOT NULL Constraint5:25
In this lesson, you are going to learn how to use the NOT NULL constraint. This constraint specifies that this column cannot store a NULL value
UNIQUE Constraint3:37
In this lesson, you are going to learn how to use the UNIQUE constraint. This constraint specifies that this column can have only Unique values, i.e. the values cannot be repeated in the column.
CHECK Constraint2:07
In this lesson, you are going to learn how to use the CHECK constraint. This constraint validates if all values in a column satisfy some particular condition or not.
DEFAULT Constraint3:35
In this lesson, you are going to learn how to use the DEFAULT constraint. This constraint specifies a default value for a column when no value is specified for that field.
PRIMARY KEY Constraint3:46
In this lesson, you are going to learn how to use the PRIMARY KEY constraint. It is a field using which it is possible to uniquely identify each row in a table.
FOREIGN KEY Constraint6:25
In this lesson, you are going to learn how to use the FOREIGN KEY constraint. It is a field using which it is possible to uniquely identify each row in some other table.

Requirements

No programming knowledge is required. You will learn everything you need to know.
A PC or Mac
Internet connection

Description

SQL is a programming language designed for managing data in relational database management systems (RDBMS). SQL is used to perform tasks such as creating, reading, updating, and deleting data in databases. It can also be used to query data and generate reports.

SQL is a powerful language that can be used to manage large amounts of data. It is also relatively easy to learn, making it a good choice for beginners.

If you are interested in learning SQL, this training program is for you. It will teach you the basics of SQL and how to use it to manage data in databases. By the end of this tutorial, you will be able to:

Create and manage databases
Insert, update, and delete data in databases
Query data and generate reports

This tutorial is divided into three parts:

In Part 1, you will learn about the basics of SQL, including the different types of data that can be stored in databases, the different types of SQL statements, and the basic syntax of SQL.

In Part 2, you will learn about basic SQL queries, such as how to select, insert, update, and delete data in databases.

In Part 3, you will learn about advanced SQL queries, such as how to use joins, functions, constraints, and stored procedures to query data in complex ways.

This training program is designed for beginners, but it also includes some advanced topics for those who want to learn more about SQL.

If you are interested in learning SQL, I encourage you to take this tutorial. It is a great way to learn the basics of SQL and how to use it to manage data in databases.

Here are some of the benefits of learning SQL:

SQL is a widely used language, so there are many job opportunities available for SQL developers.
SQL is a relatively easy language to learn, so you can start using it to manage data in databases right away.
SQL is a powerful language that can be used to manage large amounts of data.
SQL is a versatile language that can be used in a variety of different industries.

I hope this article has aroused your curiosity about SQL. If you are interested in learning more, I encourage you to start this program today.

Who this course is for:

Anyone interested in learning SQL and Databases

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

Introduction to SQL Programming1 lecture • 2min

How to Install MS SQL Server1 lecture • 2min

How to Log In to SQL Management Studio1 lecture • 4min

Database Transactions3 lectures • 8min

Table Transactions1 lecture • 6min

Main SQL Commands14 lectures • 49min

Mathematical Functions2 lectures • 9min

String Functions3 lectures • 6min

Constraints6 lectures • 25min

Requirements

Description

Who this course is for: