Showing posts with the label Free Udemy Course - SQL

Learn HTML5 Programming By Building Projects

Learn HTML5 Programming By Building Projects About this Course In order to master a technique in web development or any artistic field, the best approach is one that's hands-on. This allows you to not only learn concepts, but also apply them right away to build your own projects from scratch. That's why this course guides you through the process of actually creating a variety of games, apps, and sites using HTML5 and JavaScript. Master HTML5 and JavaScript, starting with the creation of 10 apps and games. •  HTML5 and JavaScript, Including Semantic Markup and Boilerplate Framework •  CSS3 Media Queries and Responsive Design •  JQuery, Fancybox, APIs, and More •  10 Hands-On Projects, Including Games and Apps Use HTML5 and JavaScript to Create a Variety of Projects Not all sites and apps use HTML5 yet, but the ones that do are advanced and cutting edge, and this is the way of the future in web design and app development. Using HTML5, CSS3, JavaScript, and other tools

Mastering SQL Server | Passage to become Database Developer

Mastering SQL Server | Passage to become Database Developer What you'll learn Introduction to Database Management System (DBMS) Microsoft SQL Server development and administration Installation Guide of Microsoft SQL Server How to Create database How to create and modify tables Primary Key Foreign Key Composite Key How to drop a Table Insert data into table Select data from a table Update/modify existing data of a table Delete data from a table Substring function Group By Clause Average function Inner join Left join Right join Full join Distinct function Database Views Stored procedures How to execute the stored procedure SQL jobs How to use Like Operator Taking Database Backup Restoring the database backup Show less Requirements Student must be aware of basic database concepts. must have a computer where Microsoft SQL Server could be installed Description This Course is designed for those students who want to get detailed knowledge of  Microsoft SQL Server  in short tim