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 945 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,7
Gemiddeld cijfer voor SQL Fundamentals
Gebaseerd op 56 ervaringen Lees alle ervaringenchevron_right
Xavier Glenn
starstarstarstarstar
Xavier Glenn
Student
10
SQL Fundamentals

"Remsey makes SQL very easy to use and learn, even a complete novice starting from the beginning can be successful in learning through him! Highly recommended if you need to learn, especially if it's through Azure but the skills are transferrable everywhere!" - 20-12-2024 22:32

"Remsey makes SQL very easy to use and learn, even a complete novice starting from the beginning can be successful in learning through him! H… alles lezen - 20-12-2024 22:32

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,7
Gemiddeld cijfer voor SQL Fundamentals
Gebaseerd op 56 ervaringen
Xavier Glenn
starstarstarstarstar
Xavier Glenn
Student
10
SQL Fundamentals

"Remsey makes SQL very easy to use and learn, even a complete novice starting from the beginning can be successful in learning through him! Highly recommended if you need to learn, especially if it's through Azure but the skills are transferrable everywhere!" - 20-12-2024 22:32

"Remsey makes SQL very easy to use and learn, even a complete novice starting from the beginning can be successful in learning through him! H… alles lezen - 20-12-2024 22:32

starstarstarstarstar
yoshuwa Ntigahera
10
SQL Fundamentals

"Remsey was outstanding in teaching SQL. Their step-by-step explanations and hands-on approach made complex queries simple to grasp. With their guidance, I gained a solid understanding of SQL and feel confident applying it. Highly recommended!" - 20-12-2024 22:32

"Remsey was outstanding in teaching SQL. Their step-by-step explanations and hands-on approach made complex queries simple to grasp. With the… alles lezen - 20-12-2024 22:32

Brianna Castanon
starstarstarstarstar
Brianna Castanon
10
SQL Fundamentals

"Very informative and helpful. It has been smooth and easy to learn. Remsey has been an extremely great teacher and has made learning simple! Hoping to learn a lot more and become more familiar with it!" - 20-11-2024 21:10

"Very informative and helpful. It has been smooth and easy to learn. Remsey has been an extremely great teacher and has made learning simple!… alles lezen - 20-11-2024 21:10

Bianca Madrid
starstarstarstarstar
Bianca Madrid
10
SQL Fundamentals

"I thoroughly enjoyed the SQL Fundamentals course! The content was engaging and well-structured, making complex concepts accessible for learners at all levels. The trainer did a fantastic job of explaining the material and was always ready to help with questions. I particularly loved the exercises, especially the one involving the thief who stole diamonds, where my name was used as the person who alerted the authorities. This added a personal touch and made the learning experience even more memorable. Overall, it was a great blend of theory and practical application, making it easy to grasp the fundamentals of SQL." - 19-11-2024 22:58

"I thoroughly enjoyed the SQL Fundamentals course! The content was engaging and well-structured, making complex concepts accessible for learn… alles lezen - 19-11-2024 22:58

Maya Faustin
starstarstarstarstar
Maya Faustin
10
SQL Fundamentals

"Remsey is a great instructor. He teaches in a beginner friendly way, breaking down complex concepts and making them easily understandable. He also uses engaging examples and exercises to practice concepts and makes learning fun." - 19-11-2024 22:53

"Remsey is a great instructor. He teaches in a beginner friendly way, breaking down complex concepts and making them easily understandable. H… alles lezen - 19-11-2024 22:53

Daniela Martinez
starstarstarstarstar
Daniela Martinez
10
SQL Fundamentals

"Not only was this training very informative, but it was also fun! Remsey did a great job keeping me engaged and eager to learn about SQL. Thanks to this fascinating lesson, it has become a language I am very intrigued about." - 19-11-2024 22:52

"Not only was this training very informative, but it was also fun! Remsey did a great job keeping me engaged and eager to learn about SQL. Th… alles lezen - 19-11-2024 22:52

starstarstarstarstar
Yoshuwa Ntigahera
10
SQL Fundamentals

"Remsey is an exceptional teacher, making complex concepts easy to grasp through interactive activities and clear explanations. Highly recommend him for learning SQL and Java. His teaching style is engaging, thorough, and effective, ensuring students truly understand the material. Looking forward to learning more from him!" - 19-11-2024 22:49

"Remsey is an exceptional teacher, making complex concepts easy to grasp through interactive activities and clear explanations. Highly recomm… alles lezen - 19-11-2024 22:49

Charles Mateo
starstarstarstarstar
Charles Mateo
10
SQL Fundamentals

"His teaching style is outstanding. He simplified complex topics, making everything clear and easy to understand. Learning with him is enjoyable, and I truly value the time spent gaining knowledge." - 19-11-2024 22:45

"His teaching style is outstanding. He simplified complex topics, making everything clear and easy to understand. Learning with him is enjoya… alles lezen - 19-11-2024 22:45

Torivia Vargas Rubio
starstarstarstarstar
Torivia Vargas Rubio
10
SQL Fundamentals

"Remsey managed to make learning SQL so FUN! The way he is teaching, I have no doubt he'd be able to help a 5th Grader learn SQL basics in 1 day! Before learning, I thought it'd be another hard language to get through--but I actually feel really confident in my ability! I can thank Remsey for this." - 19-11-2024 22:44

"Remsey managed to make learning SQL so FUN! The way he is teaching, I have no doubt he'd be able to help a 5th Grader learn SQL basics in 1 … alles lezen - 19-11-2024 22:44

Xavier Glenn
starstarstarstarstar
Xavier Glenn
Student
10
SQL Fundamentals

"Remsey makes learning complex concepts easy to learn. He takes the time to break concepts down and makes sure that you understand the topic. He is very knowledgeable and experienced with SQL, so having a teacher like him to guide those of us who are new/newer really helps. Please follow these courses if you'd like to learn this vital piece of database management. It is useful in many aspects, in many coding languages, and I believe it is a must-have for any budding programmer." - 19-11-2024 22:42

"Remsey makes learning complex concepts easy to learn. He takes the time to break concepts down and makes sure that you understand the topic.… alles lezen - 19-11-2024 22:42

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

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.