When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

SQL Querying: Advanced

SQL Querying: Advanced

位教师：Bill Rosenthal

包含在中

了解更多

7个模块

深入了解一个主题并学习基础知识。

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

7个模块

深入了解一个主题并学习基础知识。

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

In this course, you will construct advanced queries and apply them to data.

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有7个模块

In today's competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization's processes and give it a competitive edge. Some data analysis tasks may require that you query multiple tables simultaneously or create complex views of data.

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables; modifying table structures; inserting, updating, or deleting data; and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction. This course is intended for individuals who have basic SQL skills and who want to expand their skillset with more advanced tasks. In this course, you will: use nested queries to generate query output; manipulate table data by inserting, modifying, and deleting data; manipulate the structure of tables; work with views to present data; index data to improve querying efficiency; and manage database transactions. This course requires that you have Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

单元详情

You have performed some fairly complex queries using a basic SELECT statement. However, SQL provides advanced capabilities that enable you to take your queries further. In this course, you will use these advanced capabilities to build on the fundamentals of SQL querying. You will start by performing various types of nested queries.

涵盖的内容

10个插件

10个插件总计145分钟

Getting Started with This Course30分钟
Lesson Introduction5分钟
Search Based on Values from a Subquery15分钟
Compare Values from a Subquery15分钟
Search Based on the Existence of Records15分钟
Generate Output Using Correlated Subqueries15分钟
Filter Grouped Data Within Subqueries15分钟
Perform Multiple-Level Subqueries15分钟
Mastery Builder: Using Subqueries to Perform Advanced Querying15分钟
Lesson Summary5分钟

Although database client applications typically provide features within the user interface to manage content, in many cases you may need to set up database structure and content before you deploy an application. Or you might need to perform maintenance tasks outside the client application. Using SQL, you can directly perform such tasks. In this lesson, you will use SQL to insert, update, and delete rows.

涵盖的内容

5个插件

Over time, you might need to change your database's structure. You can use SQL to add new tables and new columns, or change the types of data stored within a particular column.

涵盖的内容

7个插件

Some database users may not know how to write SQL queries, or may not want to be bothered to write a query to view data coming from multiple tables. Or you may want to hide certain columns of data from the view of end users. Database views enable you to control what data users see, like a query, but they can be quickly invoked to present data in a particular way. In this lesson, you will create views and use them to manipulate data, modify views, and delete views.

涵盖的内容

6个插件

How Microsoft® SQL Server® retrieves the data that satisfies a query can have a huge impact on your database server's performance, especially if you have very large tables. One of the strategies you can use to improve the efficiency of SQL Server is to create indexes to support your most frequently executed queries.

涵盖的内容

5个插件

Some database transactions must be accomplished through more than one SQL statement. If a problem occurs at any point in the transaction, you need to roll back each step of the entire transaction to get the database back to its original state. SQL provides features that enable you to accomplish this.