SQL Course For Beginners: Learn SQL Using MySQL Database

7.206 estudiantes inscritos

SQL Course For Beginners: Learn SQL Using MySQL Database

Learn SQL From Scratch Using MySQL Databases, A Complete SQL Course For Beginners

7.206 estudiantes inscritos

Creado por Ashutosh Pawar

Fecha de la última actualización: 4/2020

Inglés

Inglés [automático]

Vista previa de este curso

SQL Course For Beginners: Learn SQL Using MySQL Database

135,99 € 194,99 € 30 % de descuento

¡Esta oferta termina en 5 horas!

Garantía de reembolso de 30 días

4,5 horas de vídeo bajo demanda
15 artículos
Acceso de por vida completo
Acceso en dispositivos móviles y TV

Certificado de finalización

Training 5 or more people?

Dale a tu equipo acceso a más de 4.000 de los mejores cursos de Udemy en cualquier momento y lugar.

Prueba Udemy for Business

Lo que aprenderás

Understand why databases are used.
How to write SQL queries to insert, update and delete data into database.
How to write SQL queries to manipulate data.
How to write complex SQL queries to obtain useful information from the database

+ – Introduction to the course

In this section we will have a brief introduction to the course. We will have an overview of the things which we are going to learn in this course.

Introduction to the course

Vista previa 03:11

+ – Introduction to SQL and Databases

In this lecture we will learn what are databases and why do we need databases and also what is SQL and why we need SQL while dealing with databases.

What are databases and why do we need them

Vista previa 05:19

In this lecture we will have a brief overview of SQL.

Introduction To SQL

Vista previa 01:43

+ – Installing required softwares to get us started

Installation steps for Windows users

05:41

Installation steps for Mac users

05:07

In this lecture we will learn how to install the required tools on MAC operating system.

Installation steps for MAC

01:14

In this lecture we will learn how to install the required tools on Linux operating system.

Installation steps for Linux

00:37

+ – Database Creation & The Select Statement.

11 clases 46:31

In this lecture we will learn how to create a new database in MYSQL.

Creating a new database

05:19

In this lecture we will learn how to create a table in database.

Creating a table in database

05:57

In this lecture we will learn how to insert data into the database.

Inserting Data Into Table

Vista previa 05:01

In this lecture we will learn how to use the select clause in SQL to retrieve data from database.

Using the SELECT clause

04:36

In this lecture we will learn about the select distinct clause and also learn the difference between the select clause and the select distinct clause.

Using the SELECT DISTINCT clause

03:27

In this lecture we will learn about the where clause and learn why and when is the where clause used.

Using the WHERE clause

03:14

In this lecture we will learn what is a true condition in SQL.

True condition

02:45

In this lecture we will learn what is a false condition in SQL

False condition

03:24

This quiz will test your basic knowledge about SQL.

Quiz 1: Introduction To SQL

3 preguntas

This is the coding challenge part 1 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.

Coding Challenge Part -1

03:08

This is the solution to coding challenge part 1

Coding Challenge Part-1 Solution

Vista previa 09:16

This lecture contains the summary for section 3

Summary & Notes For Section 3

00:24

+ – SQL Operators

10 clases 38:58

In this lecture we will learn what is AND operator in SQL and when exactly is the AND operator used.

SQL AND Operator

04:29

In this lecture we will learn what is OR operator in SQL and when exactly is the OR operator used.

SQL OR Operator

03:21

In this lecture we will learn what is Like operator in SQL and when exactly is the Like operator used.

SQL LIKE Operator

05:02

In this lecture we will learn what is Between operator in SQL and when exactly is the Between operator used.

SQL Between Operator

02:44

In this lecture we will learn what is Concat operator in SQL and when exactly is the Concat operator used.

SQL CONCAT Operator

04:09

In this lecture we will learn what is Numeric operator in SQL and when exactly is the Numeric operator used.

SQL Numeric Operator

03:41

In this lecture we will learn what is Comparison operator in SQL and when exactly is the Comparison operator used.

SQL Comparision Operator

02:56

This is a quiz which will test what you have learned in the current section.

Quiz 2: Test What you have learned in this section

4 preguntas

This is the coding challenge part 3 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.

Coding Challenge Part-3

02:39

This is the solution to coding challenge part 3

Coding Challenge Part-3 Solution

09:15

This lecture contains the summary and notes for section 4

Summary & Notes For Section 4

00:42

+ – Insert, Update And Delete

In this lecture we learn how to use the insert statement in SQL to insert data into the database.

Inserting data using the Insert

05:31

In this lecture we will learn about the insert into select statement and also learn what is the significance of this statement.

Insert into select statement

05:09

In this lecture we will learn how to use the update statement to update the data in the table.

Updating data using Update

04:41

In this lecture we will learn how to delete data using the delete statement in SQL.

Deleting data using delete

03:58

This is a quiz which will test what you have learned in the current section.

Quiz 3

4 preguntas

This is the coding challenge part 4 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.

Coding Challenge Part-4

02:30

This is the solution to coding challenge part 4

Coding Challenge Part-4 Solution

05:59

This lecture contains summary and notes for section 5

Summary & Notes For Section 5

00:14

+ – SQL Joins

In this lecture we will learn what are joins and and what are the different types on joins in SQL

Introduction to Joins

08:45

In this lecture we will learn what is an inner join and how to perform an inner join in SQL

Inner Join

03:45

In this lecture we will learn what is an left outer join and how to perform an inner join in SQL

Left Outer Join

05:00

In this lecture we will learn what is an right outer join and how to perform an inner join in SQL

