The Complete MySQL Bootcamp:From SQL Beginner to Expert

BY
Udemy

Learn how to use MSQL for data management while mastering the fundamental and advanced concepts of SQL.

Mode

Online

Fees

₹ 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

MySQL is a free and open-source relational database management system.  This indicates all of this for WordPress websites, it aids the operator in storing all of their blog articles, subscribers, application statistics, etc. It is relational because it saves that data in a separate table and links it with variables. The Vertex Academy Team of Developers & Bootcamp Instructors created The Complete MySQL Bootcamp: From SQL Beginner to Expert-2022 online certification, which is provided by Udemy.

The Complete MySQL Bootcamp: From SQL Beginner to Expert-2022 online training offers 9 hours of prerecorded lectures that are jam-packed with tonnes of articles, downloadable materials, and exercises to help applicants advance quickly. The Complete MySQL Bootcamp: From SQL Beginner to Expert-2022 online course aims to help the applicants acquire the expertise to be able to work with database management systems like MySQL which could also be applied to virtually any other database management system.

The highlights

  • Certificate of completion
  • Self-paced course
  • 9 hours of pre-recorded video content
  • 1 article
  • 26 downloadable resources
  • Exercises

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database management Sql knowledge

After completing The Complete MySQL Bootcamp: From SQL Beginner to Expert-2022 certification course, applicants will acquire a deep understanding of the functionality involved with MySQL for SQL operations, Applicants will explore the techniques and methodologies utilized for creating databases and will acquire a detailed understanding of the fundamentals of RDBMS. Applicants will acquire knowledge of the strategies involved with data analysis, database normalization, and stack overflow surveys using SQL. Applicants will also become familiar with SQL queries, subqueries, report generation, CSV files, and MySQL servers

The syllabus

Introduction

  • How to Pronounce SQL
  • SQL vs MySQL vs RDBMS
  • Installation - macOS
  • Installation - Windows
  • Installation - Ubuntu

Basics - Part 1

  • Video Quality - Important!!!
  • What Is a Database? Create a Database
  • Create a Table. Insert Into
  • Inserting Multiple Rows
  • Null
  • Select From
  • Exercise 1 - Task
  • Exercise 1 - Solution
  • Select Distinct
  • Where - Part 1
  • Where - Part 2
  • Order By
  • Exercise 2 - Task
  • Exercise 2 - Solution
  • Update
  • Delete

Basics - Part 2

  • Aggregate Functions + Alter Table
  • Group By
  • Logical Operators: And, Or, Not
  • Having
  • RollUp
  • Limit
  • Exercise 3 - Task
  • Exercise 3 - Solution
  • Alter Table
  • Drop
  • Exercise 4 - Task
  • Exercise 4 - Solution

Intermediate - Part 1

  • Primary and Foreign Key
  • Relationship Types (1:1, 1:many, many:many)
  • What is Join
  • Inner Join
  • Exercise 5 - Task
  • Exercise 5 - Solution
  • Left Join
  • Exercise 6 - Task
  • Exercise 6 - Solution
  • Right Join
  • Exercise 7 - Task
  • Exercise 7 - Solution
  • Full Join
  • Cross Join
  • Aliases
  • Union

Intermediate - Part 2

  • What Are Constraints?
  • Constraints: Not Null
  • Constraints: Unique. Describe + Auto_increment
  • Constraints: Default
  • Constraints: Check
  • Constraints: Primary Key & Foreign Key
  • Exercise 8 - Task
  • Exercise 8 - Solution
  • String Functions - Part 1
  • String Functions - Part 2
  • Exercise 9 - Task
  • Exercise 9 - Solution
  • Numeric Functions
  • Date Functions - Part 1
  • Date Functions - Part 2
  • IfNull
  • If
  • Case
  • Coalesce

Advanced - Part 1

  • What Is a Subquery?
  • Subquery in the Select Clause
  • Subquery in the From Clause
  • Subquery in the Where Clause
  • Correlated Subqueries
  • Exercise 10 - Task
  • Exercise 10 - Solution

Advanced - Part 2

  • Views
  • Stored Procedures
  • Exercise 11 - Task
  • Exercise 11 - Solution
  • Variables - Part 1 - System Variables
  • Variables - Part 2 - User-Defined Variables
  • Variables - Part 3 - Parameters and Local Variables
  • Input and Output Parameters
  • User-Defined Functions (2 examples)
  • Exercise 12 - Task
  • Exercise 12 - Solution
  • Triggers
  • What Are Indexes?
  • Create, Read and Delete Indexes
  • Exercise 13 - Task
  • Exercise 13 - Solution

Import and Export (CSV files)

  • What is CSV? Import and Export
  • Two Main Ways
  • CSV to MySQL - MySQL Workbench
  • MySQL to CSV - MySQL Workbench
  • Settings - macOS
  • Settings - Windows
  • CSV to MySQL - MySQL Server
  • MySQL to CSV - MySQL Server
  • Events

Database Normalization

  • What Is a Database Normalization?
  • 1st Normal Form
  • 2nd Normal Form
  • 3rd Normal Form

Important

  • Bonus Lecture

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books