Formation SQL - Fundamentals

Loading

Formation SQL - Fundamentals in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.


480.-/d
ID : 1101

Goal : The objective of this training is to design basic SQL queries by working on MS Access, MS Excel Query, SQL Server, Oracle Database, DB2 or MySQL according to the interest and the need of the learners. This training provides the knowledge that any employee working with corporate bases needs to master. It also prepares the trainee to the SQL training for Data Scientists.

Audience : This training is for anyone wishing to acquire the knowledge to be able to simply query databases of his company on the most widespread technologies in business (SQL, Server, MS Access, AS / 400, DB2, Oracle Database, MySQL or other).

Prerequisites : Knowledge of the general principles of relational databases and their modeling (see related course).

Goals :
  • Introduction
  • History of SQL
  • The norms and characteristics of the SQL
  • Determine the version of SQL
  • Traditions and use in writing SQL
  • SQL DML vs SQL DDL vs SQL RDL
  • Syntax of comments
  • Partial (projection) or total selection (SELECT) query for a single table
  • USE command to set the tableof the database
  • Using ALIAS for columns and tables
  • Selection of a random sample of data
  • Sort data taking care of the COLLATION
  • Union queries (UNION) to merge tables
  • Distinct query for unique values (without duplicates)
  • Using the WHERE statement to filter data
  • Dynamic or static (WHERE) filter
  • Managing NULL values with (WHERE) filters
  • Selection of TOP (X Larger) or BOTTOM (X Smaller) values
  • Using the LIKE operator associated with (WHERE) filters
  • Using the IN operator associated with (WHERE) filters
  • ...
Pedagogical method : Lectures where about 80% of the time is devoted to practical exercices in the various environments specified in the objectives.

Suggested duration for presentiel training (days) : 3
Suggested duration for on-line training (days) : 3.6

Daily price in face-to-face : 480 CHF
Daily price in remote : 230.4 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 2400 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Book
  • Title : SQL Cookbook
  • Author(s) : Anthony Molinaro
  • Pages : 636
  • ISBN : 9780596009762

Tags : sql, s.q.l., structured query language, jointure, join, where, update, query, requête, sql server, oracle database, mysql, ms access, access, excel, ms excel, sql course, sql training, oracle, sql server, postgre sql, mysql, mongodb.