SQL – MySQL for data manipulation

在本课程中，您将能够学习如何使用 MySQL 创建您想要的任何数据库项目。此外，您将能够与现有数据库交互、操作数据并使用最常用的查询来显示数据（选择）或执行任何类型的分析。该课程涵盖基础和高级 SQL 查询，例如选择/显示、更新、删除和许多有用的功能。为了示例的目的，创建了一个酒店预订系统，以便您在学习本课程后可以创建自己的项目。

您将学习最好的 MySQL 查询，例如：（CRUD（创建、读取、更新、删除）、通配符、子查询、将更多表连接在一起、处理日期以及在任何数据库中进行数据操作的更多操作），这将帮助您创建大型现实世界的应用程序。

Published 10/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 28 lectures (3h 1m) | Size: 1.43 GB

Understand SQL – Learn Database Design and Data analysis

What you’ll learn
Create own database
Use / interact with existing databases
Write complexe SQL queries
Joins multiple tables
Extract information & apply logic to generate different set of data
Organize data
Create, React, Update, & Delete
Clauses & Wildcards
Subqueries & Group by
Working with dates

Requirements
No preview knowledge required

Description
In this course, you will be able to learn how to use MySQL to create any database project that you would like to. Also you will be able to interact with existing database, manipulate data, and use the most used queries either to display data (select) or to perform any kind of analysis. The course covers basics and advanced SQL queries such as select / display, update, delete, and so many useful functions. A hotel reservation system is created for the purpose of an example so that you can create your own project after you take this course.

You will learn best MySQL queries such as: (CRUD (Create, Read, Update, Delete), wildcards, subqueries, connecting more tables together, working with dates, and many more operations for data manipulation in any database) that will help you creating big real-world applications.

Key concepts

SQL (Structured Query Language – in-demand technology)

SQL syntax

Understand SQL Joins

MySQL (one of the most popular and widely used databases)

Use MySQL logical operators and other functions

Database Design & Development

Data Analysis

Differences

Of course CRUD

Subqueries

Displaying data from many tables

Displaying data that do not have to be on your table, but you perform operations to get them as result

Take your time, practice, and get ready for more. Avoid having too much information on too many technologies, they are all very nice and useful things to learn and build great apps.

All the best with learning!

Who this course is for
Administrators
Database administrators
Data analyzers