INTRODUCTION TO SQL SERVER
Understanding a RDBMS
INSTALLING SQL SERVER
The SQL security and authentication
An introduction to:
- Service manager
- Enterprise manager
- The Query Analyser
DATABASES AND TABLES
Using the Enterprise Manager
Creating a simple table
Creating Primary Keys identities
Learn about SQL Server data types
Setting constraints
DATA RETRIEVAL
The SQL SELECT statement
Using Query Designer
Creating simple SQL SELECT queries
Using special operators
RELATIONSHIPS
Defining relational entities
Creating relationships
Queries vs. views
Creating views
THE QUERY ANALYSER
Query Analyser and Query window
Using Scripts
Creating Scripts to:
- Create / Drop database
- Create / Drop table
- INSERT, SELECT, UPDATE, and DELETE data
LEARNING SQL
Using Distinct, Unique
Using MAX(), MIN(), COUNT() AND AVG()
Using Group By clauses
The DATE and STRING functions
INNER SELECTS
CREATING VIEWS
What are views?
The advantages of views
Build your own views
STORED PROCEDURES
The advantages of stored procedures
Creating stored procedures
Stored procedures: a practical exercise
ADMINISTERING SQL SERVER
Backing up databases
Restoring databases
Developing a maintenance plan to suit your requirements
QUESTIONS AND ANSWERS |
