SQL Intermediate 2-Day Course, Manchester OR 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

Excellent SQL Course for advanced topics, more and more people are now attending this useful course.

82 King St

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!

SQL Intermediate 2-Day CourseDuration: 2 consecutive days, the first thereof listedBy storing data in SQL, one can easily and quickly, with the use of queries, retrieve valuable information, trends, summaries, statistics and insights from your company data. In this SQL Course you will learn how to get valuable information, trends, summaries, statistics and insights from your company data using SQL. This course is ideal for managers and data analysts who need to get business intelligence from dataCourse Overview:Candidate who would like to gain a basic understanding of a SQL database and SQL commands and move on the next stage. The content of the course covers the topics required for the Certified SQL Developer I examination.Prerequisites: Familiarity with relational database concepts is helpful but not required. No existing knowledge on SQL is required, but will help.. SQL Course Desciption Session 1: Database Concepts Brief revision of database basics. Tables, rows and columns, Indexes, primary keys, foreign keys, Supported data types, table types. Session 2: Using the SQL client Selecting a database, Executing SQL statements. Session 3: Basic SQL SELECT statement The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,&gt;,&lt;,IN, and BETWEEN).The ORDER BY clause.Column aliases.LIMIT / TOP. Distinct . Session 4: Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”), Session 4:SQL AGGERGATE Functions: Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Having. Joins:SQL Cartesian products, SQL Joins (Inner join, Left join, Right join, Full join) Table aliases. Multi-table joins Union, Union All, Except, Intersect Session 5: Built-in Functions: SQL Numeric Functions (ABS, SIGN, MOD, etc.) String Functions (Locate, Left, Right, Concat, etc.)DATE and TIME functions. Formatting numbers and dates. Converting. Session 6: SQL Subqueries, Basic Subqueries, Nested Subqueries, CTE Tables. Session 7:SQL Views (Create, alter and drop)Stored Procedures (Create, alter and drop, Input and Output parameters) Custom Functions (Create, alter and drop) Session 8: Managing Data:Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints. Session 10: SQL Indexes. Session 9:Creating Databases and Tables. Session 11:Import data into SQL and Export from SQL. Session 12: Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line.

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 Intermediate 2-Day Course, Manchester OR 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 events in Manchester and filter by date, category, and more to find the perfect fit.

SQL Intermediate 2-Day Course, Manchester OR 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 events in Manchester and filter by date, category, and more to find the perfect fit.