Processing your application. Please be patient while we make sure we receive every piece of it.
SQL Server 2014
SQL: Advanced Querying
1 Day(s)
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
Course Objective: You will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel data entry process.Target Student: Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.Prerequisites: To ensure your success, we recommend you first take the following Element K courses, or have equivalent skills and knowledge: • SQL: Fundamentals of Querying (Fourth Edition) • Windows XP Professional: Level 1 and Windows XP Professional: Level 2 or Windows XP: Introduction Course ObjectivesUpon successful completion of this course, students will be able to: • use subqueries to generate query output. • manipulate table data by inserting and updating records in a table and deleting records from a table. • manipulate the table structure. • create views, manipulate data through views, modify the view structure, and drop views. • create indices on table columns and drop inefficient indices. • mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.
Price: $445
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
SQL: Advanced Querying

Course Content

Lesson 1: Using Subqueries to Perform AdvancedQuerying
Topic 1A: SearchBased on Unknown Values
Topic 1B: Comparea Value with Unknown Values
Topic 1C: SearchBased on the Existence of Records
Topic 1D: GenerateOutput Using Correlated Subqueries
Topic 1E: FilterGrouped Data Within Subqueries
Topic 1F: PerformMultiple-Level Subqueries
Lesson 2: Manipulating Table Data
Topic 2A: InsertData
Topic 2B: Modifyand Delete Data

Lesson 3: Manipulating the TableStructure
Topic 3A: Createa Table
Topic 3B: Createa Table with Constraints
Topic 3C: Addand Drop Table Columns
Topic 3D: Addand Drop Constraints
Topic 3E: Modifythe Column Definition
Topic 3F: BackUp Tables
Topic 3G: DeleteTables
Lesson 4: Working with Views
Topic 4A: Createa View
Topic 4B: ManipulateData in Views
Topic 4C: CreateAliases
Topic 4D: Modifyand Drop Views
Lesson 5: Indexing Data
Topic 5A: CreateIndices
Topic 5B: DropIndices
Lesson 6: Managing Transactions
Topic 6A: CreateTransactions
Topic 6B: CommitTransactions

SITE MAP