SQL Querying: Fundamentals

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. 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. This book is divided into lessons and topics, covering a subject or a set of related subjects. In most cases, lessons are arranged in order of increasing proficiency.
SQL-Fundamentals
SQL-Fundamentals
SQL Querying: Fundamentals
ISBN : 978-1-61691-565-0

Here's what you will get

Lessons
Lessons
7+
Exercises
17+
Quizzes
25+
Flashcards
69+
Glossary of terms
69+
TestPrep
Pre-assessment Questions
32+
Full Length Tests
2+
Post-Assessment Questions
30+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
3+
Minutes
10+

Here's what you will learn

  • Lesson Objectives
  • Lesson Introduction
  • 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
  • Summary
  • Lesson Objectives
  • Lesson Introduction
  • 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
  • Summary
  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Perform Date Calculations
  • TOPIC B: Calculate Data Using Aggregate Functions
  • TOPIC C: Manipulate String Values
  • Summary
  • Lesson Objectives
  • Lesson Introduction
  • 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
  • Summary
  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Combine the Results of Two Queries
  • TOPIC B: Compare the Results of Two Queries
  • TOPIC C: Retrieve Data by Joining Tables
  • Summary
  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Generate a Text File
  • TOPIC B: Generate an XML File
  • Summary
  • The FullerAckerman Database
  • Schema
uCertify

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved
app_store
google_play