2 Coupons Available
Login To View AllCourse Report
Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.
Visit Course Report
Course Features
Duration
13 hours
Delivery Method
Online
Available on
Limited Access
Accessibility
Mobile, Desktop, Laptop
Language
English
Subtitles
English
Level
Beginner
Teaching Type
Self Paced
Course Description
Course Overview
Personlized Teaching
Post Course Interactions
Instructor-Moderated Discussions
Skills You Will Gain
Prerequisites/Requirements
It doesn't matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge
What You Will Learn
Introduction on MySQL
Data Types
SELECT Statements
Backticks
Limit and Offset
Creating databases
Joins
VIEWS
MySQL LOCK TABLE
TRIGGERS
Collations, Transactions, Log files, Replication, Backup
Target Students
The MySql Masterclass is fully available to anyone, and no previous qualifications are needed to enrol All One Education needs to know is that you are eager to learn and are over 16
Course Content
Module 1: MySql Masterclass
1. Introduction on MySQL
2. Data Types
3. SELECT Statements
4. Backticks
5. NULL
6. Limit and Offset
7. Creating databases
8. Using Variables
9. Comment MySQL
10. INSERT Statements
11. DELETE Statements
12. UPDATE Statements
13. ORDER BY Clause
14. Group By
15. Errors in MySQL
16. Joins
17. Joins continued
18. UNION
19. Arithmetic
20. String operations
21. Date and Time Operations
22. Handling Time Zones
23. Regular Expressions
24. VIEWS
25. Table Creation
26. ALTER TABLE
27. Drop Table
28. MySQL LOCK TABLE
29. Error codes
30. Stored routines (procedures and functions)
31. Indexes and Keys
32. Full-Text search
33. PREPARE Statements
34. JSON
35. Extract values from JSON type
36. MySQL Admin
37. TRIGGERS
38. Configuration and tuning
39. Events
40. ENUM
41. Collations, Transactions, Log files, Replication, Backup
Course Accreditations
Course Reviews
Average Rating Based on 4 reviews
100%
Course FAQs
2 Coupons Available
Get upto 50% - 70% Discount