Database Administration: Importing and Exporting Data
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.
What you'll learn
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.
Table of contents
About the author
George Smith has spent more than 25 years in the IT industry. During this time he has held a variety of positions, starting with web UI development and business analysis, progressing with system administration and infrastructure, then switching to core systems programming, technical consulting, and finally becoming an E-Commerce Architect and Subject Matter Expert. He is well versed in modern trends like Containerization, Infrastructure as Code, Serverless computing models, and more. George demo... more