客服微信
学习人数：135
课程类型：企业定制培训
课时长度：4天/24 课时
MySQL基础培训是掌握世界上最流行的开源数据库MySQL的第一步。
本次课程将教授对关系数据库、SQL、MySQL服务器及工具的深入理解和丰富实践经验。学习内容包括：解析关系数据库模型，
课程对象：
计算机专业在校生或应届生/IT开发工程师/IT运维工程师
课程特点：
以Oracle原厂最新的英文标准教材为依据，理论与实验组合教学模式
对你的益处:
本课程为您全面讲解所需知识，让您在Web、云和嵌入式应用程序中运用MySQL数据库如鱼得水。
管理MySQL数据库:
课程内容除了深入讲解核心概念，还为您介绍一些高级工具与技术，以助您高效处理和管理MySQL数据库与数据。
第一章 Introduction to MySQL
1.1 Introduction to MySQL
1.2 Practice 1-1: Accessing MySQL Resources Online
1.3 Practice 1-2: Accessing the Course Environment
第二章 MySQL Client and Server2.1 MySQL Client and Server
2.2 Practice 2-1: Installing and Starting the MySQL Server
2.3 Practice 2-2: Using the Keyboard Editing and tee Commands
2.4 Practice 2-3: Creating a Server Connection by Using MySQL Workbench
2.5 Practice 2-4: Creating the world Database
2.6 Practice 2-5: Creating the world_x Database
2.7 Practice 2-6: Creating the Pets Database第三章 Querying Table Data3.1 Querying Table Data
3.2 Oracle Member Cluster for Applications
3.3 Practice 3-1: Performing Basic Queries
3.3 Practice 3-2: Performing More Complex Queries
3.4 Practice 3-3: Performing Basic Queries from an Application第四章 Data Types4.1 Data Types
4.2 Practice 4-1: Quiz on Data Types
4.3 Practice 4-2: Explaining the Use of Data Types
4.4 Practice 4-3: Reviewing Data Types for Pets Database第五章 Functions5.1 Functions
5.2 Numeric Functions
5.3 Practice 5-1: Quiz on Functions
5.4 Practice 5-2: Using Built-In, String, and Date and Time Functions
5.5 Practice 5-3: Using Numeric Functions
5.6 Practice 5-4: Using Aggregate Functions第六章 Joins and Unions6.1 Joins and Unions
6.2 Practice 6-1: Joins in Queries for Cities, Countries, and Languages
6.3 Practice 6-2: Joins in Queries for Pets, Owners, and Types
6.4 Practice 6-3: Querying by Using Unions第七章 Subqueries7.1 Subqueries
7.2 Practice 7-1: Performing Different Types of Subqueries
7.3 Practice 7-2: Performing Advanced Subqueries第八章 Creating Databases and Tables8.1 Creating Databases and Tables
8.2 Creating a Temporary Table
8.3 Practice 8-1: Displaying Table Creation Information
8.4 Practice 8-2: Creating a Database第九章 Modifying Databases and Tables9.1 Modifying Databases and Tables
9.2 Practice 9-1: Removing a Database
9.3 Practice 9-2: Creating a New Table and Removing a Table
9.4 Practice 9-3: Altering Table Columns
9.5 Practice 9-4: Creating, Modifying, and Removing a Table第十章 Modifying Table Data10.1 Modifying Table Data
10.2 Importing Data from a Script
10.3 Practice 10-1: Inserting and Replacing Data
10.4 Practice 10-2: Modifying and Deleting Data
10.5 Practice 10-3: Adding and Modifying Data
10.6 Practice 10-4: Modifying Data in an Application第十一章 Securing Your Database11.1 Securing Your Database
11.2 Practice 11-1: Working with Views
11.3 Practice 11-2: Creating Database Roles
11.4 Practice 11-3: Creating Database Users
11.5 Practice 11-4: Assigning Roles to Users
11.6 Practice 11-5: Assuming Roles Through User Accounts
11.7 Practice 11-6: Dropping Users, Roles, and Database Objects第十二章 Backing Up Your Database12.1 Backing Up Your Database
12.2 Practice 12-1: Backing Up and Restoring a Table
12.3 Practice 12-2: Backing Up and Restoring a Database
12.4 Practice 12-3: Backing Up and Restoring a Backup File to a New Database
12.5 Practice 12-4: Backing Up and Restoring All Databases第十三章 JSON Data13.1 JSON Data
13.2 Practice 13-1: Selecting JSON Data from a JSON Column
13.3 Practice 13-2: Creating a Table with a JSON Column. Inserting and Updating Rows in a Table with a JSON Column第十四章 Conclusion14.1 Conclusion
郭一军
云贝教育创始人 腾讯云TVP PostgreSQL ACE总监
