Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.
While DBMS’s differ in the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.
-The Entity Relationship (= ER) Model
-The Relational Data Model
– Relations
– Integrity Constraints (keys, foreign keys, etc.)
-Logical Database Design
-(ER to relational schemas)
-Relational Algebra
-(an algebraic query language for the relational model)
-SQL: Querying and Manipulating Data
– SQL Data Definition Language
– Single Block Queries
– Aggregation
– Joins and Outer Joins
– Nesting
– Negation
- Transaction Management and Concurrency Control
- Database Access from a Programming Language: JDBC
-Introduction to databases and database management systems
- Overview of MySQL and its features
- Installing MySQL server and client
- Getting started with MySQL Workbench
- Understanding relational databases and data modeling concepts
- Creating and managing databases in MySQL
- Creating tables and defining columns with different data types
- Modifying tables using ALTER statements
- Retrieving data from tables using SELECT statements
- Filtering data with WHERE clause
- Performing basic mathematical and string operations in queries
- Aggregating data using GROUP BY and aggregate functions (COUNT, SUM, AVG, etc.)
- Modifying data in tables using INSERT, UPDATE, and DELETE statements
- Optimizing queries using EXPLAIN and query optimization techniques
- Importing and exporting data using MySQL utilitie
- Creating user-defined functions and calling them in queries
- Introduction to database normalization and its importance
- Refactoring database schema for normalization
- Introduction to database indexing and its benefits
- Analyzing query execution plans and optimizing indexes
- Introduction to advanced topics in MySQL (replication, clustering, etc.)
- Integrating MySQL with other programming languages (PHP)
And lots more
You can now learn from your Home or offices with our Instructor-Led live online, interactive training on ICT and computer skills. Live Online classes feature all the same benefits of live instructor interaction while saving on travel time and cost. You can also have your classes recorded, which you can watch again for revision. All online classes include practical hands-on – all you need is internet access
Enrol Now
