7 hours ago
Published 11/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 48 KHz
Language: English | Size: 66.56 MB | Duration: 19m 5s
This course will teach you how to prepare data obtained for your organization, import it into a target database, manipulate it, and then export it for third parties.
Moving data to and from a large number of systems is a must in today's dynamic businesses. In this course, Database Administration: Importing and Exporting Data, you'll learn to import and export data from one of the most popular relational databases, MySQL; a trusted datastore for many e-commerce and other transactional business needs. First, you'll explore MySQL Workbench, a robust MySQL client, and perform data imports and exports manually. Next, you'll discover how to run import and export tasks using mysqldump. Finally, you'll learn how to perform mysqldump operations using standard operating-system mechanisms, like crontab. When you're finished with this course, you'll have the skills and knowledge of handling import/export operations for a relational database needed to manipulate external and internal data to meet business needs and advance your career.
Homepage