MySQL opleiding cursus SQL

Computercursus SQL in het Nederlands, Engels of Frans

Programma SQL Training

• MySQL installatie
• Opzetten van een databank
• Beheren van een databank
• Queries
• SQL
• Data importeren en exporteren
• phpMyAdmin

 

MySQL Training

Relational Database Basics

• Brief History of SQL
• Relational Databases
• Popular Databases
• SQL Statements

Simple SELECTs with MySQL

• Introduction to the Northwind Database
• Some Basics
• SELECTing All Columns in All Rows
• Exploring the Tables
• SELECTing Specific Columns
• Sorting Records
• The WHERE Clause and Operator Symbols
• The WHERE Clause and Operator Words
• Checking Multiple Conditions
• Writing SELECTs with Multiple Conditions

Advanced SELECTs with MySQL

• Calculated Fields
• Aggregate Functions and Grouping
• Built-in Data Manipulation Functions

Subqueries, Joins, and Unions with MySQL

• Subqueries
• Joins
• Outer Joins
• Unions

Inserting, Updating and Deleting Records with MySQL

• INSERT
• UPDATE
• DELETE

Creating and Modifying Tables with MySQL

• Creating Tables
• Datatypes
• Altering Tables
• Renaming Tables
• Dropping Tables

Views and Stored Procedures

• Creating Views with MySQL
• Dropping Views
• Creating Stored Procedures
• Benefits of Stored Procedures

 

 

Alle programmeeropleidingen:

• Opleiding HTML
• Opleiding XHTML
• Opleiding XML
• Opleiding CSS
• Opleiding ActionScript
• Opleiding Flex
• Opleiding Javascript
• Opleiding Ajax
• Opleiding PHP
• Opleiding SQL
• Opleiding Visual Basic
• Opleiding Visual Studio
• Opleiding C
• Opleiding C#
• Opleiding C++
• Opleiding ASP.Net
• Opleiding VB.net
• Opleiding Web services
• Opleiding Java
• Opleiding Linux shell programming
• Opleiding Delphi
• Opleiding Cobol
• Opleiding OO Programmeren
• Opleiding UML

Enkele klanten: Cevora, IBM, Holcim, CBR, Total, Bpost, Cisco, Shape, Colruyt, Telelingua, Nestlé, OCMW Molenbeek, Fabricom, Club Med, NAVO, GSK, G4Securicor, Participatiefonds, Roularta, Georg Fischer, SGC, MIVB, Federale Politie, Vlaamse Overheid, KBC, Fortis, ING, Triodos Bank, Tetrapak, Starwood hotels, Jetair, Belgacom, VRT, Royal Canin, GSK, ULB, Nationale Bank van België,...

Meer computercursussen