SQL Fundamentals

Type product
Tijdsduur
Trainer
Remsey Mailjard

SQL Fundamentals

Skills4-IT
Logo van Skills4-IT
Opleiderscore: starstarstarstarstar 9,6 Skills4-IT heeft een gemiddelde beoordeling van 9,6 (uit 815 ervaringen)
Beste opleider van Nederland

Winnaar Beste opleider van Nederland 2020: #3 in Automatisering & ICT/IT.

Lees meer over Beste Opleider van Nederland 2020.

Tip: incompany training nodig? Vraag een offerte aan bij meerdere aanbieders!

9,6
Gemiddeld cijfer voor SQL Fundamentals
Gebaseerd op 46 ervaringen Lees alle ervaringenchevron_right
starstarstarstarstar
Victor Castaneda
10
SQL Fundamentals

"Ramsey Mailjard is an outstanding SQL instructor! His patience, interactive teaching style, and unwavering support make learning enjoyable and effective. He is incredibly helpful, always ready to clarify doubts. I highly recommend his course to anyone wanting to master SQL. Five stars! " - 18-06-2024 23:04

"Ramsey Mailjard is an outstanding SQL instructor! His patience, interactive teaching style, and unwavering support make learning enjoyable a… alles lezen - 18-06-2024 23:04

Beschrijving

SQL (Structured Query Language) is de taal voor het bevragen van databases. In deze training leer je het schrijven van queries in SQL data op te halen, te wijzigen en te aggregeren.   

Je gaat oefenen met diverse commando's zoals: create, select, inner en outer joins, update, delete. Je maakt verder kennis met views definiëren en het gebruiken van operatoren en variabelen. Je krijgt de oefen database mee naar huis zodat u zich met zelfstudie nog verder in SQL kunt bekwamen.

