- Duration: 1 month
- Timings: Flexible options
Course details
Course Overview:
- Explain SQL Server features and architecture
- Store and retrieve data from SQL Server
- Apply data integrity features to stored data
- Use indexes and views
- Use the programming language features of Transact-SQL
- Create XML documents to display SQL Server data
Course Contents:
- List the features of SQL Server
- Identify the operating systems that support SQL Server 2008
- Describe SQL Server database architecture
- List database objects
- Discuss SQL Server security
- 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
- Apply system-defined data types
- Understand user-defined data types
- Use various SQL functions to query data
- Identify and use various types of joins
- Define Data Integrity
- Describe each type of Data Integrity
- Define the DEFAULT and CHECK constraints
- Define the PRIMARY KEY, UNIQUE and FOREIGN KEY constraints
- Describe Rules
- Define Indexes
- Define Clustered and Non-Clustered Indexes, with Unique or Composite characteristics
- Define and create Views
- List the advantages of Views
- List the guidelines for creating Views
- Describe Indexed Views
- Describe Distributed Partitioned Views
- Identify the restrictions for modifying data through Views
- Modify and delete Views Declare and use local variables
- Distinguish between various control flow structures
- Define stored procedures
- Discuss types of stored procedures
- Explain the process of creating, modifying and executing stored procedures
- Use parameters in stored procedures
- Choose appropriate Recompile Options
- Handle error messages
- Define triggers
- List the uses of triggers
- List the guidelines for creating triggers
- Explain the CREATE TRIGGER T-SQL statement
- List the types of triggers
- Explain INSERT triggers
- Explain UPDATE triggers
- Explain DELETE triggers Define Transactions
- Describe Explicit, Implicit and Autocommit transactions
- Explain transaction isolation levels
- Understand the use of @@trancount
- Define the types of SQL Server Locks
- Identify resource items that can be locked
- Discuss locking issues
- Define cursors
- Use the following to work with the Internet Information Server, and merge data from SQL Server to a Web page:
- ADO in ASP pages
- Remote Data Service
- XML
- Retrieve XML data:
- Using SELECT
- Through HTTP using Queries, Stored procedures and Templates
Benefits of the Course:
Ministry Approved Certificate
Updated on 07 June, 2023About Aptech Computer Training
Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained over 4,00,000 students.
See all Aptech Computer Training courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- USD 42Duration: 1 To 2 Months
- Microsoft SQL Server for Beginners Alpha AcademyUSD 25
USD 240Duration: Upto 4 Hours