|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-introduction-to-mysql/
课程评论：没有评论
课程名称：SQL - 使用MySQL的SQL入门 课程概述： 在做出明智的商业决策之前，需要获取正确的数据，而与数据库进行沟通和查询数据的能力正是此过程的关键。SQL（结构化查询语言）是与数据库交互的语言，也是获取做出智能决策所需数据的重要工具。 为什么选择本课程： 本SQL课程将从最基础的知识点开始，帮助学员有效地与任何数据库沟通。您将学习如何使用MySQL查询和管理数据库。MySQL是一个免费开源的关系型数据库管理系统，被众多全球大型组织使用。每个模块将专注于SQL工作中的一个关键主题，视频讲座将辅以讲师的示范。每个部分结束后都会有小测验和练习，让您测试自己的理解。课程内容层层递进，激励您在学习过程中不断建构新知识。 本课程不仅仅是观看讲师在屏幕上录入代码，而是充分鼓励参与和实践，让您通过实际编写SQL来真正吸收知识。课程还提供可下载的学习资源，您可以在课程之外继续学习。Q&A板块允许您向讲师提问，并与其他学习者互动。 课程目标： 在本SQL课程中，您将学习到创建、查询和处理MySQL数据库的基本知识，包括： - 学习MySQL Workbench中的正确SQL语法 - 理解关系型数据库设计概念 - 使用SQL SELECT语句查询数据库中的数据 - 使用列别名为数据提供额外的上下文和意义 - 学习如何使用SQL WHERE子句过滤数据库查询结果 - 创建复杂查询，使用合适的过滤器 - 使用SQL ORDER BY关键字对查询结果进行排序 - 正确分组数据并创建报告计算 - 使用SQL HAVING子句在数据组内进行过滤 - 从头创建MySQL数据库 - 学习如何创建表和管理表中的记录 - 以及更多课程内容… 您还在等什么？现在就报名开始您的SQL学习之旅吧！期待在课程中见到您！
LEARN SQL WITH MySQLIn order to make intelligent business decisions you need the proper data. In order to get the proper data you will need to communicate with and query data within a database. This is where SQL comes into play. SQL stands for Structured Query Language. It's the language used to communicate with a database and more importantly the data needed to make intelligent decisions that will save time and money.WHY THIS COURSEThis SQL course starts with the absolute basic building blocks necessary to communicate effectively with any database. You'll learn how to query and manage a database using MySQL. MySQL is a free open-source relational database management system (RDBMS), used by many of the world's largest organizations.Each section of the course will focus on a key topic of working with SQL. The video lectures have been created so you can follow along as the instructor demonstrates each concept. At the end of each section you can test your understanding through a section quiz and exercise. Once you complete a section the next section will build on the topics of the previous section. This encourages your learning as you build upon the knowledge you learn as you move from one section to the next.This course is not just a sit back and watch the instructor type on the screen kind of course. The lectures and course flow has been designed to help you engage in the topic and participate by writing your own SQL. The TRUE LEARNING happens when you apply what you're learning and try it yourself.The course also contains downloadable resources you can use away from the course as you continue to learn SQL. The QA board found within the course offers you the opportunity to ask questions and get answers from the instructor and interact with the other students enrolled in the course.COURSE OBJECTIVESIn this SQL course you will learn the fundamental building blocks of creating, querying and working with databases using MySQL.Learn Proper SQL Syntax Using the MySQL WorkbenchLearn Relational Database Design ConceptsUse the SQL SELECT Statement in Order to Query Data from a DatabaseUse Column Alias to Give additional Context and Meaning to the DataLearn How to Filtering Database Query Results Using the SQL Where ClauseCreate Advanced Queries by Using the Proper Filter OperatorsUse the SQL ORDER BY Keyword to Sort the Results of a QueryLearn How to Properly Group Data and Create Calculations for ReportingUse the SQL HAVING Clause to Filter within Data GroupsCreate a MySQL Database from ScratchLearn How to Create Tables and Manage Records within the TablesAnd Much More...WHAT ARE YOU WAITING FORStart your SQL journey by enrolling now. See you in the course!
