Introduction to SQL Programming

...
This is a virtual classroom course. You can find more information about our virtual classroom here

This is a 16-hour hands-on workshop on Structured Query Language (SQL) with ultimate goal to make participants feel comfortable with the fundamentals of SQL.

A discount is available when:
  • a single customer proceeds with more than three registrations for a particular session;
  • a learner is not currently employed.
Please contact us to receive your discount coupon if you meet any of the above-mentioned criteria.

Please also note that the upcoming sessions are guaranteed to run once they have a minimum number of learners registered.
Total price:
660.00 final price

Available Sessions

DateTimezoneTraining TypeWeekend-WeekdayDescriptionPrice 
Coming soonEurope/AthensLive VirtualWeekday660.00 final price

This is a 16-hour hands-on workshop on Structured Query Language (SQL) with ultimate goal to make participants feel comfortable with the fundamentals of SQL.

Who should attend

Anyone wishing to gain knowledge of SQL, as well as those wishing to refresh their SQL skills. This includes End Users of business systems, Business Analysts, Test Analysts, Test Managers, Software Engineers and anyone who might want to query data from a database management system.

What will you learn

During this theory and hands-on course, participants will cover the following areas:

  • Introduction to relational databases
    • History of DBMS
    • Relational databases
    • Course Database: Description of the database used in the course for queries
  • Data Modeling
    • Relational Model
    • Third Normal Form
    • Entity Relationship Model
    • Constraints
      • Foreign key constraints
      • Referential Integrity
      • Not NULL constraints
    • Schema Design engineering trade-offs
    • Course project: Schema design for the course project
  • SQL basics
    • Relational algebra
    • Projections
    • NULL values
    • Ordering
    • Joins
    • Subqueries
    • Groupings and Aggregations
    • Insert, Update, Delete
    • Course project: Develop main project queries
  • Transactions
    • Why we need transactions
    • Course Project: Add transaction where needed on project queries
  • Triggers
    • Motivation
    • Engineering trade offs
  • Views
    • Virtual views
    • Materialized views
    • Course Project: Develop project views
  • Stored procedures
    • Motivation
    • Engineering trade offs
  • Query Execution
    • Query Planner
    • Query Parsing
    • Logical Query Plan
    • Physical Plan
    • Understanding query plans
    • Course Project: Optimize project queries by analyzing query plans
Date

Coming soon

Timezone

Training Type

Weekend-Weekday

How it works

Registration

You may enroll in the course by providing your full name and email address through our website's 'add to cart' feature or by sending an email to hello@learningactors.com. We treat your personal data, including your full name and email address, with strict confidentiality.

Payment Options

We offer multiple payment methods, including credit cardbank transfer, and PayPal. To receive your invoice, please provide your VAT number (when applicable), address, and zip code. Again, you may provide us with this information either through our website's 'add to cart' feature or by sending an email to hello@learningactors.com. Please note that you can typically expect to receive your invoice on the first day of training, unless there are exceptional circumstances that necessitate a different approach. We’re happy to provide you with a pro-forma invoice if this meets your needs.

Expectations

Following registration, you can anticipate an info email from us approximately one week before the course start date. This email will contain course details, such as the title, date, and time, along with a request to complete a pre-course form. Additionally, we will provide the relevant Zoom link, which is  applicable for all our virtual-live courses, and will invite you to the course's Slack channel on the LA Slack workspace (learningactors.slack.com). For specific courses, you will also receive a preparation email that will set you ready for the course.
Finally, after the session concludes, we kindly request that you take a moment to provide us with your feedback, as it is of great importance to us. Additionally, we will ensure that you receive the learning material through Slack, which will be instrumental in keeping your learning journey on track!

Reminders

  • Discounts are available in two scenarios: when a single customer registers for more than three sessions or if the customer is currently unemployed. Contact the LA team to receive a discount coupon if you meet these criteria.
  • All upcoming sessions displayed on our website are guaranteed to proceed once the minimum required number of learners register. In the case that we must cancel a session, a full refund will be issued to those who have pre-paid for that specific session.