Course SQL SERVER Database Programming
The content of the MS SQL SERVER Programming course is mastering stored procedures, triggers and MS SQL Server from a programmer's point of view.
Minimum input knowledge
Knowledge of MS SQL Server at the level of the SQL SERVER user course, working with a database.
Course dates SQL SERVER Database Programming
Daily courses (2 days): 09:00 - 15:00
Course price: 290.00 / 356.70 EUR
without VAT / incl. VAT
Training syllabus SQL SERVER Database Programming
Course Syllabus
- In detail about all database objects (tables, indexes, triggers; views; rules; default values, data types; user-defined data types).
- In detail about data types (Binary, Character, Date and time, Exact numeric, Approximate numeric; Integer, Monetary, Special, Text and Image).
- Extended stored procedures.
- In detail about some system tables.
- Parts of Transact SQL.
- In detail about SQL Server security (login names; user names in the database; rights for individual objects; login modes; security and system tables).
- Installation and configuration of SQL Server.
- SQL Server administration (viewing active processes; kill; bcp program and other utilities; database backup).
- Replication.
- Introduction to the interface for C and Visual Basic.
Output knowledge
Participants will be able to program stored procedures and triggers.
Recommended courses after completing SQL SERVER Database Programming
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews SQL SERVER Database Programming
Average rating