Free Certification Course Title: MySQL Database Development Mastery
Learn fundamental Database Development techniques with MySQL Server and MySQL Workbench
What you’ll learn:
- Basic Database Design (Tables, Columns, Data Types, Primary Keys, Foreign Keys, Normalization)
- How to Use install and MySQL Workbench
- SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
- DELETE: How to remove data from a database
- INSERT INTO: How to insert data into a table
- UPDATE: How to update existing data
- Overall Database Development Best Practices
- Creating Relationships and Foreign Keys
- How to craft SQL statements based on real scenarios
- How to export Query Results to Excel
- Using Aggregate Functions in SQL
- How to query related data from multiple tables
Requirements:
- A Reliable Computer
- A desire to learn database development
Who this course is for:
- Beginner Database Administrators
- Database Developers who want to go to the next level
- Those who work in organizations where the company typically uses MySQL databases.
What you’ll learn:
- Install MySQL Server
- Install MySQL Workbench
- Connect to an Instance
- Create a database
- Reverse Engineer Database into Data Models
- Forward Engineer Data Models into Databases
- Create Tables
- Run Queries against Tables
- General use of the MySQL Workbench
- Create Relationships
- Use Aggregate functions to do quick mathematical operations
- Export data to Excel using MySQL Workbench
- Practical use of SQL
This course includes:
- 4.5 hours on-demand video
- 1 article
- 15 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
How to subscribe the complete course for free:
- Sign Up on Udemy.com
- Subscribe Here(MySQL Database Development Mastery): CLICK HERE
Apply Coupon Code: MYSQL_APR_FREE
0 Comments