|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ultimate-sql-and-database-concepts/
课程评论：没有评论
课程名称：学习构建 SQL 查询 - 终极 SQL 和数据库概念 课程概述：SQL 开发人员在 IT 行业中薪资逐年上涨，但成功的关键在于理解并在合适的时机应用正确的查询。本课程旨在以简单易懂的方式帮助您理解复杂的 SQL 语句。此外，您将学习如何从数据库中提取数据，并编写复杂的数据库查询。本课程将全面覆盖结构化查询语言（SQL）概念，适用于使用 MySQL、Microsoft SQL Server、Oracle Server 等的学生。 课程内容分为五个章节： 第一章：基础知识 - 基础构建块 - 从数据库中选择记录 - 使用算术表达式 第二章：条件、排序与运算符 - 逻辑运算符 - 比较运算符 - 运算符优先级 - 排序结果 第三章：函数 - 字符函数 - 数字函数 - 日期函数 - 类型转换 - 通用函数 - 嵌套函数 第四章：分组 - 在单个表上处理多行函数 - 在多个表上处理多行函数 第五章：连接 - 理解主键 - 理解外键 - 连接的必要性 - 笛卡尔积 - 等值连接 - 简单连接 - 自连接 - 非等值连接 - 外连接 - 自连接 课程针对希望在短时间内掌握 SQL 和数据库概念的大学及大专学生设计。
SQL developers are earning higher salary in IT industry, but, its not about writing queries its about understanding and applying the right query at right time and this course will let you understand complex SQL Statements in an easy way. Moreover, This Course will teach you how to extract Data from Database and write complex queries to a database This course will focus on a wider scale by Covering Structure Query Language SQL concepts as a whole, whether Students work with MySQL, Microsoft SQL Server, Oracle Server, etc. This course have 5 Chapters in which you will learn Chapter 1 Fundamentals FundamentalsBuilding BlocksSelecting Records from DBWorking with Arithmetic Expressions Chapter 2 Conditioning Sorting and Operators Logical OperatorsComparison OperatorsOperator Precedence Sorting Results Chapter 3 Functions Character FunctionsNumber FunctionsDate FunctionsConversionsGeneral Purpose FunctionsNesting Functions Chapter 4 Grouping Multiple Row Functions on a single TableMultiple Row Functions on Many Table Chapter 5 Joins Understanding Primary Key Understanding Foreign Key Understanding Need of JoinsCartesian ProductEquie Join Simple Join Self JoinNon Equie JoinOuter JoinSelf Join Course is Designed for College and University Students who want Solid SQL and Data Base Concepts in a short period of time.
