SQL Server Database Training

Training Description:

---

Brand new to database administration? Take it one step at a time with Database Fundamentals, a series designed to support a new career or lifelong journey in IT. This installment is devoted to data: getting it into and out of tables and databases. Our Industry Expert Trainer shows how to get the most out of each data type, including numbers, characters, and specialized types like spatial data. Next are queries. Learn how to write commands and invoke functions in the SQL Editor to select just the records you want. Finally, get comfortable inserting, updating, and deleting data with the SQL Server Management Studio (SSMS), a suite of graphical tools and rich editors that make working with databases much more intuitive. Do you want to test your knowledge? Join our training program and practice what you've learned along the way.

Note: This course will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals

Training Contents:

---

• Step by Step Installation and Configuration of SQL Server
  
• Creating, Updating, Deleting databases and tables
  
• Insert, update, delete & retrieving data
  
• Data selection with queries and sub queries
  
• Advance queries, clauses, joins, views & store procedures
  
• Grouping, sorting, backup and restoring data
  
• Working with Triggers and Transactions in SQL Server
  

For more details and reserving your seat for upcoming SQL Server Database Training free seminar Click Here