Главная
Study mode:
on
1
Start
2
Introduction
3
Introduction to SQL
4
Installing SQL Server
5
SQL Keyword Command Language and Hierarchy
6
Connecting to a SQL Database
7
Creating and Saving a Query
8
Using One or More Query Conditions
9
Applying AND OR Operators
10
NULL NOT NULL
11
Range of Values
12
Querying Data Using Wildcard Characters
13
Formatting Column Headings with Aliases
14
Formatting Query Data Results
15
Performing Date Calculations - DateDifDateAdd
16
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max
17
Manipulating Text Results with String Functions CONCAT_SUBSTR
18
Sorting Data Order BY and GROUPBY
19
RANK and HAVING
20
Mathematical Financial Expressions
21
PIVOT
22
JOIN
23
Union ALL
24
Except Clause
25
Sub Queries
26
Exports
27
Conclusion
Description:
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.

SQL Querying for Beginners Tutorial

Learnit Training
Add to list