Expand your knowledge of Structured Query Language (SQL), the
industry standard database programming language. In this course,
you'll learn techniques that will enable you to write powerful
queries that perform complicated searches and sorts on your
data. First, you'll explore how to write and implement complex
queries on multiple tables simultaneously and how to apply
advanced filtering techniques. You'll learn to create union
queries that combine records from multiple queries, and you'll
discover how to use union queries to exclude or include
duplicate records. In addition, you'll find out how to use text
strings within union queries. Next, you'll master advanced
techniques for updating various types of data stored in your
tables. You'll learn how to update a single field, multiple
fields, multiple records, date fields, and calculated fields.
And you'll see how to update and set NULL values using an update
statement. In addition, you'll use advanced insertion techniques
to add data to your tables and learn