SQL 1 Hour. Which Employee has a birthday this month?

SQL 1 Hour. Which Employee has a birthday this month?

1-Hour Power Session to understand the basics of SQL Queries. Also learn about date functions. . Practical. Online, Instructor-Led.

Select date and time

Mon, 30 Sep 2024 05:00 - 06:00 PDT

Location

Online

Refund Policy

Refunds up to 7 days before event
Eventbrite's fee is nonrefundable.

About this event

SQL Query Dates 1 Hour.

Who has a birthday this month?


F un 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


SQL Query Basics and date Functions

Relational Database Concepts:

  • What is a Relationship? Primary Keys and Foreign Keys

SQL Language Essentials:

  • The SQL Select Statement
  • SQL Where Clause
  • Like, Wildcards
  • The SQL Order By Clause
  • SQL Column Aliases
  • Working with Null Values

Expressions :

  • Arithmetic Operations and Expressions
  • Group by and Aggregates: Sum
  • T op / Limit
  • Inner J oins

Date functions:

  • Todays date
  • Get the Year, Month, Day from a date
  • Use this in a group by


What is included in the SQL Course:

  • SQL Basics 1-Hour Course Certificate on completion.
  • SQL Course notes.
  • Practical SQL Course exercises.
  • Max group size on this SQL Online Course is 4.


Tags

Organised by

PCWorkshops

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.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses 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 Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

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 qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 Terms and Conditions:

By booking a course with us, you agree to the terms and conditions specified on our website: https://pcworkshopslondon.co.uk/termsandconditions.html

 

£15