email us
 training@pcworkshopsLondon .co.uk
contact us
 020-7164-6359

SQL Intermediate Course, 3 Days

Included - Course Topics - Book the course
SQL Intermediate Course, 3 Days
Intermediate SQL Course details

SQL Intermediate Course, 3-days

SQL Course Summary.


Practical SQL course, to leavy you fully conversant with queries, DML and DDL statements.
This is a Practical SQL course with time for hands-on exercises.
PCWorkshops SQL Course Certificate.
Max 4 people per course, we keep it personalised.

Where is the SQL Course?
  • Online: Instructor-led.
  • Classroom: Request per email.
SQL Course Materials
  • SQL Coding Examples
  • SQL Course Manuals and Notes: In-depth reference materials
  • Exercises: Practical exercises
Payment Options
  • Follow the booking link
  • Arrange for installments
Included with SQL Course:
  • SQL Course Certificate on completion.
  • SQL Course Manual.
  • Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
  • After the course, 1 free session for questions.
  • Max group size, online and in classroom, on this SQL Course is 4.
Course Details
SQL Intermediate Course summary


  • DAY 1:
    •
  • Session 1: Database Concepts
    What is a database?
    Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
  • Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
  • Session 3: Basic SQL SELECT statement
    The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.
    Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
    Column aliases.
    Arithmetic expressions.
    Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”).
    The ORDER BY clause.
  • Session 4:
    LIMIT / TOP and Distinct Queries
    SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
    Group By,
    Rollup with Group By,
    Having.
  • Session 5: Joins
    SQL Cartesian products.
    SQL Joins (Inner join, Left join, Right join, Full join).
    Table aliases.
    Natural joins, Multi-table joins.
    Union, Union All queries.
    Except/Minus, Simulating join with Intersect.


  • DAY 2:
    •
  • Session 6:
    SQL Subqueries, Nested Subqueries,
    Correlated and uncorrelated subqueries.
    Global and Local Temp Tables.
  • Session 7: SQL Built-in Functions:
    Numeric Functions (ABS, SIGN, MOD, etc.)
    and String Functions (Locate, Left, Right, Concat, etc),
    DATE and TIME functions.
  • Session 8: SQL Views (Create, alter and drop),
    Stored Procedures (Create, alter and drop, Input and Output parameters);
    Custom Functions (Create, alter and drop).


  • DAY 3:
    •
  • Session 9: Managing Data
    Inserting rows, Replacing rows, Updating rows, Deleting rows,
    The truncate statement,
    The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
  • Session 10: SQL Indexes (Create, alter and drop).
  • Session 11:
    Creating Databases and Tables (Create, alter and drop);
    Constraints (Add, alter and drop).
  • Session 12:
    Import data into SQL and Export from SQL.
    Exporting using SQL, Importing using SQL.
Book the SQL Course
About us
DOWNLOAD A CATALOGUE
java Bootcamp uk
Learn SQL
What's MySQL? MySQL, the open source database product that puts the "M" in LAMP, was created by MySQL AB, a company founded in 1995 in Sweden. In 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for $1 billion.
What Is SQLite? SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones. At PCWorkshops, we support it in Python and Java Courses teaching web apps.
Microsoft SQL Server Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
What's PostgreSQL? PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
sql course london
sql course london

Request a Free SQL Course Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.
About Us
  • Working hours: Monday to Friday, 10am to 6pm
  • About PCWorkshops
    •
  • Awards
    •
  • Locations
    •
  • Terms and Conditions
    •
  • Contact Us
    •
  • Client Comments
    •
    Quick Links
  • Working hours: Monday to Friday, 10am to 6pm
  • Software development jobs
    •
  • Python Courses
    •
  • Java Courses
    •
  • SQL Courses
    •
  • Database Courses
    •
  • MS Project Courses
    •
    Contact Us
  • Working hours: Monday to Friday, 10am to 6pm
  • Call: 020-7164-6359
  • Email: training@pcworkshopsLondon .co.uk
    • Connect with Us

    Copyright © PCWorkshops 2024. All Rights Reserved.