freeskillacademy
46 subscribers
58 photos
38 links
This is the official channel for freeskillacademy.com
Download Telegram
Lesson 8 is added to the SQL tutorial.
In this lesson, you will learn about the most used types of data in SQL:
https://freeskillacademy.com/tutorials/sql/data-types
Lesson 9 is added to the SQL tutorial.
In this lesson, you learn how to select a database using SQL Commands:
https://freeskillacademy.com/tutorials/sql/select-database
Lesson 10 is added to the SQL tutorial.
In this lesson, you will learn how to create a table using SQL commands:
https://freeskillacademy.com/tutorials/sql/create-table
Lesson 11 is added to the SQL tutorial.
In this lesson, you will learn how to delete a table using SQL commands:
https://freeskillacademy.com/tutorials/sql/drop-table
Lesson 12 is added to the SQL tutorial.
In this lesson, you will learn how to insert records in a database table using SQL commands:
https://freeskillacademy.com/tutorials/sql/insert-into
Lesson 13 is added to the SQL tutorial.
In this lesson, you will learn how to create an auto-increment field using SQL Commands:
https://freeskillacademy.com/tutorials/sql/auto-increment
Lesson 14 is added to the SQL tutorial.
In this lesson, you will learn how to select records from a database table using SQL commands:
https://freeskillacademy.com/tutorials/sql/select
Lesson 15 is added to the SQL tutorial.
In this lesson, you will learn how to give an alias name for the returned columns:
https://freeskillacademy.com/tutorials/sql/aliases
Lesson 16 is added to the SQL tutorial.
In this lesson, you will learn how to concatenate data (strings, numbers, date etc..) as a one string:
https://freeskillacademy.com/tutorials/sql/concatenation
Lesson 17 is added to the SQL tutorial.
In this lesson, you will learn how to select specific records from a database table using SQL commands:
https://freeskillacademy.com/tutorials/sql/where
Lesson 18 is added to the SQL tutorial.
In this lesson, you will learn how to sort selected records using SQL commands:
https://freeskillacademy.com/tutorials/sql/order-by
Lesson 19 is added to the SQL tutorial.
In this lesson, you will learn how to remove duplicated rows from a result set.
https://freeskillacademy.com/tutorials/sql/distinct
Lesson 20 is added to the SQL tutorial.
In this lesson, you will learn how to modify or update the existing data in the table:
https://freeskillacademy.com/tutorials/sql/update
Lesson 21 is added to the SQL tutorial.
In this lesson, you will learn how to modify or update the existing data in the table:
https://freeskillacademy.com/tutorials/sql/delete
Lesson 22 is added to the SQL tutorial.
In this lesson, you will learn how to set the maximum number of records that can be returned when retrieving records from a database table using SQL:
https://freeskillacademy.com/tutorials/sql/limit
👍1
Lesson 23 is added to the SQL tutorial.
In this lesson, you will learn how to combine the results of two or more select statements:
https://freeskillacademy.com/tutorials/sql/union
Lesson 24 is added to the SQL tutorial.
In this lesson, you will learn how to create mandatory fields, how to check whether the field is null or not and how you can replace NULL values:
https://freeskillacademy.com/tutorials/sql/null-values