access
lifetime
content
16 Hours
enrolled
1,622
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
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!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.
Course Outline
- 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
access
lifetime
content
16 Hours
enrolled
1,622