Course Syllabus

SQL Fundamental

• Need of SQL as database activity
• Describing the building blocks and standards
• Data Types, Operators and Expressions in SQL

Creating Tables Using SQL

• Creating tables with CREATE TABLE
• Modifying structure of table with ALTER TABLE
• Adding columns to an existing table
• Removing table definition with DROP TABLE

Protecting Data

• Data integrity and constraints
• Preventing Duplicacy with Primary key constraints
• Enforcing integrity with foreign key constraints
• Imposing rules with check constraints

Improving performance

• Creating indexes in SQL
• Important guidelines for index creation

Manipulating Data

• Adding table data with INSERT
• Updating content with UPDATE
• Removing records with DELETE

Controlling Transactions

• COMMIT and ROLLBACK
• BEGIN TRANSACTION in SQL Server

SELECT Statement in SQL

• Retrieving data with SELECT
• Accessing Specific column
• Sorting rows with ORDER BY
• Working with NULL values

Multiple Tables Query

• Matching rows with INNER JOIN
• Accessing non matched rows with OUTER JOIN
• CROSS JOIN

From and Where Clause

• Testing for equality
• Applying wildcard characters

Avoiding NULL values

Combining results

Arrange results with UNION

• Identify matching rows with INTERSECT
• EXCEPT to find non matching rows

Functions in SQL

• SUM
• AVG and COUNT
• MAX and MIN
• GROUP BY
• HAVING

Creating Nested Queries

• Applying sub queries
• Testing the existence of rows
• Including sub queries in expressions
• Placing sub queries in the column list
• Complex expressions