What Can SQL do? Execute queries against a database ;Retrieve data from a database ;Insert records in a database ;Updata records in a database ;Delete records in a database ;Create new databases ;Create new tables in database ;Create stored procedures in a database ;Create views in a database ;Set permissions on tables, procedures, and views | MS SQL Server DATABASE PROGRAMMING Index Session 1: Database Management Session 2: Database Normalisation Session 3: Joins & View Session 4: Stored Procedure, Union & SubQuery Session 5: SQL Operator & Functions Session 6: Trigger & Curror Appendex: MS SQL Administrator SQL Server Overview What Can SQL do? Execute queries against a database Retrieve data from a database Insert records in a database Updata records in a database Delete records in a database Create new databases Create new tables in database Create stored procedures in a database Create views in a database Set permissions on tables, procedures, and views Index Session 1: Database Management Session 2: Database Normalisation Session 3: Joins & View Session 4: Stored Procedure, Union & SubQuery Session 5: SQL Operator & Functions Session 6: Trigger & Curror Appendex: MS SQL Administrator 1. Creating Databases The SQL Server Management Studio (SSMS) graphical user interface can be used to create and configure new databases. 1. Creating Databases (Continue) Using CREATE DATABASE command Almost all the possible arguments to the CREATE DATABASE command have default values so that it's possible to create a database using a simple form of CREATE DATABASE: CREATE DATABASE Other default values apply to the new database and its files. If the LOG ON clause is not specified, but data files are specified, a log file will be automatically created with a size that is 25 percent of the sum of the sizes of all data files. For the files, if the MAXSIZE clause isn't specified, the file will grow until the disk is full. (In other words, the file size is considered unlimited.) Both SIZE and MAXSIZE can be specified in units of MB (the default) or KB. A value of 0 for FILEGROWTH indicates no growth. The default value is 10 percent, and the minimum value is 64 KB. 1. Creating Databases (Continue) CREATE DATABASE Example CREATE DATABASE Archive ON PRIMARY ( NAME = Arch1, FILENAME = . | MS SQL Server DATABASE PROGRAMMING Index Session 1: Database Management Session 2: Database Normalisation Session 3: Joins & View Session 4: Stored Procedure, Union & SubQuery Session 5: SQL Operator & Functions Session 6: Trigger & Curror Appendex: MS SQL Administrator SQL Server Overview What Can SQL do? Execute queries against a database Retrieve data from a database Insert records in a database Updata records in a database Delete records in a database Create new databases Create new tables in database Create stored procedures in a database Create views in a database Set permissions on tables, procedures, and views Index Session 1: Database Management Session 2: Database Normalisation Session 3: Joins & View Session 4: Stored Procedure, Union & SubQuery Session 5: SQL Operator & Functions Session 6: Trigger & Curror Appendex: MS SQL Administrator 1. Creating Databases The SQL Server Management Studio (SSMS) graphical user interface can be used to create and configure new databases.
