The spread of dynamic websites on the Internet today is largely due to the possibility for their content to be handled through databases. Database management is a complicated process, which has been considerably rationalized by the SQL programming language.

As its full name (Structured Query Language) implies, SQL is responsible for querying and editing information stored in a certain database management system.

SQL Server Curriculum

Below is a description of  JDP SQL Server Training curriculum RDBMS Concepts

  • Introduction to Database Management System
  • The Relational Model
  • Data Modeling
  • Normalization
  • Data Integrity
  • Advanced Database Objects

Writing Queries using MS SQL Server 2008 T-SQL

  • Getting Started with Databases and Transact-SQL in SQL Server 2008
  • Querying and Filtering Data
  • Grouping and Summarizing Data
  • Joining Data from Multiple Tables
  •  Working with Subqueries
  • Modifying Data in Tables
  • Querying Metadata, XML, and Full-Text Indexes
  • Using Programming Objects for Data Retrieval
  • Using Advanced Querying Techniques

Implementing a Microsoft SQL Server 2008 Database

  • Create databases and database files
  • Create data types and tables
  • Creating and Tuning Indexes
  • Implementing Data Integrity by Using Constraints and Triggers
  • Using XML
  • Implementing Views
  • Implementing Stored Procedures
  • Implementing Functions
  • Implementing Managed Code in the Database
  • Managing Transactions and Locks
  • Using Service Broker

SQL Programming Project

Advanced SQL Querying and Programming

  • SQL 2005 new features workshop
  • SQL 2008 new features workshop
  • Hierarchies and recursive querying
  • Working with dates
  • Concurrency and locking
  • Query performance tuning
  • Database security and encryption
  • Spatial data

Microsoft SQL Server 2008 Integration Services

  • Guided tour of SSIS
  • Control Flow
  • Data Flows
  • Variables and Configurations
  • Advanced Control Flow
  • Error logging and handling
  • Advanced Data Flow
  • Package Deployment
  • Package Management
  • Scripting and custom components
  • Best Practices

Microsoft SQL Server 2008 Reporting Services

  • Introducing SQL Server Reporting Services
  • Creating Tabular and List Reports
  • Calculation and Formatting
  • Grouping and Sorting
  •  Working with Parameters
  • Creating Matrix Reports and Charts
  • Managing Reporting Services
  • Security
  • Snapshots and Subscriptions
  • Ad-Hoc Reporting with Report Builder 2.0
  • Programming Reporting Services
  • Advanced Reporting Services Programming