|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-dpif/
课程评论：没有评论
**课程名称：SQL (完全以泰卢固语授课)** **课程概述：** 本课程专为零数据或SQL基础的学习者设计，内容丰富，示例众多，旨在帮助从初学者到高级学习者轻松掌握SQL。课程涵盖了从基础概念到高级查询的广泛主题，并为每个概念提供了PPT和大量练习示例。所有查询均通过实时演示和执行进行讲解，确保学习者能够轻松理解。 **课程内容（部分）：** 1. SQL导论 2. 数据与数据库的概念 3. SQL的定义与作用 4. 数据类型 5. SQL语句类型 6. 运算符 7. DDL与DML命令 8. DQL - SELECT语句 9. WHERE子句 10. 字符串匹配 11. 预定义函数 12. 聚合函数与窗口函数 13. 子查询 14. CASE语句与DECODE函数 15. 约束 16. NULL值处理 17. JOINS（连接） 18. 集合运算符 19. CTEs（通用表表达式） 20. PIVOT与UNPIVOT 21. 索引 22. 视图 23. 访问控制 24. 性能调优 25. 高级SQL查询 **学习建议：** 如果每天投入2小时学习，预计25天可完成本课程。 **讲师：** Janardhan **其他：** 讲师表示，学习者可以就任何特定的SQL查询需求进行咨询，讲师乐意提供帮助。
I have designed this course in such a way like any one without prior knowledge on Data or SQL also can learn easily. I have given huge content and examples that will help for beginners to advanced learners.I have given PPTs for every concept and lot of examples to practice. I have explained and executed all queries in Live so that anyone can understand it easily.Below are the topics I have covered.1.Introduction2.What is Data, Database?3.What is SQL4.DataTypes5.Types of SQL Statements6.Operators7.DDL and DML Commands8.DQL-SELECT Statement9.WHERE Clause10.String Matching11.Pre-defined Functions12.Aggregate and Window functions13.Subqueries14.Case-Statement and Decode15.Constraints16.Null Handling17.Joins18.Set Operators19.CTEs20.Pivot and Unpivot21.Indexes22.Views23.Access Controls24.Performance Tuning25.Advanced SQL QueriesPlease go through all Content and let me know if you are looking for any specific SQL query, I can write it for you.If you can spend daily 2 hours in learning SQL, you can complete this course in 25 days.Thank you and I wish you a very happy learning.Janardhan.
