- Cloud Services & Virtualisation
- Project Management
- Programming & Web Development
- Social Media & Marketing
- Medical Coding
- Business & Accounting
This course focuses on skills necessary to architect well-performing databases in SQL Server. It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database. This includes a discussion of tables, data integrity, and indexes. As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups. You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases. Another major benefit of business-focused RDBMS (Relational Database Management Systems) is the use of enforced relationships and constraints.
This course will cover all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations. One way of increasing both security and performance in a database is using stored procedures, functions, and triggers. You will learn what each of these objects is and how to write the T-SQL code to generate them. We will also cover the use of SQL Management Studio to perform these various operations using visual tools where possible. At the end of the course, you should be able to create a highly functional business database.
Key Learning Topics In This Course:
This course contains the following modules and videos. Click the down arrow to view video details.