Cache SQL must know and must know
Chapter 1 Introduction to SQL
Chapter 2 SQL basics
Chapter 3 ELEMENTS of SQL Language (I
Chapter 3 ELEMENTS of SQL Language (2
Chapter 4 SQL Identifiers ☆☆☆☆
Chapter 5 SQL Definition table (1) * * * * *
Chapter 5 SQL definition table (2) * * * * *
Chapter 5 SQL definition table (3
Chapter 6 Definition and Use of SQL
Chapter 7 Relationships between SQL tables * * * *
Chapter 8 SQL > alter database
Chapter 9 SQL Query database (a
Chapter 9 SQL Query database (2) * * * * *
Chapter 10 SQL Sorting (a) * * * * *
Chapter 10 SQL Sorting (2) * * * * *
Chapter 11 SQL implicit join (arrow syntax
Chapter 12 Using Embedded SQL (1
Chapter 12 Using Embedded SQL (2
Chapter 12 Using embedded SQL (3
Chapter 12 Using Embedded SQL (4
Chapter 12 Using Embedded SQL (5
Chapter 12 Using Embedded SQL (6
Chapter 13 Using dynamic SQL (1
Chapter 13 Using dynamic SQL (2
Chapter 13 Using dynamic SQL (3
Chapter 13 Using dynamic SQL (4
Chapter 13 Using dynamic SQL (5
Chapter 13 Using dynamic SQL (6
Chapter 13 Using dynamic SQL (7
Chapter 14 Using SQL Shell Interface (1) ☆☆☆
Chapter 14 Using the SQL Shell interface (2) ☆☆☆
Chapter 14 Using SQL Shell interface (3) ☆☆☆
Chapter 15 Using SQL Interfaces of the MANAGEMENT Portal (1) ☆☆☆
Chapter 15 Using SQL Interfaces of the MANAGEMENT Portal (2) ☆☆☆
Chapter 16 Importing SQL Code * * *
Chapter 17 Using a Trigger
Chapter 18 Definition and Use of Stored Procedures
Chapter 19 Storing and Using Streaming Data (BLOBs and CLOBs
Chapter 20 Users, Roles, and Rights ☆☆
Chapter 21 Importing and Exporting SQL data
序
This book describes how to use InterSystems SQL, which provides standard relational access to Data stored in databases on the InterSystems IRIS®Data Platform.
The book covers the following topics:
InterSystems SQL language:
- Introduction to InterSystems SQL provides an overview of InterSystems SQL’s relationship to software standards and interoperability.
- “InterSystems SQL Basics” describes the basic functions of InterSystems SQL (such as tables and queries), especially those not covered by the SQL standard or related to the InterSystems IRIS® Unified data architecture.
- “Language elements” describes how InterSystems SQL handles basic elements common to any programming language: numbers, strings, operators,
NULLAnd comments. - Identifiers describe the conventions used to name entities in InterSystems SQL.
Data definition: Create tables and views:
- “Defining tables” describes how to define tables in InterSystems SQL by defining persistent classes or using SQL DDL statements.
- “Defining Views” describes how to define views in InterSystems SQL using the administrative portal or DDL statements.
- “Defining foreign Keys” describes how to define foreign keys in InterSystems SQL.
- Defining triggers describes how to define triggers in InterSystems SQL.
- “Defining and Using Stored Procedures” discusses stored procedures in InterSystems SQL.
- “Storing and Using BLOBs and CLOBs” describes streaming data and how to store and use BLOBs and CLOBs in InterSystems SQL.
- “Users, Roles, and Permissions” addresses the relationship between InterSystems SQL and InterSystems security features.
Data management: Querying and modifying data:
- “Query database” describes how to create and use
SELECTThe query. - “Implicit join” describes an InterSystems SQL extension that provides arrow syntax for implicit joins. InterSystems SQL also provides a standard syntax for explicit joins.
- How do I use Modify Database
INSERT,UPDATEandDELETEModify data and how to group multiple data changes using transactions.
SQL execution interface:
- “Working with Embedded SQL” describes how to write and execute SQL code embedded in ObjectScript code. This chapter also introduces SQL cursors, which enable access to multiple rows of data.
- “Working with Dynamic SQL” describes how ObjectScript contains SQL that is executed at run time.
- “Using SQL Shell” describes how to write and execute SQL statements from a terminal.
- “Using the MANAGEMENT Portal SQL Interface” describes how to write and execute SQL statements from the management portal.
- Import SQL Code describes how to execute SQL statements by importing SQL statements from text files. This interface can be used with InterSystems SQL code or other vendor format SQL code. The imported SQL code can be used to define tables and populate tables with data; It cannot be used to query data.
SQL interface:
- “Importing and Exporting SQL Data” (Appendix) discusses the tools used to import or export data in the management portal.
preface
After two months of serial “Cache SQL must know must know” a total of 40. It is a good choice to learn the basics of SQL.
trailer
The next installment of Cache SQL will be published over a month.
Communication group
- QQ group number: 410039091
- Author QQ: 454115408
- Public number: straight male technology science
