Systems Engineering and RDBMS

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,
* Express
* Standard
* Enterprise
* Workgroup
* Mobile
* Developer
8. Introduction to different SQL Server Tools and Utilities,
* SSMS
* SSRS
* SSIS
* Profiler
* BIDS
* SSAC
* SSCM
* SSNS
* 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)
4. Joins,
* INNER JOIN
* OUTER JOIN
* FULL JOIN

Class 3: 4 hours

1. Different basic SQL constructs,
* UNION, UNION ALL
* Different Types of functions
* Loops
* Cursors
* 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.

 
%d bloggers like this: