SQL Data Management

SQL

Serebra Learning Corporation
Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
study at homeThis course may be available for home-study
web-based,online cbt,cdweb-based,online cbt,cd
Duration:3 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
  • B asked: I am interested in gaining knowledge on SQL. Our company is looking at the administration side of SQL (queries) as well as the programming. I am attaching some of the courses that interest me. I am wanting to know if theses courses are available via cd/dvd and if so what is the cost. Please advise.. SQL Queries Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables. more... SQL/DS Essentials This course Introduces the student to the SQL/DS environment, SQL and QMF, as well as teaches structure, commands and security features. more... Basic SQL Programming This course introduces the student to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam -. more... Advanced SQL Programming This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam -. more... SQL Basic Skills This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements. more... SQL Advanced Skills This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions. more... Database Technologies Part : Introduction to SQL The second in a two-part series this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a more...
  • S asked: Where are your price lists? I imagine you loose a lot of business because of this. Also, I do not think I need to answer all the questions below. I am looking for a CBT product.
  • D asked: Dear sir, my name is Ngoc. I'm a student. Hearing form the internet that your organization can support us the training course about Database. So now I Writing this letter with wanting to receive some more information and some document from you. Thank you very much!!!
  • E asked: I HAVE SOME BASIC KNOWLEDGE IN SQL BUT I WANT TO TOTAL GRASP OF THE COURSE. MY BACKGROUND IS PURELY BUSINESS (ACCA - QUALIFIED). COULD YOU RECOMMEND AN ONLINE COURSE AND THE COST INVOLVE.
SQL Data Management
SQL Data Management
Course Code FC480

Outline

  1. Contents
  2. Description
  3. Audience
  4. Prerequisites
  5. Topics Include
  6. Duration
  7. Minimum Requirements
  8. Media

Description

Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes.

Audience

End users, programmers, database administrators, analysts, designers and managers.

Prerequisites

An understanding of database structure and principles.

Topics Include

Manipulating Data

  • UPDATE Command
  • INSERT Command
  • DELETE Command

Defining Database Tables

  • CREATE TABLE Command
  • ALTER TABLE Command
  • DROP TABLE Command

Views, Synonyms and Indexes

  • Defining and Using Views
  • Defining and Using Synonyms
  • Defining and Using Indexes
  • Security Considerations

Duration

3 hrs

Minimum Requirements

VGA Color Monitor; 640K RAM; 3.0MB Hard Disk Space; DOS 3.3; or Higher  

Media

Diskette
CDROM

© Copyright Serebra Learning Corp., 2002

About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Do you teach command ?
Custom Search
tcw11-v473M-09/10/11-16:02:39-()[A]-[A]-[B] -17:28:14