Database Design & Management for Software Applications: Hands-on Course for Real Life Issues and Solutions
About Workshop
Introduction
In this Database course participants will learn Basic and Advanced level MySQL & MSSQL Database for all web and desktop applications. Participants will also learn about Managing Databases, Tables, and Indexes, Manipulating Data in a Database, Retrieving Data from a Database, Using Operators in SQL Statements, Using Functions in SQL Statements and Accessing Data in Multiple Tables. Here Database Normalization & Relation of Database will also be discussed.
How participants will benefit after the course
• Participants will know the use of MySQL & MSSQL Database for web & desktop application so that you can find Database jobs easily.
• High quality content for a fraction of the cost of a training course to learn Database
• Participate can design database with proper documentation.
• After finished this course participants will be able to design real world database.
Course Highlights:
• Basic and Advanced level MySQL & MSSQL Database
• Introducing the Relational Database Management System & Entity−Relationship Model
• Entity-Relationship Diagram & Design Real world Database
• Relational Model & Relational Algebra
• Designing a Relational Database
• Designing Object Oriented Databases
• Managing Databases, Tables, and Indexes
• Manipulating Data in a Database
• Retrieving Data from a Database
• Using Operators in SQL Statements
• Using Functions in SQL Statements
• Accessing Data in Multiple Tables
Workshop topics to be covered:
Lesson 01: Introducing the Relational Database Management System & Entity−Relationship Model
• About Database
• Hierarchical Model
• The Network Model
• Entity Sets
• Relationship Sets
• Mapping Cardinalities
• Keys
o Entity Sets
o Relationship Sets
• Design Issues
o Use of Entity Sets versus Attributes
o Placement of Relationship Attributes
Lesson 02: Entity-Relationship Diagram & Design Real world Database
• Entity-Relationship Diagram
• Weak Entity Sets
• Specialization
• Generalization
• Constraints on Generalizations
• Aggregation
• Design of an E-R Database Schema
• Database Design for Real world Database
Lesson 03: Relational Model & Relational Algebra
• Database Schema
• Schema Diagram
• The Relational Algebra
o Select Operation
o Project Operation
o Union Operation
o Rename Operation
o Composition of Relational Operations
o Set Difference Operation
o Set-Intersection Operation
o Natural-Join Operation
o Division Operation
• Modification of the Database
Lesson 04: Designing a Relational Database
• SQL
o Select Clause
o Where Clause
o From Clause
o Rename Operation
o Tuple Variables
o String Operations
o Ordering the Display of Tuples
o Duplicates
• Set Operations
o Union Operation
o Intersect Operation
o Except Operation
• Aggregate Functions
• Null Values
• Nested Subqueries
• Complex Queries
• Modification of the Database
o Deletion
o Insertion
o Updates
Lesson 05: Designing a Relational Database
• The Data Directory
• The Grant Tables
• Data Normalization
o First Normal Form
o Second Normal Form
o Third Normal Form
• Relationships
o One-to-One Relationships
o One-to-Many Relationships
o Many-to-Many Relationships
• Creating a Data Model
• Identifying Entities
• Normalizing Data
• Identifying Relationships
• Refining the Data Model
Lesson 06: Designing Object Oriented Databases
• Object Oriented Databases
• Object Relational Databases
o Inheritance
• Data-Definition Language
• Schema Definition in SQL
• Integrity and Security
Lesson 07: Managing Databases, Tables, and Indexes
• Managing Databases
o Creating Databases
o Modifying Databases
o Deleting Databases
• Managing Tables
o Creating Tables
o Modifying Tables
o Deleting Tables
• Managing Indexes
o Index Types
o Creating Indexes
o Removing Indexes
Lesson 08: Manipulating Data in a Database
• Inserting Data in a Database
o Using an INSERT Statement to Add Data
o Using a REPLACE Statement to Add Data
• Updating Data in a Database
• Deleting Data from a Database
o Using a DELETE Statement to Delete Data
o Using a TRUNCATE Statement to Delete Data
Lesson 09: Retrieving Data from a Database
• The SELECT Statement
o Using Expressions in a SELECT Statement
o Using Variables in a SELECT Statement
o Using a SELECT Statement to Display Values
• The SELECT Statement Options
• The Optional Clauses of a SELECT Statement
o The WHERE Clause
o The GROUP BY Clause
o The HAVING Clause
o The ORDER BY Clause
o The LIMIT Clause
Lesson 10: Using Operators in SQL Statements
• Creating Expressions
o Operator Precedence
o Grouping Operators
• Using Operators in Expressions
o Arithmetic Operators
o Comparison Operators
o Logical Operators
o Bitwise Operators
o Sort Operators
Lesson 11: Using Functions in SQL Statements
• Comparing and Converting Data
• Managing Different Types of Data
• Summarizing Data
• Performing System Operations
Lesson 12: Accessing Data in Multiple Tables
• Creating Joins in SQL Statements
o Joining Tables in a SELECT Statement
o Joining Tables in an UPDATE Statement
o Joining Tables in a DELETE Statement
• Creating Subqueries in SQL Statements
o Adding Subqueries to SELECT Statements
• Creating Unions That Join SELECT Statements
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
