SQL - Advance Querying

This Course is designed for participants who have a basic knowledge SQL Querying using SQL command language

Course Outline

This Course is designed for participants who have a basic knowledge SQL Querying using SQL command language

LEARNING OBJECTIVES On completion of course, participants will know how to perform advanced queries, add, update, and delete data, tables, views, and indexes

COURSE OUTLINE QUERYING WITH UNIONS AND ADVANCED JOINS
• Querying multiple tables with unions
• Advanced Joins
• Calculating with COMPUTE

QUERYING WITH SUBQUERIES
• Subqueries

ADDING DATA
• Inserting data
• Select into

UPDATING AND REMOVING DATA
• Updating records
• Deleting records
• Deleting the contents of tables

MANIPULATING TABLES AND VIEWS
• Creating tables
• Modifying tables
• Deleting tables
• Adding and removing views

MANIPULATING INDEXES
• Adding and removing indexes

ENSURING DATA INTEGRITY WITH TRANSACTIONS
• Transactions

CREATING DATABASES
• Creating a database with SQL
• Deleting a database

Additional Details

Pre-Requisites

Participants should have basic knowledge of SQL.

Certificates offered

Certificate of completion

Cancellation Policy

RESCHEDULING POLICY

Registrants who wish to reschedule their course may do so at least 5 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course. Otherwise, a 20% surcharge is applicable.

CANCELLATION POLICY

Notice received less than 5 working days prior to the course date is subject to a 20% service charge. If the notice is given within 48 hours of the course date, the course is non-refundable. Notice of cancellation must be received by CompuEase 5 working days prior to the confirmed date to obtain a full refund.

Map & Reviews

CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa, ON
Canada   K1P 5M9

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

I was the only participant so received one on one training. With a group you usually do exercises from a workbook which would have been beneficial to me but that didn't happen with one on one training. I was shown how to do something and then asked to do it too rather than starting an exercise from scratch in a workbook and having to figure it out myself.

Reviewed by Brenda . 2012

   

No, all good to me !

Reviewed by Claude L. 2012

   

An excellent faclity located in the heart of downtown Ottawa. Friendly instructor and staff. As this was a one on one instructional situation, the instructor tailored the workshop to my needs. She covered every one of the twenty-two topics that I had requested and sent via email the week previous. I would recommend this school to anyone needing to learn or augment their computer skills.

Reviewed by Keith H. 2012

   

Our instructor was absolutely a delight. It made learning something that could have been boring in to something very fun and interesting. Dracy Whyte was great as a teacher!

Reviewed by Dona M. 2012

   

We had individual projects with specific questions and the instructor was very flexible in the course presentation to address our issues.

Reviewed by Sheryl M. 2012

   

We had the advantage of a very small class and very attentive lecturer to answer individual's questions

Reviewed by Lothar H. 2012

   

Great beginning for me.... I would have liked a longer basic course to cover some text data entry for templates, rather than just calculations...

Reviewed by Evelyn D. 2012

   

Would have preferred some practical exercises with the instructor going around and seeing if we understood the training. eg. complete a travel claim sheet. There were only 5 participants to probably would have been a good time to wander around the class and see how we were doing. Difficult to see the screen, esp in the a.m. with the sun hitting it.

Reviewed by Trudy . 2011

   

I had been using Word 2003 for several years. My software was recently upgraded to Word 2007. I found this course extremely interesting and useful for me. Sometimes, there are some really small tricks that can help immensely for our day-to-day work. The instructor was very knowledgeable and had a great personnality. This is one of the best courses I've taken and I've taken many... Marc

Reviewed by Marc R. 2011

   

I found the instructor at CompuEase "Desiree" very patient and helpful! She is very knowledgeable and takes the time to help me through this training - especially since I've never used it before. Thank you! Connie

Reviewed by Constance L. 2011

   

This was an awesome course. The trainer was fabulous, very hands on. I would highly recommend.

Reviewed by Judy K. 2011

   

The trainer mentioned that I could retake the course for free and that this is something that is normally offered there. I might do that because it was an off day for me. I was feeling tired and my concentration was a bit off. The trainer also was having an off day because of a back injury. I have taken training with Compuease before and I find it is a friendly environment and the trainers are excellent.

Reviewed by Sylvia B. 2011

   

I was trully satisfied with the services at CompuEase. I was lucky enought to receive a one on one training with no else then the founder, who is very knowledgeable. I will definitely watch out for future courses.

Reviewed by Natalie C. 2011

   

