SQL Query, 1 Hour. Which Customer Bought The Most Beverages?

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content.Terms and Conditions:B﻿y booking a course with us, you agree to the terms and conditions specified on our website:https://pcworkshopslondon.co.uk/termsandconditions.html

PCWorkshops

1-Hour Power Session to understand the basics of SQL Queries. Practical. Online, Instructor-Led.

<h2>SQL Queries in 1 Hour.</h2> <h2>Who has a birthday this month?</h2>Course summary: Fun and informative 1-hour SQL Queries Tutorial, online, instructor-led.This 1 HOUR course is packed with power query techniques.We will in this hour reveal, which employee has a birthday this month <h2>Course Outline: </h2> Relational Database Concepts:<ul><li>What is a Relationship? Primary Keys and Foreign Keys</li></ul> SQL Language Essentials:<ul><li>The SQL Select Statement</li><li>SQL Where Clause</li><li>Like, Wildcards</li><li>The SQL Order By Clause</li><li>SQL Column Aliases</li><li>Working with Null Values</li></ul> Expressions :<ul><li>Arithmetic Operations and Expressions</li><li>Group by and Aggregates: Sum</li><li>T op / Limit</li><li>Inner J oins</li></ul> Date functions:<ul><li>Todays date</li><li>Get the Year, Month, Day from a date</li><li>Use this in a group by</li></ul> <h2>What is included in the SQL Course:</h2><ul><li>SQL Basics 1-Hour Course Certificate on completion.</li><li>SQL Course notes.</li><li>Practical SQL Course exercises.</li><li>Max group size on this SQL Online Course is 4.</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

SQL Query, 1 Hour. Which Customer Bought The Most Beverages?

More events from PCWorkshops

Discover more events from PCWorkshops, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

SQL Query, 1 Hour. Which Customer Bought The Most Beverages?

More events from PCWorkshops

Discover more events from PCWorkshops, from Science & Tech to other experiences you might love.

More Science & Tech events

Browse more Science & Tech events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.