SQL for Data Manipulation
Harness the Power of Structured Query Language
Why This Training?
Data drives the digital age, and SQL is the language that unlocks its potential. With the increasing demand for data manipulation and analysis, SQL stands as the pillar for extracting actionable insights. This course offers a comprehensive journey, from the foundational elements of SQL to its most advanced techniques.
Duration: 15 Hours (online / virtual live session)
Who Is This For?
Data enthusiasts, business analysts, upcoming data scientists, and anyone eager to gain a robust understanding of SQL for data manipulation and analysis.
Course Breakdown
Introduction to SQL's Significance: Traverse the evolution of relational databases and understand the pivotal role of SQL in modern data analytics.
Database Fundamentals: Decode the architecture of databases, gaining clarity on essential concepts like DBMS, RDBMS, tables, and keys.
See more
Basic SQL Queries: Dive into the heart of SQL by learning to extract and manipulate data with precision using the SELECT statement, functions, and more.
Advanced Query Techniques: Master the art of sophisticated querying with joins, subqueries, and result-combining operations.
Data Manipulation & Modification: Acquire skills to insert, update, delete, and modify the very structure of database tables.
Data Transformation Techniques: Enhance your data manipulation prowess with advanced string functions, date-time operations, and conditional logic.
Best Practices & Optimization: Write efficient and high-performing queries, understand their execution, and learn how to refine them for optimal results.
Conclusion & Interactive Q&A: Solidify your learning, address queries, and discover avenues for advanced SQL exploration.
Conclusion & Interactive Q&A: Solidify your learning, address queries, and discover avenues for advanced SQL exploration.
Training Highlights
Expert-Led Sessions: Learn from industry veterans who bring real-world experience to the virtual classroom.
Practical Engagement: Through hands-on exercises and case studies, ensure the application of theoretical concepts.
Comprehensive Resources: Access to course materials, guides, and cheat sheets for post-training reference and practice.
Comprehensive Resources: Access to course materials, guides, and cheat sheets for post-training reference and practice.
Materials & Pre-requisites
Software Requirements
A working SQL environment, e.g., MySQL, PostgreSQL, etc.
Sample Databases
Real-world databases provided for practice, aiding in real-time application of concepts.
Passion to Learn
A zeal to delve deep into the world of structured data manipulation.
Write your awesome label here.
Training Content
SQL for Data Manipulation
1. Introduction: The Significance of SQL in Data Analysis
Objective: Emphasize the importance and ubiquity of SQL in data-driven industries.
- Brief history of relational databases and SQL.
- Role of SQL in data extraction, transformation, and analysis.
2. Database Fundamentals
Objective: Lay the foundation by introducing databases and their structure.
2.1. What is a Database?
- Definitions: Database, DBMS, RDBMS.
- Examples: MySQL, PostgreSQL, Oracle, MS SQL Server.
2.2. Basic Components of a Database
- Tables, records, fields.
- Primary key, foreign key, indexes.
3. Basic SQL Queries
Objective: Introduce participants to the core of SQL – querying data.
3.1. SELECT Statement
- Retrieving all columns vs. specific columns.
- Using the WHERE clause for filtering.
3.2. Sorting and Limiting Results
- ORDER BY clause.
- LIMIT clause for large datasets.
3.3. Functions and Aggregation
- Common functions: COUNT(), SUM(), AVG(), MIN(), MAX().
- GROUP BY and HAVING clauses.
4. Advanced Query Techniques
Objective: Delve deeper into more complex querying techniques.
4.1. Joins
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.
- Joining on multiple criteria.
4.2. Subqueries and Nested Queries
- Using subqueries in SELECT, FROM, and WHERE clauses.
- Common pitfalls and best practices.
4.3. Combining Results
- UNION and UNION ALL.
- INTERSECT and EXCEPT.
5. Data Manipulation and Modification
Objective: Teach participants how to modify datasets using SQL.
5.1. Inserting Data
- INSERT INTO statement.
- Adding single vs. multiple records.
5.2. Updating and Deleting Data
- UPDATE statement with SET and WHERE clauses.
- DELETE statement.
5.3. Altering Table Structures
- ALTER TABLE for adding, modifying, and deleting columns.
- Renaming tables.
6. Data Transformation Techniques
Objective: Explore advanced data manipulation techniques.
6.1. String Functions
- CONCAT(), TRIM(), UPPER(), LOWER(), SUBSTRING().
6.2. Date and Time Functions
- NOW(), DATE(), DATE_FORMAT(), DATEDIFF().
- Handling different date and time formats.
6.3. Case Statements and Conditional Logic
- Using CASE for dynamic output based on conditions.
7. Best Practices and Optimization
Objective: Highlight efficient query writing and optimization techniques.
7.1. Writing Efficient Queries
- Importance of indexes.
- Avoiding common pitfalls that slow down performance.
7.2. Query Analysis and Execution Plans
- Understanding how a query is executed.
- Analyzing bottlenecks and refining query structure.
8. Conclusion & Q&A Session
Objective: Summarize the training and address any questions.
- Recap of SQL's power in data manipulation.
- Addressing queries, fostering discussions, and pointing to further resources for deeper exploration.
WOMEN AI ACADEMY
Women AI Academy is a gender-equality and technology driven learning & development organization
Site Terms & Info
ETHOS AI Training & Consulting GmbH
Weihenstephanerstr.1281673
Munich-Germany
We are driven by the vision of making AI both ethical and accessible to everyone
Copyright © 2024 Brought to you by Ethos ai AI Training & Consultancy GmbH
Ali Hessami is currently the Director of R&D and Innovation at Vega Systems, London, UK. He has an extensive track record in systems assurance and safety, security, sustainability, knowledge assessment/management methodologies. He has a background in the design and development of advanced control systems for business and safety-critical industrial applications.
Hessami represents the UK on the European Committee for Electrotechnical Standardization (CENELEC) & International Electrotechnical Commission (IEC) – safety systems, hardware & software standards committees. He was appointed by CENELEC as convener of several Working Groups for review of EN50128 Safety-Critical Software Standard and update and restructuring of the software, hardware, and system safety standards in CENELEC.
Ali is also a member of Cyber Security Standardisation SGA16, SG24, and WG26 Groups and started and chairs the IEEE Special Interest Group in Humanitarian Technologies and the Systems Council Chapters in the UK and Ireland Section. In 2017 Ali joined the IEEE Standards Association (SA), initially as a committee member for the new landmark IEEE 7000 standard focused on “Addressing Ethical Concerns in System Design.” He was subsequently appointed as the Technical Editor and later the Chair of P7000 working group. In November 2018, he was appointed as the VC and Process Architect of the IEEE’s global Ethics Certification Programme for Autonomous & Intelligent Systems (ECPAIS).
Trish advises and trains organisations internationally on Responsible AI (AI/data ethics, policy, governance), and Corporate Digital Responsibility.
Patricia has 20 years’ experience as a lawyer in data, technology and regulatory/government affairs and is a registered Solicitor in England and Wales, and the Republic of Ireland. She has authored and edited several works on law and regulation, policy, ethics, and AI.
She is an expert advisor on the Ethics Committee to the UK’s Digital Catapult Machine Intelligence Garage working with AI startups, is a Maestro (a title only given to 3 people in the world) and expert advisor “Maestro” on the IEEE’s CertifAIEd (previously known as ECPAIS) ethical certification panel, sits on IEEE’s P7003 (algorithmic bias)/P2247.4 (adaptive instructional systems)/P7010.1 (AI and ESG/UN SDGS) standards programmes, is a ForHumanity Fellow working on Independent Audit of AI Systems, is Chair of the Society for Computers and Law, and is a non-exec director on the Board of iTechlaw and on the Board of Women Leading in AI. Until 2021, Patricia was on the RSA’s online harms advisory panel, whose work contributed to the UK’s Online Safety Bill.
Trish is also a linguist and speaks fluently English, French, and German.
In 2021, Patricia was listed on the 100 Brilliant Women in AI Ethics™ and named on Computer Weekly’s longlist as one of the Most Influential Women in UK Technology in 2021.
Created with
