Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 8 - Modular_V2.0_SQL_Flipbook
P. 8

    CONTENTS

                      01   Introduction to DBMS                                                                          7

                               Understanding Database and DBMS                  What is a Relational Database?
                               Keys                                             Understanding SQL
                               Different Types of Commands in SQL               Modern DBMS

                      02   Introduction to MySQL                                                                        14
                               Installing MySQL                                 Data Types in MySQL

                               Creating a Database                              Creating a Table
                               Modifying a Table                                Deleting a Table
                           Periodic Assessment-1                                                                        24

                      03   Handling Records in MySQL                                                                    25

                               Inserting Records in a Table                     Retrieving Records from a Table
                               Updating Records in a Table                      Deleting Records from a Table
                               Using DISTINCT Clause                            Using Operators

                               MySQL Comments
                           Periodic Assessment-2                                                                        35
                           Test Sheet-1                                                                                 36

                      04   More on MySQL                                                                                38

                               Aliasing                                         Performing Calculations in Queries
                               Using Group By                                   Using Order By
                               Function

                           Periodic Assessment-3                                                                        48

                      05   Advanced Features of MySQL                                                                   49
                               Subqueries                                       Joins

                               Views                                            Index
                           Periodic Assessment-4                                                                        67
                           Test Sheet-2                                                                                 68

                           Project Work                                                                                 70
                           Explore More (Latest Trends)                                                                 73

                           Uncover Artificial Intelligence & Robotics                                                   77
                           OGO Cyber Sample Questions                                                                   81

                           Glossary                                                                                     84

                                                                      (vi)

| 3 4 5 6 7 8 9 10 11 12 13 |