SQL Querying: Advanced

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

• Construct and apply advanced SQL queries
• Write nested queries and use views effectively
• Perform database administration tasks including table modification
• Optimize queries with indexing and manage transactions

• Basic computer and internet skills
• Ability to read course instructions in English