Brochure
Enquire
- How to Pronounce SQL
- SQL vs MySQL vs RDBMS
- Installation - macOS
- Installation - Windows
- Installation - Ubuntu
The Complete MySQL Bootcamp:From SQL Beginner to Expert
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
Who it is for
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
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
prev
next
Latest Articles
prev
next
