Introduction to SQL Training Course

Introduction to SQL Training Course

1622 Enrolled
16 Hours
Deal Price$15.00
Suggested Price
$99.00
You save 84%
🔥 1,000+ Sold! Selling Fast
Introduction to SQL Training Course
$15.00$99.0084% OFF
Introduction to SQL Course

34 Lessons (16h)

  • Relational Database Basics
    Brief History of SQL
    Relational Databases
    Popular Databases
    SQL Statements
  • Simple SELECTs
    Introduction to the Northwind Database
    Some Basics
    SELECTing All Columns in All Rows
    Exploring the Tables
    SELECTing Specific Columns
    Sorting Records
    The WHERE Clause and Operator Symbols
    Using the WHERE clause to check for equality or inequality
    Using the WHERE clause to check for greater or less than
    Checking for NULL
    Using WHERE and ORDER BY Together
    The WHERE Clause and Operator Words
    More SELECTs with WHERE
    Checking Multiple Conditions
    Writing SELECTs with Multiple Conditions
  • Advanced SELECTs
    Calculated Fields
    Calculating Fields
    Aggregate Functions and Grouping
    Working with Aggregate Functions
    Built-in Data Manipulation Functions
    Data Manipulation Functions
  • Subqueries, Joins and Unions
    Subqueries
    Joins
    Using Joins
    Outer Joins
    Unions
    Working with Unions
  • If time allows, one or more of the following may be covered:
    Conditional Processing with CASE
    INSERT, UPDATE, DELETE
    Student Challenges - Design your own reports
Introduction to SQL Training Course
$15.00$99.0084% OFF
View similar items
DescriptionInstructorImportant DetailsRelated Products

Earn Some Major Business Clout--Become a Data Wizard with SQL Training!

W
Webucator

Instructor

Webucator provides onsite and online training on technologies such as Microsoft ASP.NET, XML, Windows, Java, Adobe Flash, HTML5, JavaScript, Dreamweaver, and much more. Webucator has trained more than 55,000 students from over 13,000 organizations. For more details on this course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Description

The digital world and business world are one in the same these days, and SQL is quickly becoming an essential tool for day-to-day operations. Learn to extract and manipulate data using SQL, so you can easily report and answer important questions as efficiently and accurately as possible. This course is packed with readings, trainer presentations, and exercises for mastering this essential language, from basic database concepts to advanced queries.

  • Dive into the history of SQL & understand database fundamentals
  • Utilize SQL to build applications or generate business reports
  • Apply SQL to all major databases
  • Study potential differences between databases
  • Understand how relational databases work
  • Learn to write queries for extracting data from multiple tables

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Requirements

  • Internet required
  • SQL

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...