The Complete SQL Course 2020: Become a MYSQL Master
3.9 (391 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
43,947 students enrolled

The Complete SQL Course 2020: Become a MYSQL Master

This complete SQL bootcamp will take you from beginner to master
New
3.9 (391 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
43,947 students enrolled
Created by Web Coding
Last updated 7/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 32 lectures 02:34:20
+ Introduction
2 lectures 14:00
2-Xampp (PHPmyadmin)installation
05:26
+ Getting Started With Databases
7 lectures 19:37
3-Creating a database
01:47
4-Creating tables
03:22
6-Inserting into tables
02:47
7-Updating and deleting
03:40
8-Data types
03:05
9-Conditional and comparison operators
03:31
+ Constraints
4 lectures 17:54
10-Primary keys
05:09
11-Foreign keys
06:36
12-Indexes
03:11
13-Unique indexes
02:58
+ SQL Functions
2 lectures 05:54
14-Functions part one
02:20
14-Functions part two
03:34
+ SQL Clauses
5 lectures 23:19
16-Basic queries and where claueses
04:20
17-Order by
02:47
18-Distinct
04:39
19-In
04:24
20-Group by
07:09
+ Alters
3 lectures 14:03
21-Alters part one
03:25
22-Alters part two
05:22
23-Alters part three
05:16
+ All About Joins and SQL Relations
4 lectures 22:50
24-Aliases
04:26
25-Inner joins
07:07
26-Left and right joins
05:38
27-Unions
05:39
+ Wild Cards
2 lectures 11:26
28-Wild cards part one
06:49
29-Wild cards part two
04:37
+ More Advanced Areas of SQL
3 lectures 25:17
30-Views
08:45
31-Creating functions
07:28
32-Triggers
09:04
Requirements
  • Just a computer
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 :)



Who this course is for:
  • Anyone interested in learning SQL, MYSQL for software engineering, data analysis or big data