There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
In this intro to SQL Server course, you gain the introductory skills to maximize SQL Server's benefits. Learn how to use the various administrative and development tools within SQL Server including the Microsoft BI stack of Integration Services, Analysis Services, and Reporting Services.
SQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence solutions. Attend this hands-on course and learn to leverage these features.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Mar 29 - Apr 1
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Apr 27 - 30
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Jul 6 - 9
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare)
Aug 24 - 27
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Oct 12 - 15
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Jan 11 - 14
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare)
Feb 22 - 25
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.SQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence (BI) solutions. This hands-on course provides the foundational knowledge and skills to build SQL Server databases and develop solutions with the BI stack. Participants learn to write Transact-SQL queries to retrieve and manipulate data, integrate SQL Server with Microsoft Office, and secure, back up and monitor databases with Management Studio.
This is a SQL Server training for beginners so no prior experience is needed to take this course. You will learn the basics of SQL Server and gain the introductory skills needed to maximize SQL Server’s benefits.
Overview of the SQL Server suite of products
SQL Server components and tools
Constructing a relational database
Defining tables
Safeguarding data with constraints
Retrieving data with Transact-SQL
Modifying data with SQL commands
Introduction of developing programming constructs
Executing the Maintenance Plan Wizard
Automating administrative tasks
Monitoring SQL Server resources
Securing the database infrastructure
Connecting to Microsoft Office
Transferring business information
Extracting data with Integration Services
Information delivery with Reporting Services
Aggregating data with Analysis Services
Developing a Business Intelligence strategy
As a Microsoft Gold Learning Partner, Learning Tree can help you prepare for the Microsoft exams that lead to popular SQL certifications like MCSA SQL Server Database Development and the MCSE Data Management & Analytics.
Learn more about SQL Server certification and training options ›
This class runs on SQL Server 2017 Developer version. However, the class is valuable to users on previous versions of SQL Server, and SQL Server 2019 users.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.