The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 certification confirms that you have the essential skills required to develop and maintain mission critical Microsoft SQL Server 2012/2014 environments. MCSA: SQL Server 2012/2014 certification is the first step towards earning an MCSE: Data Platform certification or MCSE: Business Intelligence certification.
The MCSA: SQL Server 2012/2014 Bootcamp is 9 days of an intense deep dive into all aspect of SQL Server 2012/2014 including query, administration and data warehousing.
The Boot Camp will prepare you for the following exams:
Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
What you will learn?
Exam 70-461: Querying Microsoft SQL Server 2012/2014
After completing this course, students will be able to:
Write SELECT queries
Query multiple tables
Use built-in functions
Execute stored procedures
Use set operators
Implement error handling
Use table expressions
Sort and filter data
Use window ranking, offset and aggregate functions
Query SQL Server metadata
Program with T-SQL
Improve query performance
Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases
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.
Implement SQL Server agent security, proxy accounts and credentials.
Configure database mail, alerts and notifications.
Create database maintenance plans.
Work with SQL Profiler and SQL Trace stored procedures.
Introduce DMVs and the configuration of data collection.
Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
Troubleshoot SQL Server databases.
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
After completing this course, students will be able to:
Describe data warehouse concepts and architecture considerations.
Select an appropriate hardware platform for a data warehouse.
Design and implement a data warehouse.
Implement Data Flow in an SSIS Package.
Implement Control Flow in an SSIS Package.
Debug and Troubleshoot SSIS packages.
Implement an SSIS solution that supports incremental data warehouse loads and changing data.
Integrate cloud data into a data warehouse ecosystem infrastructure.
Implement data cleansing by using Microsoft Data Quality Services.
Implement Master Data Services to enforce data integrity.
Extend SSIS with custom scripts and components.
Deploy and Configure SSIS packages.
Describe how information workers can consume data from the data warehouse.
Each day of training is section wise of Lecture, Lab, and Review modules.
Days 1-3: Querying Microsoft SQL Server 2012/2014
Days 3-6: Administering Microsoft SQL Server 2012/2014 Databases
Days 7-8: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Note: Daily schedule might be changes according to materials requirements to ensure that the objectives of the course are met.
LIIT's Certification Boot Camp include the following:
Hands-on Instructor-Led Training
Our Guarantee - Pass first time or Free retake within a year of completion, just pay for accommodation, meals, and vendor exam fees.
Books & Study Materials
Test Preparation Questions and answers for practice
Certification exams vouchers, one retake exam voucher (if required)
Breakfast & Lunch
Also we have all include in price option with AirFair and Hotel.
AWESOME JOB! GREAT SCHOOL !!!
- Maria M 3
The instructor is extremely intelligent and knowledgable. I learned so much and have bever really been involved in any type of networking. I really enjoyed this class and networking. I really enjoyed this and too away a tremendous amount of understanding and knowledge and would recommend it to any IT Professional.
I would like to say that LasComp Institute was very helpful and accomodating. The teachers are great and very knowledgable. Both are awesome. the classes are very helpful and provide great knowledge and preparation to work in the field.
Excellent program. Extremely knowledgable instructor. Mr. Levario is an asset to this institution. He doesn't only teach but puches us to a point we didn't think we could reach. He also constantly advises us on what will be demaned from us in corporate.
The HR Management class covers every detail you need to know in the HR industry. The instructor is extremely knowledgable and a great choice for the school. I have learned a lot and am thankkful I was a student here. The computer classes have really brought my computer skills up to date.
- Margie SP
Although I'd a Computer science background, I wanted to broaden and advance my professional development with training specializing in the latest advances summarizing data and data science in order to address business challenges.
The training I received as well as earning several certifications specializing in enterprise management, data analyzing and data science was instrumental in landing my current position.
I would recommend the LasComp PMP Course to anyone looking to enhance their project management skills. I feel that the instructors were very knowledgeable in the subject matter (PMP, MS Project, MS Visio) Their ability to cover the material ensuring that everying understood how to apply the principles learned. My overall experience at LasComp was excellent.
- Joann B
- Ruth S
- Rosa R
- Joan L
- Jeanette P
This is a great program and I would recommend it to other people. Hope it's going to help me to find a better job.
Thank you !!!
- Genrietta S
This course was very helpful to me. It helped me get my new job! Thank you . It gave me knowledge and confidence.
- Deidke Y
Course is conveniently scheduled in a firendly atmoshpere. Software instruction is very interactive. Instructor has a strong understanding of software and is able to communicate his knowledge to users of all levels.
- Catherine S
It was very interesting what they teached and what I learned. Very friendly people I meet.
Instructors very knowledgable and helpful. Materials for MS Office excellent. Materials for Quickbooks (book provided) not supportive for learning the entire program. Flexible hours beneficial to studying and looking for employment. Overall a great program for learning MS OFFICE.
I would definitely recommend LASCOMP to family and friends. The two (2) instructors that I had were both great! I learned a lot and really enjoyed coming to class everyday/ The program was perfect for me.
The instructor is an excellent teacher. There was not an instant that I had a question where the teacher didn't have the answer. The teacher always guided me when I needed help to grasp the material. Even though the classes was made up for different age groups, computer knowledge and background the teacher was able to help us master the different microsoft programs.
The instructor is the best teacher I had. Helped me with MS Excel and Quickbooks. Thanks to the teacher. I have no limits in business. The accounting teacher made the class fun when I was in the class. I discovered a new interest for accounting and bookeeping.
Teachers were bery patient and helpful. The students all helping one another to learn and boost each other up was humbling. Th eonly downfall to the school was how hot the upstairs medical class room was ( but that will be better very soon). Computer and books were all available to the students and helpful. Overall so happy I did this.
Current certifications/course subject matter for job market. Mr. Alam worked with student to increase likelihood of success in classroom training and certification. I would have like more support on lab days but I think that is being addressed.
The staff of professors is very knowledgable. the material for classeds is well chosen and geared to an optimal learning experience. The upcoming change of locations will make the insitution be among the very best.
The instructor effectively covered Java concepts to allow me to bridge the gap from structured programming to object oriented programming. The instructor also convinced me tat I must be focused and test all code to relaler understand fundamentals and architectures. This java class has been a great expereince for me and will opwn up opportunies.
I had a a very good experience at LIIT. The teachers were very knowledgable and I learned a lot during my course. The only thing I would do is shorten the time of each class and extend my course from 6 weeks to 10 weeks. It would give more time to absorb each chapter of the book.
Gordana is very knowledgable and essential to the learning atmosphere. She's pateint and explains indtails so that ou clearly understanmd what you are doing. It was truly a pleasure coming to class everyday. I enjoyed the leaning experience.
The instructors for the 3 courses are extremely knowledgable in the subjects and they did and excellent job. Their program is very challenging but if you effort to work in this labs and review the call materials you will learn a lot. I really enjoyed this take the program.
The school provides an opportunity to learn at your pace. This affords you the time you need to review certain areas and also to advance when you feel you are comfortable enough with the material to move forward.
I found the coursework and materials very educational and challenging, but also impactful. The instructor was very knowledgable and had a good approach to reaching that help to clarify and solidiify the materials. I would recommend this course institute and instructor to anyone wanting to advance their education.
The school was great. they taight pertinent, real-world skills. The instructors were top-notched and knowledgable. It was easy to adjust to school classes around personal schedule because they have there campuses that all students can attend.
I am extremely happy and grateful with my selection to participate in the AOSS course with LasComp. I learned at my own pace with help from an outstanding staff and teacher who was very patient with his students. I highly recommend this school.
"LasComp" has been an incredible experience ! It was everything that I had been looking for. My teacher Gordana was amazing. I highly recommend this school. Thank you for a wonderful experience to my new computer skills!!
The teacher was very skilled with strong practical knowledge of the subject matter. The class mates were very involved, makign for an extremely balanced learning experience. The hands on approach worked well and I found this experience to be top notch. I would recommend this course to anyone looking to enhance their skills in an interesting way.
It was an incredible program! Mr. Levario and Mr. Alam were always on top of our training and are incredibly knowledgable! They genuinely care about their students and wat them to succeed! Thank you !!
The instructors are exceptionally knowledgable and extremely helpful. Expecially, Ms. Gordana who instilled confidence as well as knowledge. Each instructor was so patient and kind no matter what the question or how many times it was asked. I am very happy with the training I received and feel confident that I will excell in any positon I receive.
Liit has a very welcoming environment. The teachers and administration is very cooperative. The classes have good equipment and refreshments/coffee in supplied well. My entire Experience here has been positive.
LIIT offered a very comprehensive program that allowed me to progress at my own pace. The instructor was extremely knowledged and had a pleasant demanor. The atmosphere of the classroom allowed for learning in a stree free environment.
I liked very much the entrepreneurship and the microsoft learning program. I learned a lot of new functions which will help me do my job better. I was able to pass the exam to get the microsoft excel certification.
It was an incredible program! Mr. Levario and Mr. Alam were always on top of our training and are incredibly knowledagable! They genuinely care about their students and want them to succeed! Thank you !
Excellent Teacher, school facility, and books. Staff very helpful and available. CFR Class is the best training I have been in. The lab work is excellent and the system training is up to date and easy to use.
I have very little experience with web design, but I am confident in my new skills. IT is is best to have basic understanding of at least HTML, but the teachers are very knowledgable. Be sure to ask questions and practice. I learned a lot in such liitel time.
The instructor is the best thing about the school. The instructor is nice and great. The other two sub instructors are also nice. It was not easy for me to learn now things at my age but I did thanks to LIIT.
LIIT was very helpful in helping me to uderstand as well as use computers in a corporate environment. I definitely recommend this to all who are trying to get their foot in the door in the IT industry.
The LIIT Course was a positive experience both regarding to kowledge gained and the staff. The instructor was positive and always hellpful with the course and with the resume and job assistance I would recommend this school to anyone.
The director, Mr. Alam, allowed me to move to another room where there is less noise, which was amplified with my hearing aids, because disruptive to my training classes. His understanding was appreciated. The PROGRAM allowed progressing through the microsoft suite at your own pace; which was an advantage. The IT Support always responded to questions. The program will be a great tool in my employment search.
The instructors are wonderful and very helpful. They are willing to go the extra mile to assist and give you practical advise in attaining the knowledge to pursue your career goals. Mr. Alam provides you with the necessary resources to assist in your education. The rest is up to you! Take advantage of the opportunities provided.
First I want to thank you for this opportunity to be in this school; I t was a nice experience , and understood I was not alone, my classmates were very nice and our instructor is GREAT with knowledge and very helpful everytime and on every need. THANK YOU INSTRUCTOR and THANK YOU LASCOMP!
As a long time PM, with over 20+ years' experience, LIIT provided a strong curriculum in PMP training. I know that the training will rfeinforce my confidence and kills in moving forward PMP Certification.
I really like coming to this school, because the facility and teacher was very helpful to gain my knowledge and certification for microsoft. The teacher was very helpful and pleasant to work with and is the best teacher ever.
At first I was a little hesitant about LasComp's teaching style not being teacher led), but it turned out that it was a good thing. I was able to progress at my own speed and had the help of the teacher if I encountered difficulty.
The class was very informative and went at a good pace. There was a lot of interaction between members of the class which was helpful in reviewing the test questions. The teacher was very knowledgable and personable. I enjoyed the class and would recommend it.
Mr. Alam, Instructors and staff are very knowledgable, kind and bery helpful. I am glad that I picked lasComp Institute to enhance my computer skills and add a new career direction as a MAAS-Medical Administration Assistant. I would recommend this school for anyone looking to develop new skills.
The Classes were comprehensive and the instructor knowledgable. Although there were many students; the instructor always available whenever I needed help. She was and also very patient. Additionally, the atmosphere was friendly and relaxed.
Excellent program at a great location with an amazing instructor . I have learned so much in 2 months here than I have ever done in the last 5 years. I wish I could have done this sooner because so far best decision I've made.
The director is friendly helpful and knowledgable. Teachers were excellent. The facilties are state of the art and up to date. Very surprising how many computers there are for the students. You work and learn at your own pace. Teachers are very patient. My program was taught well. Sad to see it end.
The class is very easy to understand; the labs done during the classroom help understanmd everything faster. The professor taught very well and the school provided you with anything you needed to study for the exam.
Before I started at LIIT I asked who was the best IT School ground. The answer was LASCOMP and they they delivered what I was looking for. The Staff is awesome and now my future is bright. Thank you for the esteem boost.
I appreciate the "Learn at your own pace" format. I know it may not be everyones cup of tea, but if you need to slow down to pay more attention, you can or if you want to fly thorugh the sections that's an option (if you already know some of it, a taught" class may hold you back).
Class Conducted by teacher being available was helpful. Learned a lot of programs in short amount of time - Hope I am able to retain information for the future. Happy to know I am welcome back anytime - THANK YOU!
The Instructors is wonderful and knowsexcel very well. The Duration of the accounting & Bookkeeping class. Should be longer you can follow the book and speed thorough chapter and not retain much. Students needs to that the instructor to understand what they are doing.
Great School great teachers and Shams makes sure you are progressing and are take care of. The facilty is cozy and the equipment is new and functional. The way they have it set up enables the student to learn at their own pace. No pressure from the teachers or to finish, the environment is ideal to learn and master whatever course you decide. The AOSS class helped me learn new things with Microsoft Office that I would have never otherwise learned. Shams and the teachers are great team and this is the place to go if you want to actually learn something without the added stress that most schools place on you.
I had the opportunity to expand my knowledge in networking. The instructor was very knowledgable of the materials and very helpful especially the classroom with small amount of the student helped to have enough time to do question and answer.
Knowledgable teachers in a friendly, almore "FAMILY" environment. Equipment up to date and were maintained, other students easy to work with and Network together. I have had and overall positive experience.
Detailed step by step process of software programs and accounting fundamental principles. smaller classes provide more "One on One" individual training/assessmen from instructors. Great program for new or experienced in the accounting field.
During my time at LIIT, I have gained more knowledge of working with the programs dealing with Microsoft Office Applications and learning quickbooks. My instructor was very helpful nd knowledgable and patience. I would recommend LIIT school to others.
I had the opportunity to take the PMP class at LIIT with great intructor. It was great. Small class which allows for more interaction and personalized class. Our instructor was amazing and had great tips to help us pass the exam. Thank you for th opportunity.
Classes are great !!! HAving personally taught classes years ago, retention of learned & practical use is important. I feel more times on lengthy key chapters like, Cost or Time management are imperative to passing PMBOK standard questions. MS Project needs better integration & different teaching process. PROJECT needs to work.
I fealt really happy with my knowledge. I am more confident when I went looking for a new job position. The Teacher in this school are very professional and kind with the students. I am very happy to recommend lascomp to others.
The dynamics was excellent. The instructor added a lot of depth of knowledge from his PM experience. The instructor challenged us to think within the PMBOK(PMI) universe. This is a must for practical project managers.
Excellent class, great instructor. I am very happy that I chose lascomp to take this course. I will highly recommend the school to anyone wanting to take a class in preparation for Project Management certifications.
My Experience learning microsoft office and quickbooks pro at LIIT was wonderful. Not only did I learn a great deal, I also enjoyed the people/teachers who assisted me throughout the course. Very helpful, kind people and I enjoyed the entire experience.
I liked to study in he liit Montvale location very much. director of the achool Alam was very helpful during all my training. The teachers of all classes that I took were very knowledgeable. I had greatly improved my skills.
Mr. Alam has been flexible to allow students to go on job interviews, etc. He works with the students whenever possible. The instructors work in the industry and bring real life knowledge, tips, interview questions etc. to the class.
The School was very accomodating in working with students schedules. Encouraged class paticipation. They tried and succeeded in getting all of the students involved. They were able to do this due to small class size.
This class is very good. It provided me a loot of information about Project Manager's role, which I found out my previcious job had overlapped a lot of functionalization with PM. Now I'd have learned more. My experience on PM that would help me on the job interview. I wich this course would also cover some waterfall and agile concepts.
Teachers are very easy to talk to and very willing to help. Mr. Alam is very helpful and understanding. Classes are easy and you can take it at your own pace. Great place to make friends and clasmates help each other out.
The amount of software knowledge that I acquired during my 5 to 6 months training persued, Exceeded my expectation levels. Very satisfied with the there knowledge that I attaintd at LIIT. VERY SATISFIED.
Excellent School offering an Optional environment for student learning. Classes were Small with one on one assistance when needed. Instructors were great knowledge and well experienced. Thank you Alam for a great course.
I was very impressed by the knowledge & professionalism of the instructor, and the way he “led” the students through & studies discussions & testing, guiding how to understand the PMP rationale in testing.
One of the best Schools I have ever been. I am grateful to GOD that I have met Alam. One of the finest exaple of a mentor and friend.
- Salih B.
Excellent Instructors! It was a pleasure attending class here. Mr. Alam was very responsive to all my needs. He worked with me in getting the classes which I wanted to learn. LIIT ( LasComp Institute of IT) helped me to get my new job!
The school "LasComp owned by Mr. Alam is a perfect place to learn and be certified. Thank you, to my teachers: Dr. Anand K. and Tom P., who tried their best to understand, guide and impart their knowledge to a student like me. I'm going to pass this good impression of mine to the students who will be interested to come and learn form their betterment in life.
Program: Certified Medical Administrative Assistant & MOS Certifications
I was impressed by the depth and knowledge of the instructor. I look forward to attending another class in the near future. The LasComp facility is comfortable and easily accessible. Classrooms are warms bright & the computer equipment is modern.
- Ana J.
Very well done. I liked the option of the fast paced course. I was able to get it done quick and still able to cover the dense material at a level of understanding.
In this place you will find people willing to help you throughout the process to make you awre marketble to find a job.
Program: Medical Administrative Assistant Specialist
- Paola C.
The overall course was excellent. I do think that discussions at times become too lengthy, students interjected too much. Oneremedy maybe the use of a projector that would create more of an audience atmosphere among students, tather than a one on one setup. A realted issue is that more time could be devoted to reviewing the several technical subject areas that constitute a large precentage of the exam.
- Mark F.
Instructors provided us with a lot of material. Instructors were very knowledgeable and patient with the students. Being allowed to retake classes at no additional cost is GREAT!!
mike was a very knowledgeable instructor. He is a professional, extremely polite and enjoyable lean from. However, I wish there was more of a coaching direction on how to do better on the pre-test so that I can gain more confidence for the SHRM exam. Excellent teacher.
The school “LasComp owned by Mr. Alam” is a perfect place to learn and be certified thank you, to my teacher. Dr. K. and Tom P., who tried their best to understood, guide& impart their knowledge to a student like me. I’m going to pass this good impression of mine to the students who will be interested to come and learn for their betterment in life
- Norma A.
Our instructor is extremely knowledgeable e and the heads on portion of the class really helped for better understanding of the practices.
- Joseph D.
The instructor was insightful and well prepared bringing real world scenario’s to the classroom. Having a professional network engineer teaching the class made it all worth while
LIIT (LasComp Institute of IT) was very helpful in extending my SQL server knowledge. The teacher was expert in SQL server and if he did not have answer he responded. Teacher aslo went the extra mile to help further knowledge.