SQL Server Training

by Doussou Formation Claim Listing

At the end of this course, participants will be able to create tables, insert, query, modify,, and delete data from tables.

$699

Contact the Institutes

Fill this form

Advertisement

Doussou Formation Logo

img Duration

1 Day

Course Details

Both practical and complete, this SQL course is aimed at anyone wishing to to work with a relational database management system (RDBMS). At the end of this course, participants will be able to create tables, insert, query, modify,, and delete data from tables.

 

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;

  • Montreal Branch

    1176 Bishop Street, Montreal

Check out more SQL Server courses in Canada

Canadian College of Business, Science and Technology (CCBST) Logo

Oracle Certified Professional

The Oracle Certified Professional Java Programmer Certificate Course is a great starting point for both new and experienced programmers interested in learning the Java programming language, the foundation for most networked applications.

by Canadian College of Business, Science and Technology (CCBST) [Claim Listing ]
HiTech Institute Logo

Database

Database courses are offered by HiTech Institute. HiTech Institute offers courses in three settings: traditional state-of-the art classrooms, on-site at your office, and virtual learning opportunities.

by HiTech Institute [Claim Listing ]
Centennial College Logo

Oracle Database Administration Fundamentals 1

Oracle Database Administration Fundamentals 1 teaches how to install and maintain an Oracle database, the first step in obtaining a solid foundation in basic database administration.

by Centennial College [Claim Listing ]
  • Price
  • Start Date
  • Duration
Camosun Coastal Centre Logo

Database 12c Administration Workshop

Database 12c Administration course is offered by Camosun Coastal Centre. The Camosun Coastal Centre (CCC) brokers training to enhance workforce development in the shipbuilding industry.

by Camosun Coastal Centre [Claim Listing ]
Roicians Logo

SQL Training

This course is aimed at providing practical, in-depth SQL training. This training is meant to provide knowledge from the basic to the advanced level. SQL Training is for all the databases, i.e Oracle, SQL Server, etc. We prepare students for real-time scenarios.

by Roicians [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy