SQL Server Training

Course Details

• Introduction to training SQL server

• Training presentation: SQL server

• Definition of a database and the different types of objects

• Data Manipulation Language (LMD)

• Inserting rows (INSERT)

• Inserting multiple lines

• Inserting from a SELECT

• Update with UPDATE

• UPDATE with subqueries

• Deleting a record (DELETE)

• Practical workshop: Modifying the content of our database

Data Query Language (LID)

• Data type (date, float, etc.)

• Data selection: SELECT

• The criteria are TOP, WHERE, HAVING, etc.

• Join: INNER, LEFT, RIGHT, OR OUTER

• Creation and modification of data: insert, update, delete

Benefits :

• Course material for each participant

• Trainer support after training

• We offer you, in public session:

  • Tea, coffee

  • Parking (only in certain cities)

  • Wireless internet connection

Goals :

• Discover SQL Server;

• Retrieve, create and modify data from a database;