Chapter 1 - SQL Tips and Techniques
Chapter 1: Understanding SQL Basics and Creating Database Files
Understanding Flat Files - SQL Tips and TechniquesUnderstanding the Hierarchical Database Model - SQL Tips and Techniques
Understanding the Network Database Model
Understanding the Relational Database Model
Understanding Codd's 12-Rule Relational Database Definition
Understanding Terms Used to Define an SQL Database
Understanding the Components of a Table
Understanding Table Names
Understanding Column Names
Understanding Views
Understanding Schemas
Understanding the SQL System Catalog
Understanding Domains
Understanding Constraints
Understanding the History of SQL
Understanding the Difference Between SQL and a Programming Language
Understanding Data Definition Language (DDL)
Understanding Data Manipulation Language (DML)
Understanding Data Control Language (DCL)
Understanding SQL Numeric Integer Data Types
Understanding SQL Character Data Types
Understanding the Advantages of Using the VARCHAR Data Type
Understanding the LONG (Oracle) or TEXT (MS-SQL Server) Data TypeUnderstanding the MS-SQL Server IMAGE Data Type
Understanding Standard SQL Datetime Data Types and the DATETIME Data Type
Understanding the SQL BIT Data Type
Understanding Constants
Understanding the MS-SQL Server ISNULL() Function
Understanding the MS-SQL Server IDENTITY Property
Understanding Assertions
Understanding the SQL DBMS Client/Server Model
Understanding the Structure of SQL Statements
Understanding SQL Keywords
Using the MS-SQL Server Query Analyzer to Execute SQL Statements
Using the CREATE DATABASE Statement to Create an MS-SQL Server Database and Transaction Log
Using the ED Command Within ISQL to Edit SQL Statements
Using the MS-SQL Server ISQL to Execute SQL Statements from the Command Line or Statements Stored in an ASCII File
Using the MS-SQL Server Enterprise Manager to Create a Database and Transaction Log
Using DROP DATABASE to Erase an MS-SQL Server Database and Transaction Log
Understanding How to Size MS-SQL Server Databases and Transaction Logs
Understanding the MS-SQL Server TempDB Database
No comments:
Post a Comment