• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3: Week 3 At a Glance > Using Advanced SQL Techniques

Day 19. Using Advanced SQL Techniques

In Day 4, "Building a Database and Organizing Data," you learned how to create simple SQL statements that enable you to SELECT certain records from a table in a datasource. In today's lesson, you'll learn more about SQL and its advanced arsenal of selection techniques. You'll learn how to use SQL statements to work with databases that use unconventional table or field names, how to create queries within queries, and how to use SQL's special aggregate functions to find out more about the data you've selected. Users of server-based database applications such as Microsoft SQL Server, Oracle, and Sybase will also learn how to save commonly used SQL statements as stored procedures.

Today's lesson covers:

  • Column aliases

  • Aggregate functions

  • Table joins

  • Subqueries

  • SQL views

  • Stored procedures


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint