VUGRADHUB
← Back to CS511

Laravel - Raw SQL | Web Engineering | CS511_Topic168

CS511 — Web Engineering

Open on YouTube

Other Lectures

Introduction to Web Engineering | Web Engineering | CS511_Topic001Ecosystem of Web | Web Engineering | CS511_Topic002Static vs Dynamic Websites | Web Engineering | CS511_Topic003Static vs Dynamic Website | Web Engineering | CS511_Topic004Client Server Model | Web Engineering | CS511_Topic005How Internet Works | Web Engineering | CS511_Topic006Web Development Jobs | Web Engineering | CS511_Topic007Internet Protocols | Web Engineering | CS511_Topic008Domain Name System | Web Engineering | CS511_Topic009Uniform Resource Locators | Web Engineering | CS511_Topic010Hypertext Transfer Protocol | Web Engineering | CS511_Topic011How a web browser works? | Web Engineering | CS511_Topic012Introduction to web servers | Web Engineering | CS511_Topic013Architecture of web-based system | Web Engineering | CS511_Topic014Introduction to HTML | Web Engineering | CS511_Topic015Common HTML Tags | Web Engineering | CS511_Topic016Links | Web Engineering | CS511_Topic017Lists | Web Engineering | CS511_Topic018Semantics in HTML 5 | Web Engineering | CS511_Topic019Tools Insight | Web Engineering | CS511_Topic020Introduction to CSS | Web Engineering | CS511_Topic021CSS Syntax (Properties) | Web Engineering | CS511_Topic022CSS Syntax (Values) | Web Engineering | CS511_Topic023Location of styles | Web Engineering | CS511_Topic024CSS selectors (Element, Class, ID) | Web Engineering | CS511_Topic025CSS Selectors (Attribute) | Web Engineering | CS511_Topic026CSS Selectors (Pseudo) | Web Engineering | CS511_Topic027CSS selectors (Contextual) | Web Engineering | CS511_Topic028CSS cascading | Web Engineering | CS511_Topic029The Box Model (1) | Web Engineering | CS511_Topic030The Box Model (2) | Web Engineering | CS511_Topic031CSS Text Styling | Web Engineering | CS511_Topic032Introducing Tables | Web Engineering | CS511_Topic033Introducing Tables (2) | Web Engineering | CS511_Topic034Styling table using CSS; Making tables accessible using CSS | Web Engineering | CS511_Topic035Introducing Forms | Web Engineering | CS511_Topic036Form control elements 1 | Web Engineering | CS511_Topic037Form control elements 2 | Web Engineering | CS511_Topic038Microformats | Web Engineering | CS511_Topic039Image formats for the web | Web Engineering | CS511_Topic040Understanding normal document flow | Web Engineering | CS511_Topic041Positioning elements (Relative, absolute, fixed) | Web Engineering | CS511_Topic042Absolute positioning | Web Engineering | CS511_Topic043z-index | Web Engineering | CS511_Topic044Fixed positioning | Web Engineering | CS511_Topic045Floating elements (1) | Web Engineering | CS511_Topic046Floating elements (2) | Web Engineering | CS511_Topic047Multi-column layouts using floats | Web Engineering | CS511_Topic048Multi-column layouts using flexbox | Web Engineering | CS511_Topic049Approaches to CSS layout (Fixed and liquid) | Web Engineering | CS511_Topic050Introduction to responsive design | Web Engineering | CS511_Topic051Responsive design Viewports | Web Engineering | CS511_Topic052Responsive design Media queries | Web Engineering | CS511_Topic053Scaling images for liquid layouts | Web Engineering | CS511_Topic054CSS Frameworks and Preprocessors | Web Engineering | CS511_Topic055Installing Bootstrap | Web Engineering | CS511_Topic056Grid layout of bootstrap| Web Engineering | CS511_Topic057Typography in bootstrap | Web Engineering | CS511_Topic058Colors in bootstrap | Web Engineering | CS511_Topic059Navigation in bootstrap | Web Engineering | CS511_Topic060Introduction to Javascript | Web Engineering | CS511_Topic061Writing and storing the script | Web Engineering | CS511_Topic062Variables and data types in Javascript | Web Engineering | CS511_Topic063Javascript output | Web Engineering | CS511_Topic064Conditions in Javascript | Web Engineering | CS511_Topic065Conditions in Javascript | Web Engineering | CS511_Topic066Loops in Javascript | Web Engineering | CS511_Topic067Objects in Javascript | Web Engineering | CS511_Topic068Functions in Javascript | Web Engineering | CS511_Topic069Functions - Nested | Web Engineering | CS511_Topic070Functions - Callback | Web Engineering | CS511_Topic071Functions - Objects | Web Engineering | CS511_Topic072Functions - Scope | Web Engineering | _Topic073Exception handling using Try and Catch | Web Engineering | CS511_Topic074Javascript built in Objects (Date Math Navigator String, & etc) | Web Engineering | CS511_Topic075Object prototypes; Prototypes for extending objects | Web Engineering | CS511_Topic076Introduction to the Document Object Model (DOM) | Web Engineering | CS511_Topic077Accessing DOM Elements | Web Engineering | CS511_Topic078Modifying DOM elements | Web Engineering | CS511_Topic079Creating DOM elements | Web Engineering | CS511_Topic080Event handling | Web Engineering | CS511_Topic081Capturing and Bubbling | Web Engineering | CS511_Topic082Event Types | Web Engineering | CS511_Topic083Form Validation; Client side input validation | Web Engineering | CS511_Topic084Introduction to jQuery | Web Engineering | CS511_Topic085Introduction to jquery | Web Engineering | CS511_Topic086jQuery Manipulators | Web Engineering | CS511_Topic087jQuery Manipulators - Example | Web Engineering | CS511_Topic088Events in jQuery | Web Engineering | CS511_Topic089DOM manipulation using jQuery | Web Engineering | CS511_Topic090Animations using jQuery | Web Engineering | CS511_Topic091Introduction to Ajax | Web Engineering | CS511_Topic092Asynchronous file transmission | Web Engineering | CS511_Topic093Introduction to server side development | Web Engineering | CS511_Topic094Installation of Apache webserver PHP & MySQL local developments | Web Engineering | CS511_Topic095Introduction to PHP | Web Engineering | CS511_Topic096Introduction to PHP (String Concatenation) | Web Engineering | CS511_Topic097Program Control - Conditional Program Statements | Web Engineering | CS511_Topic098Program Control - Loopss | Web Engineering | CS511_Topic099Functions in PHP (1) | Web Engineering | CS511_Topic100Functions in PHP (2) | Web Engineering | CS511_Topic101Arrays in PHP | Web Engineering | CS511_Topic102Sorting arrays | Web Engineering | CS511_Topic103Arrays - Super Globals | Web Engineering | CS511_Topic104$_GET and $_POST arrays | Web Engineering | CS511_Topic105$_GET and $_POST arrays - Example | Web Engineering | CS511_Topic106$_SERVER array | Web Engineering | CS511_Topic107$_FILES array | Web Engineering | CS511_Topic108Reading and writing files | Web Engineering | CS511_Topic109Classes and Objects in PHP; Object properties | Web Engineering | CS511_Topic110Constructor; Methods | Web Engineering | CS511_Topic111Visibility | Web Engineering | CS511_Topic112Static members; Constants | Web Engineering | CS511_Topic113Databases and Web Development | Web Engineering | CS511_Topic114SQL - Select, Insert, Update, Delete | Web Engineering | CS511_Topic115Introduction to MySQL | Web Engineering | CS511_Topic116phpMyAdmin | Web Engineering | CS511_Topic117Accessing MySQL in PHP | Web Engineering | CS511_Topic118Fetching data | Web Engineering | CS511_Topic119Performing transactions | Web Engineering | CS511_Topic120Example: database creation | Web Engineering | CS511_Topic121Example: database insertion | Web Engineering | CS511_Topic122Example: database search | Web Engineering | CS511_Topic123Example: database update | Web Engineering | CS511_Topic124Error handling in PHP; Types of errors | Web Engineering | CS511_Topic125PHP Error Reporting | Web Engineering | CS511_Topic126PHP Error and Exception handling | Web Engineering | CS511_Topic127Regular Expressions | Web Engineering | CS511_Topic128Regular Expressions - Examples | Web Engineering | CS511_Topic129PHP Filters | Web Engineering | CS511_Topic130Validating user input | Web Engineering | CS511_Topic131Where to perform validation | Web Engineering | CS511_Topic132The problem of state management; State management on server side | Web Engineering | CS511_Topic133State management using query string | Web Engineering | CS511_Topic134Cookies | Web Engineering | CS511_Topic135Cookies Example | Web Engineering | CS511_Topic136Serialization | Web Engineering | CS511_Topic137Session state; using sessions | Web Engineering | CS511_Topic138Session state; using sessions Using Session - Example | Web Engineering | CS511_Topic139HTML5 web storage | Web Engineering | CS511_Topic140Caching | Web Engineering | CS511_Topic141PHP with AJAX | Web Engineering | CS511_Topic142PHP with AJAX case study (e.g., Live search) | Web Engineering | CS511_Topic143Web Application Design - Layering | Web Engineering | CS511_Topic144Web Application Design - 3-Layer Model | Web Engineering | CS511_Topic145Software Design Patterns Adapter pattern; Simple Factory Pattern | Web Engineering | CS511_Topic146Template method and dependency injection patterns | Web Engineering | CS511_Topic147Data and Domain Patterns - Table Data Gateway, domain model | Web Engineering | CS511_Topic148Presentation Patterns - MVC and Front Controller patterns | Web Engineering | CS511_Topic149Designing and Implementing an MVC based Website | Web Engineering | CS511_Topic150Laravel - Introduction | Web Engineering | CS511_Topic151Laravel - Installation | Web Engineering | CS511_Topic152Laravel - Introduction to Routes | Web Engineering | CS511_Topic153Laravel - Routes with variables | Web Engineering | CS511_Topic154Laravel - Views | Web Engineering | CS511_Topic155Laravel - Controllers | Web Engineering | CS511_Topic156Laravel - Controller with CRUD Operations | Web Engineering | CS511_Topic157Laravel - Redirects | Web Engineering | CS511_Topic158Laravel - Blade Templates | Web Engineering | CS511_Topic159Laravel - Conditions in Blade | Web Engineering | CS511_Topic160Laravel - Loops in Blade | Web Engineering | CS511_Topic161Laravel - Parent Template | Web Engineering | CS511_Topic162Laravel - Child Template | Web Engineering | CS511_Topic163Laravel - Working with Databases | Web Engineering | CS511_Topic164Laravel - Creating a Table | Web Engineering | CS511_Topic165Laravel - Running a Migration | Web Engineering | CS511_Topic166Laravel - Adding a Foreign Key | Web Engineering | CS511_Topic167Laravel - View with Data | Web Engineering | CS511_Topic169Laravel - Query Builder | Web Engineering | CS511_Topic170Laravel - Eloquent | Web Engineering | CS511_Topic171Laravel - Eloquent (Getting Data) | Web Engineering | CS511_Topic172Laravel - Eloquent (Viewing Data) | Web Engineering | CS511_Topic173Laravel - Eloquent (Relations) | Web Engineering | CS511_Topic174Laravel - Form Request (Create) | Web Engineering | CS511_Topic175Laravel - Form Request (Update) | Web Engineering | CS511_Topic176Laravel - Form Request (Delete) | Web Engineering | CS511_Topic177Laravel - CRUD Operations | Web Engineering | CS511_Topic178Security Principles | Web Engineering | CS511_Topic179Security by design | Web Engineering | CS511_Topic180Authentication; Authentication factors; HTTP authentication; | Web Engineering | CS511_Topic181Cryptography; Cyphers Public Key Cryptography; Digital Signatures | Web Engineering | CS511_Topic182HTTPS; Secure handshakes; Certificates; From HTTP to HTTPS | Web Engineering | CS511_Topic183Security Best Practices; Monitoring web systems; Auditing | Web Engineering | CS511_Topic184Common threats vector; Brute force attacks; SQL injection; XSS; | Web Engineering | CS511_Topic185XML overview; XML parser; XML DOM; XML validation; XML DTD; | Web Engineering | CS511_Topic186XSLT and XPath | Web Engineering | CS511_Topic187XML processing; XML in JavaScript; XML in PHP; PHP XML parser | Web Engineering | CS511_Topic188JSON; JSON in JavaScript; JSON in PHP | Web Engineering | CS511_Topic189Overview of web services; SOAP based web services | Web Engineering | CS511_Topic190Consuming Web services in PHP; Consuming XML based web service | Web Engineering | CS511_Topic191Creating a web service in PHP; Working an XML-based web services| Web Engineering | CS511_Topic192Web services using AJAX; Using Google MAPS web service | Web Engineering | CS511_Topic193JavaScript Frameworks; Front-end and back-end frameworks | Web Engineering | CS511_Topic194Node.js; Introduction to Node.js; Architecture of Node| Web Engineering | CS511_Topic195Simple Node.js program; Node Package Manager (NPM) | Web Engineering | CS511_Topic196Express.js; Routing in express | Web Engineering | CS511_Topic197MySQL with Node.js| Web Engineering | CS511_Topic198Introduction to Angular; Single Page Applications; | CS511_Topic199Introduction to web sockets; Web sockets on server side | Web Engineering | CS511_Topic200Web server hosting | Web Engineering | CS511_Topic201Web server hosting - Demo | Web Engineering | CS511_Topic202Domain and name server administration | Web Engineering | CS511_Topic203Search Engines; Before search engines; Search Engine Overview | Web Engineering | CS511_Topic204Search Engines; Before search engines; Search Engine Overview | Web Engineering | CS511_Topic205Search Engine Optimization; | Web Engineering | CS511_Topic206Understanding bad SEO; Content spamming; Link spamming; | Web Engineering | CS511_Topic207Introduction to online social networks; Social media presence| Web Engineering | CS511_Topic208Monetization with ads How web ads work?; Ad networks Creating ads | Web Engineering | CS511_Topic209Web analytics Web metrics Internal analytics Third party analytic | Web Engineering | CS511_Topic210Google analytics; Google analytics dashboard | Web Engineering | CS511_Topic211

Handouts

cs511 handouts clearDownload