Udemy

Platform

English

Language

Web Development

Category

The Complete SQL Course 2021: Become a MYSQL Master

This complete SQL bootcamp will take you from beginner to master

4.00 (1093 reviews)

Students

2.5 hours

Content

Apr 2021

Last Update
Regular Price

EXCLUSIVE SKILLSHARE OFFER
Exclusive  SkillShare  Offer
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

Learn how to create and deal with databases

Learn CRUD operations and how to use them to make use out of your database

Grasp the concept of SQL clauses, functions, data types

How to write simple to complex SQL queries


Description

You will learn to write SQL queries like a pro by building a real-world blog database

Here is a list of some of the things you will get after this course:


How to create your first database

How to create and delete your tables

How to perform CRUD operations

How to use SQL complex constraints

Running your first query

learn how to use Alters to tweak your columns and tables

learn and perform functions

create and understand complicated joins and unions and more..


More Specifically :

1-create database

2-create and deleting tables

3-insert

4-update and delete

5-data types

6-Conditional & comparison operators

7-basic queries

8-constraints (primary key, foreign key, and indexes)

9-functions (SUM-MIN-AVG-MAX-COUNT)

10-clauses (WHERE, ORDER by, DISTRICT, IN, GROUP By,)

11-alters

12-aliases

13-joins (INNER-RIGHT-LEFT)

14-UNIONS

15-wild cards

16-views

17-creating functions

18-triggers


Pretty cool huh? I hope you are ready for this journey :)




Screenshots

The Complete SQL Course 2021: Become a MYSQL Master
The Complete SQL Course 2021: Become a MYSQL Master
The Complete SQL Course 2021: Become a MYSQL Master
The Complete SQL Course 2021: Become a MYSQL Master

Content

Introduction

Introduction

2-Xampp (PHPmyadmin)installation

Getting Started With Databases

3-Creating a database

4-Creating tables

5-More about tables

6-Inserting into tables

7-Updating and deleting

8-Data types

9-Conditional and comparison operators

Constraints

10-Primary keys

11-Foreign keys

12-Indexes

13-Unique indexes

SQL Functions

14-Functions part one

14-Functions part two

SQL Clauses

16-Basic queries and where claueses

17-Order by

18-Distinct

19-In

20-Group by

Alters

21-Alters part one

22-Alters part two

23-Alters part three

All About Joins and SQL Relations

24-Aliases

25-Inner joins

26-Left and right joins

27-Unions

Wild Cards

28-Wild cards part one

29-Wild cards part two

More Advanced Areas of SQL

30-Views

31-Creating functions

32-Triggers


Reviews

Z
ZAKZI15 December 2020

The sound is so disturbing and not clear and also it feels like the person who made this course didn't enjoy making it or he made it while he was sleeping and instead of "SQL" he's sayin "CQL"

H
HET9 December 2020

It's very interesting and very well taught. Understood each and every topic now I'm confident about SQL.

B
Bisera7 December 2020

I am not very satisfied by the amount of information provided since the description was, become master, you are far below master with this course, but for the basics to be understood it would be enough

D
Daniel7 November 2020

Well, I have SQL knowledge, maybe that's why the course felt a bit long (even though I saw it in 2x speed) but I learned a lot. I will not say that the course is perfect and deserves 5 stars. But I feel that buying it is not a good idea, perhaps at a discount, or when it is free, as I got it.

S
Sankararaja18 October 2020

The way the instructor communicates is very difficult to understand . He must talk a bit louder and focus on the pronounciation of the words. I don't know how others feels regarding this ,but it is really difficult for me to understand his pronounciation of the words. Other than that, I am okay with the content.

M
Mohamed30 September 2020

instructor has good knowledge but need to focus on his language as many times i lost my concentration and also need to provide more examples and area to practice and dedicate section for quiz

K
Krzysztof24 September 2020

super slow talking, wish i could speed it up, also wish there was example of SQL in use, like for real, not the basic stuff..

T
Trupti21 September 2020

This course is really helpfull for me thank u sir. And all topics which are mentioned and teached by sir is very understandable thank you so much sir..?

M
Minette20 September 2020

The tutorial is really helpful.. Speaker is very detailed and informative. He even gives other examples. I am a beginner with just some familiarity before starting the course but now, I have better understanding and more confidence. One comment that I am not sure if you will like it, but I think this is worth telling. Since his way of teaching is actual samples, I like the fact that even a master can commit errors when making query and just needs good logical thinking to fix it. That scenario teaches me not to be afraid - I do not need to be perfectly good even before doing MySQL. Salute to the mentor.. Salute to Udemy. Thank you very much.

S
Shailesh20 September 2020

He has covered all the main topics in very short video. Explained very well. Recommended for beginners

İ
İdri̇s8 August 2020

Adam o kadar sıkıcı anlatıyor ki hayatımda hiç bu kadar sıkılmamıştım. The teacher is so boring. When I try to listen and learn something, teacher's boring voice preventing me.

C
Cletus4 August 2020

The person or instructor was reading like he was forced to do so. It is my opinion and it can be wrong.

N
Neeraj16 July 2020

concepts are not in detail and the voice is not clear and louder , it seems like the instructoor is talking with himself

M
Md7 July 2020

Yes it is good match for me and thank you so much my teacher who learns me a lot.. I m grateful to here and learns a lot..

N
Nirmal28 June 2020

Pretty straight to codes. (plus point) Sound is many times unclear.(minus point) Had to depend on subtitle which is still many times meaningless.(minus point) Basic knowledge opposite to what is titled.(minus point) compared to my past online course on same topic from courseera.(plus point)


Coupons

DateDiscountStatus
6/23/2020100% OFFExpired
7/2/2020100% OFFExpired
7/9/2020100% OFFExpired
8/2/2020100% OFFExpired
9/18/2020100% OFFExpired
10/14/2020100% OFFExpired
11/14/2020100% OFFExpired
12/6/2020100% OFFExpired
2/5/2021100% OFFExpired

3150550

Udemy ID

5/20/2020

Course created date

6/23/2020

Course Indexed date
Lee Jia Cheng
Course Submitted by

Twitter
Telegram