- +61417667434
- info@docsmarket.com
This comprehensive course provides the essential knowledge and practical skills required to understand and work with modern database systems. With a focus on relational databases and hands-on experience using platforms like Microsoft SQL Server, this program is your gateway to the world of data management.
Students will explore core concepts that form the backbone of Database Management Systems (DBMS), including data storage, table design, and the powerful Transact-SQL (T-SQL) language used for querying and manipulation.
Learning Outcomes:
Upon successful completion, students will be proficient in:
- Designing and creating database tables with appropriate data types.
- Writing advanced SQL queries to retrieve, insert, update, and delete data.
- Building database objects like views, stored procedures, and functions.
- Combining datasets using JOINs, UNION, and INTERSECT operations.
- Applying database normalization rules to ensure data integrity.
- Implementing primary keys, foreign keys, and composite keys to define relationships.
- Improving query performance through the use of indexes (clustered and non-clustered).
- Understanding core database security concepts, including user accounts and roles.
- Executing database backup and restore procedures for data protection.
Curriculum
- 10 Sections
- 0 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Module 1: Introduction to DatabasesThe role of databases in storing and managing information. Comparing different types of databases, with a focus on Relational Database Management Systems (RDBMS).0
- Module 2: Core Relational Database ConceptsUnderstanding the structure of data: tables, columns (fields), and rows (records). How relationships are established between tables in an RDBMS.0
- Module 3: Structured Query Language (SQL) FundamentalsData Definition Language (DDL): Using T-SQL to create and alter database objects (tables, views). Data Manipulation Language (DML): The role of DML in interacting with stored data.0
- Module 4: Working with Data Types and TablesSelecting the correct data types to ensure data integrity and optimize storage. Creating well-structured tables using proper ANSI SQL syntax.0
- Module 5: Retrieving Data with SELECT QueriesCrafting basic to advanced SELECT statements to filter and retrieve data. Combining data from multiple tables using INNER, OUTER, LEFT, and RIGHT JOINS. Merging result sets with UNION and INTERSECT operators.0
- Module 6: Modifying Data0
- Module 7: Building Database ObjectsCreating Views: Understanding the purpose of views and how to build them. Developing Stored Procedures and Functions: Writing encapsulated logic for complex operations.0
- Module 8: Database Design & NormalizationThe principles of database normalization (1NF, 2NF, 3NF) to eliminate data redundancy. Practical steps to normalize a database to the third normal form.0
- Module 9: Implementing Keys and IndexesDesigning primary keys, foreign keys, and composite keys to enforce table relationships. Utilizing clustered and non-clustered indexes to dramatically improve query performance.0
- Module 10: Database Administration EssentialsSecurity Concepts: Securing database objects, managing user accounts, and assigning roles. Backup and Recovery: Understanding different backup strategies (full, differential) and performing database restores.0
Instructor
