Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online

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

This SQL Queries Course covers retrieval and analysing data  in a powerful, feature-filled training day. Instructor-led and Classroom.

SQL Courses

SQL courses: 1-day query basics, 3-day intermediate or 2-day advanced course. Then we also have interesting 1 hour session for fast-tracking SQL query basics. SQL is essential for all who would like to work with data!

Please print out ticket and bring along. Please call 07784 357309 on arrival to be met at reception.

<h1>SQL Course, 1-Day in Manchester</h1>This SQL Course provides all necessary SQL knowledge and skills to retrieve and analyse data held in a database.  Who Should Attend the SQL CourseAnyone who needs to understand and use SQL to manipulate a database, should attend this SQL Course. There are no formal pre-requisites for this course, although an understanding of databases and exposure to information technology in general would be useful.  <ul><li>Virtual Classroom: Attend online, Instructor-led, Interactive, Practical.</li><li>C﻿lassroom: Select your option at checkout.</li></ul><ul><li><a href="https://pcworkshopslondon.co.uk/sql-beginners-1-day-course.html" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Read more</a></li></ul>SQL Course OutlineWhat is a Relational Database?<ul><li>Tables, Rows and Columns, Data Types</li><li>Relationships, Primary Keys and Foreign Keys</li></ul>SQL Queries with the Select Statement<ul><li>The Select and From Clause</li><li>Column Aliases</li><li>The Order By Clause</li><li>Conditions and the Where Clause </li><li>Wildcards</li><li>Working with null values</li></ul>Hour 3Expression queries<ul><li>SQL Arithmetic Operation</li><li>Case, iif, choose</li><li>Date function and date formatting basics</li></ul>Hour 4 SQL Query Summarizing and Grouping<ul><li>SQL Aggregate Functions </li><li>Sum, Avg, Count, Max, Min</li><li>The Group By Clause</li><li>The Having Clause</li></ul>Combining Queries :<ul><li>The Union,</li><li>Intersect and</li><li>Minus Operators</li></ul>Hour 5Querying Multiple Tables<ul><li>Joining Tables Inner Joins, </li><li>Left and right Joins, </li><li>Full Joins,</li><li>Self Joins, </li><li>Cross Joins</li></ul>Hour 6<ul><li>The Basic Concept and Structure of Subqueries</li><li>S﻿ubquery examples</li><li>C﻿TE Tables </li></ul>Certificates:  Certificates includedIncluded: Notes. Query examples and exercises. After course support: 1-hours online revision sessionRead more: https://pcworkshopslondon.co.uk/sql-beginners-1-day-course.html

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}

Ticket sales have ended

Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online

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.

Ticket sales have ended

Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online

More events from PCWorkshops

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

You might also like...

Browse more 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.