|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/all-in-sql/
课程评论：没有评论
课程名称：精通SQL：SQL Server、MySQL、PostGre、MariaDB和SQLite 课程概览： 本课程的独特之处在于，它围绕五种数据库管理系统（DBMS）设计：MySQL、SQL Server、PostGre、MariaDB和SQLite。数据驱动业务，因此课程围绕一个商业案例展开，学员的目标是学习SQL，以向商业所有者展示数据和分析，帮助其做出正确的商业决策。 课程内容全面，涵盖从基础到高级主题，包括递归公用表表达式（CTE）和游标等进阶知识。完成50%课程后，学员将获得一个独特的数据库，包含该课程涵盖的五种DBMS的250多个关键字，鼓励学员不局限于一种DBMS。 此外，课程深入探讨SQL的方方面面，从数据导入、创建查询到数据使用。学员将学习如何利用Excel构建数据管道，如何在Java、Python和R中使用SQL，如何在Android应用中使用SQL，以及如何构建一个网络应用，其中还涵盖了通过测试SQL注入案例学习道德黑客技术。 课程还包括40多道练习，帮助学员熟悉创建复杂的50行以上的查询，使用视图、相关子查询、连接表、CTE、存储过程和函数等技术。
What makes this course unique:1. This course is designed around 5 DBMS - MYSql - SQL Server - PostGre - MariaDB - SQLite2. Data drives business. This is is why the course is built around 1 business case. Your objective if you choose to accept it is to learn SQL is such a way in order to present data and analysis to a business owner that will empower such business owner to make the right business decision. 3. A very comprehensive SQL course. We don't shy away from advanced topics such as Recursive CTE and cursors.4. This course comes with a unique database (upon completion of 50% of course) that contains 250+ key words of the 5 DBMS covered by this course. Don't restrict your career to 1 DBMS!5. This course really covers the ins and out of SQL. From importing data, creating queries to using the data. We will show you how to use Excel to construct a data pipeline. How to use SQL in Java,Python and R. How to use SQL in an Android application and finally how to build a web application where can learn about ethical hacking by testing a case of SQL injection.6. More than 40 exercises where you will get familiar with creating complex queries of 50+ lines of codes using views, correlated subqueries, joining tables,, cte.in views, stored procedures, functions...
