Indice degli argomenti

• Using SQL in InterSystems IRIS

  Using SQL in InterSystems IRIS

  Content Type
  Learning path

  Duration
  3h 45m
  

  Level
  Introductory

  Learn how to manage SQL operations and use advanced SQL features within an InterSystems IRIS® data platform environment. In this learning path, you will see best practices and gain knowledge of query optimization and SQL application management so you can build efficient, scalable SQL applications.

  This path contains three sections. One, Establish SQL Development Best Practices, 35 minutes. Two, Enhance SQL Query Performance, 1 hour 45 minutes. Three, Manage SQL Operations, 1 hour 25 minutes.
• Minimizza tuttoEspandi tutto
  1. Establish SQL development best practices

  1. Establish SQL development best practices

  Learn the fundamentals and best practices of SQL development in InterSystems IRIS.

  • URLDocumentation: Define SQL Optimized Tables Through Persistent Classes (10m)
  • URLDocumentation: Relationships Between SQL Tables (5m)
  • URLVideo: Connecting an SQL Client to InterSystems IRIS (2m)
  • URLExercise: Running Fast Queries with SQL in InterSystems IRIS (10m)
  • URLVideo: Setting Up Foreign Key Constraints (6m)
  • URL(Optional) Documentation: Working with Collection Classes (15m)
• 2. Enhance SQL query performance

  2. Enhance SQL query performance

  Optimize SQL queries for improved performance and efficiency within InterSystems IRIS.

  • URLVideo: Enhancing Query Performance with the SQL Optimizer (35m)
  • URLVideo: Finding and Fixing Slow SQL Queries (9m)
  • URLOnline Course: Optimizing SQL Queries in InterSystems IRIS (15m)
  • URLVideo: Optimizing Your SQL Queries (40m)
  • URL(Optional) Documentation: Choose an SQL Table Storage Layout (10m)
  • URL(Optional) Developer Community: Learn more about the Universal Query Cache (10m)
• 3. Manage SQL operations

  3. Manage SQL operations

  Implement and manage SQL operations while ensuring data integrity and security.

  • URLDocumentation: SQL Performance Analysis Toolkit (15m)
  • URLDocumentation: SQL Users, Roles, Privileges (20m)
  • URLDocumentation: InterSystems IRIS Auditing Guide (45m)
  • URLVideo: Navigating SQL Privileges and Security in InterSystems IRIS (6m)
  • URL(Optional) Documentation: Transaction Isolation Level (5m)
  • URL(Optional) Documentation: Locking and Concurrency Control (30m)
• What's Next?

  What's Next?
  • Get an overview of using SQL in InterSystems IRIS (online course, 30m).
  • Learn in depth about developing with InterSystems Objects and InterSystems SQL (classroom course, 5 days).
  • Read more about InterSystems SQL commands, and functions (documentation).
  • Prepare for the InterSystems IRIS SQL Specialist certification exam (practice questions).

  • Share Your Feedback!