SQL Querying: Fundamentals

SQL-Fundamentals
SQL-Fundamentals
SQL Querying: Fundamentals
ISBN : 978-1-61691-565-0
Learn the skills of SQL Querying with the SQL Querying Fundamentals course. 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. The study guide offers coverage of topics including data organization, simple Query, performing conditional search, exporting Query results, retrieving data from multiple tables, and many more.

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