Course Details
MySQL
Database
Created On
June 26, 2023Description
MySQL is an open-source relational database management system known for its speed, reliability, and ease of use. It uses client-server architecture and supports SQL for data storage, retrieval, and management. MySQL is widely used for various applications and industries, providing scalability, security, and compatibility with different platforms and programming languages.
Overview
This course provides a comprehensive understanding of MySQL fundamentals, practical database skills, query optimization, data analysis and aggregation, advanced SQL techniques, pattern matching, and range-based selection, along with a balanced blend of theory and hands-on experience, equipping participants with the confidence and expertise needed for a wide range of database-related job opportunities and enhancing their resumes in the field.
Features
- Course material
- Course resources
- On demand recorded videos
- Practical exercises
- Quizzes
- Assignments
- Course completion certificate
What you'll learn
- MySQL tables
- Primary keys and foreign keys
- CRUD operations
- SQL queries
- Joins
- ACID in database
- Database engines
Prerequisites
Curriculum
- 9 modules
Overview
MySQL Essentials
MySQL on macOS
Windows MySQL Installation
Creating and dropping database - Startup
Resolving the issue for future
Creating table
Adding values to canon table
Answering customer question
Primary key, default and NULL
Table with primary key and default values
Testing the new table
Adding new values and answering questions
Update in customers table
Delete from the customers table
Understand the new lco user DB
Task for CONCAT
Task for REPLACE
Task for SUBSTRING
Task for reverse and CHAR_LENGTH
Task for case conversion and DOCS
A task on DISTINCT
A task for ORDER BY
A task on LIMIT
Match the pattern
A task on COUNT
SQL MODES and GROUP BY
MIN MAX and SUBQUERIES
GROUP BY with MAX and MIN
SUM and AVERAGE with GROUP BY
A task on AND OR
A task in RANGE based selection
CASE THEN - multiple range selection
Data type for INTEGER and STRING
Data type for DATE, DATETIME and JSON/DATE TIME code Example
Get the date and time
Types of JOIN
Code talk over FOREIGN keys
Understand a new database
A task on INNER join
ONE to MANY and MANY TO MANY
Join more 3 or more tables
A task on LEFT JOIN
A task on RIGHT JOIN
FULL OUTER join and UNION tasks
Database engines - INNODB and more
ACID in database
How practice database works – FILM
Instructors
Experienced Technostragist with three decades in IT, excelling in Sales, Product Management, and Marketing across IT hardware, networking, and software. Proven strategic planner, startup pioneer, and mentor for large teams. Marketing authority in areas such as Business Incubation, Branding, and Sales. Vast industry expertise spans ITES, IT Hardware, IT Training (Software), Distribution, and Retail. Recognized for interpersonal leadership, intuitive decision-making, and a collaborative approach. Complemented by four years as a Data Scientist, enhancing analytical and problem-solving skills with a deep passion for coding and a knack for simplifying complex concepts,
- 9 Modules
- 8 Hours
- Database
Login to Purchase the Course