In this lecture, we will learn the definition of databases, with examples.

In this lecture we will take the definition of tables and relationships between them, with examples.

In this lecture we will learn how to add databases and tables using SQL queries and scripts.

In this lecture we are going to create databases, tables, primary keys and foreign keys using graphical interface of MySQL workbench.

In this lecture, we will add data to tables using the Insert query.

In this lecture, we are going to use select query to select all, some columns or rows from a table.

In this lecture, we are going to learn about Update query syntax.

In this lecture, we are going to learn about delete query.

In this lecture we are going to learn how to:

1. Add a column;
2. Modify a column name or datatype;
3. Drop a column.

In this lecture we are going to learn about join types with their specific queries

In this lecture, we are going to learn about LEFT Join query.

In this lecture, we are going to learn how to write a multiple join query.

In this lecture, we are going to learn about cross joins.

In this lecture, we will see why we use sometimes, cross joins.

in this lecture, we are going to learn about some SQL pre-made functions.

In this lecture, we are going to learn the SQL union all query.

In this lecture, we are going to learn about SQL subqueries.

In this lecture, we are going to learn how to search inside character values inside database.

In this lecture, we are going to learn the SQL between query.

This is a resume about section 2 of this course.

In this lecture, we are going to take small introduction about views.

In this lecture, we are going to make our first view.

In this lecture, we are going to learn how to create views, with sub queries.

In this lecture, we are going to take an introduction about SQL Procedures.

In this lecture, we are going to make an example about procedures but without parameters.

In this lecture, we are going to make an example about procedures with parameters.

SQL Cursors slides.

In this lecture, we are going to learn about SQL Cursors.

In this lecture, we are going to write an SQL script with cursors.

In this lecture, we are going to change the script, so instead of cursors, we will uses Case statements.

In this lecture, we will take an introduction about functions.

In this lecture, we will write a function with no parameters.

In this lecture, we will write a function with parameters.

In this lecture, we are going to learn some of the pre-made date and time functions in MySQL.

In this lecture, we are going to learn how to write trigger codes.

In this lecture, you are going to learn how to grant some privileges, to your users.

In this lecture, you are going to learn, how to export and import SQL in MySQL.

In this lecture, we will be introduced to our database where we are going to create views and procedures.

This file contains views and procedures exercises.

This lecture is about resolving exercise 1.

This lecture is about resolving exercise 2.

This file contains solutions of all view exercises.

In this lecture, we are going to make a procedure that counts number of goals in each half.

In this lecture, we are going to make a procedure that calculates the number of goals at a specific time.

In this lecture, we are going to make a function exercise.

In this file, you will find the solution of all procedures and functions.

In this lecture, we will be introduced to some PHP editors to work with, during our web developing.

In this lecture, we are going to create our web application working folder.

In this lecture, we will see how to work with variables, and echo them in our web application.

In this lecture, we will see how to create web forms.

In this lecture, we will see how to POST variables from web forms into our code.

In this lecture, we are going to learn about PHP operators like AND, OR and the empty function.

In this lecture, we are going to learn what are sessions.

In this lecture, we are going to learn about SQL injections with a fast and easy example.

In this lecture, we are going to connect php file into our database.

In this lecture, we are going to take username and password, and see if they're true, to redirect to a new page.

In this lecture, we are going to see how to make a connection file and call it in all our pages, instead of writing it every time.

In this lecture, we are going to learn how to make a logout page with PHP codes.

Before we continue, we should learn about HTML tables, so we can use them in displaying some data in our web pages.

In this lecture, we are going to learn how to display MySQL data into our web page.

In this lecture, we are going to learn how to request variables from URL.

Instead of sending variables throughout URL, and request them, we can send those variable through a hidden input.

In this lecture, we are going to add data to database through our html table.

In this lecture, we are going to update some rows, using html table.

In this lecture, we are going to add a delete button, so we can delete data from our table.

In this lecture we are going to take an introduction about JavaScript and why we use it in web developing.

PDF file.

In this lecture we are going to learn how start typing JavaScript and see the different types of variable.

Instead of using PHP to see if a text box is empty or not, we can do that on client-side using JS.

In this lecture, we are going to change colors of input, and set a character condition.

In this section, we are going to type our first OnMouseOver and OnMouseOut functions.

In this lecture, we are going to learn how to increment and decrement a variable.

In this lecture, we are going to learn how to acces a div using innerHTML.

In this lecture, we are going to learn about arrays and how to work with in JS.

in JS, we have many type of loops. Do While, While, and For loops.

In this lecture, we are going to work with OnClick, and how we can go to another page using JS.

In this lecture, we are going to learn some date and time methods.

In this lecture, we are going to learn some string methods using JS.

In this lecture, we are going to learn basic math and numbers methods.

In this lecture, we are going to learn how to include JS files in our pages.

In this lecture, we are going to learn how to append elements.

From now on, we are going to learn some jQuery codes. And this lecture, is an introduction about it.

In this lecture, we are going to learn about jQuery events.

In this lecture, we are going to learn some new events to use.

In this lecture, we are going to learn how to show an element.

In this lecture, we are going to learn how to animate an element using fadeIn().

In this lecture, we are going to learn how to set and get contents from html elements.

In this lecture, we are going to learn how to add elements using jQuery.

In this lecture, we are going to learn how to remove elements, or make them empty.

In this lecture, we are going to learn some jQuery animation coding.

In this lecture, we are going to learn how to make a print button using JavaScript and jQuery.