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.
Aug 4 - 7 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare) Reserve Your Seat
Sep 8 - 11 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Reserve Your Seat
Oct 6 - 9 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
Jan 19 - 22 9:00 AM - 4:30 PM EST Toronto / Online (AnyWare) Reserve Your Seat
Feb 23 - 26 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Mar 29 - Apr 1 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
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. In this hands-on course provides the foundational knowledge and skills to build SQL Server 2012 or 2014 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
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.
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.