welcome to Extech IT

Database Management SQL Server

Overflow

The APTECH PL/SQL programming training is an intense course that is designed to give the student hands-on exposure to Oracle PL/SQL.  The student learns by coding, and this class has dozens of in-class exercises and the student will be guided from very simple PL/SQL programs to increasingly complex PL/SQL coding techniques.

The topics start with the basics of PL/SQL and progress into increasingly complex programmatic structures including array manipulation cursor management and bulking operations.  The PL/SQL training class begins with simple concepts and the student gradually masters PL/SQL through increasingly challenging classroom exercises. 

Students get the knowledge and experience to be productive Oracle DBA in any company from Day one.

MODULES

Class 01 Installing, Configuring and Managing MS SQL Server 2012
Class 02 RDBMS Basics
Class 03 Learning the Tools of the Trade
Class 04 The Foundation Statements of T-SQL
Class 05 The Foundation Statements of T-SQL
Class 06 The Foundation Statements of T-SQL
Class 07 JOINs
Class 08 JOINs
Class 09 Creating and Altering Tables
Class 10 Creating and Altering Tables
Class 11 Keys and Constraints
Class 12 Keys and Constraints
Class 13 Adding More to Your Queries
Class 14 Adding More to Your Queries
Class 15 Being Normal: Normalization and Other Basic Design Issues
Class 16 Being Normal: Normalization and Other Basic Design Issues
Class 17 Being Normal: Normalization and Other Basic Design Issues
Class 18 Being Normal: Normalization and Other Basic Design Issues
Class 19 SQL Server Storage and Index Structures
Class 20 SQL Server Storage and Index Structures
Class 21 SQL Server Storage and Index Structures
Class 22 Views
Class 23 Writing Scripts and Batches
Class 24 Writing Scripts and Batches
Class 25 STORED PROCEDURES
Class 26 STORED PROCEDURES
Class 27 User-Defined Functions
Class 28 Transactions and Locks
Class 29 Triggers
Class 30 Triggers
Class 31 A Brief XML Primer
Class 32 Business Intelligence Fundamentals, Storage and Reporting Resources
Class 33 Reporting Services
Class 34 Getting Integrated with Integration Services
Class 35 Playing Administrator