|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-microsoft-access-2007-to-2016/
课程评论：没有评论
**Coursera 课程《Microsoft Access SQL》内容摘要** 本课程旨在帮助学员掌握在 Microsoft Access 中编写更高级的 SQL 查询，并使这些查询能够迁移到 SQL Server 和 Access 中。学员将学习以下核心内容： * **SQL 查询基础：** 熟练运用 SELECT 语句的六个子句。 * **函数与公式应用：** 在 SELECT 语句中使用函数和公式。 * **表格连接：** 掌握创建表格连接的方法，包括只能通过代码实现的复杂连接。 * **操作查询与交叉查询：** 学习创建操作查询和交叉查询。 * **高级查询技巧：** 使用 FROM 子句中的派生表、WHERE 子句中的子查询，以及创建相关查询和交叉查询。 * **数据集成与查询：** 学习使用 UNION 和 UNION ALL，以及导入或联合数据并创建跨数据库的 Pass-Through 查询。 通过本课程的学习，学员将能够深入理解 Access SQL，并利用其独有的功能构建更强大的数据库。课程以其逻辑清晰的结构、循序渐进的讲解和丰富的实践内容而受到好评，即使是初学者也能从中受益匪浅，建立坚实的 SQL 基础。
Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.What do people just like you think of this course?"This is an excellent course, very well organized, structured, explained and paced. In addition, the course is content rich, provides a very good context and helpful tips! This is exactly what I was looking for. Thank you very much!" - Dmitry Tlusten"I am a 51 year old complete beginner and just wanted to learn access to create my own database for a side business. I first took an MS Access course and then this SQL for Access course which allowed me to understand access better and to add some useful functionality to my database. Really enjoyed it, felt like a great introduction to SQL." - Mark Nugent"If I were to name single biggest advantage of this course I would say that it is very logically structured. In my opinion essential to master any subject. Before the course I had some vague idea of SQL, but after it I feel quite solid." - Bartomiej KurzejaIn this course learn how to:Write SQL code, using the six SELECT clauses.Use functions and formulas in your SELECT statements.Create joins between tables, including more complex joins which cannot be evaluated using the graphical interface.Write action queries and cross-queries.Using derived tables in the FROM clause, and subqueries in the WHERE clause.Creating correlated queries and cross-queries.Using UNION and UNION ALL, andImporting or Linking data and creating Pass-Through queries from other databases.Hopefully, by the end of this course, you will also feel "quite solid" in Access SQL, and be able to use the extra functionality allowed only when using Access SQL to build even better databases.
