MySQL Course Syllabus
Course Syllabus
Download SyllabusMySQL Course Content
- A Brief History Of Databases
- Relational Database Concepts
- Database Tables
- MySQL Data Types
- Introduction To P HPMyadmin
- Creating And Checking Tables
- Auto_increment And Primary Keys
- Inserting Values Into Tables
Mini Project With PHP And MySQL
- Creation Of Database And Required Tables Using PHPMyadmin.
- Creation Of Required Templates, Pages And Managing Site Using IDEDreamweaver.
- Keeping Structure, Style And Behavior Of Created Pages Apart.
- Creating Login And Logout Pages For Maintaining Sessions.
- Creating Forms To Insert Data Into Address Book-Personal Details, Image Etc.
- Creating Page To View The Data From Address Book.
- Adding PHPScript For Form Validation.
- Adding Server Side Validation.
- Adding Mouse Events Like Mouseout And Mouseover Dynamically.
- Creating Page To Edit Or Delete The Records In The Address Book.
- Creating Page To Enable Searching The Address Book
Introduction To Ajax
- What Is Ajax
- Connecting To Server Using PHPScript
- Downloading Data Behind Scenes
- Modifying Web Pages On The Fly
- Creating An XMLHttpRequest Object In Different Browsers
- Checking The XMLHttpRequest Object’s ReadyState Property
- Checking The XMLHttpRequest Object’s Status Property
- Getting Your Data With The XMLHttpRequest Object
- Problems Creating An XMLHttpRequest Object
- Fetching Text Data From The Server
- Using The Text Data Received Through XMLHttpRequest
You will explore the core concepts of relational databases and learn to effectively use MySQL to create, manage, and query databases through our MySQL course.
