This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management.
This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management.
Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title.
Learning Objectives
After completing this course, you will be able to:
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
New Horizons Computer Learning Centers was named as one of the top 20 IT training companies on TrainingIndustry.com’s annual Top 20 IT Training Companies List. We’ve been honored with this designation 15 years in a row!
Selection of the top IT companies is based on leadership & innovation in IT training, breadth of IT training and delivery methods offered, company size and growth potential, strength of clients and geographic reach.
"Our Top IT Training List is based on thorough analysis of the capabilities, experience and expertise of IT training providers," wrote the publication's editors when the 2022 awards were announced. "We continuously monitor the training marketplace looking for the best providers of IT training that offer a breadth of courses and content."
New Horizons Computer Learning Centers has earned the 2019 Top 20 Learning Provider designation from The Learning & Performance Institute (LPI). The LPI is a leading authority in learning efficacy, or the “demonstrable impact of learning on individual and organizational performance.”
New Horizons has shown a clear roadmap that leads towards continued success, demonstrating a strong customer value proposition and having a corporate culture that instills confidence throughout sales and marketing, to delivery and after-sales support.
You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.
SQL Server courses are offered by Practicum Canada. Practicum Canada has highly skilled and proficient professionals with over 20 years of industry and academic experience. We are equipped with innate abilities to instill academic and professional expertise.
The MySQL Fundamentals training is the first step in mastering MySQL, the world's most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.
In this course, you apply guidelines and considerations for securing data using encryption and certificates. You describe various data encryption policies. Finally, you determine a key storage method.
Compuease offers SQL Training at its Ottawa training centre. Our SQL classes are led by trainers with practical experience using language in all sorts of business and government environments. Their friendly and approachable style will help you get comfortable speaking this new language.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy