×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

SQL for beginners

Track :

Programming

Lessons no : 37

For Free Certificate After Complete The Course

To Register in Course you have to watch at least 30 Second of any lesson

Join The Course Go To Community Download Course Content

What will you learn in this course?
  • Write and execute basic SQL queries to retrieve and update data in relational databases using SQL syntax and commands
  • Design simple database schemas and create tables with appropriate data types and constraints using SQL
  • Apply filtering, sorting, and aggregation techniques to analyze data effectively with SQL queries
  • Utilize SQL joins and subqueries to combine and retrieve data from multiple tables efficiently
  • Implement data manipulation operations such as INSERT, UPDATE, and DELETE to manage database records
  • Use SQL functions and expressions to perform calculations and data transformations within queries
  • Identify and resolve common SQL errors and optimize query performance for faster data retrieval
  • Create and manage database objects like indexes, views, and stored procedures to enhance database functionality
  • Understand and apply best practices for writing clean, efficient, and maintainable SQL code
  • Interpret SQL execution plans to troubleshoot and improve query performance in relational databases
  • Secure database data by implementing user permissions and access controls using SQL commands
  • Develop practical skills for real-world database management, reporting, and data analysis with SQL

How to Get The Certificate

  • You must have an account Register
  • Watch All Lessons
  • Watch at least 50% of Lesson Duration
  • you can follow your course progress From Your Profile
  • You can Register With Any Course For Free
  • The Certificate is free !
Lessons | 37
01 SQL Full course for beginners | Introduction
00:01:50

01 SQL Full course for beginners | Introduction
02 SQL Full course for beginners | What is SQL
00:02:56

02 SQL Full course for beginners | What is SQL
03 SQL Full course for beginners | What is MySQL How does it Differ from SQL
00:02:10

03 SQL Full course for beginners | What is MySQL How does it Differ from SQL
04 SQL Full course for beginners | Installation in Mac Windows and Linux Machines
00:02:34

04 SQL Full course for beginners | Installation in Mac Windows and Linux Machines
05 SQL Full course for beginners | Possible XAMPP Installation Problem
00:03:36

05 SQL Full course for beginners | Possible XAMPP Installation Problem
06 SQL Full course for beginners | What is DB and Table
00:02:25

06 SQL Full course for beginners | What is DB and Table
07 SQL Full course for beginners | How to create DB and Tables
00:05:51

07 SQL Full course for beginners | How to create DB and Tables
08 SQL Full course for beginners | Add Data with INSERT
00:03:44

08 SQL Full course for beginners | Add Data with INSERT
09 SQL Full course for beginners | See Data with SELECT
00:01:37

09 SQL Full course for beginners | See Data with SELECT
10 SQL Full course for beginners | LIMIT
00:01:45

10 SQL Full course for beginners | LIMIT
11 SQL Full course for beginners | Conditions with WHERE clause
00:02:28

11 SQL Full course for beginners | Conditions with WHERE clause
12 SQL Full course for beginners | Modify Data with Update
00:02:15

12 SQL Full course for beginners | Modify Data with Update
13 SQL Full course for beginners | Table structure change with ALTER
00:04:24

13 SQL Full course for beginners | Table structure change with ALTER
14 SQL Full course for beginners | AND as well as OR Clause
00:03:56

14 SQL Full course for beginners | AND as well as OR Clause
15 SQL Full course for beginners | Sort result using ORDER BY Clause
00:03:22

15 SQL Full course for beginners | Sort result using ORDER BY Clause
16 SQL Full course for beginners | IN Clause
00:02:19

16 SQL Full course for beginners | IN Clause
17 SQL Full course for beginners | Find Patterns in Data with LIKE Clause
00:04:05

17 SQL Full course for beginners | Find Patterns in Data with LIKE Clause
18 SQL Full course for beginners | Selecting specific Fields Columns
00:01:20

18 SQL Full course for beginners | Selecting specific Fields Columns
19 SQL Full course for beginners | DISTINCT
00:01:46

19 SQL Full course for beginners | DISTINCT
20 SQL Full course for beginners | ALIAS
00:02:55

20 SQL Full course for beginners | ALIAS
21 SQL Full course for beginners | Datatypes
00:03:47

21 SQL Full course for beginners | Datatypes
22 SQL Full course for beginners | Constraints
00:02:52

22 SQL Full course for beginners | Constraints
23 SQL Full course for beginners | Creating base for Future Lectures
00:04:45

23 SQL Full course for beginners | Creating base for Future Lectures
24 SQL Full course for beginners | Relational Databases
00:08:41

24 SQL Full course for beginners | Relational Databases
25 SQL Full course for beginners | What is a FOREIGN KEY Constraint
00:07:37

25 SQL Full course for beginners | What is a FOREIGN KEY Constraint
26 SQL Full course for beginners | What are JOINS
00:00:48

26 SQL Full course for beginners | What are JOINS
27 SQL Full course for beginners | LEFT JOIN
00:07:42

27 SQL Full course for beginners | LEFT JOIN
28 SQL Full course for beginners | RIGHT JOIN
00:02:01

28 SQL Full course for beginners | RIGHT JOIN
29 SQL Full course for beginners | INNER JOIN
00:01:35

29 SQL Full course for beginners | INNER JOIN
30 SQL Full course for beginners | UNION
00:02:23

30 SQL Full course for beginners | UNION
31 SQL Full course for beginners | MySQL Functions
00:04:42

31 SQL Full course for beginners | MySQL Functions
32 SQL Full course for beginners | GROUP BY Clause
00:02:07

32 SQL Full course for beginners | GROUP BY Clause
33 SQL Full course for beginners HAVING Clause
00:01:36

33 SQL Full course for beginners HAVING Clause
34 SQL Full course for beginners| What are VIEWS and how to Create Them
00:02:32

34 SQL Full course for beginners| What are VIEWS and how to Create Them
35 SQL Full course for beginners| ALTER and DROP VIEWS
00:01:54

35 SQL Full course for beginners| ALTER and DROP VIEWS
36 SQL Full course for beginners| DELETE data from tables
00:01:16

36 SQL Full course for beginners| DELETE data from tables
37 SQL Full course for beginners | TRUNCATE Tables DROP Tables and Database
00:01:04

37 SQL Full course for beginners | TRUNCATE Tables DROP Tables and Database

Recommended Courses



MySQL For Beginners
18 Lessons

MySQL For Beginners

PostgreSQL for Beginners
25 Lessons

PostgreSQL for Beginners

SQL for Beginners till Advanced
8 Lessons

SQL for Beginners till Advanced

PHP MYSQL for beginners
83 Lessons

PHP MYSQL for beginners

NoSQL for Beginners
10 Lessons

NoSQL for Beginners

PLSQL for Beginners
4 Lessons

PLSQL for Beginners

Window Functions in MySQL for Beginners
6 Lessons

Window Functions in MySQL for Beginners

PostgreSQL for beginners
12 Lessons

PostgreSQL for beginners

Oracle SQL for beginners
8 Lessons

Oracle SQL for beginners



We Appreciate Your Feedback

Be the First One Review This Course

Excellent
0 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
0
0 Reviews
Mamoun Elrayah Mohamed

5 2022-01-28

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

Related Courses

React Projects Workshops
33 Lessons

React Projects Workshops

Node js back end JavaScript
34 Lessons

Node js back end JavaScript

Python programming language
15 Lessons

Python programming language

Social Network Theme UI With Sass
4 Lessons

Social Network Theme UI With Sass

Full Stack React Django
7 Lessons

Full Stack React Django

Build a Node js App With Sequelize
3 Lessons

Build a Node js App With Sequelize

GraphQL With React Apollo
4 Lessons

GraphQL With React Apollo

Node js REST API With Restify Mongoose JWT
2 Lessons

Node js REST API With Restify Mongoose JWT

Full Stack Vue js Express MongoDB
3 Lessons

Full Stack Vue js Express MongoDB

Exploring Docker
3 Lessons

Exploring Docker

Responsive Portfolio Website
7 Lessons

Responsive Portfolio Website

The MERN Stack
12 Lessons

The MERN Stack

PHP REST API High level
3 Lessons

PHP REST API High level

Up unning With Symfony 4
3 Lessons

Up unning With Symfony 4

JavaScript Workshops
3 Lessons

JavaScript Workshops

PHP MySQL Stripe API Payment App
3 Lessons

PHP MySQL Stripe API Payment App

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.