TAILIEUCHUNG - SQL PROGRAMMING STYLE- P43

SQL PROGRAMMING STYLE- P43:Im mot trying to teach you to program in SQL in this book. You might want to read that again. If that is what you wanted, there are better books. This ought to be the second book you buy, not the first. I assume that you already write SQL at some level and want to get better at it. If you want to learn SQL programming tricks, get a copy of my other book, SQL for Smarties (3rd edition, 2005). | Follow the ISO-11179 Standards Naming Conventions 7 the SQL standard. The second is that Microsoft does not follow the SQL standard. These problems make it difficult for one naming convention to fit everyone. Exceptions I will give a simple set of rules based on principles of readability and typography but there are other possible conventions 1. Avoid delimited identifiers so you have no problems. 2. IBM uses only uppercase. Unfortunately this is difficult to read and looks like you are still programming on a punchcard system. 3. Microsoft and Oracle use lowercase except where it would look odd. Unfortunately the definition of looking odd is not at all precise. Sometimes reserved words are uppercased sometimes lowercased and so forth. Follow the ISO-11179 Standards Naming Conventions This is a fairly new ISO standard for metadata and it is not well understood. Fortunately the parts that a SQL programmer needs to know are pretty obvious and simple. The real problem is in the many ways that people violate them. A short summary of the NCITS L8 Metadata Standards Committee rules for data elements can be found at the following sites http olken X3L8 drafts archives ubl-ndrsc 200111 Also the pdf file committees 6233 c002349_ISO_IEC_11179 and the draft iso en ittf PubliclyAvailableStandards c002349_ISO_IEC_11179-1_1999 E .zip The ISO-11179 standard is broken down into six sections 8 CHAPTER 1 NAMES AND DATA ELEMENTS 11179-1 Framework for the Specification and Standardization of Data Elements Definitions 11179-2 Classification for Data Elements 11179-3 Basic Attributes of Data Elements 11179-4 Rules and Guidelines for the Formulation of Data 11179-5 Naming and Identification Principles for Data 11179-6 Registration of Data Elements ISO-11179 for SQL Rationale Although the formal standards are good they are very general. It is handy to have a set of

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản