Cursus SQL Basis in Zwolle

In this course you work under the guidance of an experienced trainer on building a solid foundation in SQL. You learn how relational databases work and write your own queries to retrieve, filter and edit data. Practical and directly applicable.

Lees de volledige beschrijving van de cursus SQL Basis

All dates in Zwolle

None of the dates suitable? In-company takes place on a day of your choosing, and the course also runs in other cities.

Where in Zwolle

Who you'll learn from in Zwolle

• Mike Web design and IT trainer Score 8,6 from 1097 evaluations
• Pascal ICT and communication trainer Rating 8,3 from 753 evaluations

What participants thought

• “You get value for money. And you leave with the knowledge to write your own SQL statements.”

  D. Knijnsberg, Gemeente Purmerend - SQL Basics

• “Excellent SQL Server course with a clear structure.”

  L. Wong - Gemeente Rotterdam- SQL Basics

• “I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”

  C. van Lumig, Woonpunt - SQL Basics

• “Absolutely excellent, a pleasant and knowledgeable trainer. Good pace, plenty of variation between content and exercises. The course comes highly recommended!”

  A. Rebergen - CBS Academy - SQL Basics

Frequently asked questions

What prior knowledge do you need for the SQL Basics course?

For the SQL Basics course you do not need any specific prior knowledge of SQL or databases. Basic computer skills are sufficient. The course starts at the beginning: you first learn how relational databases work and then build up your SQL skills step by step. The course is therefore suitable both for beginners and for professionals who want to formalise their knowledge.

Which topics does the SQL Basics course cover?

The SQL Basics course covers the most important SQL topics in . Day 1: database systems, data types, keys and simple queries using SELECT, ORDER BY, GROUP BY, WHERE and LIKE. Day 2: more advanced queries with functions (ROUND, DATEPART), calculations (COUNT, SUM, AVG), subqueries, JOINs (INNER, LEFT, RIGHT) and modifying data and tables with INSERT, UPDATE, DELETE, CREATE, ALTER and DROP.

Which database systems will you learn to use in the SQL Basics course?

In the SQL Basics course you learn to work with all common relational database systems, including Microsoft SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 and SQLite. The course covers the standard SQL language and the differences between the various DBMSs. As a result, after classroom training you can get straight to work with virtually any SQL database you come across in your workplace.

Who is the SQL Basics course suitable for?

The SQL Basics course is suitable for anyone who wants to learn to work with relational databases, without needing any prior knowledge of SQL. Think of functional administrators, data analysts, information managers, system administrators, aspiring database developers and programmers. This classroom course is also a good fit if your work increasingly requires you to retrieve data from a database.

Do you receive a certificate after the SQL Basics course?

Yes, on completion of the SQL Basics course you receive a certificate of participation. This certificate shows that you have attended the classroom course and have mastered the basics of SQL, including writing SELECT queries, filtering with WHERE, sorting, grouping and combining tables with JOINs. A useful piece of evidence for your CV or LinkedIn profile.

What is the difference between the classroom SQL Basics course at Learnit and an online SQL course or self-study via YouTube?

The classroom SQL Basics course You work under the guidance of an experienced database trainer and practise with assignments that you can link to your own daily work. That last point is the biggest difference with self-study via YouTube or an online course: you get direct feedback on your queries and can ask questions about your specific database situation. In you cover both the basics (SELECT, WHERE, ORDER BY, GROUP BY) and more advanced topics (JOINS, subqueries, INSERT, UPDATE, DELETE, CREATE). With self-study you are more inclined to click through without really practising. Choose the classroom option if you want to learn in a structured way and become productive quickly; choose self-study if your budget is limited and you are able to keep going in a disciplined way.

How quickly after the SQL Basics course can I write queries independently in practice?

Straight after the course you will be able to write simple to medium-sized SQL queries. On day 1 you practise with SELECT, WHERE, ORDER BY, GROUP BY and filtering with wildcards. On day 2 you work with JOINs, subqueries, aggregate functions (COUNT, SUM, AVG) and modifying data using INSERT, UPDATE and DELETE. The mix of theory, demonstrations and plenty of practice exercises with sample files means the material sinks in quickly. How soon you can apply it in your own working environment depends on the database system (Microsoft SQL Server, MySQL, PostgreSQL, Oracle) and the complexity of your data model. Most participants are writing their own reporting queries within a week. For more complex matters such as stored procedures or performance tuning you will need a follow-up course; this is a basic course.

Which SQL dialects do I learn during the SQL Basics course, and is that knowledge usable in PostgreSQL or MySQL, for example?

The SQL Basics course covers standard SQL: the syntax and functions that work in virtually all relational database systems. Think of SELECT, WHERE, GROUP BY, JOIN, INSERT, UPDATE, DELETE and CREATE. That knowledge can be applied directly in Microsoft SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2, Microsoft Access and SQLite. The trainer explicitly points out the differences between the dialects, so you know what to watch out for when moving between systems. Functions such as ROUND, LTRIM, RTRIM and DATEPART are covered; the exact name can differ slightly per DBMS (for example EXTRACT in PostgreSQL instead of DATEPART). The course material is in English, as is the software. After , you can start working with basic queries in any common DBMS.