This three-day course teaches students how to use basic Transact-SQL statements and other languages to query modern editions of Microsoft SQL Server and Azure SQL Server.
This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development, and Business Intelligence.
By using demonstrations and hands-on labs, attendees will learn to perform these tasks using SQL Server, Azure Data Studio, and other database tools.
Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
Access to Microsoft Official Courseware (MOC).
Real-time Virtual Lab Environment.
Experience 24*7 Learner Support.
Self-paced learning and flexible schedules.
Years of Experience
What you will learn
Query, sort and filter data in database tables
Query external data sources
Query SQL Server and Azure SQL Server programmatically
Optimize query performance
Modify data using Transact-SQL
Work with XML and JSON formatted data
Use stored procedures and functions
Use SQL Server tools like SSMS and Azure Data Studio
Use Linked Servers
Experience working on Windows computers.
Who should attend this course?
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. Report writers, business analysts, application developers, and SQL users who want to familiarize themselves with SQL Server will also benefit from this material.
Microsoft Learning Partner
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This
class uses official Microsoft courseware and will be delivered by a Microsoft
Certified Trainer (MCT).