SQL Server Administrator Bootcamp
2-course track: $2,400 3-course track: $3,600
Veterans Discount: To inquire about discounts, please call 978.250.4983.
The SQL Server Administrator bootcamp includes coverage of relational database fundamentals, SQL programming and administering SQL Server 2016 databases.
Our unique approach combines on-demand streaming with personal facilitation and comprehensive hands-on exercises to assure successful training and competence in the IT workplace. Our support staff provides personal setup assistance, guidance and lab equipment setup for each student. An instructor is assigned to each student to assist in completing lab exercises and to help with any questions about the course content. Our classes are designed to be 50% lecture and 50% hands on exercises. Lab exercises are performed via direct high-speed access to a dedicated lab machine, providing responsive interaction and anywhere/anytime accessibility by the lab facilitator as well as the student.
This bootcamp provides a solid understanding of relational database design concepts, coding and utilizing SQL queries and database management tools. It includes comprehensive coverage of SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. Administration topics include installing and configuring SQL Server, backing up and restoring databases, configuring security as well as monitoring and optimizing performance of a SQL Server.
Take advantage of quality content and personal service to assure your success. Curriculum Advisors are available at 978.250.4983 to answer any questions you may have regarding the programs of interest to you.
- Designing normalized table structures for relational databases
- Creating databases and tables
- Writing SQL queries
- Using subqueries
- Using triggers and stored procedures
- Installing and configuring SQL Server 2016
- Using the SQL Server client tools to manage and configure SQL Server
- Configuring security in SQL Server
- Backing up and restoring databases
- Replicating data using SQL Server replication
- Monitoring events and data changes on a SQL Server
- Managing multiple SQL Server instances using central management
|SQL Programming||21 hours|
|Microsoft SQL Server 2016 Administration||35 hours|
|SQL Server 2016 Business Intelligence: Integration Services and Analysis Services||35 hours|
Students wishing to opt out of first-level courses will be evaluated one-on-one by a technical instructor. Track price will be adjusted accordingly.
50% Lab Time
Call us today to set up a free demonstration of our on-demand platform. We know that you will see the benefits of our self-paced training platform.