Train your entire team with our Private Group Training solutions. AstraTech specializes in creating customized training programs to fit your organization’s unique learning needs and business objectives. Take advantage of multiple student discounts, customized curriculum and flexible scheduling with Private Group Training from AstraTech!
In this course, students will compose SQL queries to retrieve desired information from a database.
Audience
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Basic computer literacy
Basic PC operating system navigation skills
Basic Internet usage skills
Basic IP address knowledge
1 – Executing a Simple Query
Connect to the SQL Database
Query a Database
Save a Query
Modify a Query
Execute a Saved Query
2 – Performing a Conditional Search
Search Using a Simple Condition
Compare Column Values
Search Using Multiple Conditions
Search for a Range of Values and Null Values
Retrieve Data Based on Patterns
3 – Working with Functions
Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values
4 – Organizing Data
Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators
5 – Retrieving Data from Tables
Combine Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables
Check for Unmatched Records
Retrieve Information from a Single Table Using Joins
6 – Presenting Query Results
Save the Query Result
Generate an XML Report
Related Job Roles
This course builds skills and demonstrates qualifications for the job roles and average base salaries below.Â
In this learning path, you practice building model-driven apps by using Microsoft Power Apps. The skills validated include creating Dataverse tables, modifying forms and views, and configuring a model-driven app.…
Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.
As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and…
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry…
Live, Instructor-Led (ILT)
TechSherpas 365 Student Testimonials
IT Certification Training Course Reviews
Posted on
mike h
Trustindex verifies that the original source of the review is Google.
I have used TechSherpas twice now and they have exceeded expectations both times. Their instructors are always knowledgeable and the content is exactly what you need to pass your exams. I would highly recommend TechSherpas for any Microsoft training needs.
Posted on
Casey Evert
Trustindex verifies that the original source of the review is Google.
I recently took the Microsoft Azure Admin course and was impressed. The bistro was great, and hands on in teaching. Though it was a class, I felt as if it was just the instructor and myself. He answered every question fully, left no doubt or confusion in anyone’s mind, and paced our workload so that we would complete everything in time. The time management and instructor knowledge was amazing. I recommend TechSherpas and their team for your IT necessities!
Posted on
Sven Akerman Jr
Trustindex verifies that the original source of the review is Google.
I heard that TechSherpas 365 is under new management and wanted to share a very positive report (esp. for those reading some old reviews >9mo). Although I had not had any interaction under the previous management, I can definitely speak to the new team!
My first experience with TechSherpas 365 was for a boot camp. I think that people don't associate the intensity of a technical training class boot camp to the first six weeks in the military, but I am pretty sure the six days of boot camp I got was on par! You will find yourself working with minimal sleep in a mentally engaging environment under high pressure for 4 days straight - it's really a lot of fun!
Boot camps are not for beginners. They are for individuals who have been working in the space with relevant experience and are ready to fill in the knowledge gaps and get exam ready. You really should be well versed in a full stack of infrastructure knowledge. You are expected to have read ALL of the courseware Modules for the coming day before class and be ready in class to ask questions, fill in gaps in understanding, and learn how Microsoft exam questions work.
I estimate that I spent between 14-17 hours per day over those six days, not to mention one all-nighter... but I won't go into details. The time was spent between class and homework/reading in preparation for class, and ultimately practicing for my exams.
In the end, I accomplished my mission and I passed a nasty role based AZ-300 exam on a Friday and the evil twin AZ-301 on the next day, Saturday. I am happy to say that my goal was to become an Azure Solutions Architect Expert and at the end of 6 tough days, that goal was achieved.
This would not have been possible without the great team that made sure it happened -thank you to the amazing support from the whole TechSherpas 365 team. Special shout out to Nicole, Della, and Ricy for helping me chase my dreams!
Posted on
Elena Roe
Trustindex verifies that the original source of the review is Google.
I had a great experience with TechSherpas! The instructor was excellent. He is an expert in his field. Also, the staff go above and beyond to accommodate the students.
Posted on
Joanna Johnson
Trustindex verifies that the original source of the review is Google.
The most wonderful place for all of your training needs! I can't say enough about the entire staff! They are so kind and accommodating and really care that you pass the certifications you take there. Don't even get me started about the fresh baked cookies every day at 2! Thanks so much TechSherpas for the great training experience!! You all rock!!
Posted on
Frank Furnari
Trustindex verifies that the original source of the review is Google.
TechSherpas was excellent in their delivery and content for both 20483B C# and 20480B HTML5. Both Ken Sproule and Paul Elias are excellent instructors, the tempo and the content made real easy to learn and it answered all my questions. Take these classes in a location where you are comfortable and not interrupted, both courses are fast paced.
I would recommend TechSherpas to anyone looking to further their understanding of these languages and gain some insight into the bigger picture.
Posted on
Kavita Ghia
Trustindex verifies that the original source of the review is Google.
TechSherpas is a great company with a very Homey feel. All of their staff is very cordial and inviting. I enjoyed taking the MCSA: SQL 2012 boot camp their facility; I was amazed with the flexibility of the staff and a personal touch they all had when working with their clients.
TechSherpas-Thank you for an enjoyable experience, I will be coming back to finish my exams and I hope to take more courses in the near future.
GTR 
