SQL Programming

Essential Structured Query Language (ANSI SQL-99) six page laminated guide with core commands, statements, syntax and terms for support of beginners who are learning, and experts as a handy quick reference. Author Robin Nixon worked with computers in the 80s and started developing websites in the 90s becoming an expert and writing over 40 programming books and over 500 articles for top computer magazines. With his expertise in the field and writing to his audience in our succinct and organized QuickStudy format, this reference has more quality actionable facts per page than any book or website. Designed for quick access to the facts you need, this inexpensive tool has been a best seller for over 10 years and is an easy add to your programming toolbox. 6 page laminated reference Includes: Overview History Popular RDBMS Key Components & Operations Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Transaction Control Language (TCL) Data Query Language (DQL) Conventions Data Types Numeric Types String Types Date & Time Types Other Data Types Operators Math Comparison String Variables Comments Bitwise Miscellaneous Logical Operator Precedence DDL Databases Creating a database Modifying a database Deleting a database Tables Creating a table Altering a table Deleting a table Table Indexes Creating an index Deleting an index Views DML Search Conditions Where From & Join Group By Having Order By Into Top SQL Statements Select Insert Update Delete Truncate Table

Sdílet