SQL Training

S

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

Upcoming Events

SAP ERP CERTIFICATION & INTENSIVE TRAINING WORKSHOP

The SAP Academy Port Harcourt in partnership with SAP Germany is organizing a Three Day SAP ERP Certification & Intensive Training Workshop at the SAP Academy, Port Harcourt.

DATE: 20th - 22nd October, 2016.

Venue: Plot 144 Circular Road, Elekahia Housing Estate, Port Harcourt, Rivers State, Nigeria.

Give yourself and your workforce the knowledge and skills needed to meet strategic goals – with a full suite of training and education courses and certifications designed to help maximize the power of SAP solutions.

We have Designed this 3 Day Intensive and practical base workshop to equip you with the right knowledge that will help maximize your potentials and model your career to a level that employers will not say NO to your Credentials.

COURSE OUTLINE:

FINANCIAL ACCOUNTING

PROCUREMENT CYCLE

MATERIAL PLANNING

HUMAN CAPITAL MANAGEMENT

MANUFACTURING EXECUTION

INVENTORY AND WAREHOUSE MANAGEMENT

SALES ORDER MANAGEMENT



Attractions are:

  • Network with industry users
  • Know companies implementing SAP and how to work with them
  • Free Certification materials
  • SAP Exam tips and how to pass at one sitting
  • Free one month SAP Access
  • Refreshment


Register online Here

You can apply for any of our training programs by filling this form. Enter your full name, functional email address, active phone number and select the program you want to enroll for.

A member of our team will contact you shortly with cost, payment method and other information via email or phone call.

Name

Email

Phone

Select Course


Message