SQL Advanced Querying

KnowledgeAir
Buffalo, New York, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index tables.

--------------------------------------------------------------------------------

Course Outline:

--------------------------------------------------------------------------------

Lesson 1: 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

Lesson 2: Manipulating Table Data

Insert Data
Modify Data
Delete Data

Lesson 3: 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

Lesson 4: Working with Views

Create a View
Manipulate Data in Views
Create Aliases
Modify and Drop Views

Lesson 5: Indexing Data

Create Indices
Drop Indices

Lesson 6: Managing Transactions

Create Transactions
Commit Transactions
...''

Phone:866-322-3685

School Address:

KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210

KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618


Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo

Search other schools for SQL Advanced Querying training resources.

Excel 2007
OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
SQL Server 2005
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
SQL
Windows 2003 Active directory
Exchange Server 2007
ACT!
CISSP
Advanced Administration of Blackberry Enterprise Server
BlackBerry Enterprise Server
BlackBerry End User
Microsoft Windows SharePoint Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.