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