-
Please login to continue
-
Sign Up For Free
Join the World’s Largest Free Learning Community
- Already have an Alison account? Log In
orThis is the name that will appear on your Certification
-
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
5
Modules
19
Topics
1.5-3
hours
Modules (5)
Resources ()
-
learn how to use a mysql database like a pro with this free online beginners course.
-
Module 1
Understanding and Installing MySQL
Resources availableOne of the most relevant and used databases in today’s modern world is MySQL. This module will start by helping you understand the importance of using MySQL in any profitable or non-profitable business or organization. It is often compared to a well-organized notebook that can contain various formats of data. Follow the simple step-by-step methods taught in this section to download and install MySQL on your workstation correctly.Understanding and Installing MySQL - Learning Outcomes
Start TopicMySQL Database and Architecture
Start TopicMySQL Installation and Testing
Start TopicUnderstanding and Installing MySQL - Lesson Summary
Start Topic -
Module 2
Database Design
Resources availableUnderstanding database design and entity-relationships are crucial because they significantly impact the performance of a database server. This module will teach you how tables function and how to identify specific data using foreign or primary keys that provide an intersection or links between databases. Particular aspects that contribute to creating a better consistency for data and security will be considered. Each topic in this module includes tutorials with simple, easy-to-follow methods.Database Design - Learning Outcomes
Start TopicDatabase and MySQL Workbench
Start TopicConstraints and Primary Keys
Start TopicStorage and Data Types
Start TopicSecuring Data and Transactions
Start TopicDatabase Design - Lesson Summary
Start Topic -
Module 3
Database Administration
Resources availableThis module will outline the responsibilities of a database administrator. These essential duties ensure that the access to data is controlled and the server is kept functioning at optimal levels. We will consider the main types of encryption and security for the database. It is crucial to be aware of the correct procedures to prevent the partial or complete loss of data if the server fails.Database Administration - Learning Outcomes
Start TopicAdministrator Duties and Creating Users
Start TopicProtection and Performance
Start TopicDatabase Administration - Lesson Summary
Start Topic -
Module 4
Indexing Database Performance
Resources availableThis module will consider the crucial reasons of maintaining a well-tuned database server. If we apply the specific optimization recommendations mentioned, we will ensure a quick response from a query execution. This process is usually more cost-effective than if we were to go out and purchase additional hardware resources. As we work with a server, it is vital to evaluate what type of query should be optimized first and the efficient use of an index.Indexing Database Performance - Learning Outcomes
Start TopicIndexing and Queries
Start TopicDatabase Performance and Optimization
Start TopicIndexing Database Performance - Lesson Summary
Start Topic -
course assessment: MySQL for Beginners
-
Module 5
Course assessment
Resources available