The Complete MySQL Bootcamp:From SQL Beginner to Expert-2023

The Complete MySQL Bootcamp:From SQL Beginner to Expert-2023, available at $89.99, has an average rating of 4.48, with 106 lectures, based on 431 reviews, and has 2325 subscribers.

You will learn about Create databases and interact with existing databases Write SQL queries and generate reports Use SQL for data analysis Start using MySQL (#1 according to the latest Stack Overflow Survey) Boost your resume with the most in-demand skill This course is ideal for individuals who are Web Developers or Python Developers or Java Developers or Business Analysts or Marketing Analysts or Data Science Specialists or Anyone working with databases and data analysis It is particularly useful for Web Developers or Python Developers or Java Developers or Business Analysts or Marketing Analysts or Data Science Specialists or Anyone working with databases and data analysis.

Enroll now: The Complete MySQL Bootcamp:From SQL Beginner to Expert-2023

Summary

Title: The Complete MySQL Bootcamp:From SQL Beginner to Expert-2023

Price: $89.99

Average Rating: 4.48

Number of Lectures: 106

Number of Published Lectures: 105

Number of Curriculum Items: 106

Number of Published Curriculum Objects: 105

Original Price: $74.99

Quality Status: approved

Status: Live

What You Will Learn

Create databases and interact with existing databases
Write SQL queries and generate reports
Use SQL for data analysis
Start using MySQL (#1 according to the latest Stack Overflow Survey)
Boost your resume with the most in-demand skill

Who Should Attend

Web Developers
Python Developers
Java Developers
Business Analysts
Marketing Analysts
Data Science Specialists
Anyone working with databases and data analysis

Target Audiences

Web Developers
Python Developers
Java Developers
Business Analysts
Marketing Analysts
Data Science Specialists
Anyone working with databases and data analysis

Welcome to The Complete MySQL Bootcamp: From SQL Beginner to Expert.

Learn SQL from scratch with us:

This course is 100% up-to-date
We answer absolutely every question our students ask and the responses we give are thoroughly detailed

Why to learn SQL?

Because according to the latest Stack Overflow Survey, SQL takes third place (54.7%)among the most popular programming, scripting and markup languages.

Knowing SQL is a MUST for:

Web Developers
Node.js Developers
Python Developers
Java Developers
Business Analysts
Marketing Analysts
Data Science Specialists
Everyone working with databases and data analysis

Strengthen your resume now by learning SQL and find a better job by mastering the most in-demand skill used by tech giants like Google, YouTube, Amazon, PayPal, Netflix and others.

Do I need prior programming experience?

No prior programming experience is necessary. We will take you step by step through everything there is to know about SQL.

What if I have questions during the course?

In this SQL course you will never be alone. Our support team will be with you every step of the way, ready to answer your questions.

How will my lessons look?

Straight to the point, no time wasted! Firstly, all theory will be explained on slides and after you get the concept, we show you how it works in practice.

Will I have lots of practice?

This course comes packed with lots of exercises to effectively practice and actually use SQL in order to help you advance quickly.

Will I learn MySQL or PostgreSQL?

SQL-language can be used with different databases such as MySQL, PostgreSQL, SQLite and many others.

According to the latest Stack Overflow Developer Survey, MySQL is the most commonly used database:

MySQL (55.6%)
PostgreSQL (36.1%)
Microsoft SQL Server (33.0%)
SQLite (31.2%)
MongoDB (26.4%)
Redis (18.3%)
MariaDB (16.8%)
Oracle (16.5%)
Firebase (14.4%)
Elasticsearch (13.8%)
DynamoDB (7.1%)
IBM DB2 (2.9%)
Couchbase (1.9%)

In this course you will be working with the MySQL database management system but the knowledge gained here can be applied to virtually every other database management system.

Will I get a certificate?

At the end of this SQL course, you will get a certificate which can be added to LinkedIn, adding a feather to your cap that employers will surely notice.

What’s more, you have a 30-day money-back guarantee. No questions asked.

So, what are you waiting for? Enroll today. We will help you gain the skills to be successful in the market for many years to come. Your future starts now!

Course Curriculum

Chapter 1: Introduction

Lecture 1: How to Pronounce SQL

Lecture 2: SQL vs MySQL vs RDBMS

Lecture 3: Installation – macOS

Lecture 4: Installation – Windows

Lecture 5: Installation – Ubuntu

Chapter 2: Basics – Part 1

Lecture 1: Video Quality – IMPORTANT!!!

Lecture 2: What Is a Database? Create a Database

Lecture 3: Create a Table. INSERT INTO

Lecture 4: Inserting Multiple Rows

Lecture 5: NULL

Lecture 6: SELECT FROM

Lecture 7: Exercise 1 – TASK

Lecture 8: Exercise 1 – SOLUTION

Lecture 9: SELECT DISTINCT

Lecture 10: WHERE – Part 1

Lecture 11: WHERE – Part 2

Lecture 12: ORDER BY

Lecture 13: Exercise 2 – TASK

Lecture 14: Exercise 2 – SOLUTION

Lecture 15: UPDATE

Lecture 16: DELETE

Chapter 3: Basics – Part 2

Lecture 1: Aggregate Functions + ALTER TABLE

Lecture 2: GROUP BY

Lecture 3: Logical Operators: AND, OR, NOT

Lecture 4: HAVING

Lecture 5: ROLLUP

Lecture 6: LIMIT

Lecture 7: Exercise 3 – TASK

Lecture 8: Exercise 3 – SOLUTION

Lecture 9: ALTER TABLE

Lecture 10: DROP

Lecture 11: Exercise 4 – TASK

Lecture 12: Exercise 4 – SOLUTION

Chapter 4: Intermediate – Part 1

Lecture 1: Primary and Foreign Key

Lecture 2: Relationship Types (1:1, 1:many, many:many)

Lecture 3: What is JOIN

Lecture 4: INNER JOIN

Lecture 5: Exercise 5 – TASK

Lecture 6: Exercise 5 – SOLUTION

Lecture 7: LEFT JOIN

Lecture 8: Exercise 6 – TASK

Lecture 9: Exercise 6 – SOLUTION

Lecture 10: RIGHT JOIN

Lecture 11: Exercise 7 – TASK

Lecture 12: Exercise 7 – SOLUTION

Lecture 13: FULL JOIN

Lecture 14: CROSS JOIN

Lecture 15: Aliases

Lecture 16: UNION

Chapter 5: Intermediate – Part 2

Lecture 1: What Are Constraints?

Lecture 2: CONSTRAINTS: NOT NULL

Lecture 3: CONSTRAINTS: UNIQUE. DESCRIBE + AUTO_INCREMENT

Lecture 4: CONSTRAINTS: DEFAULT

Lecture 5: CONSTRAINTS: CHECK

Lecture 6: CONSTRAINTS: PRIMARY KEY & FOREIGN KEY

Lecture 7: Exercise 8 – TASK

Lecture 8: Exercise 8 – SOLUTION

Lecture 9: String Functions – Part 1

Lecture 10: String Functions – Part 2

Lecture 11: Exercise 9 – TASK

Lecture 12: Exercise 9 – SOLUTION

Lecture 13: Numeric Functions

Lecture 14: Date Functions – Part 1

Lecture 15: Date Functions – Part 2

Lecture 16: IFNULL

Lecture 17: IF

Lecture 18: CASE

Lecture 19: COALESCE

Chapter 6: Advanced – Part 1

Lecture 1: What Is a Subquery?

Lecture 2: Subquery in the SELECT Clause

Lecture 3: Subquery in the FROM Clause

Lecture 4: Subquery in the WHERE Clause

Lecture 5: Correlated Subqueries

Lecture 6: Exercise 10 – TASK

Lecture 7: Exercise 10 – SOLUTION

Chapter 7: Advanced – Part 2

Lecture 1: Views

Lecture 2: Stored Procedures

Lecture 3: Exercise 11 – TASK

Lecture 4: Exercise 11 – SOLUTION

Lecture 5: Variables – Part 1 – System Variables

Lecture 6: Variables – Part 2 – User-Defined Variables

Lecture 7: Variables – Part 3 – Parameters and Local Variables

Lecture 8: Input and Output Parameters

Lecture 9: User-Defined Functions (2 examples)

Lecture 10: Exercise 12 – TASK

Lecture 11: Exercise 12 – SOLUTION

Lecture 12: Triggers

Lecture 13: What Are Indexes?

Lecture 14: CREATE, READ and DELETE Indexes

Lecture 15: Exercise 13 – TASK

Lecture 16: Exercise 13 – SOLUTION

Chapter 8: Import and Export (CSV files)

Lecture 1: What is CSV? Import and Export

Instructors

Vertex Academy
Team of Developers and Bootcamp Instructors

Rating Distribution

1 stars: 5 votes
2 stars: 5 votes
3 stars: 35 votes
4 stars: 137 votes
5 stars: 249 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu