RDBMS | MySQL Training Institute Vijayanagar Bangalore
MySQL is an open source relational database management system. MySQL is popular among all databases, and is ranked as the 2nd most popular database, it is one of the most reliable and performative database and is known for organizing data into one or more data tables in which data types are related to each other. These relations help structure data, as SQL is a language programmers use for creation, modification and extraction of data from a relational database.
Book Free Consultation
Book Free Consultation
Course Objectives
The primary goal of this MySQL Course is to make one ample knowledge about MySQL ,so that they can begin working on this database technology right after finishing the course. This MySQL training is also focused on having one learn how MySQL database can be used alone or in conjunction with the web application that needs to store the data in the database.
Things you will learn in Module 1: RDBMS Concepts and Data Modeling Course
We help our students at every stage, from the start of a course to the actual skill-building technique. Our curriculum covers the following.
- Requirements of RDBMS
- Relational Model
- What is a Data Model?
- Steps involved in the development of
- Data Model
- Goals of Conceptual Data Modeling
- Conceptual Database Design
- Database design process
- Main Elements of an Entity-Relationship Diagram
- Entities
- Sub type, super type
- Regular or Strong & Weak entities (Independent and dependent entities)
- Entity Instances
- Identifying and Modelling Entities
- Relationships
- Modelling Relationships
- Defining a Relationship
- Types of relationships
- Minimum and maximum relationships
- Finding Attributes
- Meaningful Components for Attributes
- Different diagrammatic Conventions
- Transformation of entity relationship model into relational schema
- Logical Database Design
- Top-Down approach – E/R Modeling technique
- Bottom-Up approach –
- Normalization
- Differentiate between the above two approach
- Relational database design and update anomalies
- Discussion of case study on E/R modelling
- Execution of case study
- Normalization
- Appreciate the need for normalization
- Functional Dependencies
- Loss-less decomposition
- Various forms of Normalization
- I Normal form
- II Normal form
- III Normal form
- Boyce Codd Normal form (BCNF)
- Discussion of case study on
- Normalization
- Execution of case study
- Introduction to MySQL
- MySQL Tools to Access Data
Things you will learn in Module 2: SQL Course
We help our students at every stage, from the start of a course to the actual skill-building technique. Our curriculum covers the following.
- Schema Objects – List of schema, usages and Conventions
- RDBMS Data types in General
- MySQL Data types
- Identify the major structural components of the MySQL Database
- Table manipulation – Creating,
- Inserting Data into tables
- Write SELECT statements that include queries
- Lab exercises
- Using metadata
- Retrieve row and column data from tables with the SELECT statement
- Run data manipulation statements (DML) to update data in the tables
- Viewing the data – Restricting, Organizing, Grouping
- Returning top rows
- Auto Increment
- Integrity constraints
- Domain integrity constraints
- Entity integrity constraints
- Referential integrity constraints
- Self-referential integrity constraints
- Querying Data dictionary – Querying system tables for Tables, Constraints
- ‘Group by’ clause and ‘Having’ clause
- SQL Functions
- Single row functions
- Number functions
- Character functions
- Date functions
- Miscellaneous functions
- Conversion Functions
- Group functions
- Creating and altering the structure and constraints of the table
- Temporary tables
- Joins – Equi-join, non-equi join
- Outer joins, Left Outer join, Right Outer join
- Self join
- Cross Join
- Natural Join
- Using
- On
- Set operators
- CASE expressions
- Lab exercises
- Hands on practice session
- Queries – Complex
- Sub Queries
- Writing Single-Row and Multi-Row Sub-queries
- Describing and Explaining the Behaviour of Sub-queries when NULL values are retrieved
- Using Regular Expressions
- Write multiple-column sub-queries
- Correlated Sub-Queries
- Introduction to other Schema Objects
- Lab exercises
- Hands on practice session
- Views – Concepts, Features,
- Definition, Creation, Join views updateable rule
- Manipulating and Altering Views
- Transactions and Transactional
- Statements
- TCL
- Indexes
- Purpose of indexes
- Classification of indexes
- Examples of indexes
- Creating and dropping indexes
- Querying the data dictionary
- SQL Tuning – overview
- Order of execution of SELECT statements
- Rules for writing SELECT statements
- Rules for writing join statements – to improve performance
- Concepts of Privileges and Role
- DCL – Data Control Language – Grant and Revoke
- Concurrency and Locking Mechanism
- Types of Locks – Implicit and Explicit locking
- Levels of Lock
- Lab exercises
- Hands on practice session
Things you will learn in Module 3: Stored Routines Course
We help our students at every stage, from the start of a course to the actual skill-building technique. Our curriculum covers the following.
- Managing Stored Routines
- Procedural extensions to standard SQL
- Delimiter
- Flow control
- Loops
- While
- Loop
- Repeat
- Cursors
- Error handling
- Stored Procedures
- Calling or executing a Procedure
- Drop procedure
- Modification
- Metadata
- Lab exercises
- Hands on practice session
- Show Function / Procedure Status
- INFORMATION_SCHEMA.ROUTINES
- INFORMATION_SCHEMA.PARAMETERS
- Managing Triggers
- Creating Triggers
- Drop Triggers
- Metadata
- Show Create Trigger
- Show Triggers
- INFORMATION_SCHEMA.TRIGGERS
- Exercises
- Hands on practice session
- Events
- Managing Events
- Create Event
- Alter Event
- Drop Event
- Metadata
- SHOW CREATE EVENT
- SHOW EVENTS
- INFORMATION_SCHEMA.EVENTS
Job Assured Courses Offered by Thinkworks Vijayanagar
C | C++ Programming
Python Training
Core Java Training
Advanced Java Training
JAVA Framework Training
HTML5, CSS3, Bootstrap
JAVAScript / JQuery Training
Angular Training
React JS
React Native Training
PHP Training
Mysql Development
Oracle Advanced PL/SQL Development Training
MongoDB Training
Frontend Development
DevOps AWS | KUBERNETES | JENKINS Training
Ethical Hacking Training
Cyber Security Associate
Digital Marketing Training
Work on Live Projects & Get 100% JOB Guarantee
Why Choose Thinkworks Training Institute Vijayanagar ?
Years of successful legacy
No Royalty Model
Huge Target Audience
Recession Free Business
Multiple Revenue Streams
Marketing Support
Days Incubation Support
Comprehensive Roadmap
Globally Acclaimed Certification
Train the Trainer Programs
Technical Support
Recruitment Support
Course Curriculum
Guaranteed Placement Programs
Cloud Based Management Platform
Logistics Support
Book Free Consultation
Frequently Asked Questions
THINKWorks Guaranteed Placement Program (TWGPP)covers all aspects of developing a fresher to a qualified professional ready to meet human resources needs of today digital world. Exhaustive program covers pre assessment, grooming, industry ready skills and soft skills trainings to empower students to become qualified professionals. We offer interview opportunities and work relentlessly to help our students placed
At the core of THINKWorks Placement Program’s Skill journey is the vision to empower and make job ready the tech freshers with a consistent academic track record.
This unique program provides job aspirants an opportunity to unlock their IT-Career by following the strenuous hands on training on industry skills, employability skills and internship opportunities.
In addition to the technical skill training leaner will go through a 36 hour training to develop him/her for employment. Skills covered in this program include:
Employability skills covering honesty & integrity, Communication, Team work and collaboration, Problem solving, Leadership, Critical (analysis) thinking, adaptability, Time management, Digital Skills/Technology use, Planning and organising, Decision making, Learning agility, Emotional Intelligence and Proactivity
Interview related skills covering Resume building, presentation skills, campus to corporate, SWOT Analysis, Phone and Email Etiquette, Grooming, Dressing and presentability, Group discussion, Commonly asked questions and Mock Interviews
Aptitude covering Verbal ability, Numerical ability, Analytical ability and reasoning and quantitative analysis
Fresh graduates who are keen to embark on a fulfilling career in Information Technology
10th & 12th ≥ 50%
BE/BTech(All Streams) ≥ 60%
BCA, BSc (CS/IT) Degree ≥ 60%
It’s expected for an aspiring candidate to have basic knowledge on a programming language, data structure, OOPs, and web fundamentals
Minimum technical requirements are
- Laptop running Intel i5 with 8 GB RAM
- Webcam with audio enabled headset
- Windows 10 or Ubuntu OS
- Stable Internet connection with minimum dedicated 1Mbps
There will be assignments throughout the programme. Apart from daily practices, there will be weekly assignments and a live project as a final assignment. Participants are expected to complete each assignment to ensure project readiness.
There will be assignments throughout the programme. Apart from daily practices, there will be weekly assignments and a live project as a final assignment. Participants are expected to complete each assignment to ensure project readiness.
Fill in the Application Form and Complete Screening Process.
If you are selected, you will receive an Admission Offer letter.
On receiving the Offer Letter, pay Rs.15,000 + 18% GST to block your seat for the programme.
Initiate Loan Application for the Balance fee + 18% GST **
You will be re-directed to the lender with whom where you can complete the loan application and submit all supporting documents.
Await Loan Approval from the lender.
** GST of 18% is applicable on all Fees
** One-time Processing Fee of 1% of loan amount + 18% GST is payable to the lender post-approval of the loan.
PAN Card: Pan Card (Mandatory)
If the learner is below 21 years of age then they need to apply for the loan along with a co-applicant that is at least 21 years of age.
In case you are unable to provide the documents listed above, please reach out to your Programme Advisor to discuss other possible alternatives.
Subject to the Learner completing the program successfully and meeting all the Placement requirements and if THINKWorks, is not able to get a Job for the Learner within 90 days of the program completion as per the requirements, then THINKWorks will refund the program fee paid by the learner after retaining the non-refundable fee component (booking amount, course material cost, certification and administration cost) and any other gateway charges with applicable taxes. It is clarified that the said refund shall be applicable to only such Learners who have not availed of any loan facility. It is clarified that Placement Assurance is offered to qualified candidates only.
- Full Stack Developer Program
- Program in Web Development
- Master Program in Programming Language
- Full Stack Digital Marketing Programme
- Professional Program in Cyber Security
- For Students below 25 years of age
Academic Qualification should be
≥ 50% in X, XII, Graduation
Aptitude Test score should be
≥ 60% – For Placement Assurance
< 60% or No Score – For Placement Assistance - For Students between 25-28 years of age
We provide Placement Assistance - For Students above 28 years of age
We provide Career Guidance
1.Successful completion of the program is mandatory for any of the placement services
2. Placement Assistance – Learners will be provided with up to 3 selection opportunities
3. Career Guidance – Learners are supported for online portfolio, LinkedIn profiling and soft skill workshop
4. Placement Assurance is applicable for only STEM Graduates
Get Free Consultation Online Now +9189512 71223
THINKWorks is a registered trademark owned by EduCADD, pioneers in skill based learning for over 2 decades. THINKWorks is an idea derived with a vision to make quality Tech skill-oriented education available and affordable to every job aspiring youth of the nation.
Quick Links
Reach Us
- Phone : +9189512 71223
- Email : inquiry@educaddcenter.com
- Address : Service road, 10th Cross Rd, SBI Staff Colony, Hoshalli Extension, Stage 1, Vijayanagar, Bengaluru, Karnataka 560040
Copyright © Thinkworks Vijayanagar Bangalore 2022 All rights Reserved