The room was kept at about 100 degrees. Also, we needed Photoshop CS5 on MACS. After we paid/registered, I was emailed and told they didn't have Macs. I said okay, we'll cancel. Then they said whoops sorry, we do have Macs. 12 hours before the course was to begin (we were travelling from out of town) they emailed to say they didn't have CS5 but only CS4 but that the instructor was "very knowledgeable." When we got there, there were in fact two computers that had CS5, but they weren't MACS, so we had to choose, either a PC with CS5 or a MAC with CS4. My PC kept crashing because it was so old and slow it couldn't handle a program like Photoshop. And since we were on CS5, everything the instructor told the class to do did not match what was on our screen and we had to hold the class up every half an hour saying "I don't have that option on my screen." The instructor made several references to sex (I appreciated his sense of humor, but not his taste or lack of) and he seemed more like a surfer dude than a teacher. He was very disorganized ,jumping all over the place, changing his mind about what he was going to talk about, etc. It was hard to follow what was going on in his head.

Reviewed by Shannon B. 2011

   

Excellent course! Excellent Training Provider! Stellar Instructor!

Reviewed by Cristiane P. 2011

   

The smaller class size allowed for more one-on-one time with the instructor during the hands-on exercises, which optimized the learning experience. The course manual was a bit lacking, but luckily our instructor was a true expert in the field and was able to go into detail and even treat us to more advance applications when he saw that we were ready to take on the more advanced applications. I will certainly be taking another course with the training provider, especially if they continue to provide the student with such stellar instructors!

Reviewed by Cristiane P. 2011

   

The course provided by CompuEase was great. The instructor was excellent and very knowledgeable. The course content directly applied to my needs. I would recommend this course to others and am considering taking the next level myself.

Reviewed by Eileen I. 2011

   

My instructor was very interesting and knowledgable. She took the time to explain things to me that were not covered in the course outline, but were relevant to my employment needs.

Reviewed by sarah w. 2011

   

I thought that in some cases we could have practiced a bit more with the features that we learned about.

Reviewed by Karl S. 2011

   

I am satisfied - in fact, I will go to another training within the few next weeks.

Reviewed by Suzanne R. 2011

   

Good course and since I was the only participant I had the benefit of a one-on-one.

Reviewed by Patricia R. 2011

   

It was an excellent course, but I think it could be done in 1-day instead of 2-day course.

Reviewed by Laura . 2011

   

Instructor is very knowledgeable, patient and has a great rapport with her students.

Reviewed by Rose P. 2011

   

The crse was very well paced, covering all aspects of Microsoft Excel that I wanted to learn / had questions on. The trg provider is very well versed in both the subject and teaching / instructing skills, ensuring that all questions are answered before moving on to the next lesson / exercise. The crse handout booklet used and will use in the future is a great ref.

Reviewed by Arthur K. 2011

   

Excellent instructor; flexible and willing to accommodate students by explaining specific details. Has great overview of MS office suite. Provides learning experience that enables.

Reviewed by Cathleen K. 2011

   

Would love to receive course manual (not available at time of course).

Reviewed by Sylvie J. 2011

   

This was a great course for beginers using Excel! Very well taught. Thank you.

Reviewed by Angela C. 2011

   

From the "get go" the day was filled with delays and set backs (crashing computers and time delays to upload material). It appears that zero time given to course preparation....photo's had not been uploaded onto computers; the computers had not been pre-tested for functionality. The training room was filled with static - likely contributing to the problems with the computers. There was student manual that was missing (mine). The instructor provided his copy to me, but was left with none himself until after the lunch hour. I do not beleive the instructor had any kind of tuturial/instructor manual prepared - certainly one was not followed. Students were not given the basic of this course in any formal training approach - it might have been useful to follow the manual but it all seemed very hap-hazard hard understand, confusing. I did not know should be learning and why. The terms or functions (tools/keys)in the software was not well explained leaving the student wondering what was and wasn't important to know and why... - The training area lacks professionalism and cleanliness....There is nowhere to go for "breaks" (ie no lounge areas / or lunch if you happen to bring your own... the stairways skinks...

Reviewed by Linda G. 2011

   

Extremly bad training. Company obviously not prepared for training--trainer's computer did not work and went down 4 or 5 times, my workstation did not work, I moved from computer to computer, none of these worked so had to share. Workstations not prepared prior to course with proper files (instructor had to load during break and this took over an hour). I could go on and on about how terrible this training was and this was not due to the instructor who was trying. We ended the session and asked for a re-take as the training was a complete disaster from start to end. One star for many of the above ratings is being generous.

Reviewed by Lee-Ann S. 2011

   

This was the first time ever that I can remember having a two instructors teach a course. The tag team approach to teaching kept me on the edge of my seat. The thought of having a new voice and personality teaching the course material was like a breathe of fresh air. We was so wrapped up the level of passion the instructors brought to the classroom regarding Excel that we only stopped for a 30 minute lunch and then spent an additional hour at the end of the day where the instrctors shared experiences which had even challenged them.

Reviewed by jonathan r. 2011