SQL Server Administrator Bootcamp
2-course track: $2,400 3-course track: $3,600
Veterans Discount: We offer a 20% discount to Veterans.
Location: Courses may be taken at home or the workplace, via a combination of on-demand video lectures and facilitated hands-on labs.
The SQL Server Administrator bootcamp includes coverage of relational database fundamentals, SQL programming and administering SQL Server 2016 & 2017 databases.
Our unique approach combines on-demand training 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.
The SQL Server Administrator bootcamp provides a solid understanding of relational database design concepts, coding SQL queries and utilizing SQL 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. SQL Administration topics include installing and configuring SQL Server, backing up and restoring SQL databases, configuring security as well as monitoring and optimizing performance of a SQL Server.
Upon completion of the SQL Server Admin bootcamp, students will have developed an excellent fundamental knowledge of database design, as well as critical SQL querying & SQL programming techniques that are required for any positions related to database programming and/or administration. Students will have an appropriate skillset to pursue an entry level Microsoft SQL Server Database Administrator position.
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.
If you would like to enroll in this bootcamp, click here.
SQL Server Administrator Highlights:
- 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 2017
- 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
Note: The Microsoft SQL Server 2017 curriculum is listed below, but if you prefer to take courses for SQL Server 2016 or SQL Server 2014, corresponding courses for those versions are also available.
|Microsoft Transact-SQL Programming||35 hours|
|Microsoft SQL Server 2017 Administration||35 hours|
|SQL Server 2017 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.