094005
1 day
Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.
In this course, you will compose SQL queries to retrieve desired information from a database.
You will:
This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Basic end-user computer skills and some familiarity with database terminology and structure are required. Completion of one of the following Logical Operations courses or equivalent knowledge and skill are highly recommended:
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configurations:
Microsoft® SQL Server® 2012 Express Edition with Service Pack 1
Microsoft® Silverlight®
Topic A: Connect to the SQL Database
Topic B: Query a Database
Topic C: Save a Query
Topic D: Modify and Execute a Saved Query
Topic A: Search Using One or More Conditions
Topic B: Search for a Range of Values and NULL Values
Topic C: Search Data Based on Patterns
Topic A: Perform Date Calculations
Topic B: Calculate Data Using Aggregate Functions
Topic C: Manipulate String Values
Topic A: Sort Data
Topic B: Rank Data
Topic C: Group Data
Topic D: Filter Grouped Data
Topic E: Summarize Grouped Data
Topic F: Use PIVOT and UNPIVOT Operators
Topic A: Combine the Results of Two Queries
Topic B: Compare the Results of Two Queries
Topic C: Retrieve Data by Joining Tables
Topic A: Generate a Text File
Topic B: Generate an XML File
SKU | 094005IE |
---|---|
Weight | 0.0000 |
Coming Soon | No |
Days of Training | 1 |
Audience | Instructor |
Product Family | CHOICE |
Product Type | Digital Courseware |
Electronic | Yes |
ISBN | 1424636353 |
Language | English |
Page Count | No |
Curriculum Library | SQL |
Year | No |
Manufacturer's Product Code | No |
Current Revision | 1.0 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2015-01-20 00:00:00 |