Right Outer Join

04:00

In this lecture we will learn what is an full outer join and how to perform an inner join in SQL

Full Outer Join

04:58

In this lecture we will learn what is an cross join and how to perform an inner join in SQL

Cross Join

03:07

This is a quiz which will test what you have learned in the current section.

Quiz 4

4 preguntas

This is the coding challenge part 5 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.

Coding Challenge Part-5

00:29

This is the solution to coding challenge part 5

Coding Challenge Part-5 Solution

02:12

This lecture contains summary and notes for section 6

Summary & Notes For Section 6

00:40

+ – Built In SQL Functions

12 clases 43:20

In this lecture we will learn what is Average function in SQL.

SQL AVG() Function

04:21

In this lecture we will learn what is a count function in SQL and how to use the count function to calculate total number of rows in a table.

SQL Count() Function

03:54

In this lecture we will learn what is a Min function in SQL and how it can be used to find the minimum value from a particular column in a table.

SQL Min() Function

03:50

In this lecture we will learn what is a Max function in SQL and how it can be used to find the maximum value from a particular column in a table.

SQL Max() Function

02:15

In this lecture we will learn what is a sum function in SQL and how it can be used to find the sum of a particular column in a table.

SQL Sum() Function

03:13

In this lecture we will learn what is the ucase function in SQL and how it can be used in SQL.

SQL Ucase() Function

03:05

In this lecture we will learn what is the lcase function in SQL and how it can be used in SQL.

SQL Lcase() Function

02:29

In this lecture we will learn what is the MID function in SQL and how it can be used in SQL.

SQL Mid() Function

04:12

In this lecture we will learn what is the len function in SQL and how it can be used in SQL.

SQL LEN() Function

02:36

This is a quiz which will test what you have learned in the current section.

Quiz 5

5 preguntas

This is the coding challenge part 6 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.

Coding Challenge Part-6

03:07

This is the solution to coding challenge part 6

Coding Challenge Part-6 Solution

10:00

This lecture contains summary and notes for section 7

Summary & Notes For Section 7

00:18

+ – Constrains In SQL

In this lecture we will learn what are constrains in SQL and why constrains are needed.

Constrains In SQL

02:17

In this lecture we will learn what is a not null constrain in SQL

Not Null Constrain In SQL

05:17

In this lecture we will learn what is the unique constrain in SQL

Unique Constrain In SQL

04:50

In this lecture we will learn what is a primary key in SQL

Primary Key Constrain In SQL

03:00

In this lecture we will learn what is a foreign key in SQL.

Foreign Key Constrain In SQL

04:26

In this lecture we take an example to understand the concept of foreign key in a much more better way.

Foreign Key Example

07:52

In this lecture we will learn what is a default constrain in SQL

Default Constrain In SQL

03:42

In this lecture we will learn what is auto increment

Auto Increment Constrain In SQL

03:55

This is a quiz which will test what you have learned in the current section.

Quiz 6

5 preguntas

This section contains summary and notes for section 8

Summary & Notes For Section 8

00:55

+ – Practice Examples

10 clases 40:57

Practice Example Part 1

00:13

Practice Example Part 1 Solution

09:33

Practice Example Part 2

00:15

Practice Example Part 2 Solution

08:20

Practice Example Part 3

00:09

Practice Example Part 3 Solution

06:04

Practice Example Part 4

00:12

Practice Example Part 4 Solution

04:30

Practice Example Part 5

00:17

Practice Example Part 5 Solution

11:23

1 secciones más

Requisitos

No coding, or technical knowledge required.
A computer with internet connection.
No paid tools are required as the tools required for this course are free.
Passion and curiosity to learn someting new.

Descripción

SQL Course For Beginners: Learn SQL Using MySQL Database

Here Is What You Get By Enrolling In This Course:

Word-By-Word Explanation: In the entire course, I explain each line of code, without skipping a single line of code.

Practice Examples: Special set of practice examples included at the end of each section.

Awesome Quality Content: Over 5+ hours of HD(1080p) Videos.

Well Structured & Easy To Learn: Course has been specially designed to make it easy for the students to learn SQL.

24 X 7 Support: I will always be there to guide you in your journey to become SQL expert.

Note: Student queries and problems will be answered immediately.

_________________________________________________________________________

Here Is Everything You Will Learn In This Complete Course:

What are databases and why databases are used.

What is SQL and how it can be used to manipulate data into database.

What are the different types of data definition queries used to create tables.

What are the different types of data manipulation queries which can be used to manipulate data.

We first begin the course with the basic introduction about databases and understand what exactly are databases and why they are used. We then learn how to install the required tools which will allow us to create our own databases and add data into it.

Moving along, we learn some SQL operators, and we also learn how these operators can be used in SQL queries which allows us to form more complex queries.

Moving along we learn how SQL statements can be used to insert, update and delete data into the database. Once it is done, we move forward to learn about joins and learn what are different types of joins.

Once we complete each and every concept in SQL, we finally have a set of practice examples, which will allow you to practice SQL queries on your own.

_________________________________________________________________________

So let's begin the journey of becoming an expert in SQL.

In addition to the Udemy 30-day money back guarantee,you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!

_________________________________________________________________________

Make sure to enroll in the course before the price changes.

Take yourself one step closer towards becoming a professional SQL developer by clicking the "take this course button" now!

Join the journey.

Sincerely,

Ashutosh Pawar

¿Para quién es este curso?

Beginners who want to learn SQL.
Database developers and database administrators.
Mobile application developers.
Web developers.
Students who wish to learn a new skill to develop their career.