Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

The Complete SQL Course 2021: Become a MYSQL Master

person icon Web Coding

3.9

The Complete SQL Course 2021: Become a MYSQL Master

This Complete SQL Bootcamp will Take you From Beginner to Master

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Web Coding

English [CC]

category icon Development,Databases,SQL

Lectures -33

Duration -2.5 hours

3.9

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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 :)

Goals

What will you learn in this course:

  • Learn how to create and deal with databases
  • Grasp the concept of SQL clauses, functions, data types
  • How to write simple to complex SQL queries

Prerequisites

What are the prerequisites for this course?

  • Just a computer
The Complete SQL Course 2021: Become a MYSQL Master

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures
  • play icon Introduction 08:34 08:34
  • play icon Installing Xampp 05:26 05:26
Getting Started With Databases
7 Lectures
Tutorialspoint
Constraints
4 Lectures
Tutorialspoint
SQL Functions
2 Lectures
Tutorialspoint
SQL Clauses
5 Lectures
Tutorialspoint
Alters
3 Lectures
Tutorialspoint
All About Joins and SQL Relations
4 Lectures
Tutorialspoint
Wild Cards
2 Lectures
Tutorialspoint
More Advanced Areas of SQL
3 Lectures
Tutorialspoint

Instructor Details

Web Coding

Web Coding

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515