SQL Querying - Level 1 Fundamentals of Querying
- Course Categorization:
- Databases
- Course Provider:
- New Horizons Computer Learning Centers
- Learning Method:
- Classroom Learning
Lesson 1: Executing a Simple Query
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify a Query
- Execute a Saved Query
Lesson 2: 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
Lesson 3: Working with Functions
- Perform Date Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
Lesson 4: Organizing Data
- Sort Data
- Rank Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
- Use PIVOT and UNPIVOT Operators
Lesson 5: 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
Lesson 6: Presenting Query Results
- Save the Query Result
- Generate an XML Report
- Atlanta, GA - April 20, 2012
- Chattanooga, TN - April 26, 2012
- Madison, WI - April 26, 2012
- Memphis, TN - April 30, 2012
- Charleston, SC - May 2, 2012
- Columbia, SC - May 2, 2012
- Greenville, SC - May 2, 2012
- Charleston, WV - May 2, 2012
- Mechanicsburg, PA - May 3, 2012
- Madison, WI - May 7, 2012
- Gainesville, FL - May 8, 2012
- Pensacola, FL - May 8, 2012
- New York, NY - May 11, 2012
- Irving, TX - May 16, 2012
- West Valley City, UT - May 21, 2012
- Pittsburgh, PA - May 22, 2012
- Wauwatosa, WI - May 22, 2012
- Carmel, IN - May 25, 2012
- Eagan, MN - May 25, 2012
- Westerville, OH - May 29, 2012
- Las Vegas, NV - May 30, 2012
- Sacramento, CA - May 30, 2012
- Reno, NV - May 30, 2012
- Richmond, VA - June 4, 2012
- Parsippany, NJ - June 4, 2012
- Charleston, SC - June 5, 2012
- Columbia, SC - June 5, 2012
- Greenville, SC - June 5, 2012
- Charleston, WV - June 5, 2012
- Madison, WI - June 5, 2012
People Also Registered For
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Unix Introduction Level 1
Students will learn the basic skills necessary to understand the structure of the UNIX operating system and to use the available utilities and commands to manage their personal file structures in...
SQL Querying - Level 2 Advanced Querying
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
Red Hat System Administration I (RH124)
This course will actively engage students in task-focused activities, lab-based knowledge checks, and facilitative discussions to ensure maximum skill transfer and retention.
Windows 7 - Level 1
Students will log on to Windows 7, explore its interface, identify the different components in the interface, customize the Windows 7 desktop, manage files and folders, use the common tools and...
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
ITIL Foundations 2011 Edition
This course covers the latest version of core ITIL best practices presented from a lifecycle perspective. The course introduces the principles and core elements of IT service management (ITSM)...
Relational Database Design A Practical Approach
In this course, students will design and create a relational database.
Related Courses
Relational Database Design A Practical Approach
In this course, students will design and create a relational database.
SQL Querying - Level 1 Fundamentals of Querying
In this course, students will compose SQL queries to retrieve desired information from a database.
SQL Querying - Level 2 Advanced Querying
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2
This course focuses on the new features SQL Server 2008 R2 for BI specialists.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...
6231 Maintaining a Microsoft SQL Server 2008 R2 Database
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...
6232 Implementing a Microsoft SQL Server 2008 R2 Database
This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...