Cursusinhoud:

  • Introductie Microsoft SQL Server
  • Introductie T-SQL Querying
  • SELECT queries
  • Combineren van data uit verschillende tabellen: JOINS
  • • Inleiding in SQL, basisprincipes: datatypes, sleutels (primary key,…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: SQL, Microsoft SQL Server, MySQL, Data Science en PostgreSQL.

SQL (Structured Query Language) is de taal voor het bevragen van databases. In deze training leer je het schrijven van queries in SQL data op te halen, te wijzigen en te aggregeren.   

Je gaat oefenen met diverse commando's zoals: create, select, inner en outer joins, update, delete. Je maakt verder kennis met views definiëren en het gebruiken van operatoren en variabelen. Je krijgt de oefen database mee naar huis zodat u zich met zelfstudie nog verder in SQL kunt bekwamen.

Cursusinhoud:

  • Introductie Microsoft SQL Server
  • Introductie T-SQL Querying
  • SELECT queries
  • Combineren van data uit verschillende tabellen: JOINS
  • • Inleiding in SQL, basisprincipes: datatypes, sleutels (primary key, foreign key)
    • Het ophalen van gegevens (SELECT FROM, TOP, DISTINCT)
    • Gegevens sorteren (ORDER BY)
    • Gegevens filteren (WHERE, vergelijking operatoren, BETWEEN)
    • Geavanceerde filteringen (AND, OR, IN NOT)
    • Filteren met behulp van wildcards (LIKE)
    • Berekende velden (concateren)
    • Gegevens samenvatten (COUNT, SUM, AVG, MAX, MIN)
    • Groeperen van gegevens (GROUP BY, HAVING)
    • Werken met subqueries (IN)
    • Combineren van gegevens uit meerdere tabellen met joining (INNER JOIN, LEFT OUTER JOIN,
    RIGHT OUTER JOIN)
    • Geavanceerde Joins (tabel aliasen)
    • Queries combineren (UNION)
    • Gegevens toevoegen (INSERT INTO)
    • Gegevens aanpassen en verwijderen (UPDATE, DELETE)
    • Tabellen maken, aanpassen en verwijderen (CREATE, ALTER, DROP)

Na deze cursus bent u bekend met de taal SQL
Je kan zelfstandig SQL query's schrijven die voor veel verschillende databases hetzelfde werken

9,6
Gemiddeld cijfer voor SQL Fundamentals
Gebaseerd op 46 ervaringen
starstarstarstarstar
Victor Castaneda
10
SQL Fundamentals

"Ramsey Mailjard is an outstanding SQL instructor! His patience, interactive teaching style, and unwavering support make learning enjoyable and effective. He is incredibly helpful, always ready to clarify doubts. I highly recommend his course to anyone wanting to master SQL. Five stars! " - 18-06-2024 23:04

"Ramsey Mailjard is an outstanding SQL instructor! His patience, interactive teaching style, and unwavering support make learning enjoyable a… alles lezen - 18-06-2024 23:04

Daniel Solar
starstarstarstarstar
Daniel Solar
10
SQL Fundamentals

"The overall experience is great. There is much support and patience whenever needed. When it comes to teaching the material, Remsey is able to explain it thoroughly and efficiently. Anyone would have a great experience in any of his courses." - 18-06-2024 23:01

"The overall experience is great. There is much support and patience whenever needed. When it comes to teaching the material, Remsey is able … alles lezen - 18-06-2024 23:01

starstarstarstarstar
Rene Banuelos Arellano
10
SQL Fundamentals

"Excellent teacher, very knowledgeable and has patience for his students. The lesson was easy to understand. Also Has a wide variety of different trainings as well. Remsey is a 10 out of 10 instructor. I highly recommend this instructor to anyone who wants to polish up there skills in it. " - 18-06-2024 22:58

"Excellent teacher, very knowledgeable and has patience for his students. The lesson was easy to understand. Also Has a wide variety of diffe… alles lezen - 18-06-2024 22:58

ALFI ALI
starstarstarstarstar
ALFI ALI
10
SQL Fundamentals

"The SQL Fundamentals course was incredibly helpful. It provided a concise overview of how the backend works and introduced me to the essential SQL commands. The straightforward approach made it easy to grasp the concepts." - 18-06-2024 22:55

"The SQL Fundamentals course was incredibly helpful. It provided a concise overview of how the backend works and introduced me to the essenti… alles lezen - 18-06-2024 22:55

starstarstarstarstar
Kaaliyah Gray
10
SQL Fundamentals

"The structure of the course was well-thought-out but also delivered with clarity and relevance. Remsey is 10 out of 10. I highly recommend this course to anyone looking to expand their expertise." - 18-06-2024 22:51

"The structure of the course was well-thought-out but also delivered with clarity and relevance. Remsey is 10 out of 10. I highly recommend t… alles lezen - 18-06-2024 22:51

Moncerrat Lua Salas
starstarstarstarstar
Moncerrat Lua Salas
10
SQL Fundamentals

"Mr. Mailjard is a wonderful instructor. He makes sure to explain everything step by step in a detailed manner, making it easy to grasp any and all concepts. His positive and welcoming attitude also makes it easy to ask questions as I know that seeking help can sometimes be difficult, Mr. Mailjard is always happy to assist with any questions." - 18-06-2024 22:48

"Mr. Mailjard is a wonderful instructor. He makes sure to explain everything step by step in a detailed manner, making it easy to grasp any a… alles lezen - 18-06-2024 22:48

Guadalupe Argumedo Saucedo
starstarstarstarstar
Guadalupe Argumedo Saucedo
10
SQL Fundamentals

"The SQL training conducted by Remsey was exceptional. Their deep knowledge and clear teaching style made learning SQL enjoyable and accessible. His practical examples were particularly effective in demonstrating real-world applications of SQL concepts. His dedication to ensuring every participant felt prepared and confident in their SQL skills was evident throughout the course." - 18-06-2024 22:47

"The SQL training conducted by Remsey was exceptional. Their deep knowledge and clear teaching style made learning SQL enjoyable and accessib… alles lezen - 18-06-2024 22:47

kadiatou barry
starstarstarstarstar
kadiatou barry
10
SQL Fundamentals

"He is an excellent teacher and is very knowledgeable. I like the pace of the course; he takes time to explain every single thing, but it is not slow either. I would definitely recommend him." - 18-06-2024 22:47

"He is an excellent teacher and is very knowledgeable. I like the pace of the course; he takes time to explain every single thing, but it is … alles lezen - 18-06-2024 22:47

starstarstarstarstar
Jaranesca Braker
10
SQL Fundamentals

"Remsey excels in delivering comprehensive content, offering highly effective beginner-level instructions that are both accessible and insightful. As a knowledgeable trainer, he consistently demonstrates a deep understanding of his subject matter, making him someone I wholeheartedly recommend for anyone starting their journey in this field. For anyone seeking a solid foundation and expert guidance, Remsey is undoubtedly the person you are looking for." - 18-06-2024 22:46

"Remsey excels in delivering comprehensive content, offering highly effective beginner-level instructions that are both accessible and insigh… alles lezen - 18-06-2024 22:46

Leslie Alvarado
starstarstarstarstar
Leslie Alvarado
10
SQL Fundamentals

"Great instructor, did well with explanations. A great experience involving hands on practice, detailed explanations and guided teaching on sql fundamentals. Beginner friendly! Remsey does a great job with courses." - 18-06-2024 22:46

"Great instructor, did well with explanations. A great experience involving hands on practice, detailed explanations and guided teaching on s… alles lezen - 18-06-2024 22:46

Niran Abdulqader
starstarstarstarstar
Niran Abdulqader
10
SQL Fundamentals

"Remsey's teaching style was a perfect blend of clear explanations, real-world examples, and hands-on exercises. He was always patient and encouraging, readily answering any questions I had and ensuring everyone in the class grasped the concepts." - 18-06-2024 22:45

"Remsey's teaching style was a perfect blend of clear explanations, real-world examples, and hands-on exercises. He was always patient and en… alles lezen - 18-06-2024 22:45

Jesus Mimila
starstarstarstarstar
Jesus Mimila
10
SQL Fundamentals

"I have had a great experience as there is always a willingness to help. He also ensures that the course is not to fast paced so that everyone understands the content before proceeding." - 18-06-2024 22:44

"I have had a great experience as there is always a willingness to help. He also ensures that the course is not to fast paced so that everyon… alles lezen - 18-06-2024 22:44

Andrea Ceballos
starstarstarstarstar
Andrea Ceballos
10
SQL Fundamentals

"This was a great course and I learned a lot! He was very nice, explained everything in detail, and answered my questions. I would recommend all of his courses. " - 18-06-2024 22:44

"This was a great course and I learned a lot! He was very nice, explained everything in detail, and answered my questions. I would recommend … alles lezen - 18-06-2024 22:44

kadiatou barry
starstarstarstarstar
kadiatou barry
10
SQL Fundamentals

"He is an excellent instructor and very knowledgeable. He makes sure that you understand the material before moving on to something else. I learned so much from him. His course is definitely worth it." - 18-06-2024 22:44

"He is an excellent instructor and very knowledgeable. He makes sure that you understand the material before moving on to something else. I l… alles lezen - 18-06-2024 22:44

starstarstarstarstar
Uriel Delgado
10
SQL Fundamentals

"This was a great experience. Remsey takes his time and explains what everything does and why. When asked questions he tries to lead you to the answer and if you're stuck, he'll jump in and help." - 18-06-2024 22:43

"This was a great experience. Remsey takes his time and explains what everything does and why. When asked questions he tries to lead you to t… alles lezen - 18-06-2024 22:43

Dante Angerame
starstarstarstarstar
Dante Angerame
10
SQL Fundamentals

"Excellent for a one-day course, all the base-line information is covered well and you are set up to expand upon SQL concepts and knowledge very effectively. Remsey makes concepts easy to understand and teaches with a passion that inspires you to bring out your best. " - 18-06-2024 22:43

"Excellent for a one-day course, all the base-line information is covered well and you are set up to expand upon SQL concepts and knowledge v… alles lezen - 18-06-2024 22:43

Maximo Mayo
starstarstarstarstar
Maximo Mayo
10
SQL Fundamentals

"I can safely say that I have learned the fundamentals of SQL with the careful and well explained training by Ramsey. He has helped with many aspects of coding and I greatly appreciate the way he teaches the material." - 18-06-2024 22:42

"I can safely say that I have learned the fundamentals of SQL with the careful and well explained training by Ramsey. He has helped with many… alles lezen - 18-06-2024 22:42

Brett Spokes
starstarstarstarstar
Brett Spokes
10
SQL Fundamentals

"With the help of Remsey, the fundamentals of SQL were easy to grasp. He provided a good understanding along with real world examples on how SQL may be utilized. Along with making it clear how to incorporate SQL into other applications." - 18-06-2024 22:40

"With the help of Remsey, the fundamentals of SQL were easy to grasp. He provided a good understanding along with real world examples on how … alles lezen - 18-06-2024 22:40

starstarstarstarstar
Victor Castaneda
10
SQL Fundamentals

"Ramsey Mailjard is an outstanding SQL instructor! His patience, interactive teaching style, and unwavering support make learning enjoyable and effective. He is incredibly helpful, always ready to clarify doubts. I highly recommend his course to anyone wanting to master SQL. Five stars! " - 18-06-2024 22:39

"Ramsey Mailjard is an outstanding SQL instructor! His patience, interactive teaching style, and unwavering support make learning enjoyable a… alles lezen - 18-06-2024 22:39

starstarstarstarstar_half
Rob Franke
9
SQL Fundamentals

"Via mijn werk een SQL- Fundamentals training gevolgd gegeven door Remsey Mailjard. Een goede proffesionele trainer die het op een leuke en interessante manier kan brengen. Zeker een aanrader wanneer je een goede SQL training zoekt." - 18-10-2022 05:47

"Via mijn werk een SQL- Fundamentals training gevolgd gegeven door Remsey Mailjard. Een goede proffesionele trainer die het op een leuke en i… alles lezen - 18-10-2022 05:47

Remsey Mailjard
Remsey Mailjard
Remsey Mailjard - IT trainer en developer
9,6

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.