Regular Course Price: £120.00
Total Duration: 6 Hours
Course level: Beginner
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course

Course Overview:

If you want to learn Standard SQL (Structured Query Language) which can be used with any Database Management Systems (i.e. SQLite, MySQL, Microsoft SQL Server, Oracle) then this course is for you. This course has designed specifically for those who are new to SQL. This course focuses more on Standard SQL rather than the database management systems. You’ll learn SQL programming through MySQL which is one of the most popular open-source database management system.

Following topics are included in this course:

  • Creating databases
  • Creating tables
  • Altering tables
  • Deleting tables
  • Inserting records
  • Retrieving records
  • Modifying records
  • Removing records

Skills Required

No existing knowledge of SQL Server is required. You should have basic computing knowledge.

Course Dates, Prices & Enrolment

Please check back our website again soon for dates or contact us.
  1. What is SQL?
  2. Creating and Using a Database
  3. Working with Tables
    • Create a table
    • Alter a table
    • Drop a table
  4. Data Integrity
    • NOT NULL
    • Primary Key
    • Foreign Key
  5. Insert Data with SQL
  6. Retrieve Data with SQL
  7. Modify Data with SQL
  8. Remove Data with SQL
  9. Introduction of Functions
  10. Retrieve date from multiple tables

Course Tutors

The course instructor is a .NET developer with 15 years of experience in software and web development. He is a Microsoft Certified Application Developer and skilled on C#, ASP.NET, Microsoft SQL Server, Ajax, HTML, and CSS.

Newsletter Sign-up

Have a Question?