What you’ll learn
- Basic database design (tables, columns, data types, primary keys, foreign keys, normalization)
- Using Installation and MySQL Workbench
- SELECT statement: Query on individual table (filter, sort, group)
- DELETE: How to delete data from database
- INSERT INTO : How to insert data into a table
- UPDATE: How to update existing data
- Common database development best practices
- Create relations and foreign keys
- How to create SQL statements based on real-world scenarios
- How to export query results to Excel
- Using aggregate functions in SQL
- Query related data from multiple tables
This course includes:
- 4.5 hours of video on demand
- 1 item
- 15 resources to download
- Completion Certificate
Description
This is a MySQL Database Server and MySQL Workbench zero to hero course. There are no prerequisites for this course. If you want to become familiar with database and query concepts, this is the course for you.
Why learn MySQL?
MySQL is the most popular open source database in the world. With proven performance, reliability and ease of use, MySQL has become the leading database choice for web-based applications used by high-profile web properties such as Facebook, Twitter and YouTube.
We will examine best practices in database development using MySQL Database Server and create a database management system for small schools.
All you need is a Windows computer and we’ll guide you through setting up your environment, creating your database, creating your first tables, and writing your queries.
At the end of this course, you will be able to write queries for various situations and reports.
How to Get this course FREE?
Get a 100% Discount On Udemy Paid Courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course 100% Free. After that, you will get this course at a discounted price. (Still, It’s a good deal for you to get this course at a discounted price).
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase. Read our disclosure.
