Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

The Complete SQL Course 2020: Become a MYSQL Master

via Udemy

Overview

This complete SQL bootcamp will take you from beginner to master

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

You will learn to write SQLqueries 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 CRUDoperations

How to use SQLcomplex 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 :)



Taught by

Web Coding

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of The Complete SQL Course 2020: Become a MYSQL Master

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free