SQL

Course details

• Explain SQL Server features and architecture
• Store and retrieve data from SQL Server
• Apply data integrity features to stored data
• Use indexes and views 

• List the features of SQL Server
• Identify the operating systems that support SQL Server 2008
• Describe SQL Server database architecture 
• List database objects
• Use the SELECT statement with different clauses
• Use System Global Variables 
• Use Unions and Subqueries to retrieve data from multiple tables 
• Use Nested and Correlated Subqueries
• Use Aggregate Functions to display summary data 
• Use the GROUP BY clause to generate grouped information
• Apply the HAVING clause to set a condition on grouped data
• Use various SQL functions to query data
• Identify and use various types of joins 
• Define the DEFAULT and CHECK constraints
• Define the PRIMARY KEY, UNIQUE and FOREIGN KEY constraints
• Describe Rules 
• Define Indexes 
• Define and create Views
• List the advantages of Views
• List the guidelines for creating Views
• Define stored procedures
• Discuss types of stored procedures
• Explain the process of creating, modifying and executing stored procedures
• Use parameters in stored procedures
• Define triggers
• List the uses of triggers
• List the guidelines for creating triggers