Basic SQL Training Material
Posted by decipherinfosys on April 23, 2008
At the request of one of our clients, we are going to prepare and do basic SQL training sessions for them which will be later on followed with more advanced topics. Here is the current tentative outline:
Basic SQL Training: 20 hours
All the training will be provided using AdventureWorks database.
Class 1: 4 hours
1. Introduction to RDBMS (Relational Database Management Systems),
2. Concept of an Instance vs a Database in different RDBMS,
3. Concept of a login and a user and a schema,
4. Concept of a session,
5. Concept of a client and a server process,
6. Concept of session vs server level settings,
7. Introduction to SQL Server Editions,
8. Introduction to different SQL Server Tools and Utilities,
* Command Line Utilities
Class 2: 4 hours
1. Basic storage data types,
2. Tables, Relationships and Constraints,
* Tables, Constraints and Indexes
* Defining columns and attributes
* Selecting appropriate datatypes
* Setting the primary keys and indexes
* Modifying or removing columns
3. Introduction to SQL – Basic statements,
* INSERT (C)
* SELECT (R)
* UPDATE (U)
* DELETE (D)
* INNER JOIN
* OUTER JOIN
* FULL JOIN
Class 3: 4 hours
1. Different basic SQL constructs,
* UNION, UNION ALL
* Different Types of functions
* SET based Operations
2. Basic meta-data queries,
3. Concept of different object types – Views, Stored Procedures, Functions, Triggers etc.
4. Basic concepts of the storage – Pages/Blocks, Indexes, Heaps, blobs, XML etc.
5. Basic Security Concepts
* Allowing logins access to databases
* Creating SQL Server logins
* Implementing a security plan
* Defining database roles
* Granting permissions on tables to roles
6. Basic Data Export/Import
* Importing data into SQL Server
* Exporting data to text or CSV format
Class 4: 4 hours
1. Using SQL Profiler to monitor the activity.
2. Using SSRS as a reporting platform.
3. Solving some real life problems with SQL,
4. Using BIDS for SSIS packages,
Class 5: 4 hours
1. Performance Tuning,
2. Good coding Practices,
3. Tuning Tips and Guidelines.
If you are interested in receiving the training materials/videos/scripts, please send an e-mail to us at: Training Material and we will e-mail them to you at no cost.
Sorry, the comment form is closed at this time.