Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Beginner MySQL
Learn the Basics of an Open-Source Relational Database SystemPreview the first lesson free — get full access to all 34 lessons.
Beginner Provider : Kati Gordon 7 chapters · 34 Lessons · 1h 26m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
Take the first step toward using the open source relational database system with Beginner MySQL. In this course you will learn how to work with fundamental data, aggregates, strings, configuring rows and data.
What You'll Learn
- Select rows and columns from MySQL tables to retrieve data
- Insert, update, and delete data within a relational database
- Create, modify, and delete tables and change a table schema
- Filter, order, and remove duplicate data using conditional expressions
- Apply aggregate functions to summarize data
- Work with strings using string functions such as length
Key Takeaways
- MySQL is an open source relational database system, and this course is a first step toward using it.
- The course covers how databases are organized along with SQL and MySQL overviews.
- Learners work with fundamental data, aggregates, strings, and the configuring of rows and data.
- Table-level operations are covered, including creating tables, deleting tables, constraining columns, and creating ID columns.
- The course addresses handling null values, removing duplicates, and using distinct statements.
Frequently Asked Questions
Who is this course for?
It is designed for beginners taking their first step toward using the open source relational database system MySQL.
What will this course teach me?
You will learn how to work with fundamental data, aggregates, strings, and the configuring of rows and data in MySQL.
What topics does the course cover?
It covers SQL and MySQL overviews, how databases are organized, selecting rows and columns, inserting, updating and deleting data, working with tables, filtering, ordering and removing duplicates, conditional expressions, aggregate functions, and working with strings.
What skills will I gain?
The course builds skills in database development, database programming, relational databases, and MySQL.
