|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-mariadb-sql-for-beginners-from-scratch/
课程评论：没有评论
课程名称：从零开始学习MariaDB SQL基础 课程概述： MariaDB是一种优秀的开源创新和企业级可靠性并具现代关系数据库的技术。SQL（结构化查询语言）是国际公认的语言，用于与各种数据库系统进行通信和数据操作。数据无处不在，并以快速的速度增长。我们日常使用的大多数软件应用程序都涉及存储数据，从与银行的交互到像Facebook和Instagram这样的社交媒体应用。由于对数据的相关性和依赖性，掌握SQL的专业人才在各行业中需求量大，他们帮助与各种数据库互动，以支持商业智能等依赖数据的领域。 本课程将从绝对初学者教你到成为专家，使你具备足够的技能，能够构建从简单到复杂的查询，以与数据库进行沟通和互动。我们将使用MariaDB服务器来托管数据库。MariaDB服务器是一种广泛应用于全球众多公司的关系数据库管理系统（RDBMS）。 你将学习的内容包括： - 如何通过连接（Joins）从多个数据库表中提取数据 - 如何使用SQL向数据库插入新数据 - 如何更新数据库中的现有数据 - 如何从数据库中删除数据 - 如何过滤数据 - 如何对数据进行排序 - 如何使用聚合函数总结返回的数据 - 如何对数据进行分组 - 如何使用别名 - 如何使用各种运算符 此课程旨在使学员在面对实际数据问题时具备自信和能力。
MariaDB is great for its open-source innovation and enterprise-grade reliability, as well as its modern relational database. SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data. From our interaction with our banks to social media applications like Facebook and Instagram..Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand to help interact with various databases to help business intelligence and other sectors that relies on data.This course will teach you from absolute beginner to expert so you can be confident with enough skills to build simple to complex queries to communicate and interact with databases.We will be using MariaDB Server to host our database.MariaDB Server is a relational database management system -RDBMS used by lots of companies all over the world What You Will Learn include:How to extract data from multiple Database Tables using JoinsHow to insert new data into database with SQLHow to update existing data inside a databaseHow to delete data from a databaseHow to filter dataHow to sort dataHow to use Aggregate functions to summarize returned dataHow to group dataUsing AliasesUsing various Operators
