Learn the fundamentals of SQL querying in this comprehensive 2-hour 45-minute tutorial designed for beginners. Master basic SQL usage and terminology, execute simple queries and queries with criteria conditions, and discover how to summarize, organize, and export valuable query data. Explore topics such as SQL keyword command language, connecting to databases, creating and saving queries, using wildcard characters, formatting results, performing date calculations, and applying aggregate functions. Dive into advanced concepts like JOINs, UNION ALL, subqueries, and data exports. Gain practical skills through hands-on exercises and downloadable resources, including SQL Express and the Northwind database. Perfect for individuals looking to extract and manipulate data from relational databases using Structured Query Language.
Overview
Syllabus
Start
Introduction
Introduction to SQL
Installing SQL Server
SQL Keyword Command Language and Hierarchy
Connecting to a SQL Database
Creating and Saving a Query
Using One or More Query Conditions
Applying AND OR Operators
NULL NOT NULL
Range of Values
Querying Data Using Wildcard Characters
Formatting Column Headings with Aliases
Formatting Query Data Results
Performing Date Calculations - DateDifDateAdd
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max
Manipulating Text Results with String Functions CONCAT_SUBSTR
Sorting Data Order BY and GROUPBY
RANK and HAVING
Mathematical Financial Expressions
PIVOT
JOIN
Union ALL
Except Clause
Sub Queries
Exports
Conclusion
Taught by
Learnit Training
