What's Included
-
Airfare To/From Sarasota or Tampa -
1 Microsoft Test Voucher -
Microsoft Training Books -
5 Nights of Lodging -
Ground Transportation -
Instructor Led Classroom Training
About this Course
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
At Course Completion
After completing this course, students will be able to:
• Plan and install SQL Server
• Describes the system databases, the physical structure of databases and the most common configuration options related to them.
• Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
• Create SQL Server Backups.
• Restore SQL Server databases.
• Use the import/export wizards and explain how they relate to SSIS.
• Work with SQL Server security models, logins and users.
• Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
• Work with permissions and the assignment of permissions.
• Work with SQL Server Audit.
• Work with SQL Server Agent, jobs and job history.
• Configure database mail, alerts and notifications.
• Create database maintenance plans.
• Work with SQL Profiler and SQL Trace stored procedures.
CertificationCamps has developed a comprehensive training format which focuses on learning beyond the core content accessible to any Microsoft training provider. Our program incorporates interactive demonstrations with explanations which go beyond the content of the book. Additional content, videos, labs & demonstrations are provided to expand on advanced topics - providing additional insight and perspective.
As a Microsoft Certified Partner with Gold Learning Competency - we adhere to the strict guidelines, standards and requirements to use Microsoft's exclusive curriculum. Our standards go beyond the "minimum requirements" set forth by Microsoft.
We leverage our partnership benefits of courseware customization to build end to end technology solutions. The idea is for students to leave with practical skills which can be implemented immediately when leave class.
Our training program offers solutions before the course by providing you with pre-study materials / pre-class remote lab access, during the course with industry leading instructors and after the course with continued access to the lab environment.
Additionally, we limit our class sizes to 12 students with an average class size of 8. The instructor to student ratio is an important aspect of the learning environment and strict self-imposed rule of our organization.
CertificationCamps core service is training. Our instructors, all of whom hold the Microsoft Certified Trainer (MCT) credential, have over 80 years combined experience training students.
Prior to teaching at Certification Camps - hundreds of hours are dedicated to
• Constructing the content and layout of the course
• Prepping the lecture materials
• Evaluating and testing labs
• Researching additional resources to value add to the course
• Studying and passing the corresponding Microsoft exams
The idea behind these efforts is to provide the best most prepared, qualified and knowledgable instructors in the industry.
Our facilities are second to none. We use top end computer equipment - 22in monitors, cpu's with Intel Virtualization processors, 8 gigs (min) of memory. Our classrooms are outfitted with executive leather chairs to ensure comfort during class hours. Every student has an individual desk allow plenty of room for student computer, personal laptop and book.
The campus is connected with a 2 x 150Mbs Verizon Fios Business Connection which provides a network open for internet access and VPN connections. We provide wired (CAT5E) and wireless (b/g/n) connections.
Additionally, our student break area has complimentary snacks including fruits, chips, baked goods and drinks. Our lounge area provides plenty of comfortable seating and
a 50in LED TV w/ Verizon Fios programming.
Students stay at Marriott & Hilton brand hotels which provide full suite amenities including flat panel tvs, microwave and refrigerator in every room. Students have access to 20+ restaurants within short distance of the hotel.
If you chose not to rent a vehicle - we provide all transportation between airport/hotel/campus/restaurants. Close to the hotel - you will find BoneFish Grill, 5 Guys Burgers & Fries, Urban Flats, Moes, Jersey Mikes, Lee Roy Selmons, Pei Wei, Carrabas, Stonewood Grill, Ruby Tuesdays and more.
What makes us different? Quality of training, state of the art facilities, newer equipment, better location and higher end lodging.
Facilities - Many of our competitors over-crowd classrooms by placing 2 to 3 students per desk. Often they try to extend the life of very old equipment with lag and slow performance on the software used today. Our facilities have the best equipment and provide the most comfort of any environment.
Instructors - Our CEO, Chester Flake holds one of the rarest Microsoft Certifications - the Microsoft Certified Learning Consultant (MCLC) Certification. This certification reflects our company commitment to make sure our instructors are also actively engaged in real world consulting projects.
Vendor Partnership - Our primary focus is teaching Microsoft Courses - as such we are proud to be recognized as a Microsoft Gold Certified Partner. This is the highest level offered.
When you get ready to register for a class - ask these questions -
Will you provide me the BIO of the instructor who will teach my course?
How many students will attend this course, do you have a upper limit you can guarantee?
What type of equipment will be used in class?
Where is the lodging, can you provide pictures of the area?
Get these answers from us and our competitors - we are confident you'll find us to have the answers you want to hear!
From the Blog
Microsoft, Piracy And Serious Changes To The Microsoft Certification Exams
Microsoft started implementing changes to the official Microsoft certification exams as promised in the most recent MCT Summit.  The most significant changes come in the form of addressing piracy of the exams.  Microsoft has a dedicated Psychometrician named Liberty Munson who focuses on data forensics (aka exam results) and looks for “patterns of anomalous behavior†(aka [...]