PDF Add to WishList
SQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence (BI) solutions. In this training course, you gain the introductory skills to maximize SQL Server's benefits, and learn how to use the various administrative and development tools within SQL Server — including the Microsoft BI stack: Integration Services, Analysis Services, and Reporting Services.
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
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
“I attended the SQL Server 2012 course remotely via web-based AnyWare and was pleased with my experience. We will be using SQL Server in our next project, so taking this course has been extremely useful in preparation for the future.”
- B. Melideo, Sr. Data Administration Analyst