Transact-SQL Essentials for Data Extraction (SF)
About This Course
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
Learners will learn to:
● Use the basic components of SQL Server querying tools.
● Manage data with Transact-SQL
● Query data with advanced Transact-SQL components
● Program databases by using Transact-SQL
● Provision a SQL database over the Azure cloud
The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
What You'll Learn
● Gain an understanding of the Transact-SQL language which is used by all SQL Server-related disciplines.
● Learn how to use SQL Server product features and tools.
Entry Requirements
Basic knowledge of the Microsoft Windows operating system and its core functionality.