Design & Implementation Of SQL Server 2000
Training
Provided by Bigtec Pvt. Ltd.
The course starts with an introduction to client-server architecture. It introduces the Structured Query Language and builds on the complexity of query handling in SQL Server 2000.In addition it also introduces the comparison between SQL server 2000 and SQL server 2005. It includes the manipulation of Extensible Markup Language data (XML Data). This course covers data modeling, database objects, database programming, indexes and views, optimization and security and XML.
|
|
||||||||||||||
Design & Implementation Of SQL Server 2000
1. INTRODUCTION TO RDBMS
Data & Database
Database Models
Object Based Modeling: ER Diagrams, Relationships, Attributes
Record Based Modeling
Key Concepts
Normalization and Denormalization
2. SQL SERVER 2000
Architecture of SQL Server 2000
Features of SQL2000
Database Architecture & Data files
System Defined Databases
Advantages of SQL 2000
3. SQL COMMANDS
DDL, DML, DCL, TCL and Query
Languages
Data types
Operators
Simple Queries
TOP keyword
ORDER BY, GROUP BY AND COMPUTE BY CLAUSES
4. PREDEFINED SQL FUNCTIONS
String functions
Date Functions
Mathematical functions
System Functions
5. RELATIONAL TABLES
Joins - Inner join, Outer join, Cross join, Equi join, Self join
Subqueries - Nested subqueries, Corelated subqueries
6. DATA INTEGRITY
Maintaining data integrity in the databaseEntity, Domain, Referential and User defined Integrities
Constraints - Primary key, foreign key, unique key constraints
Check Constraint and Default Constraints
User Defined Data types
Rules and Defaults
7. DATA STORAGE IN SQL
Batches
Stored Procedures
User Defined Functions
8. XML
Need for XML documents
Conversion from SQL to XML
Conversion from XML to SQL
9. INDEXES
Features of indexes
Types of indexes
10. VIEWS
Operations on views
11. TRIGGERS
DML Triggers
Data Integrity through triggers
After Trigger and Instead of Trigger
12. TRANSACTIONS IN SQL 2000
ACID Property
Automatic Transactions
Manual Transactions
Cursors
Data & Database
Database Models
Object Based Modeling: ER Diagrams, Relationships, Attributes
Record Based Modeling
Key Concepts
Normalization and Denormalization
2. SQL SERVER 2000
Architecture of SQL Server 2000
Features of SQL2000
Database Architecture & Data files
System Defined Databases
Advantages of SQL 2000
3. SQL COMMANDS
DDL, DML, DCL, TCL and Query
Languages
Data types
Operators
Simple Queries
TOP keyword
ORDER BY, GROUP BY AND COMPUTE BY CLAUSES
4. PREDEFINED SQL FUNCTIONS
String functions
Date Functions
Mathematical functions
System Functions
5. RELATIONAL TABLES
Joins - Inner join, Outer join, Cross join, Equi join, Self join
Subqueries - Nested subqueries, Corelated subqueries
6. DATA INTEGRITY
Maintaining data integrity in the databaseEntity, Domain, Referential and User defined Integrities
Constraints - Primary key, foreign key, unique key constraints
Check Constraint and Default Constraints
User Defined Data types
Rules and Defaults
7. DATA STORAGE IN SQL
Batches
Stored Procedures
User Defined Functions
8. XML
Need for XML documents
Conversion from SQL to XML
Conversion from XML to SQL
9. INDEXES
Features of indexes
Types of indexes
10. VIEWS
Operations on views
11. TRIGGERS
DML Triggers
Data Integrity through triggers
After Trigger and Instead of Trigger
12. TRANSACTIONS IN SQL 2000
ACID Property
Automatic Transactions
Manual Transactions
Cursors
About The Training Provider: Bigtec Pvt. Ltd.
Bigtec Pvt. Ltd. - Bigtec has been conducting inhouse corporate trainings and public workshops and mini conferences on wide variety of subjects related to software engineering since last 4 years and is a very well established training house in India.
Our public workshops have been very popular on Agile Methodology, Rational Unified Process, Requirements Management, OOAD/UML, Architecture, Design Patterns,...
