Scribd Logo
Upload

Welcome to Scribd!

  • 45 views

    Three Day SQL Workshop

    Uploaded by

    Jojo Jacob
    This three-day SQL programming workshop teaches relational database fundamentals and SQL skills, including database design techniques, query writing, and database manipulation. Topics covered over the three days include relational database concepts, data normalization, SQL syntax, database creation, query writing, aggregate functions, and database manipulation using DML, functions, procedures, and triggers. The goal is for participants to understand SQL and be able to design databases and write various SQL statements to select, insert, update and delete data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Three Day SQL Workshop

    Uploaded by

    Jojo Jacob
    45 views1 page
    This three-day SQL programming workshop teaches relational database fundamentals and SQL skills, including database design techniques, query writing, and database manipulation. Topics covered over the three days include relational database concepts, data normalization, SQL syntax, database creation, query writing, aggregate functions, and database manipulation using DML, functions, procedures, and triggers. The goal is for participants to understand SQL and be able to design databases and write various SQL statements to select, insert, update and delete data.

    Original Description:

    Three Day SQL Workshop

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This three-day SQL programming workshop teaches relational database fundamentals and SQL skills, including database design techniques, query writing, and database manipulation. Topics covered over the three days include relational database concepts, data normalization, SQL syntax, database creation, query writing, aggregate functions, and database manipulation using DML, functions, procedures, and triggers. The goal is for participants to understand SQL and be able to design databases and write various SQL statements to select, insert, update and delete data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    45 views1 page

    Three Day SQL Workshop

    Uploaded by

    Jojo Jacob
    This three-day SQL programming workshop teaches relational database fundamentals and SQL skills, including database design techniques, query writing, and database manipulation. Topics covered over the three days include relational database concepts, data normalization, SQL syntax, database creation, query writing, aggregate functions, and database manipulation using DML, functions, procedures, and triggers. The goal is for participants to understand SQL and be able to design databases and write various SQL statements to select, insert, update and delete data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    2nd Floor, Vettuvazhi Plaza www.credencetechnologies.

    in
    Aramana Junction [email protected]
    Muvattupuzha, Kerala – 686661 0485 2837512 | +91 9656117512

    Three Day SQL Programming Workshop


    Course Description Day 1

    This SQL programming workshop teaches students  Overview of Relational Database


    relational database fundamentals and SQL programming Concepts
    skills. Topics covered include relational database  Data Normalization
    architecture, database design techniques, and simple and  DDL Syntax
    complex query skills. This class is intended for analysts,  Creating a Database
    developers, designers, administrators, and managers new  Building a Logical Data Model
    to the SQL programming language. Upon completion,  Transforming to Physical Design
    participants will understand SQL functions, join
     Constructing the Database Using
    techniques, database objects and constraints, and will be DDL
    able to write useful Select, Insert, Update and Delete
    statements. Comprehensive hands on exercises are
    integrated throughout to reinforce learning and develop
    real competency.
    Course Duration : Three Days Day 2
    Course Objectives
     Writing Basic SQL Queries
     Inculcate interest towards Database technology.  Manipulating Query Results
     Familiarize with SQL Query Language.  Advanced Query Techniques
     It will develop your skills according to present  Using Aggregate Functions
    technology.
     It covers all the basic aspects needed for Database
    Design.

    Pre Requirements

    General computer knowledge.

    Course Outcomes Day 3

     Designing normalized table structures for relational  Manipulating Table Using DML
    databases  User-Defined Functions
     Creating databases and tables  Stored Procedures
     Using primary and foreign keys  Triggers
     Writing SQL queries
     Using triggers and stored procedures
     Using aggregate functions to return totals and
    subtotals
     Using DML for SELECT, INSERT, UPDATE,
    DELETE

    Embedded System | Robotics | Basic Electronics | MATLAB | openCV | Python | NS2 | R | C | C++
    Hadoop | Java | PHP | .net | Android | Swift | MySQL | Networking | Personality Development | Interview Preparation

    You might also like