SQL Training for Data Analysts
Description
This course introduces the SQL language based on the SQL Server platform to people who are new to this topic. In this course, the students will learn how to write Transact-SQL queries against tables and other objects in SQL Server, for various purposes: reporting, testing, data analysis, and more.
The course includes a lot of exercises so that the students will be able to experience what they learn. At the end of this course, the students will be able to work in a SQL Server environment and write efficient queries against database objects.
Intended audience
The course is intended for inexperienced database users, who are required to use databases in their daily work, mainly for data reporting and analysis scenarios. The course is relevant for data analysts, data testers, second level support engineers, and other personnel who are using databases. No previous knowledge or experience is required.
Topics
Introduction to the SQL Language
SQL vs. Transact-SQL
Types of Transact-SQL Statements
Transact-SQL Syntax Elements
System Data Types
System Functions
Connections, Sessions, Batches, and Transactions
The Use of NULL
The SELECT Statement
A Simple Query
Formatting the Result Set
Filtering the Data
Grouping and Sorting
Joining Multiple Tables
Programming Basics
Working with Variables
Conditional Statements
Control of Flow Statements
Views and Temporary Tables
Working with Views
Using Temporary Tables
Manipulating Data in a Temporary Table
Advanced Querying
The CASE Clause
Combining Multiple Result Sets
Using Sub-Queries
Common Table Expressions
Window Functions
Using PIVOT and UNPIVOT
Querying Best Practices
Think Set-Based, not Row-By-Row
Use SARGable Predicates
Retrieve Only the Required Data
Avoid Implicit Conversions
Sort the Data Only If You Have To
Try Several Approaches
האם אתה בטוח שאתה רוצה לסגור את הטופס ולאבד את כל השינויים?
