- Duration: Upto 25 Hours
- Timings: Part Time, Flexible
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
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
- 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
Job roles this course is suitable for:
Database Administrator , SQL Database Administrator , SQL Developer / SQL SupportCourse Location
About Rolla Computer and Management Training
In this day and age, When information and technology is progressing day by day, importance of well-trained professionals has been two folds. Rolla Computer & Management training was established to produce Skilled professionals who not only meet the requirements of today but, in future as well. After taking enormous potential of information technology into consideration Rolla Computer and Management has designed its programs in the light of latest information.Rolla computers and management is known as the center of the IT training for executives and students.
We are one of the pioneer institute which offer Internationally Recognized Certifications in United Arab Emirates. It is great credit for Rolla Computer and Management that have successfully trained Thousands of professionals and students through introducing most advance programs like " MCSE, MCP, **OCP, CIW, A++ and **CCNA". Our achievement, growth and development are proof our popularity and reputation for our high standard of education.
SQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft SQL Server Development Apex LearningAED 90
AED 882Duration: Upto 6 Hours - SQL Developer Diploma Lead AcademyAED 95
AED 1,432Duration: Upto 5 Hours