NR Computer Learning Center
          HOME PAGE  |   ABOUT US  |   TRAINING  |   SCHEDULE  |   SITE MAP  |   FAQ's  |   TEENS  |   CONTACT US  |   CAREER
 

 

A640 SQL Language
  Description:
 
The 2-days hands-on course helps student learn develop,edit and execute the basic to advanced SQL queries to manipulate data and index tables.
 
  PreRequisite:
    Basic end-user computer skills and some familiarity with database terminology and structure are required.
 
  Duration:
    16 hour(s)
 
  Course Detail:
    Upon successful completion of this course, the students will be able to:
connect to the SQL Server database and execute a queries.
include a search condition in a query.
use various functions to perform calculations on data.
 
  Topics:
    Executing a Simple Query
  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify a Query
  • Execute a Saved Query
Performing a Conditional Search
  • Search Using a Simple Condition
  • Compare Column Values
  • Search Using Multiple Conditions
  • Search for a Range of Values and Null Values
  • Retrieve Data Based on Patterns
Working with Functions
  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values
  • Organizing Data
  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators
Retrieving Data from Tables
  • Combine Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables
  • Check for Unmatched Records
  • Retrieve Information from a Single Table Using Joins
  • Presenting Query Results
  • Save the Query Result
  • Generate an XML Report
Advanced Querying Using Subqueries
  • Search Based on an Unknown Value
  • Search Based on Multiple Unknown Values
  • Compare a Value with Unknown Values
  • Search Based on the Existence of Records
  • Generate Output Using Correlated Subqueries
  • Filter Grouped Data Within Subqueries
  • Perform Multiple-Level Subqueries
Manipulating Table Data
  • Insert Data
  • Modify Data
  • Delete Data
Manipulating the Table Structure
  • Create a Simple Table
  • Create a Table with Constraints
  • Add and Drop Table Columns
  • Add and Drop Constraints
  • Modify the Column Definition
  • Back Up Tables
  • Delete Tables
Working with Views
  • Create a View
  • Manipulate Data in Views
  • Create Aliases
  • Modify and Drop Views
Indexing Data
  • Create Indices
  • Drop Indices
Managing Transactions
  • Create Transactions
  • Commit Transactions
 
  Date & Time:

Start DateEnd DateStart TimeEnd TimeFeeRegistrationLink
10/11/201010/12/201009:00:00AM04:00:00PM$499
     
   

© COPYRIGHT 2001 ALL RIGHTS RESERVED N&R Technology, LLC