☰
DEVELOPMENT
DEVELOPMENT Courses
-
14 Classes
-
129 Minutes
-
2 Students
A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.
- 499.00₹
2000.00₹
What learn
- • How to login in SQL Server • Introduction to Database • Difference between frontend software and backend software •...
- • Use of SQL • Data base in SQL • Tables in SQL Data base • Data Field • Data Record • Types of SQL • DML (Data Ma...
- • Different types of DDL • Use of DDL
- • Syntax of Create table query • Create table example "ALTER TABLE QUERY" • Syntax of Alter table query • Alter ta...
- • Different types of DML • "INSERT QUERY11,Syntax of Insert query • Working example of insert query • Insert values f...
- • Use of Update Query • Syntax of Update Query • Working Example of Update query • "DELETE QUERY" • Syntax of De...
- • Order by Clause • Syntax of Order by • Working Example of Order by AND---OR" • Use of "AND---OR" • Combine wher...
- • Use of "IN" • Operator in select query • Syntax of "IN" Operator • Working Example of "IN" Operator "BETWEEN -AN...
- • Use of "UNION" • Combine select query by using "UNION" • Syntax of "UNION" • Working Example of "UNION" • "INTERSE...
- • Syntax of Built in Functions • Different types built in Functions • Examples of Built in functions • "SELECT INTO Q...
- • How to join more than one table • Use of keys in SQL, Primary Key • Introduction to Primary Key • Syntax to create...
- • Use of "INDEX" • Advantages of Index • Syntax to create an Index • Syntax to Drop an Index Working Example to crea...
- • How to create a virtual copy of table • Use of "VIEW" • Syntax to create "VIEW" • Sub quires • Working example of...
- • How to create procedures • Advantages of Procedures • Syntax to create procedures • Calling Procedures • Declaring...
-
18 Classes
-
235 Minutes
-
1 Students
Want to learn how to program with VB.NET? This beginners guide to programming in Visual Basic.NET will show you how.
- 499.00₹
2000.00₹
What learn
- • Introduction to VB.Net • How to open VB.Net • How to create a new window application • Introduction to IDE • Intro...
- • Control adding Items to list box • How to remove Items from list box • VB.Net program to add textbox contents to l...
- • If statement • If...else statement • Program to find largest number • Program to check whether a • Given number is...
- • While loop • Working of while loop statements • Program to display numbers completely • divisible by 7 by using wh...
- • Syntax of user defined functions • Call user defined subprograms • Parameterized functions • Return statements • P...
- • Message box result variable • Syntax of message box input box • Syntax of input box • Program to find addition of...
- • Create our own menus in VB.Net application • Program for mathematical operations by using menus • Context Menu • H...
- • Properties of picture box • Introduction to tab window • How to create a tab dialog • Introduction to MDI (Multiple...
- • Introduction to multitasking • Resume, start, stop and • pause functions in thread. • Syntax to assign threads in p...
- • Control rich textbox • Program to create a notepad by using rich textbox
- • HTML help workshop • Creating contents in help • Creating Index in help • Attaching help to VB.Net application
- • Creating class property • Get and set property • Creating objects of property • Assign values to property members...
- • Introduction to windows control library • Creating user controls • Adding controls to tool box • Program to create...
- • Introduction to backend soft wares • Creating connection between VB.Net • and Access software Query settings in VB....
- • Program to update salary of an employee • Searching a particular record by using loop
- • Delete a particular employee record • Searching and delete record
- • Pay roll
- • File setup • Creating shortcuts of VB.Net application