Processing your application. Please be patient while we make sure we receive every piece of it.
SQL Server 2014
SQL: Fundamentals of Querying
1 Day(s)
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
Course Objective: You will compose SQL queries to retrieve desired information from a database.Target Student: Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.Prerequisites: Basic end-user computer skills and some familiarity with database terminology and structure are required. The following Element K courses or equivalent knowledge and skills are highly recommended: • Windows XP Professional: Level 1 • Windows XP Professional: Level 2 • Microsoft Windows Vista: Level 1 • Microsoft Windows Vista: Level 2 • Relational Databases Design (Second Edition)• Access 2003: Designing a Database Course ObjectivesUpon successful completion of this course, students will be able to: • connect to the SQL Server database and execute a simple query. • include a search condition in a simple query.• use various functions to perform calculations on data.• organize data obtained from a query before it is displayed on-screen. • retrieve data from tables.• format an output, save a result, and generate a report.
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: Fundamentals of Querying

Topics

Lesson 1: Executing a Simple Query
Topic 1A: Connectto the SQL Database
Topic 1B: Querya Database
Topic 1C: Savea Query
Topic 1D: Modifya Query
Topic 1E: Executea Saved Query
Lesson 2: Performing a Conditional Search
Topic 2A: SearchUsing a Simple Condition
Topic 2B: CompareColumn Values
Topic 2C: SearchUsing Multiple Conditions
Topic 2D: Searchfor a Range of Values and Null Values
Topic 2E: RetrieveData Based on Patterns
Lesson 3: Working with Functions
Topic 3A: PerformDate Calculations
Topic 3B: CalculateData Using Aggregate Functions
Topic 3C: ManipulateString Values
Lesson 4: Organizing Data
Topic 4A: SortData
Topic 4B: RankData
Topic 4C: GroupData
Topic 4D: FilterGrouped Data
Topic 4E: SummarizeGrouped Data
Topic 4F: UsePIVOT and UNPIVOT Operators
Lesson 5: Retrieving Data from Tables
Topic 5A: CombineResults of Two Queries
Topic 5B: Comparethe Results of Two Queries
Topic 5C: RetrieveData by Joining Tables
Topic 5D: Checkfor Unmatched Records
Topic 5E: RetrieveInformation from a Single Table Using Joins
Lesson 6: Presenting Query Results
Topic 6A: Savethe Query Result
Topic6B: Generate anXML Report

SITE MAP