Superwebdesign Software Trainers are Microsoft Certified Application Specialists
Superwebdesign Software Trainers are Adobe Certified Experts
nl | en

Formation et Cours en mySQL

Cours en informatique mySQL

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

 

 

Toutes les formations techniques:

Quelques clients: Cefora, IBM, Holcim, CBR, Total, Bpost, Cisco, Shape, Colruyt, Telelingua, Nestlé, CPAS Molenbeek, Fabricom, Club Med, OTAN, G4Securicor, Fonds de Participation, Roularta, Georg Fischer, SGC, STIB, Police Fédérale, KBC, Fortis, ING, Tetrapak, Starwood hotels, Royal Canin, GSK, ULB, Jetair, Belgacom, VRT, Banque National de Belgique, Hansgrohe, Regie des Batiments, General Electric, Hiscox, Prace, Toyota,...

Plus de cours en informatique à Bruxelles

Formation en informatique Bruxelles

 

 

50% de réduction pour les indépendants et PME de la Region Bruxelles-Capitale

50% de réduction pour les indépendants
et PME par la Region Bruxelles-Capitale

 

Valid HTML 4.01 Transitional Valid CSS!