Introduction to SQL Training Course

1622 Enrolled

16 Hours

$15.00$99.00

You save 84%

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

DescriptionInstructorImportant DetailsRelated Products

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

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...