Microsoft Data & Power BI
SQL Fundamentals - Part 1: Essential Querying Skills
Learn the essentials of SQL in one day: run basic statements, filter with conditions, use built-in functions, structure and summarise results, and join tables.
1 dayFoundation6 modules
About this course
Learn the essentials of SQL in one day: run basic statements, filter with conditions, use built-in functions, structure and summarise results, and join tables.
What you'll learn
- Run basic SQL statements to retrieve data
- Apply conditions and logical filters using WHERE clauses
- Use string, numeric, and date functions for calculated results
- Organize and group query output
- Join tables and identify missing or unmatched records
Curriculum
6 modules
- Connect to a SQL Server database
- Create, modify, and execute queries
- Save and reopen query files
- Limit results using comparison operators
- Combine multiple conditions
- Search for ranges, NULL values, and patterns
- Perform date and time calculations
- Manipulate strings and text fields
- Calculate summaries with aggregate functions
- Sort results and apply custom rankings
- Group data and filter grouped rows
- Pivot and unpivot results for advanced formatting
- Merge data with inner and outer joins
- Identify records without matches
- Compare and combine multiple result sets
- Format and save query results
- Generate basic XML output
- Review common reporting use cases
Who it's for
Beginners who need to pull data from databases.
Before you start
- Basic computer literacy
- Basic PC operating system navigation skills
- Basic Internet usage skills
Part of these Alalamia diplomas
Related courses
More in Microsoft Data & Power BI →IntermediateDP-080T00
DP-080T00 Query and modify data with Transact-SQL
Microsoft Data & Power BI
View course →Intermediate
Querying Data with Transact-SQL 55366
Microsoft Data & Power BI
View course →Foundation
SQL Querying Fundamentals Part 2
Microsoft Data & Power BI
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.