Bridging the Gap between Technology and Business

SQL Server 2012 Developer Course (37 Hours)

  • Databases – Relational and Others
  • The Database as Part of the System Architecture
  • The Role of the Database Administrator (DBA)
  • SQL Server Versions and Editions
  • SQL Server Services and Components
  • SQL Server Client Tools

  • Overview of System Databases
  • Filegroups and Files
  • Introducing the Transaction Log
  • Database Configuration Options
  • Creating a Database
  • Database Snapshots
  • Schemas and Database Objects
  • Demo and Lab

  • System Tables and System Views
  • System Data Types
  • The Use of NULL
  • Creating a Table
  • Special Data Types
  • User-Defined Data Types
  • Table @Variables vs. #Temporary Tables
  • Table Types
  • Sparse Columns
  • Using FILESTREAM and FileTables
  • Working with Spatial Data
  • Demo and Lab

  • Introduction to Indexes
  • Physical Structures
  • Special Types of Indexes
  • Creating an Index
  • Guidelines for Planning Indexes
  • The Database Engine Tuning Advisor
  • Introducing Statistics
  • Understanding Execution Plans
  • Guidelines for Writing Efficient Queries
  • Indexes and Statistics Maintenance
  • Demo and Lab

  • Data Integrity Overview
  • Primary Key and Unique Constraint
  • Foreign Key
  • Check and Default Constraints
  • Creating Constraints
  • Disabling Constraints
  • Demo and Lab

  • Introduction to Partitioning
  • Partitioning Setup
  • Operations on a Partitioned Table
  • Partitioned Indexes
  • Special Guidelines
  • Demo and Lab

  • Transactions Overview
  • Lock Types
  • Concurrency Issues
  • Transaction Isolation Levels
  • Locking Hints
  • Deadlocks
  • Nesting Transactions
  • Demo and Lab

  • Introduction to Views
  • Creating a View
  • Modifying Data through a View
  • Indexed Views
  • Partitioned Views
  • Demo and Lab

  • Introduction to User-Defined Functions
  • Scalar Functions
  • Table-Valued Functions
  • Joining with APPLY
  • Demo and Lab

  • Introduction to Stored Procedures
  • Stored Procedure Interfaces
  • Creating and Executing Stored Procedures
  • Compilation Sequence
  • Demo and Lab

  • Introduction to Triggers
  • The INSERTED and DELETED Tables
  • Creating a Trigger
  • Nested and Recursive Triggers
  • Triggers Pros and Cons
  • Scenarios for Using Triggers
  • Demo and Lab

  • Introduction to XML
  • XPath and XQuery
  • The XML System Data Type
  • XML Schema Collections
  • XML Indexes
  • Converting Relational Data to XML
  • Converting XML to Relational Data
  • Demo and Lab



Be Our Channel Partner for IT Training Division

Do you want to be a part of our mission in providing Quality Training and help in “Bridging the Gap Between technology and Business”?

  • Amoeba Technologies Sales Executive will contact you and shortlist you for being our channel partner based out on our discussion and shortlisting process
  • We only promote limited partnership depending upon the credibility, location and Business demand
  • No compromise on Trainer Technical Expertise. Amoeba Technologies will provide their own Technical Consultants and Trainers

Please drop your interest and profile at Sales@amoebatechno.com

Testimonials

We sincerely perceive, consider and positively act on our customer’s feedback

Our Clients

Our focus is only you and your benefit