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.
TRAINING AT YOUR SITE
Our 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.
Feb 22 - 25
9:00 AM - 4:30 PM EST
Apr 11 - 14
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Aug 16 - 19
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Guaranteed to RunWhen 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
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
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?888-843-8733 Live Chat
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.