|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-tutorial-for-beginners/
课程评论：没有评论
课程名称：测试人员的SQL教程 课程概述：SQL查询教程专为初学者设计，旨在通过实际示例帮助学习者掌握SQL查询技能。在当今IT行业中，SQL查询同样对测试人员和开发人员至关重要，成为市场上最重要的技能之一。随着大数据的兴起，数据分析已成为非常迫切的需求，全球都在努力提升其SQL查询能力。本教程系统地涵盖了SQL查询的各个方面。 课程内容包括： 1. 关系数据库的介绍 2. 使用选择语句进行数据检索 3. 数据库和数据表的创建、数据的插入 4. 删除、丢弃和截断之间的区别 5. 连接（Join）的概念 6. SQL中约束的实现 7. 在MySQL中设置sql_mode，以更好地实现约束 课程中使用的软件： 1. XAMPP，用于设置MySQL 2. SQLYog，作为MySQL数据库管理工具，用于执行所有SQL查询 该课程特别适合希望在实践中学习SQL查询的初学者。
SQL Query Tutorial For Beginners has been designed specially for all the beginners who wants to learn sql query with real time examples with practical examples. In today's IT Industry , Sql Query is equally good for Testers and Developer and it is most important skill set in today's market and with big data boom now data analysis has become the need of minute and whole world is trying to tune up their SQL query skill. This tutorial has been design in a very systematic way and it covers most of the areas. This course is going to cover1- Relational database introduction2- Data retrieval using Select Statement3- Creation of database, data table, insertion of data4- Difference between delete, drop and truncate5- Concept of Join6- Constraints implementation in sql7- Setting sql_mode in mysql for better result of Constraints in mysqlSoftware Used in this course1- XAMPP for setting up mysql2- SQLYog as mysql database administrative tool and it will be used to execute all the sql queries.
