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