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