SQL Programming

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on SQL Programming which gives you the opportunity to interact with a SQL Programming instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


A Tour of SQL Server 2008 

  • SQL Server 2008 Editions, Components, and Tools 
  • Using SQL Server Management Studio (SSMS) 
  • Working with Tables, Queries, and Views 
  • Business Intelligence Services 

Designing and Creating a Database 

  • Relational Database Design Principles 
  • Implementing the Design 

Working with SQL Server Management Studio 

  • Getting Started with Management Studio 
  • Exploring the Object Explorer 
  • Working with the Query Editor 
  • Using SQL Server Books Online 

Transact-SQL Programming 

  • Overview of Transact-SQL 
  • Using Built-In Functions 
  • Controlling Flow 
  • Ranking Results 

Transactions and Error Handling 

  • Transaction Concepts 
  • Applications and Transactions 
  • Creating Explicit Transactions 
  • Using TRY/CATCH Error Handling 

Data Selection Queries 

  • Understanding Transact-SQL 
  • The SELECT Statement 
  • The WHERE Clause 
  • Using ORDER BY to Sort Data 
  • The GROUP BY Clause 
  • Joining Tables

Advanced Data Types 

  • Introduction  
  • The HierarchyID Data Type  
  • Sparse Columns and Column Sets  
  • FILESTREAM Storage  
  • Spatial Data  

Complex Querying  

  • Working with NULL Values  
  • Ranking Grouped Data  
  • Writing Correlated Subqueries  
  • Using Common Table Expressions  

Modifying Data  

  • Modifying Data with Transact-SQL  
  • Inserting Data  
  • Updating Data  
  • Deleting Data  
  • Understanding Transaction Isolation  

Working with XML  

  • The XML Data Type  
  • XML Schema Collections  
  • Querying XML  
  • Best Practices  

Creating Views  

  • What Is a View?  
  • Creating Views  
  • Updating Data Using a View  
  • Using Computed Columns  
  • Indexed Views  
  • Partitioned Views  

Implementing SQL Server Partitions 

  • Overview of Table-Based Partitions  
  • Creating Partitioned Tables  
  • Querying Partitions  
  • Managing Partitions  

Creating User-Defined Functions  

  • User-Defined Function Overview  
  • Scalar Functions  
  • Inline Table-Valued Functions  
  • Multi-Statement Table-Valued Functions  
  • Using Functions, Views, and Stored Procedures  

Creating Stored Procedures and Triggers  

  • Creating Stored Procedures  
  • Creating Triggers  

Advanced Query Techniques  

  • Full-Text Search  
  • Advanced T-SQL Techniques  
  • Executing Dynamic SQL  

Advanced Techniques  

  • Complex Data and Structures  
  • Writing More Efficient Queries  
  • Working with Complex Queries  
  • Maintaining Query Files  

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234