Build a strong foundation in SQL using MySQL — perfect for aspiring developers, analysts, and data enthusiasts.
Sub Category
- Database Design & Development
{inAds}
Objectives
- Introduction to Databases and SQ
- Basic SQL Syntax (SELECT, FROM, WHERE)
- Installing and Configuring MySQL
- Working with the MySQL Command-Line Client
- Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
- Common Table Expressions (CTEs)
- SELECT Statement
- WHERE Clause
- ORDER BY and GROUP BY Clauses
- INSERT, UPDATE and DELETE Statement
- Joining Tables : Left, Right, Full Outer, Self and Cross
- User Management and Permissions
- Database Backup and Recovery
- Database Monitoring and Troubleshooting
- Performance Tuning
- Access Control
- Security Best Practices
Pre Requisites
- No MYSQL experience needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. 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!
{inAds}
Coupon Code(s)