- announcement
Welcome to the New SQL Training Online
We've rebuilt SQL Training Online with modern technology to deliver faster, better content. Here's what's new and what you can expect.
- Database Normalization
SQL Database Normalization - 1NF, 2NF, 3NF, and 4NF
Understand database normalization principles for efficient schema design. Learn 1NF, 2NF, 3NF rules with practical examples and downloadable resources.
- SQL Where
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join - SQL Training Online
Complete SQL Joins tutorial covering INNER, LEFT, RIGHT, and FULL OUTER joins. Learn to combine data from multiple tables with video examples.
- PowerBI
Zillow House Price Analysis from CSV Archive - #PowerBI 002
Visualize Zillow housing data in Power BI. Import CSV files and create interactive dashboards for real estate market analysis.
- Beginning SQL
Learn Basic SQL - 1 Hour Training Course - SQL Training Online
Free comprehensive SQL course for beginners. Learn SELECT, WHERE, JOIN, and more in this complete video tutorial covering SQL fundamentals.
- SQL Delete
Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset - SQL Training Online
Learn to create tables in SQL Server with proper syntax. Understand data types, constraints, and best practices for database schema design.
- PowerBI
Clickbank Product Analysis from the XML Feed - #PowerBI 001
Analyze Clickbank product data with Power BI. Learn data visualization and business intelligence techniques for affiliate marketing insights.
- SQL Cast
Latitude and Longitude with the Geography Data Type - SQL Training Online
Work with latitude/longitude using SQL Server Geography data type. Learn spatial queries, distance calculations, and mapping with T-SQL.
- SQL Datetime
Year-to-Date using Partition By with Windowing - SQL Training Online
Calculate year-to-date totals with PARTITION BY and window functions. Learn cumulative sums and running totals for financial reporting.
- SQL INTO
Prior Day Profit using the Lag Function with Windowing in SQL Server
Compare values across rows with LAG function. Learn window functions for time-series analysis and day-over-day calculations in SQL Server.
- SQL Where
Moving Average with Windowing in SQL Server
Master window functions for moving average calculations. Learn OVER clause, PARTITION BY, and ORDER BY for advanced analytics in SQL Server.
- SQL Where
Format Function in SQL Server
Format dates and numbers with SQL Server FORMAT function. Learn custom formats, cultural settings, and best practices for data presentation.
- SQL Between
Union and Union All - How to use it in SQL Server
Combine query results with UNION and UNION ALL operators. Learn differences, performance implications, and use cases for merging data sets.
-
Big Data Everywhere
Big Data has entered mainstream consciousness. Explore how Watson, data analytics, and business intelligence are transforming industries and daily life.
- SQL Server 2012
How to use the SQL Server String Concat Function in SQL Server 2012
Concatenate strings using CONCAT function in SQL Server. Learn to combine text columns, handle NULLs, and build dynamic strings efficiently.
- SQL
How to Filter using SQL IsDate() Function and Cast
Validate date strings with ISDATE and CAST functions. Learn to identify valid dates and handle date conversions safely in SQL Server.
- SQL Subquery
How to Calculate a SQL Moving Average without a Cursor
Calculate moving averages using window functions. Learn ROWS BETWEEN for rolling calculations and trend analysis in SQL Server.
- SQL
Simple Trick to Copy and Paste Web Data into SQL Server
Import web data into SQL Server quickly. Learn the clipboard import trick for rapid data loading from websites into database tables.
- Beginning SQL
SQL Not Like with Multiple Values
Filter with SQL NOT LIKE for pattern exclusions. Learn to exclude multiple patterns and combine with OR operator in SQL Server queries.
- SQL
How to test numeric in SQL Server
Validate numeric data with ISNUMERIC and TRY_CAST functions. Learn to identify and filter non-numeric values in SQL Server queries.
-
Where are Statistics Used?
Understand SQL Server query optimizer statistics. Learn how statistics impact query performance and execution plans for better database tuning.
- Windows Azure
Microsoft Excel to Windows Azure SQL in 10 minutes
Migrate Excel data to Azure SQL Database in minutes. Learn import techniques and cloud database setup for quick data transfer.
- Microsoft SQL Server
Microsoft Business Intelligence Poster
Download Microsoft BI reference poster covering SSRS, SSIS, SSAS, and Power BI. Complete visual guide to SQL Server business intelligence tools.
- SQL
How to Remove Duplicate Rows in SQL Server
Remove duplicate records using ROW_NUMBER, CTE, and DISTINCT. Learn multiple methods to clean data and eliminate duplicate rows in SQL Server.
- SQL Where
How to Filter for SQL Null or Empty String
Handle NULL values and empty strings in SQL Server queries. Learn ISNULL, COALESCE, and comparison techniques for clean data filtering.
- SQL Function
How to Test SQL Server Functions
Test and validate SQL Server functions effectively. Learn debugging techniques, unit testing approaches, and best practices for reliable code.
- SQL IN
How to use the SQL In Statement with Subquery
Combine IN operator with subqueries for dynamic filtering. Learn to write flexible queries using nested SELECT statements in SQL Server.
- tsql
SQL Variable Declaration - How to Declare a Variable in SQL Server
Declare and use variables in T-SQL scripts. Learn DECLARE, SET, and SELECT statements for variable assignment in SQL Server.
- SQL Where
SQL Date Comparison - How to Filter Datetime in SQL Server
Filter dates effectively in SQL Server queries. Learn date range comparisons, BETWEEN operator, and date function techniques for accurate results.
- SQL INTO
SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online
Copy table data using SELECT INTO statement. Learn to create new tables, backup data, and duplicate table structures in SQL Server.
- ODBC
Jet Driver - How to find the Microsoft Access Driver (ODBC) in Windows 7 64 bit - SQL Training Online
Install Microsoft Access ODBC drivers on 64-bit Windows. Solve Jet driver compatibility issues for legacy database connections.
-
SQL With - How to Use the WITH Statement/Common Table Expressions (CTE) in SQL Server - SQL Training Online
Write readable queries with Common Table Expressions (CTE). Learn WITH statement syntax, recursive CTEs, and query optimization in SQL Server.
- SQL
How to use Datetime in SQL Server - SQL Training Online
Master DATETIME data type in SQL Server. Learn date storage, formatting, conversion, and manipulation with practical T-SQL examples.
-
SQL Add - How to Use Addition in SQL Server - SQL Training Online
Perform mathematical operations with SQL addition operator. Learn numeric calculations, column arithmetic, and aggregate functions in queries.
- Beginning SQL
SQL Count
Master the SQL COUNT function to calculate row totals and aggregates. Learn COUNT(*), COUNT(column), and COUNT(DISTINCT) with practical examples for SQL Server.
- Beginning SQL
SQL Average
Calculate averages using the SQL AVG function. Learn how to compute mean values, handle NULL values, and group averages by category in SQL Server queries.
- Beginning SQL
SQL Functions
Explore essential SQL Server functions for data manipulation. Learn string, date, numeric, and aggregate functions with practical examples and best practices.
- Beginning SQL
SQL Order By
Sort query results with SQL ORDER BY clause. Master ascending/descending sorts, multiple column ordering, and NULL handling in SQL Server databases.
- Oracle
SQL Jobs in Oracle and Microsoft SQL Server
Compare database job scheduling in Oracle vs SQL Server. Understand dbms_scheduler, SQL Agent, and career opportunities in database administration.
- Beginning SQL
SQL Like
Pattern matching with SQL LIKE operator and wildcards. Learn %, _, [], and [^] patterns for flexible text searching in SQL Server queries.
- Beginning SQL
SQL Wildcard
Master SQL wildcard characters for pattern matching. Learn how to use %, _, [], and [^] with LIKE operator for flexible searching in SQL Server.
- SQL Join
Troubleshooting a SQL Join
Debug common SQL JOIN problems and unexpected results. Learn to troubleshoot missing rows, duplicates, and incorrect JOIN conditions.
- Beginning SQL
SQL Between
Filter data ranges efficiently with SQL BETWEEN operator. Learn inclusive range filtering for dates, numbers, and text values with practical SQL Server examples.
- Beginning SQL
SQL IN
Learn how to use the SQL IN clause for filtering multiple values. Replace complex OR statements with cleaner, more readable SQL queries in this beginner-friendly tutorial.
- Beginning SQL
SQL AND OR
Understand SQL AND and OR operators for complex WHERE clauses. Learn how to combine multiple conditions and control query logic in SQL Server effectively.
- Beginning SQL
SQL Where
Filter data effectively with SQL WHERE clause. Learn comparison operators, combining conditions, and writing efficient queries in SQL Server.
- Beginning SQL
SQL Distinct
Remove duplicate rows using SQL DISTINCT keyword. Learn how to find unique values, count distinct records, and improve query performance in SQL Server.
- Beginning SQL
SQL Select Statement
Learn SQL SELECT statement fundamentals. Master retrieving data, filtering columns, and writing basic queries for SQL Server databases.