259/1A 3rd Floor, ADA Rd, Vinoba Nagar, Naini, Prayagraj, Uttar Pradesh 211010
05323557581, +919555433745 (9am - 8pm IST, Monday - Saturday)
ConaxInfotech
Training | Development | Internship
Course Description
Prerequisites to take this course.
No prior knowledge is needed for learning MYSQL Database Design & Development.
Course curriculum.
-
Introduction
-
Basics - Part 1
-
Basics - Part 2
-
Intermediate - Part 1
-
Intermediate - Part 2
- What Are Constraints?
- CONSTRAINTS: NOT NULL
- CONSTRAINTS: UNIQUE. DESCRIBE + AUTO_INCREMENT
- CONSTRAINTS: DEFAULT
- CONSTRAINTS: CHECK
- CONSTRAINTS: PRIMARY KEY & FOREIGN KEY
- Exercise 8 - TASK
- Exercise 8 - SOLUTION
- String Functions - Part 1
- String Functions - Part 2
- Exercise 9 - TASK
- Exercise 9 - SOLUTION
- Numeric Functions
- Date Functions - Part 1
- Date Functions - Part 2
- IFNULL
- IF
- CASE
- COALESCE
-
Advanced - Part 1
-
Advanced - Part 2
- Views
- Stored Procedures
- Exercise 11 - TASK
- Exercise 11 - SOLUTION
- Variables - Part 1 - System Variables
- Variables - Part 2 - User-Defined Variables
- Variables - Part 3 - Parameters and Local Variables
- Input and Output Parameters
- User-Defined Functions (2 examples)
- Exercise 12 - TASK
- Exercise 12 - SOLUTION
- Triggers
- What Are Indexes?
- CREATE, READ and DELETE Indexes
- Exercise 13 - TASK
- Exercise 13 - SOLUTION
-
Import and Export (CSV files)
-
Database Normalization
-
IMPORTANT
Why Conax Infotech For Databases Design & Development Training.
- Training by experienced faculty.
- Certificate after training completion.
- Free WIFI for students.
- Fully AC Classrooms with Projector.
- 100% Job Assistance.
- Interview guide and career consulting.
- Doubt sessions and real IT working experience.
- Curated study material with code documents.
- Job oriented training programs, available in offline/online mode.
Databases Design & Development Course Schedule.
| Track | Week Days | Course Duration | Fast Track |
|---|---|---|---|
| Course Duration | 45 - 60 Days | 10 Weekends | 15 Days |
| Hours | 2 Hrs. Per Day | 3 Hrs. Per Day | 6+ Hrs. Per Day |
| Training Mode | Classroom/Online | Classroom/Online | Classroom/Online |
Want To Know More About This Course.
-
Ajinkya
Highly Impressed!
The Complete MYSQL Course helped me master MYSQL. The instructors were patient, and the course covered all aspects of database management. Great training!
-
Niraj
"The Complete MYSQL Course Gave Me the Confidence to Become a MySQL Expert!"
I was a complete beginner to MySQL when I started this course, but by the end, I felt like an expert! The course was well-organized and easy to follow, and the instructor was very knowledgeable. I learned everything I needed to know to start using MySQL in my own projects, and I'm confident that I can now use it to build powerful databases. I highly recommend this course to anyone who wants to learn MySQL
-
Mukesh
"The Complete MYSQL Course Is the Best Way to Learn MySQL!"
I've tried a few different MySQL courses, but this one is by far the best. The instructor is clear and concise, and the course covers everything you need to know to become a MySQL expert. I especially appreciated the hands-on exercises, which helped me to solidify my understanding of the material. If you're serious about learning MySQL, then this is the course for you."
Related Courses
