email us
 training@pcworkshopsLondon.co.uk
contact us
 07784-357309

SQL Intermediate Course, 3 Days

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

SQL Intermediate Course, 3-days

SQL Intermediate 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 Intermediate 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.
    SQL Column aliases.
    SQL Arithmetic expressions.
    SQL Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”).
    The SQL ORDER BY clause.
  • Session 4:
    SQL LIMIT / TOP and Distinct Queries
    SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
    SQL Group By,
    SQL Rollup with Group By, Having.
  • Session 5: Joins
    SQL Cartesian products.
    SQL Joins (Inner join, Left join, Right join, Full join).
    Table aliases.
    SQL Natural joins, Multi-table joins.
    SQL Union, Union All queries.
    Except/Minus, Simulating join with Intersect.


  • DAY 2:
    •
  • Session 6:
    SQL Subqueries, Nested Subqueries,
    SQL Correlated and uncorrelated subqueries.
    SQL 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),
    SQL DATE and TIME functions.
  • Session 8: SQL Views (Create, alter and drop),
    SQL Stored Procedures (Create, alter and drop, Input and Output parameters);
    SQL 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 widely used open-source database that represents the "M" in the LAMP stack, was originally developed by MySQL AB, a Swedish company established in 1995. In 2008, MySQL AB revealed its decision to be acquired by Sun Microsystems in a deal valued at $1 billion.
What Is SQLite? SQLite is a lightweight, high-performance SQL database engine written in C. Known for its speed, reliability, and self-contained architecture, it is one of the most widely used database systems globally. SQLite comes pre-installed on all mobile devices, making it a go-to choice for embedded applications. At PCWorkshops, we incorporate SQLite into our Python and Java courses, guiding students in building dynamic web applications that leverage its efficiency and simplicity.
Microsoft SQL Server Microsoft SQL Server is a proprietary relational database management system created by Microsoft. It is available in multiple editions, each designed to meet different user needs, from small-scale applications running on a single machine to high-traffic, enterprise-level systems supporting numerous simultaneous users. Microsoft tailors these versions to accommodate diverse workloads, including business intelligence, analytics, and large-scale web applications.
What's PostgreSQL? PostgreSQL, commonly referred to as Postgres, is a powerful open-source relational database management system (RDBMS) known for its extensibility and strong SQL compliance. It is widely used for handling complex queries and large datasets, making it a preferred choice for developers and enterprises seeking a scalable and feature-rich database solution.
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: 07784-357309
  • Email: training@pcworkshopsLondon .co.uk
    • Connect with Us

    Copyright © PCWorkshops 2024. All Rights Reserved.