Online Video Lectures | Specialization Certificate | Virtual Lab | Project Work
Skills you will gain
Programming Languages, Tools & Libraries Covered
About this Specialization
Mastering this range of technologies will allow you to develop high-quality websites that, work seamlessly on the mobile, tablet, and large screen browsers accessible.
In the Project, you’ll use the technologies learned throughout the Specialization to design and create your own applications for data retrieval, processing, and visualization.
How the Specialization Works
Prutor.ai Specialization is a series of courses that help you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.
Every Specialization includes a hands-on project. You'll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.
Earn a Certificate
When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network.
Courses in this Specialization
Internet Technology And Web Design
Learn HTML5, CSS3 & Bootstrap to Build Responsive Website
MySQL - A Practical Approach
This chapter we will talk about what a database actually is. When people talk about a database, they mean many things. So we will define what a database really is.
Learning Objectives: This chapter we re going to focus on the features of MySQL.
You can download the source code files by clicking on the button "Download Source"
This chapter we will talk about datatypes in MySQL. Any data that is added to the database table has to have a certain datatype.
This chapter covers the introduction to MySQL. MySQL is a very popular and robust relational database management system. This database is most widely used in big and small businesses. MySQL was developed by a Swedish company named MYSQL AB. You’ll also learn about the concepts of the database, a database is an organized collection of data and information which can be easily accessed and maintained. The chapter also covers the details of datatypes in MySQL. A datatype is defined as the type of data in which a variable can hold. In MySQL, the datatypes can be numeric, strings, date and time, bit, Boolean and enumeration. Apart from this the chapter also attempts to cover the installation instructions of MySQL including XAMPP configuring and setting up of MySQL workbench, PHPMYADMIN, normalization and principles.
This chapter we will cover Setting up XAMPP, Introduction to phpmyadmin, Setting up MySQL Workbench.
This chapter covers the details of SQL Joins. A SQL Join clause combines the columns from two or more tables in a relational database. This creates a set which can be used as a table or as it is. There are various types of joins in MySQL, such as Inner Join, Left Join, Right Join, Full Join, Self-Join etc. The chapter also includes the aggregate functions which are there in MySQL.
The chapter covers the details of the database structure which includes some important terms such as Applications, End user, Data Definition Language, DDL compiler, DML Compiler, Query Optimizer, Stored data manager, Data files, Compiled DML and Data Dictionary.
This chapter covers the details of how to create and manage users in MySQL database, understanding users and privileges.
This Chapter we will learn about the performance related issues in MySQL. We will learn about monitoring the server and the system variables and viewing the logs. Then we will learn about performance tuning and denormalization.
This chapter covers the details of creating a backup and restoring the data from the database with the help of SQL queries.
ASP.NET Core MVC
Agile Software Development Framework – Scrum
What You Benefit from This Program
Frequently Asked Questions
This program intends to produce extremely well-rounded Web developers with deep knowledge of programming skills, expertise in relevant tools/languages.
This program is designed for anyone looking to pick up skills in advanced concepts like ASP.NET, MVC, Agile Software Development Framework – Scrum, Responsive Web Design, along with Internet Technology And Web Design. This program demands consistent work and time commitment over the entire duration of 6 months.
The content will be a mix of asynchronous lectures from industry leaders as well as world-class faculty. Additionally, the program comprises of some live lectures or hangout sessions dedicated to solving your academic queries and to reinforce learning.
Post completion of each course separate certificates will be issued (5 courses 5 certificates) from Prutor.ai, IIT Kanpur.
I'm interested in This Program