|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-beyond-the-basics/
课程评论：没有评论
**SQL - 深入进阶** 本课程专为已有SQL基础知识的学习者设计，旨在深入探讨SQL的高级技巧。您将学习如何转换数据类型、创建临时表、声明和使用变量。随后，课程将覆盖子查询、CASE语句以及编号和排名技术。此外，您还将学习使用内置函数、创建和使用自定义函数，以及创建视图。最后，课程将重点讲解存储过程，包括如何创建和运行存储过程、使用WHILE和IF进行循环，以及动态构建SQL语句。完成本课程后，您将显著提升SQL应用能力，更高效地使用SQL。
In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL. You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking. This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements. Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL.
