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

Introduction to SQL

Now that you have had a glimpse of what SQL can do, let’s take a closer look. SQL is a standard for which every major relational database management system (DBMS) has a version. After you learn it, it’s not difficult to begin learning and using the SQL versions of other database systems.

You can construct queries directly in the SQL, but strict syntax (language rules) must be applied if you want to run your query. One of the things that sets Access SQL apart is its capability to interpret queries in both directions. This means that you can type SQL statements directly into the SQL window and immediately see the equivalent QBE Design view before running the query. Likewise, you can construct a QBE query and immediately see its counterpart in the SQL window.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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