|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/rdbms-sql-course-step-by-step-guide-to-learn-sql/
课程评论：没有评论
**课程名称：** RDBMS - SQL 循序渐进学习指南 **课程概述：** 本课程是为技术专业人士设计的，旨在教授数据库开发中的核心技能——SQL。从MySQL的安装和数据库创建基础，到复杂查询的解决，本课程将带你一步步掌握SQL的方方面面。您将学习RDBMS和数据管理的基础知识，以及如何使用SQL这个最流行的数据操作语言来构建查询。课程内容融合了理论概念和实际操作，并通过10小时以上的点播视频、社区答疑、内置评估等方式，帮助您逐步成为SQL专家。 **课程内容亮点：** * 数据与信息的区别、数据的重要性 * RDBMS及其历史，数据库对象和设计 * 键和约束的概念，数据规范化及其类型 * 事务的概念和类型 * SQL语句的编写，包括数据插入、更新和删除 * 使用聚合函数进行数据分析 * 运用MySQL逻辑运算符运行复杂查询，处理NULL值 * 各种常见的SQL Join操作 * 使用集合运算符进行数据查询 * 利用字符串函数执行复杂查询 * 更多实用SQL技巧！ **学习方式：** 本课程为自定进度，学员可根据自己的节奏进行学习，理论与实践相结合，并设有内置的评估环节以检验学习成果。
Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today's workplace. This course gives you that skill. You'll start with the absolute basics of installing and creating databases to resolving the complex queries.In this course you can learn the fundamental basics of RDBMS and Data Management with SQL. Learn everything that you will need to construct queries with the most popular data manipulating programming language - SQL. The course is a self-paced and you can work through it at your own pace. The course is a right blend of concepts and hands-on to take a step towards making you a pro in SQL. 10+ hours of on demand videos Clarifications through community Right blend of concepts and hands-on Built in Assessment to test your knowledgeIn this course, you will:The difference between Data and InformationWhy do we need Data?Learn the ins and outs of SQL syntax What is RDBMS and its History?Database Objects and Database DesignLearning about the Keys and ConstraintsExplaining the Normalization and its typesUnderstanding the Transactions and its typesHow to write SQL queries to Manipulate dataHow to write SQL queries to insert, update and delete data into databaseAnalyze data using Aggregate FunctionsRun complex queries using MySQL logical operators How to handle the NULL values in the SQLWrite all the common SQL joinsQuerying the data using Set Operators Executing the complex queries with String FunctionsAnd more!!!!
