What you'll learn
Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Learn about database design and normalization
Using joins, return columns from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Group data together using the GROUP BY clause
Filter groups of data using the HAVING clause
What you'll learn
Add beautiful effects & animations to your sites
Use AJAX to add content to the page dynamically from APIs
Create dynamic websites that users enjoy
Handle arbitrary user events such as mouse clicks and keyboard presses
Add fast feedback and validation for forms using jQuery.
Manipulate the appearance and content of any element on the page
Fundamentals of a Great Website User Experience
Your website is the most valuable digital asset for your …
What you'll learn
Basic understanding of a great website user experience
How to design your website with the user in mind
Interactive website design
Optimizing a Website for Mobile
Since thousands of people worldwide use mobile devices to access …
What you'll learn
Discover how responsive design works
How to set up viewport for your website
Understand the best practices for using fonts and interactive elements on your website
The Database Development Lifecycle
The Database Development Lifecycle course is intended to give you …
What you'll learn
Describe the key points of the waterfall model applied to database development
Discover the roles of various development artefacts, such as the data requirements document, conceptual data model used to communicate between activities in the database development life cycle