SQL / MySQL Masterclass For Complete Beginners

  • Post category:StudyBullet-7
  • Reading time:12 mins read


SQL course for complete beginners : MySql From Zero to Hero.. 90% OFF Coupon: 9E68BEC1B5C491D3376B

What you will learn

You will learn how to query a database in SQL

You will have detailed knowledge and understanding of using MySQL, one of the most used databases in the world.

You will code SQL to solve a variety of database problems, with applicability in IT industry projects

You will gain knowledge of SQL and MySQL, which will allow you to apply for jobs in the IT sector.

Description

Hello,

Getting here means you want to learn programming. You’ve come to the right place!

Why programming?

Because you earn well, the employment rate in the field is almost 100% or maybe just for fun.

We want to help you build a real experience in the field, not just learn a programming language.

When you are just starting out in IT and want to get a job, the most important thing is to prove to your employer that you are capable of producing for him.

If you bring added value to the employer, everything is fine, and our complete beginner course can help you do just that. You will learn how to read and write complex queries in a database using one of the most sought after skills. – MySQL.

Learning SQL is one of the fastest ways to improve your career prospects, as it is one of the most sought-after technological skills! In this course you will learn quickly and you will receive challenges along the way to improve your understanding!

In this course you will learn the basics of SQL without the need for prior knowledge of databases.

You will learn the basics of SQL syntax.

You will learn what databases are, tables, and how to use them.

You will learn how to create databases and tables.

You will learn to manipulate the structure of tables


Get Instant Notification of New Courses on our Telegram channel.


You will learn to modify existing tables.

You will learn to enter data in tables.

You will learn to read data from tables.

You will learn to modify existing data in tables.

You will learn how to delete data from tables.

You will learn what joins are and how to use them.

You will learn what aggregation functions are and how to use them

You will learn what triggers are and how to use them

You will learn what functions are stored and how they are used

You will learn what stored procedures are and how to use them

Upon completion of this course, you will have the skills to be able to use SQL with confidence, to have a solid understanding of MySQL and to be skilled in designing databases.

Success!

English
language

Content

Course presentation

What is a database?

Installing the necessary software

Installing the MySql Server & MySql Workbench

What is a database and what is a table?

MySql Databases
Tables

Data Types in SQL

Data Types
Quiz 1
Quiz 2

Creating databases and tables

CREATE DATABASE & CREATE TABLE – theory
CREATE DATABASE & CREATE TABLE – practice
Quiz 1
Quiz 2
Quiz 3

Modifying our table structure

ALTER TABLE : Modifying the structure of the tables – theory
ALTER TABLE : Modifying the structure of the tables – practice
Quiz 1
Quiz 2
Quiz 3

Inserting data into tables

INSERT : Inserting data in tables – theory
INSERT : Inserting data in tables – practice
Quiz 1
Quiz 2
Quiz 3

Unique Identifiers

PRIMARY KEY – theory
PRIMARY KEY – practice
AUTO_INCREMENT – theory
AUTO_INCREMENT – practice
Quiz1
Quiz 2
Quiz 3

Table specific SQL Keywords

NOT NULL – theory
NOT NULL – practice
UNIQUE – theory
UNIQUE – practice
DEFAULT – theory
DEFAULT – practice
Quiz 1
Quiz 2
Quiz 3

Reading data from tables

SELECT : Reading data from our tables – theory
SELECT : Reading data from our tables – practice
Quiz 1
Quiz 2
Quiz 3

Filtering the table data

WHERE – theory
WHERE – practice
AND & OR – theory
AND & OR – practice
IN – theory
IN – practice
BETWEEN – theory
BETWEEN – practice
LIKE – theory
LIKE – practice
DISTINCT – theory
DISTINCT – practice
COALESCE – theory
COALESCE – practice
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5
Quiz 6

Updating table data

UPDATE : modifying our table data – theory
Settings
UPDATE : modifying our table data – practice
Quiz 1
Quiz 2

Deleting the table data

DELETE & TRUNCATE – theory
DELETE & TRUNCATE – practice
Quiz 1
Quiz 2

Pagination and Order

LIMIT & OFFSET – theory
LIMIT & OFFSET – practice
ORDER BY – theory
ORDER BY – practice
Quiz 1
Quiz 2
Quiz 3
Quiz 4

Foreign keys

FOREIGN KEY – theory
FOREIGN KEY – practice
ON DELETE – theory
ON DELETE – practice
Quiz 1
Quiz 2
Quiz 3

Joins

INNER JOIN – theory
INNER JOIN – practice
LEFT JOIN – theory
LEFT JOIN – practice
RIGHT JOIN – theory
RIGHT JOIN – practice
FULL JOIN & UNION – theory & practice
Quiz 1
Quiz 2

SQL Aggregate Functions

COUNT – theory
COUNT – practice
SUM – theory
SUM – practice
MIN & MAX – theory
MIN & MAX – practice
AVG – theory
AVG – practice
GROUP BY – theory
GROUP BY – practice
Quiz 1
Quiz 2
Quiz 3

Triggers

TRIGGERS Part 1 – theory
TRIGGERS Part 2 – theory
TRIGGERS Part 3 – practice
TRIGGERS Part 4 – practice
TRIGGERS Part 5 – practice
Quiz 1

Stored Functions

STORED FUNCTIONS – theory
STORED FUNCTIONS – practice
CASE – theory & practice
Quiz 1
Quiz 2

Stored Procedures

STORED PROCEDURES – theory
STORED PROCEDURES & SUBSELECT – practice
STORED PROCEDURES Part 2 – practice
Quiz 1

What’s next?

What’s next
Enroll for Free

💠 Follow this Video to Get Free Courses on Every Udemy Topics! 💠

Tags: , ,