RDBMS for Data Science
- nasscom and Ministry of Electronics and Information Technology initiative
- Official partner with Cranes Varsity
- Certification from IT-ITeS SSC Council
- Government of India Incentive
Duration– 30 hrs
Certificates
Objectives
- Learning RDBMS equips individuals with skills to design, implement, and manage efficient and secure databases, mastering SQL for data manipulation and ensuring data integrity.
- It involves optimizing performance, handling data security, and integrating databases with applications. These skills support effective data management, essential for various applications and business needs.
Hardware and Software tools
- Sql yog or Mysql Work beanch
Take aways
- Before learning RDBMS, it’s beneficial to have a basic understanding of data structures, algorithms, and programming concepts. Familiarity with basic computer science principles and experience with a programming language like Python or Java can also be helpful. Additionally, understanding the fundamentals of data storage and retrieval will provide a solid foundation for diving into RDBMS.
Introduction to databases and RDBMS, Significance and advantages
- Features
- Versions
- Configurations
- DBMS, RDBMS and their Differences Etc…
What is SQL and Types of SQL
- Features of MySQL and types of SQL
- Advantages and Disadvantages of MySQL
- Database creation, concept of relation and working
- Create ,Select , Drop Database
- Concept of Relational and Security
- Datatypes
- Variables
Creating tables. Design view of the table, Alter table operations
- Create table
- Design View of table —> create view
- Alter table –> alter, modify, rename, drop
Constraints and working examples
- NOT NULL, CHECK , DEFAULT
- PRIMARY KEY, AUTO_INCREMENT, UNIQUE
- INDEX, ENUM, FOREIGN KEY
Querying tables , Sorting and Filtering tables
- Select statement, examples and its variations
- Insert, Update, Delete ,Read Operations and working examples
- Sorting and Filtering tables
SQL Clauses and Control flow functions
- where, distinct, Order by , Group by , Having , from
Aggregate Functions –> count, min, max, avg ,group_concat if, ifnull, nullif, case and if statement
Indexes and Locks
- create index
- drop index
- show index
- clustered and non-clustered index
Joins in SQL with working examples , Normalization & De-Normalization
Inner join, Left outer join, Right outer join, Cross join and Full joinFunctional Dependency
1NF , 2NF, 3NF, BCNF
Scalar functions in SQL and working examples
- Inbuilt scalar functions
- Creating scalar functions
- Calling scalar functions
- Removing scalar functions
Stored Procedure and Functions
- Creating procedures
- Calling procedure
