In this section, you will learn how to import and export data with the table data import and export processes in MySQL Workbench. Table data import and export allows you to import and export both CSV and JavaScript Object Notation (JSON) files via MySQL Workbench. It provides you with many configuration options—for example, column separator types such as a comma or a semicolon—and it allows you to map columns in the file to columns in the table.
- Title Page
- Copyright and Credits
- About Packt
- Contributors
- Preface
- Section 1: Database Fundamentals
- Introduction to Relational Database Management Systems
- Installing and Using MySQL Workbench
- Understanding Data Types
- Designing and Creating a Database
- Technical requirements
- Creating a database
- Understanding table relationships
- Creating a table in the database
- Understanding indexes
- Summary 
- Further reading
- Questions
- Importing and Exporting Data
- Section 2: Basic SQL Querying
- Querying a Single Table
- Technical requirements
- Using the SELECT statement and FROM clause
- Understanding the SELECT statement and the FROM clause
- Learning the correct order of other clauses you can use with SELECT
- Understanding the different ways to query with a SELECT statement
- Learning how to use column aliases
- Using the USE statement
- Learning how to use the DISTINCT clause 
- Learning how to use the LIMIT clause
- Learning how to save a SQL query to a file
- Learning how to open a SQL file
- Learning how to add comments to your SQL code
- Using the WHERE clause
- Using the ORDER BY clause
- Using indexes with your queries 
- Summary
- Questions
- Further reading 
- Querying Multiple Tables
- Technical requirements
- Understanding joins 
- Using INNER JOIN 
- Using OUTER JOIN 
- Using advanced joins 
- Understanding set theory
- Using indexes with your queries 
- Summary 
- Questions
- Further reading 
- Modifying Data and Table Structures
- Section 3: Advanced SQL Querying
- Working with Expressions
- Technical requirements
- Using expressions
- Using statistical functions
- Using generated columns 
- Summary 
- Questions 
- Further reading 
- Grouping and Summarizing Data
- Advanced Querying Techniques
- Technical requirements
- Using subqueries
- Understanding the different types of subqueries and their usage
- Using non-correlated subqueries 
- Using a non-correlated subquery in the WHERE clause
- Using a non-correlated subquery in the SELECT clause
- Using a non-correlated subquery in the FROM clause
- Using INSERT, UPDATE, and DELETE with non-correlated subqueries
- Differences between non-correlated subqueries in other relational database management systems (RDMSes)
- Using correlated subqueries 
- Using non-correlated subqueries 
- Understanding the different types of subqueries and their usage
- Using common table expressions
- Using query hints and transaction isolation levels
- Summary 
- Questions 
- Further reading 
- Programmable Objects
- Technical requirements
- Creating and using views
- Creating and using variables
- Creating and using stored procedures
- Creating and using functions
- Creating and using triggers
- Creating and using temporary tables
- Summary 
- Questions
- Further reading 
- Section 4: Presenting Your Findings
- Exploring and Processing Your Data
- Technical requirements
- Exploring your dataset
- Processing your dataset
- Summary 
- Questions 
- Telling a Story with Your Data
- Section 5: SQL Best Practices
- Best Practices for Designing and Querying
- SQL Appendix
- Assessments
- Other Books You May Enjoy
Understanding table data import and export
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.