structured query language and introduction

structured query language and introduction

• 1.
  MYSQL ( INTRODUCTION TO DATABASEAND MYSQL) Dr. Shubhra goyal shubhrag@regenesys.net Basi c Dat a Sci ence
• 2.
  2
• 3.
  Holistic focus onthe individual (SQ, EQ, IQ, and PQ) Interrelationships are dynamic between individual, team, institution and the external environment (systemic) Strategy affects individual, team, organisational, and environmental performance Delivery requires alignment of strategy, structure, systems and culture 3 REGENESYS’ INTEGRATED LEADERSHIP AND MANAGEMENT MODEL
• 4.
  REGENESYS GRADUATE ATTRIBUTES 4
• 5.
  Ground Rules • Beopen-minded • Listen carefully • Avoid doing other unrelated tasks when attending the session so that you can be FOCUSED. • Raise your hand if you have any query so that we can ensure one conversation at a time • When speaking, use “I think”, “I feel”, etc. (you are a very important aspect of this learning) • Respect the opinions of others • Give constructive feedback • Build on the ideas of others rather than destroying them Have fun and ENJOY the learning experience! 7
• 6.
  Know Your Mentor Qualification PhD in Machine Learning Master in Computer Science 13 Years of experience Teaching Corporate Trainer Assistant Professor Areas of specialization AI & Data Science Database Management Software Engineering Publications –Research papers Dr. Shubhra Goyal www.linkedin.com/in/dr-shubhra-goyal- 03a4a922/ shubhrag@regenesys.net
• 7.
  What is aDatabase? • A database is a structured system for storing, organizing, and managing data. • It acts as a digital version of a file cabinet. • Examples include online banking, e-commerce systems, and social media platforms.
• 8.
  Why Are DatabasesImportant? • Handle large volumes of data efficiently. • Enable multi-user access with data integrity. • Ensure data security, backups, and recovery. • Power analytics, automation, and business intelligence.
• 9.
  Examples of Databasesin Daily Life • E-commerce: Products, inventory, customers. • Banking: Transactions, accounts. • Healthcare: Patient records. • Social Media: Profiles, posts, messages.
• 10.
  University Database Example Applicationprogram examples Add new students, instructors, and courses Register students for courses, and generate class rosters Assign grades to students, compute grade point averages (GPA) and generate transcripts In the early days, database applications were built directly on top of file systems
• 11.
  Relational Model All thedata is stored in various tables. Example of tabular data in the relational model Columns Rows
• 12.
  A Sample RelationalDatabase
• 13.
  Types of Databases •Relational (SQL): Structured tables (MySQL, PostgreSQL). • NoSQL: Schema-less (MongoDB, Firebase). • Cloud-Based: Scalable and hosted (Google BigQuery, AWS RDS). • This presentation focuses on Relational Databases.
• 14.
  What is MySQL? •MySQL is an open-source relational database management system. • Developed by MySQL AB, now owned by Oracle. • Uses SQL (Structured Query Language) to access and manage data. • Common in web development stacks like LAMP.
• 15.
  SQL Data Definition Language(DDL) Create/alter/delete tables and their attributes Following lectures... Data Manipulation Language (DML) Query one or more tables – discussed next ! Insert/delete/modify tuples in tables
• 17.
  Core Concepts inMySQL • Tables: Organize data in rows and columns. • Primary Key: Uniquely identifies each record. • Foreign Key: References relationships across tables. • Schemas: Logical structure of the database.
• 18.
  Tables in SQL PNamePrice Category Manufacturer Gizmo $19.99 Gadgets GizmoWorks Powergizmo $29.99 Gadgets GizmoWorks SingleTouch $149.99 Photography Canon MultiTouch $203.99 Household Hitachi Product Attribute names Table name Tuples or rows
• 19.
  Tables Explained The schemaof a table is the table name and its attributes: Product(PName, Price, Category, Manfacturer) A key is an attribute whose values are unique; we underline a key Product(PName, Price, Category, Manfacturer)
• 20.
  SQL in Action CREATETABLE students ( id INT PRIMARY KEY, name VARCHAR(100), age INT, major VARCHAR(50) ); INSERT INTO students VALUES (1, 'Alice', 20, 'CS'); SELECT * FROM students;
• 21.
  Advantages of MySQL •Open-source and free to use. • Scalable, fast, and secure. • Works with many programming languages. • Supported by a large community.
• 22.
  Summary • Databases areessential for data storage and access. • MySQL is a powerful and popular relational DBMS. • SQL is a foundational skill for developers and data analysts. • Databases power nearly every modern digital system.
• 23.
  Questions & Discussion Thankyou for your attention! Feel free to ask questions or request a demo. Contact: [Your Email or LinkedIn]