Microsoft SQL Server Training | Introduction To SQL Databases Training 10985C in Philadelphia

Introduction to SQL Databases Training 10985C Course Outline

Module 1: Introduction to Databases

• Introduction to Relational Databases
• Retrieve Data from a Relational Database by using SQL

Lab 1: Use the SELECT Statement to Retrieve Data from a Database

• Use the SELECT Statement to Retrieve Data from a Database

Module 2: Database Tables

• Identify and use Microsoft SQL Server Data Types
• Create Tables with SQL
• Altering and Dropping a Table
• Collect Information from Multiple Tables by using Joins and Views

Lab 1: Create and Alter a Table in Microsoft SQL Server

• Create and Alter a Table in Microsoft SQL Server
• Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Lab 2: Create and Alter a Table in Microsoft SQL Server

• Create and Alter a Table in Microsoft SQL Server

Lab 3: Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

• Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Module 3: Add and Update Data

• Insert, Update, and Delete Information

Lab 1: Add and Change Data in SQL Server

• Add and Change Data in SQL Server

Lab 2: Create and use Stored Procedures in Microsoft SQL Server

• Create and use Stored Procedures in Microsoft SQL Server

Module 4: Entity Relationships

• Model Entity Relationships
• Design for Referential Integrity What is Referential Integrity?

Lab 1: Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio

• Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio

Module 5: Normalization and Denormalization

• Normalization
• Denormalization

Lab 1: Deformalize a Table by Adding a Redundant Column of Computed Data

• Deformalize a Table by Adding a Redundant Column of Computed Data

Module 6: Query Performance and Safety

• Indexes
• Write Performant SQL Code
• Concurrency

Lab 1: Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio

• Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio

Who should attend this Introduction to SQL Databases Training 10985C Course?

This Introduction to SQL Databases Training 10985C Course in Philadelphia is designed for individuals who want to develop a foundational understanding of working with SQL databases and querying data. This training course is beneficial for the following professionals:

• Administrative Assistants
• Database Administrators
• Data Analysts
• IT Professionals
• Clerical Staff
• Web Developers
• Researchers

Prerequisites of the Introduction to SQL Databases Training 10985C Course

There are no formal prerequisites for this Introduction to SQL Databases Training 10985C Course.

Introduction to SQL Databases Training 10985C Course Overview

Introduction to SQL Databases Training 10985C in Philadelphia provides a foundational understanding of SQL databases, emphasizing their pivotal role in managing and retrieving data. The course explores the relevance of SQL databases in modern information systems, serving as the backbone for data-driven applications and effective information storage.

IT, Database Administration, and Software Development Professionals must master SQL databases to proficiently design, query, and maintain databases in Philadelphia. This knowledge is paramount for developers, database administrators, and analysts seeking to harness the power of SQL databases for efficient data management, retrieval, and analysis.

The Knowledge Academy's 3-day training course in Philadelphia immerses delegates in practical skills to navigate SQL databases effectively. Participants gain hands-on experience in creating, querying, and managing databases, ensuring a solid foundation in SQL. This training is tailored to empower delegates to immediately apply their knowledge, enhancing their proficiency in working with SQL databases.

Course Objectives

• To comprehend the fundamentals of SQL databases
• To master the creation and management of SQL databases
• To understand SQL querying for efficient data retrieval
• To explore database normalization principles for effective data organization
• To grasp the importance of data integrity and security in SQL databases
• To apply learned skills through practical exercises and case studies

Upon completing this Microsoft SQL Server Training in Philadelphia, delegates benefit from a strong foundational knowledge of SQL databases, enabling them to design, query, and manage databases proficiently, enhancing their capabilities in data-driven roles and contributing to organizational efficiency.

What’s included in this Introduction to SQL Databases Training 10985C Training Course?

• World-Class Training Sessions from Experienced Instructors
• Introduction to SQL Databases Training 10985C Certificate
• Digital Delegate Pack