Description
SQL is used to communicate with a database. According
to ANSI (American National Standards Institute), it is the standard language
for relational database management systems. SQL statements are used to perform
tasks such as update data on a database or retrieve data from a database. It is
a specialized language for updating, deleting, and requesting information from
databases
Course Contents
- Categorize
the main database objects
- Review the table structure
- List the data types that are available
for columns
- Create a simple table
- Explain how constraints are created at
the time of table creation
- Describe how schema objects work
- Limit
the rows that are retrieved by a query
- Sort the rows that are retrieved by a
query
- Ampersand substitution to restrict and
sort output at runtime
- Describe
various types of functions (character, number, date, string etc.)
available in SQL
- Joins,
Inner Join, Outer Join, Left Join, Right Join
