By the end of this project, you will be able to manage data efficiently in a specific database using MYSQL Workbench. You will be able to select data from tables from your database and use keywords in select statements such as LIMIT and Top. You will be able to update the data and filter them using where statements, and also apply conditions with different ways and keywords such as like, and, or, and between. Moreover, you will be able to apply the aggregate functions in your select statement and the grouping by, and finally, you will be able to join tables with each other using three different joins, left, inner and right join. A database management system stores organize and manage a large amount of information within a single software application. The Use of this system increases the efficiency of business operations and reduces overall costs. The world of data is constantly changing and evolving every second. This in turn has created a completely new dimension of growth and challenges for companies around the globe like Google, Facebook, or Amazon.

Data Manipulation and Management using MYSQL Workbench

位教师:Omnya Khaled
访问权限由 New York State Department of Labor 提供
1,548 人已注册
您将学到什么
You will be able to select data from tables with cutom filter by different SQL keywords.
You will be able to create a query with aggregate function and groupingby statement and how to join between tables with different properties and data
您将练习的技能
要了解的详细信息

添加到您的领英档案
仅桌面可用
了解顶级公司的员工如何掌握热门技能

在 2 小时内学习、练习并应用岗位必备技能
- 接受行业专家的培训
- 获得解决实训工作任务的实践经验
- 使用最新的工具和技术来建立信心

关于此指导项目
分步进行学习
在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:
-
By the end of task 1, you will be able to select data with several features and keywords.
-
By the end of task 2, you will be able to update the data and filter them using different conditions.
-
By the end of task 3, you will be able to apply the aggregate functions and the grouping by.
-
By the end of task 4, you will be able to join tables with each other through three different ways as inner join, left join, and right join.
推荐体验
Familiarity with data types as String, INT.
3个项目图片
位教师

提供方
学习方式
基于技能的实践学习
通过完成与工作相关的任务来练习新技能。
专家指导
使用独特的并排界面,按照预先录制的专家视频操作。
无需下载或安装
在预配置的云工作空间中访问所需的工具和资源。
仅在台式计算机上可用
此指导项目专为具有可靠互联网连接的笔记本电脑或台式计算机而设计,而不是移动设备。
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.







