Oracle Training In Lucknow

Registration Started
Enquiry Now
+91 9198483820
+91 8081347355
+91 8081329320
+91 7525953975
+91 6394296293
+91 8787291185
0522-4235604

About Our Oracle Training

TheDigiCoders Technologies Pvt Limited is now the largest Software Development Training CompanyOracle Corporation, formerly Software Development Laboratories (1977–79), Relational Software Inc. (1979–82), and Oracle Systems Corporation (1982–95), global corporation and brand that develops and markets computer software applications for business. latest technologies.The company, initially called Software Development Laboratories, was founded in 1977 by Larry Ellison and Bob Miner, computer programmers at the American electronics company Ampex Corporation, and by Ed Oates, Ellison’s supervisor at Ampex. Inspired by a research paper written by British-born computer scientist Edgar F. Codd that outlined a relational database model, Ellison and his colleagues saw commercial potential in the approach, which organized large amounts of data in a way that allowed for efficient storage and quick retrieval. The trio set to work developing and marketing a program based on Codd’s data management theory. In 1979 the company released Oracle, the earliest commercial relational database program to use Structured Query Language (SQL), and it quickly became popular. Its first customer was the U.S. Air Force, which used the program at Wright-Patterson Air Force Base, near Dayton, OhioKnown for innovation and aggressive marketing, the company, renamed Oracle in 1982 after its flagship product, grew rapidly throughout the 1980s, going public in 1986. In 1987 Oracle became the largest database management company in the world. Although Oracle’s eponymous database has steadily increased in popularity, much of the company’s growth has come through its aggressive acquisitions of software companies with products for a range of business and technology applications. In its history Oracle lays claim to buying scores of companies, including high-profile multibillion-dollar purchases of PeopleSoft (2005), Siebel (2006), BEA (2008), Sun Microsystems (2010), and NetSuite (2016) live projects in training.

Disappointing earnings in the early 1990s led to a period of restructuring, and the company faced increasing competition in the database technology market. The company also stumbled in the mid-1990s with its investment in and vocal support for the Network Computer (NC). The NC was not as fully equipped as a standard personal computer and relied on computer servers for its data and software. Ellison, now Oracle’s chief executiveOracle training in Lucknow

officer (CEO), and partners such as Sun Microsystems’ Scott McNealy bet that business users of computers would adopt NCs, which would slow the growth and influence of archcompetitor Microsoft Corporation. That ploy failed, and personal computers running the Microsoft Windows operating system continued to dominate business users’ desktops.officer (CEO), and partners such as Sun Microsystems’ Scott McNealy bet that business users of computers would adopt NCs, which would slow the growth and influence of archcompetitor Microsoft Corporation. That ploy failed, and personal computers running the Microsoft Windows operating system continued to dominate business users’ desktops.
Oracle remained a leader in database technology, with versions available for many different operating systems and for a variety of computers ranging from large mainframes to microcomputers. With the purchase of Sun Microsystems, Oracle acquired not only the computer programming language Java and the operating system Solaris but also the popular open-source database MySQL, which Sun had acquired in 2008 for $1 billion. The European Union, before it approved the purchase in January 2010, required assurances from Oracle that it would continue to develop and support MySQL. Later that year, Oracle filed a multibillion-dollar lawsuit against Google, Inc., alleging that Google had illegally used elements of Java in its development of the Android operating system for mobile phones. After years of litigation and a remanded trial, a jury found in 2016 that Google had not violated Oracle’s copyrights.
out of that research came SQL. The late 1970s and early ’80s saw the release of a number of SQL-based products. SQL gained popularity when the American National Standards Institute (ANSI) adopted the first SQL standard in 1986. Continued work on relational databases led to improvements in SQL, making it one of the most popular database languages in existence. Some large software companies, such as Microsoft Corporation and Oracle Corporation, produced their own versions of SQL, and an open-source version, MySQL, became extremely popular.
SQL works by providing a way for programmers and other computer users to get desired information from a database using something resembling normal English. On the simplest level, SQL consists of only a few commands: Select, which grabs data; Insert, which adds data to a database; Update, which changes information; and Delete, which deletes information. Other commands exist to create, modify, and administer databases.

Register Now
Enquiry Now
+91 9198483820
+91 8081347355
+91 8081329320
+91 7525953975
+91 6394296293
+91 8787291185
0522-4235604
Course Description

This training is important as it ensures that equal amount of time is given in learning the theoretical concepts and matching it with the industry requirements in terms of practical skills. It fosters an individual to face the challenges of the corporate world. Summer Training Program imparts necessary skills to its participants which are needed to survive in this competitive industry. It also makes ensure that students gain skill and competencies which are required to survive in the industry. Students also get chance to work on the live project depending upon the technology they select as well as personality development.

Certification

After successfully complete training we have provide the certificate to students.

Learning Outcomes
  • Over 45 lectures of training content!
  • LIVE PROJECT End to End Software Testing Training Included.
  • Learn Software Testing and Automation basics from a professional trainer from your own desk.
  • Information packed practical training starting from basics to advanced testing techniques.
  • Best suitable for beginners to advanced level users and who learn faster when demonstrated.
  • Course content designed by considering current software testing technology and the job market.
  • Practical assignments at the end of every session.
  • Practical learning experience with live project work and examples.cv
  • summers training
  • summers training
  • summers training
  • summers training
  • summers training
  • summers training
  • summers training
  • summers training

Android Curriculum

Foundation of ‘C’
L.N. Contents Hours
1
  1. Introduction to Programming
  2. Translator
  3. Introduction of ‘C’
  4. History of ‘C’
  5. C tokens
    1. Keywords
    2. Identifiers
    3. Variables/Constant
    4. Data types
    5. Operators
    6. Function
    7. Header Files
 2
2.
  1. Decision making statements
    1. If
      1. Simple if
      2. Else if
      3. Nested if
      4. Else if ladder
    2. Switch case
    3. Goto
  2. Looping statements / Iterative statements
    1. While loop
    2. For loop
    3. Do while loop
 2
3.
  1. Array
    1. Single Dimensional Arrays
    2. Double Dimensional Arrays
  2. String
    1. String Handling
    2. String Function
 2
4.
  1. Function
    1. Built in/Library Functions
    2. User Define Functions
      1. Declaring a function
      2. Defining a function
        1. No Return, No Parameter
        2. Return, No Parameter
        3. No Return, Parameter
        4. Return, Parameter
      3. Calling a function
 2
5.
  1. Recursion
  2. Type Casting
  3. Scope of variable
    1. Local variable
    2. Global variable
  4. Storage Classes
    1. Automatic
    2. Register
    3. Static
    4. External
 2
6.
  1. Preprocessors
    1. File inclusion (#include)
    2. Macro Expansion (#define)
  2. Header files
    1. Built in/Library header Files
    2. User Define header file
      1. Creating user define header file
      2. Using user define header file
 2
7.
  1. Problem Solving & Recovery Session
  2. Test
 2
Foundation of ‘Core Java’
L.N. Content Hours
8
  1. Introduction of Java
  2. History of Java
  3. Introduction of JVM
  4. Environment Setup for Java in Windows OS
  5. Basic Syntax of Java Programming Language
  6. Run First Java Program
  7. Java Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
  8. Introduction of OOPs
  9. Basic Concept of OPPs with its Properties
  10. Java Input/Outputs
 2
9
  1. Decision Making Statements
    1. If Statement
    2. If…Else Statement
    3. If…Else...If…Else Statement
    4. Nested if Else Statement
    5. Switch Statement
    6. Ternary Operator (Condition?True:False)
  2. Looping Statement
    1. While Loop
    2. For Loop
    3. Do While Loop
    4. Break Statement
    5. Continue Statement
  3. Type Conversion
 2
10
  1. Arrays
    1. Single Dimensional Array
    2. Double Dimensional Array
  2. For each loop
  3. String
  4. Object
  5. Classes
  6. Constructor
  7. Member Variables
  8. Member Functions
  9. Create Instance/Object of Class
  10. User Class Members
11
  1. Modifiers
    1. Access Modifiers
      1. Public
      2. Private
      3. Protected
    2. Static
    3. Final
    4. Abstract
  2. This Keywords
  3. Polymorphism
    1. Method Overloading
    2. Method Overriding
 2
12
  1. Inheritance
    1. Type of Inheritance
    2. Extend keyword
2
Foundation of ‘Android’
L.N. Content Hours
13
  1. Introduction of Mobile Application
  2. Introduction Of Android OS
  3. Installation of Android Studio
  4. Overview of Android Studio
  5. Creating First Project in Android Studio
  6. What is Android?
  7. History of Android and its Versions
  8. Hello Android App
14
  1. Android Application Architecture
  2. Application Components
  3. Resources
  4. Activities
  5. Services
  6. Broadcast Receivers
  7. Content Providers
 2
15
  1. Fragment
  2. Intents & Filters
  3. Android Layouts
  4. Creating Layouts
  5. Views
  6. View holders
  7. UI Elements
2
16
  1. Relative Layout
  2. Linear Layouts
  3. Coordinator Layout
  4. Table Layout
  5. Constraint Layout
 2
17
  1. TextView
  2. EditText
  3. Spinner
  4. RadioButton
  5. CheckBox
  6. Button
 2
18
  1. ImageView
  2. ToggleButton
  3. Switch
  4. View
  5. CalendarView
  6. ProgressBar
 2
19
  1. Seekbar
  2. RatingBar
  3. ScrollView
  4. NestedScrollView
 2
20
  1. CardView
  2. RecyclerView
  3. ListView
  4. AppBarLayout
 2
21
  1. WebView
  2. Video
  3. Audio
 2
22
  1. Tab Layout
 2
23
  1. NavigationDrawer
24
  1. Bottom Navigation
 2
25
  1. Context Menu
  2. Search View
 2
26
  1. Design Form
  2. SQLite Database Connectivity
  3. Database Insert Operation
27
  1. Database Select Operation
  2. Show Data in Recycler View
 2
28
  1. Database Update Operation
  2. Database Delete Operation
 2
29
  1. Networking Class (Volley/Retrofit)
  2. Sample API Calling
 2
30
  1. Get and Set data from API
  2. JSON Parsing
  3. Glide
 2
31
  1. Slider
  2. Card Scrolling View
  3. Share App Module
 2
32
  1. Login
  2. Registration
2
33
  1. OTP Validation
 2
34
  1. Location
  2. Google Map
 2
35
  1. Get Data from API
  2. Post Data to API
  3. API Example App
2
36
  1. Problem Solving & Recovery Class
  2. Test
  3. Project Allotment
  4. Divide Team & Project Coordinators
 2
37-44
  1. Project Development (Complete All Project Modules)
 2
45
  1. Project Testing & Submission
 2

ASP.Net Curriculum

Foundation of ‘C’
L.N. Contents Hours
1
  1. Introduction to Programming
  2. Translator
  3. Introduction of ‘C’
  4. History of ‘C’
  5. C tokens
    1. Keywords
    2. Identifiers
    3. Variables/Constant
    4. Data types
    5. Operators
    6. Function
    7. Header Files
 2
2.
  1. Decision making statements
    1. If
      1. Simple if
      2. Else if
      3. Nested if
      4. Else if ladder
    2. Switch case
    3. Goto
  2. Looping statements / Iterative statements
    1. While loop
    2. For loop
    3. Do while loop
 2
3.
  1. Array
    1. Single Dimensional Arrays
    2. Double Dimensional Arrays
  2. String
    1. String Handling
    2. String Function
 2
4.
  1. Function
    1. Built in/Library Functions
    2. User Define Functions
      1. Declaring a function
      2. Defining a function
        1. No Return, No Parameter
        2. Return, No Parameter
        3. No Return, Parameter
        4. Return, Parameter
      3. Calling a function
 2
5.
  1. Recursion
  2. Type Casting
  3. Scope of variable
    1. Local variable
    2. Global variable
  4. Storage Classes
    1. Automatic
    2. Register
    3. Static
    4. External
 2
6.
  1. Preprocessors
    1. File inclusion (#include)
    2. Macro Expansion (#define)
  2. Header files
    1. Built in/Library header Files
    2. User Define header file
      1. Creating user define header file
      2. Using user define header file
 2
7.
  1. Problem Solving & Recovery Session
  2. Test
 2
-->
Foundation of ‘HTML & CSS’
L.N. Contents Hours
8.
  1. Introduction of Web pages
  2. Introduction of Websites
  3. Introduction of Web Browsers
  4. Introduction of HTML
    1. What is Hypertext?
    2. What is Markup language
  5. History of HTML
  6. How to use HTML to create web pages?
  7. What is tag?
  8. What is element?
  9. HTML tag
  10. Head tag
    1. Title tag
    2. Style tag
    3. Script tag
    4. Noscript tag
    5. Link tag
    6. Meta tag
    7. Base tag
  11. Body tag
  12. Attributes
 2
9.
  1. Text Editing tags
    1. H1, h2, h3, h4, h5, h6, p, pre, center, br, hr, b, strong, i, em, u, ins, s, strike, del, sup, sub, big, small
  2. Lists
    1. Ordered List (ol, li)
    2. Unordered list (ul, li)
    3. Definition list (dl, dt, dd)
  3. Table (table, tr, th, td, thead, tbody, tfoot)
  4. Marquee (marquee)
  5. Image (img)
  6. Hyperlink (a)
 2
10.
  1. Form
    1. input (type=text, number, date, email, password, url, range, button, submit, reset, radio, checkbox)
    2. textarea
    3. label
    4. fieldset
    5. legend
    6. select
    7. option
    8. optgroup
    9. button
    10. datalist
11.
  1. div
  2. span
  3. iframe
  4. video
  5. audio
  6. Introduction of CSS
  7. Selectors
  8. Properties & values
  9. Text Styling Properties
    1. Font -family
    2. Font -size
    3. Font -weight
    4. Text -decoration
    5. Text -transform
    6. Color
    7. Line - height
    8. Word -spacing
    9. Text -shadow
    10. Text -align
2
12.
  1. Box Modal Properties
    1. Width
    2. Height
    3. Padding
    4. Margin
    5. Border
    6. Box -shadow
    7. Border -radius
    8. Float
    9. Outline
  2. Background
    1. Background -color
    2. Background -image
    3. Background -repeat
    4. Background -size
    5. Background -position
    6. Background -attachment
    7. Background (rbga)
  3. List (list -style -type, list -style -image
  4. Table (border, border -collapse)
2
13.
  1. Position
  2. Z -index
  3. opacity
  4. Pseudo -classes
    1. Hover
    2. Focus
    3. Active
    4. Visited
    5. Link
    6. Disabled
    7. Enabled
    8. First-child
    9. Last-child
    10. Nth-child (odd,even,2n+1,1)
  5. Designing a simple menu
  6. Designing a menu have sub menu
2
14.
  1. Designing a simple home page of a website
  2. Designing a Registration page of a website
  3. Designing a login page of a website
15.
  1. Problem Solving & Recovery Class
  2. Test
-->
Foundation of ‘JavaScript’
L.N. Contents 2
16.
  1. Introduction of Scripting language
  2. Difference between Client & Server Side Scripting
  3. Introduction of JavaScript
  4. JavaScript Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
    6. Variable declaration
  5. Document object Modal
  6. Write & writeln & message (alert) box
  7. Events
  8. DOM traversing
 2
17.
  1. Conditional Statements (if, else if, nested if, else if ladder)
  2. Looping Statements (while, for, do while)
  3. Arrays
  4. Objects
  5. Functions
  6. Call function on events
18.
  1. Dialog boxes
    1. Alert Box
    2. Confirm Box
    3. Prompt Box
  2. String Functions
  3. Number Functions
  4. Math’s Functions
  5. Date Functions
2
19.
  1. Creating a Simple Slider
  2. Form validation using JavaScript (using regular expression)
 2
20.
  1. Problem Solving & Recovery Class
  2. Test
 2
Foundation of ‘Database’
L.N. Contents Hours
21.
  1. Introduction of database
  2. Introduction of DBMS / RDBMS
  3. Introduction of SQL (Structured Query Language)
  4. Introduction of DDL commands
  5. Introduction of DML commands
  6. Introduction of DCL commands
22.
  1. Create Command
    1. Create Database
    2. Create table
  2. Drop Command
    1. Drop database
    2. Drop table
  3. Truncate Command
    1. Truncate table
  4. Alter Command
    1. Modify table column
    2. Drop Table column
    3. Add new column into table
  5. Insert Command
    1. Insert single record into table
    2. Insert multiple records into table
 2
23.
  1. Select Command
    1. Select all columns from table
    2. Select specific columns from table
    3. Select using where clause
  2. Update Command
    1. Update all records of table
    2. Update single record of table using where clause
  3. Delete Command
    1. Delete all records from table
    2. Delete single multiple records from table using where clause
  4. Keys
    1. Unique Key
    2. Primary Key
    3. Foreign key
  5. Not Null
  6. Default
  7. Auto Increment
 2
24.
  1. AND & OR Operators
  2. Order By (Ascending or Descending Orders)
  3. Top or Limit
  4. Like
  5. Distinct
  6. Between
  7. Joins
    1. Inner join
    2. Left Join
    3. Right Join
    4. Full Join
 2
25.
  1. SQL Aggregate Functions
    1. Avg()
    2. Count()
    3. Min()
    4. Max()
    5. Sum()
    6. Now()
  2. Problem Solving & Recovery Class
  3. Test
Foundation of ‘Core C#’
L.N. Contents Hours
26.
  1. Introduction of C#
  2. History of C#
  3. Environment Setup for Visual Studio
  4. Basic Syntax of C# Programming Language
  5. Run First C# Program
  6. C# Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
  7. Introduction of OOPs
  8. Basic Concept of OPPs with its Properties
  9. C# Input/Outputs
 2
27.
  1. Decision Making Statements
    1. If Statement
    2. If…Else Statement
    3. If…Else...If…Else Statement
    4. Nested if Else Statement
    5. Switch Statement
    6. Ternary Operator (Condition?True:False)
  2. Looping Statement
    1. While Loop
    2. For Loop
    3. Do While Loop
    4. Break Statement
    5. Continue Statement
  3. Type Conversion
 2
28.
  1. Arrays
    1. Single Dimensional Array
    2. Double Dimensional Array
  2. For each loop
  3. String
  4. Object
  5. Classes
  6. Constructor
  7. Member Variables
  8. Member Functions
  9. Create Instance/Object of Class
  10. User Class Members
 2
29.
  1. Modifiers
    1. Access Modifiers
      1. Public
      2. Private
      3. Protected
    2. Static
    3. Final
  2. This Keywords
  3. Polymorphism
    1. Method Overloading
    2. Method Overriding
2
30.
  1. Inheritance
    1. Type of Inheritance
      1. Single Inheritance
      2. Multilevel Inheritance
      3. Hierarchical Inheritance
      4. Multiple Inheritance
      5. Hybrid Inheritance
    2. Extend keyword
2
Foundation of ‘ASP.Net’
L.N. Contents Hours
31.
  1. Introduction of Active Server Pages
  2. Introduction of Server Side Scripting language
  3. Overview of Asp.Net
  4. Installation of Visual Studio and MS SQL Server
  5. Syntax
  6. Input/ Output
  7. Data types
  8. Variables
  9. Constant
 2
32.
  1. ASP.Net Tools
    1. Textbox
    2. Button
    3. Image
    4. Dropdown
    5. Content Place Holder
    6. LinkButton
    7. CheckBoxList
    8. RadioButtonList
    9. Etc
  2. Concept of Master Page
33.
  1. Form Handling
  2. Form Requesting
  3. Form Data Collection
  4. Post and Get Method
  5. Collecting Data from Text Box
  6. Collecting Data from Dropdown List
  7. Collecting Data from Check Box
  8. Collecting Data from Radio Button
 2
34.
  1. Database Connectivity
  2. ADO.Net
  3. SQL Connection
  4. SQL Statement
  5. Database Insert Operation
  6. Database Update Operation
  7. Database Delete Operation
 2
35.
  1. File Uploading with validation
  2. Database Select Operation
  3. Data Edit and Update
2
36.
  1. User Registration
  2. Save user registration data into MSSQL database
  3. Show registered users data
  4. Delete registered users
  5. Edit registered users
 2
37.
  1. User Login
  2. Cookies
  3. Sessions
 2
38.
  1. Date & Time
  2. ASP.Net AJAX
  3. Server Side Form Validation
  4. User Authentication (Login and Logout)
39.
  1. Problem Solving & Recovery Class
  2. Test
  3. Project Allotment
  4. Divide Team & Project Coordinators
 2
40-44
  1. Project Development (Complete All Project Modules)
45.
  1. Project Testing & Submission

PHP Curriculum

Foundation of ‘C’
L.N. Contents Hours
1
  1. Introduction to Programming
  2. Translator
  3. Introduction of ‘C’
  4. History of ‘C’
  5. C tokens
    1. Keywords
    2. Identifiers
    3. Variables/Constant
    4. Data types
    5. Operators
    6. Function
    7. Header Files
 2
2.
  1. Decision making statements
    1. If
      1. Simple if
      2. Else if
      3. Nested if
      4. Else if ladder
    2. Switch case
    3. Goto
  2. Looping statements / Iterative statements
    1. While loop
    2. For loop
    3. Do while loop
 2
3.
  1. Array
    1. Single Dimensional Arrays
    2. Double Dimensional Arrays
  2. String
    1. String Handling
    2. String Function
 2
4.
  1. Function
    1. Built in/Library Functions
    2. User Define Functions
      1. Declaring a function
      2. Defining a function
        1. No Return, No Parameter
        2. Return, No Parameter
        3. No Return, Parameter
        4. Return, Parameter
      3. Calling a function
 2
5.
  1. Recursion
  2. Type Casting
  3. Scope of variable
    1. Local variable
    2. Global variable
  4. Storage Classes
    1. Automatic
    2. Register
    3. Static
    4. External
 2
6.
  1. Preprocessors
    1. File inclusion (#include)
    2. Macro Expansion (#define)
  2. Header files
    1. Built in/Library header Files
    2. User Define header file
      1. Creating user define header file
      2. Using user define header file
 2
7.
  1. Problem Solving & Recovery Session
  2. Test
 2
Foundation of ‘HTML & CSS’
L.N. Contents Hours
8.
  1. Introduction of Web pages
  2. Introduction of Websites
  3. Introduction of Web Browsers
  4. Introduction of HTML
    1. What is Hypertext?
    2. What is Markup language
  5. History of HTML
  6. How to use HTML to create web pages?
  7. What is tag?
  8. What is element?
  9. HTML tag
  10. Head tag
    1. Title tag
    2. Style tag
    3. Script tag
    4. Noscript tag
    5. Link tag
    6. Meta tag
    7. Base tag
  11. Body tag
  12. Attributes
 2
9.
  1. Text Editing tags
    1. H1, h2, h3, h4, h5, h6, p, pre, center, br, hr, b, strong, i, em, u, ins, s, strike, del, sup, sub, big, small
  2. Lists
    1. Ordered List (ol, li)
    2. Unordered list (ul, li)
    3. Definition list (dl, dt, dd)
  3. Table (table, tr, th, td, thead, tbody, tfoot)
  4. Marquee (marquee)
  5. Image (img)
  6. Hyperlink (a)
 2
10.
  1. Form
    1. input (type=text, number, date, email, password, url, range, button, submit, reset, radio, checkbox)
    2. textarea
    3. label
    4. fieldset
    5. legend
    6. select
    7. option
    8. optgroup
    9. button
    10. datalist
11.
  1. div
  2. span
  3. iframe
  4. video
  5. audio
  6. Introduction of CSS
  7. Selectors
  8. Properties & values
  9. Text Styling Properties
    1. Font -family
    2. Font -size
    3. Font -weight
    4. Text -decoration
    5. Text -transform
    6. Color
    7. Line - height
    8. Word -spacing
    9. Text -shadow
    10. Text -align
2
12.
  1. Box Modal Properties
    1. Width
    2. Height
    3. Padding
    4. Margin
    5. Border
    6. Box -shadow
    7. Border -radius
    8. Float
    9. Outline
  2. Background
    1. Background -color
    2. Background -image
    3. Background -repeat
    4. Background -size
    5. Background -position
    6. Background -attachment
    7. Background (rbga)
  3. List (list -style -type, list -style -image
  4. Table (border, border -collapse)
2
13.
  1. Position
  2. Z -index
  3. opacity
  4. Pseudo -classes
    1. Hover
    2. Focus
    3. Active
    4. Visited
    5. Link
    6. Disabled
    7. Enabled
    8. First-child
    9. Last-child
    10. Nth-child (odd,even,2n+1,1)
  5. Designing a simple menu
  6. Designing a menu have sub menu
2
14.
  1. Designing a simple home page of a website
  2. Designing a Registration page of a website
  3. Designing a login page of a website
15.
  1. Problem Solving & Recovery Class
  2. Test
Foundation of ‘JavaScript’
L.N. Contents Hours
16.
  1. Introduction of Scripting language
  2. Difference between Client & Server Side Scripting
  3. Introduction of JavaScript
  4. JavaScript Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
    6. Variable declaration
  5. Document object Modal
  6. Write & writeln & message (alert) box
  7. Events
  8. DOM traversing
 2
17.
  1. Conditional Statements (if, else if, nested if, else if ladder)
  2. Looping Statements (while, for, do while)
  3. Arrays
  4. Objects
  5. Functions
  6. Call function on events
18.
  1. Dialog boxes
    1. Alert Box
    2. Confirm Box
    3. Prompt Box
  2. String Functions
  3. Number Functions
  4. Math’s Functions
  5. Date Functions
2
19.
  1. Creating a Simple Slider
  2. Form validation using JavaScript (using regular expression)
 2
20.
  1. Problem Solving & Recovery Class
  2. Test
 2
Foundation of ‘Database’
L.N. Contents Hours
21.
  1. Introduction of database
  2. Introduction of DBMS / RDBMS
  3. Introduction of SQL (Structured Query Language)
  4. Introduction of DDL commands
  5. Introduction of DML commands
  6. Introduction of DCL commands
22.
  1. Create Command
    1. Create Database
    2. Create table
  2. Drop Command
    1. Drop database
    2. Drop table
  3. Truncate Command
    1. Truncate table
  4. Alter Command
    1. Modify table column
    2. Drop Table column
    3. Add new column into table
  5. Insert Command
    1. Insert single record into table
    2. Insert multiple records into table
 2
23.
  1. Select Command
    1. Select all columns from table
    2. Select specific columns from table
    3. Select using where clause
  2. Update Command
    1. Update all records of table
    2. Update single record of table using where clause
  3. Delete Command
    1. Delete all records from table
    2. Delete single multiple records from table using where clause
  4. Keys
    1. Unique Key
    2. Primary Key
    3. Foreign key
  5. Not Null
  6. Default
  7. Auto Increment
 2
24.
  1. AND & OR Operators
  2. Order By (Ascending or Descending Orders)
  3. Top or Limit
  4. Like
  5. Distinct
  6. Between
  7. Joins
    1. Inner join
    2. Left Join
    3. Right Join
    4. Full Join
 2
25.
  1. SQL Aggregate Functions
    1. Avg()
    2. Count()
    3. Min()
    4. Max()
    5. Sum()
    6. Now()
  2. Problem Solving & Recovery Class
  3. Test
 2
Foundation of ‘PHP’
L.N. Content Hours
26
  1. Introduction of Scripting language
  2. Introduction of Server Side Scripting language
  3. Introduction of PHP
  4. Overview of PHP
  5. Installation of PHP
  6. Syntax
  7. Echo / Print
  8. Data types
  9. Variables
  10. Constant
 2
27
  1. PHP operators
    1. Arithmetic Operators
    2. Assignment Operators
    3. Comparison Operators
    4. Logical Operators
    5. Concatenation Operators
  2. Decision Making Statements
    1. If else statement
    2. Else if statement
    3. Switch case statement
  3. Looping Statement
    1. While loop
    2. Do-while loop
    3. For loop
    4. Foreach loop
 2
28
  1. Strings
  2. Function
    1. Defining a user define function
    2. Function with arguments
    3. Function with return type
  3. Arrays
    1. Indexed arrays
    2. Associative arrays
    3. Single Dimensional arrays
    4. Double dimensional arrays
    5. Multi-dimensional arrays
  4. Arrays Sorting
    1. Sort()
    2. Rsort()
    3. Asort()
    4. Ksort()
    5. Arsort()
    6. Krsort()
 2
29
  1. Introduction of all Super global variables
    1. $Global
    2. $_SERVER
    3. $_REQUEST
    4. $_POST
    5. $_GET
    6. $_FILES
    7. $_SESSION
    8. $_COOKIE
  2. Form Handling
  3. Collect form data by $_GET, $_POST and $_REQUEST
  4. Implode & explode function
  5. Submit all data of registration form with validation
2
30
  1. File Uploading with validation
  2. Working with MySql
  3. Connect to MySql with PHP using mysqli()
  4. Execute insert/update/delete query using mysqli_query()
  5. Execute select query using mysqli_query()
  6. Show data in table from database
2
31
  1. User Registration
  2. Save user registration data into MySql database
  3. Show registered users data
  4. Delete registered users
  5. Edit registered users
2
32
  1. Include & require functions
  2. Sending Emails Using PHP Mailer
  3. $_SERVER (Web Concept)
  4. Cookies
  5. Sessions
 2
33
  1. Date & Time
  2. PHP AJAX
  3. File handling
    1. Opening/Creating a File
    2. Reading a File
    3. Writing a File
    4. Closing a File
 2
34
  1. Server Side Form Validation
  2. User Authentication (Login and Logout)
 2
35
  1. Problem Solving & Recovery Class
  2. Test
  3. Project Allotment
  4. Divide Team & Project Coordinators
 2
36-44
  1. Project Development (Complete All Project Modules)
 2
45
  1. Project Testing & Submission
 2

Java Curriculum

Foundation of ‘C’
L.N. Contents Hours
1
  1. Introduction to Programming
  2. Translator
  3. Introduction of ‘C’
  4. History of ‘C’
  5. C tokens
    1. Keywords
    2. Identifiers
    3. Variables/Constant
    4. Data types
    5. Operators
    6. Function
    7. Header Files
 2
2.
  1. Decision making statements
    1. If
      1. Simple if
      2. Else if
      3. Nested if
      4. Else if ladder
    2. Switch case
    3. Goto
  2. Looping statements / Iterative statements
    1. While loop
    2. For loop
    3. Do while loop
 2
3.
  1. Array
    1. Single Dimensional Arrays
    2. Double Dimensional Arrays
  2. String
    1. String Handling
    2. String Function
 2
4.
  1. Function
    1. Built in/Library Functions
    2. User Define Functions
      1. Declaring a function
      2. Defining a function
        1. No Return, No Parameter
        2. Return, No Parameter
        3. No Return, Parameter
        4. Return, Parameter
      3. Calling a function
 2
5.
  1. Recursion
  2. Type Casting
  3. Scope of variable
    1. Local variable
    2. Global variable
  4. Storage Classes
    1. Automatic
    2. Register
    3. Static
    4. External
 2
6.
  1. Preprocessors
    1. File inclusion (#include)
    2. Macro Expansion (#define)
  2. Header files
    1. Built in/Library header Files
    2. User Define header file
      1. Creating user define header file
      2. Using user define header file
 2
7.
  1. Problem Solving & Recovery Session
  2. Test
 2
Foundation of ‘HTML & CSS’
L.N. Contents Hours
8.
  1. Introduction of Web pages
  2. Introduction of Websites
  3. Introduction of Web Browsers
  4. Introduction of HTML
    1. What is Hypertext?
    2. What is Markup language
  5. History of HTML
  6. How to use HTML to create web pages?
  7. What is tag?
  8. What is element?
  9. HTML tag
  10. Head tag
    1. Title tag
    2. Style tag
    3. Script tag
    4. Noscript tag
    5. Link tag
    6. Meta tag
    7. Base tag
  11. Body tag
  12. Attributes
 2
9.
  1. Text Editing tags
    1. H1, h2, h3, h4, h5, h6, p, pre, center, br, hr, b, strong, i, em, u, ins, s, strike, del, sup, sub, big, small
  2. Lists
    1. Ordered List (ol, li)
    2. Unordered list (ul, li)
    3. Definition list (dl, dt, dd)
  3. Table (table, tr, th, td, thead, tbody, tfoot)
  4. Marquee (marquee)
  5. Image (img)
  6. Hyperlink (a)
 2
10.
  1. Form
    1. input (type=text, number, date, email, password, url, range, button, submit, reset, radio, checkbox)
    2. textarea
    3. label
    4. fieldset
    5. legend
    6. select
    7. option
    8. optgroup
    9. button
    10. datalist
11.
  1. div
  2. span
  3. iframe
  4. video
  5. audio
  6. Introduction of CSS
  7. Selectors
  8. Properties & values
  9. Text Styling Properties
    1. Font -family
    2. Font -size
    3. Font -weight
    4. Text -decoration
    5. Text -transform
    6. Color
    7. Line - height
    8. Word -spacing
    9. Text -shadow
    10. Text -align
2
12.
  1. Box Modal Properties
    1. Width
    2. Height
    3. Padding
    4. Margin
    5. Border
    6. Box -shadow
    7. Border -radius
    8. Float
    9. Outline
  2. Background
    1. Background -color
    2. Background -image
    3. Background -repeat
    4. Background -size
    5. Background -position
    6. Background -attachment
    7. Background (rbga)
  3. List (list -style -type, list -style -image
  4. Table (border, border -collapse)
2
13.
  1. Position
  2. Z -index
  3. opacity
  4. Pseudo -classes
    1. Hover
    2. Focus
    3. Active
    4. Visited
    5. Link
    6. Disabled
    7. Enabled
    8. First-child
    9. Last-child
    10. Nth-child (odd,even,2n+1,1)
  5. Designing a simple menu
  6. Designing a menu have sub menu
2
14.
  1. Designing a simple home page of a website
  2. Designing a Registration page of a website
  3. Designing a login page of a website
15.
  1. Problem Solving & Recovery Class
  2. Test
Foundation of ‘JavaScript’
L.N. Contents Hours
16.
  1. Introduction of Scripting language
  2. Difference between Client & Server Side Scripting
  3. Introduction of JavaScript
  4. JavaScript Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
    6. Variable declaration
  5. Document object Modal
  6. Write & writeln & message (alert) box
  7. Events
  8. DOM traversing
 2
17.
  1. Conditional Statements (if, else if, nested if, else if ladder)
  2. Looping Statements (while, for, do while)
  3. Arrays
  4. Objects
  5. Functions
  6. Call function on events
18.
  1. Dialog boxes
    1. Alert Box
    2. Confirm Box
    3. Prompt Box
  2. String Functions
  3. Number Functions
  4. Math’s Functions
  5. Date Functions
2
19.
  1. Creating a Simple Slider
  2. Form validation using JavaScript (using regular expression)
 2
20.
  1. Problem Solving & Recovery Class
  2. Test
 2
Foundation of ‘Database’
L.N. Contents Hours
21.
  1. Introduction of database
  2. Introduction of DBMS / RDBMS
  3. Introduction of SQL (Structured Query Language)
  4. Introduction of DDL commands
  5. Introduction of DML commands
  6. Introduction of DCL commands
22.
  1. Create Command
    1. Create Database
    2. Create table
  2. Drop Command
    1. Drop database
    2. Drop table
  3. Truncate Command
    1. Truncate table
  4. Alter Command
    1. Modify table column
    2. Drop Table column
    3. Add new column into table
  5. Insert Command
    1. Insert single record into table
    2. Insert multiple records into table
 2
23.
  1. Select Command
    1. Select all columns from table
    2. Select specific columns from table
    3. Select using where clause
  2. Update Command
    1. Update all records of table
    2. Update single record of table using where clause
  3. Delete Command
    1. Delete all records from table
    2. Delete single multiple records from table using where clause
  4. Keys
    1. Unique Key
    2. Primary Key
    3. Foreign key
  5. Not Null
  6. Default
  7. Auto Increment
 2
24.
  1. AND & OR Operators
  2. Order By (Ascending or Descending Orders)
  3. Top or Limit
  4. Like
  5. Distinct
  6. Between
  7. Joins
    1. Inner join
    2. Left Join
    3. Right Join
    4. Full Join
 2
25.
  1. SQL Aggregate Functions
    1. Avg()
    2. Count()
    3. Min()
    4. Max()
    5. Sum()
    6. Now()
  2. Problem Solving & Recovery Class
  3. Test
 2
Foundation of ‘Core Java’
L.N. Content Hours
26
  1. Introduction of Java
  2. History of Java
  3. Introduction of JVM
  4. Environment Setup for Java in Windows OS
  5. Basic Syntax of Java Programming Language
  6. Run First Java Program
  7. Java Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
  8. Introduction of OOPs
  9. Basic Concept of OPPs with its Properties
  10. Java Input/Outputs
 2
27
  1. Decision Making Statements
    1. If Statement
    2. If…Else Statement
    3. If…Else...If…Else Statement
    4. Nested if Else Statement
    5. Switch Statement
    6. Ternary Operator (Condition?True:False)
  2. Looping Statement
    1. While Loop
    2. For Loop
    3. Do While Loop
    4. Break Statement
    5. Continue Statement
  3. Type Conversion
2
28
  1. Arrays
    1. Single Dimensional Array
    2. Double Dimensional Array
  2. For each loop
  3. String
  4. Object
  5. Classes
  6. Constructor
  7. Member Variables
  8. Member Functions
  9. Create Instance/Object of Class
  10. User Class Members
29
  1. Modifiers
    1. Access Modifiers
      1. Public
      2. Private
      3. Protected
    2. Static
    3. Final
    4. Abstract
  2. This Keywords
  3. Polymorphism
    1. Method Overloading
    2. Method Overriding
 2
30
  1. Inheritance
    1. Type of Inheritance
      1. Single Inheritance
      2. Multilevel Inheritance
      3. Hierarchical Inheritance
      4. Multiple Inheritance
      5. Hybrid Inheritance
    2. Extend keyword
2
Foundation of ‘JSP’
L.N. Content Hours
31
  1. Introduction of Java Server Pages
  2. Introduction of Server Side Scripting language
  3. Overview of JSP
  4. Installation of JSP
  5. Syntax
  6. Input/ Output
  7. Data types
  8. Variables
  9. Constant
 2
32
  1. Decision Making Statements
    1. If else statement
    2. Else if statement
    3. Switch case statement
  2. Looping Statement
    1. While loop
    2. Do-while loop
    3. For loop
    4. Foreach loop
 2
33
  1. Form Handling
  2. Form Requesting
  3. Form Data Collection
  4. Post and Get Method
  5. JSP Directives
  6. Collecting Data from Text Box
  7. Collecting Data from Dropdown List
  8. Collecting Data from Check Box
  9. Collecting Data from Radio Button
 2
34
  1. Database Connectivity
  2. JDBC
  3. JDBC Driver Class
  4. SQL Connection
  5. SQL Statement
  6. Database Insert Operation
  7. Database Update Operation
  8. Database Delete Operation
 2
35
  1. File Uploading with validation
  2. Database Select Operation
  3. Data Edit and Update
2
36
  1. User Registration
  2. Save user registration data into MySql database
  3. Show registered users data
  4. Delete registered users
  5. Edit registered users
 2
37
  1. Include Directive
  2. User Login
  3. Cookies
  4. Sessions
 2
38
  1. Date & Time
  2. JSP AJAX
  3. Server Side Form Validation
  4. User Authentication (Login and Logout)
 2
39
  1. Problem Solving & Recovery Class
  2. Test
  3. Project Allotment
  4. Divide Team & Project Coordinators
 2
40-44
  1. Project Development (Complete All Project Modules)
 2
45
  1. Project Testing & Submission
 2

Python Curriculum

Foundation of ‘C’
L.N. Contents Hours
1
  1. Introduction to Programming
  2. Translator
  3. Introduction of ‘C’
  4. History of ‘C’
  5. C tokens
    1. Keywords
    2. Identifiers
    3. Variables/Constant
    4. Data types
    5. Operators
    6. Function
    7. Header Files
 2
2.
  1. Decision making statements
    1. If
      1. Simple if
      2. Else if
      3. Nested if
      4. Else if ladder
    2. Switch case
    3. Goto
  2. Looping statements / Iterative statements
    1. While loop
    2. For loop
    3. Do while loop
 2
3.
  1. Array
    1. Single Dimensional Arrays
    2. Double Dimensional Arrays
  2. String
    1. String Handling
    2. String Function
 2
4.
  1. Function
    1. Built in/Library Functions
    2. User Define Functions
      1. Declaring a function
      2. Defining a function
        1. No Return, No Parameter
        2. Return, No Parameter
        3. No Return, Parameter
        4. Return, Parameter
      3. Calling a function
 2
5.
  1. Recursion
  2. Type Casting
  3. Scope of variable
    1. Local variable
    2. Global variable
  4. Storage Classes
    1. Automatic
    2. Register
    3. Static
    4. External
 2
6.
  1. Preprocessors
    1. File inclusion (#include)
    2. Macro Expansion (#define)
  2. Header files
    1. Built in/Library header Files
    2. User Define header file
      1. Creating user define header file
      2. Using user define header file
 2
7.
  1. Problem Solving & Recovery Session
  2. Test
 2
HTML & CSS
L.N. Content Houres
  1. Introduction of Web pages
  2. Introduction of Websites
  3. Introduction of Web Browsers
  4. Introduction of HTML
    1. What is Hypertext?
    2. What is Markup language
  5. History of HTML
  6. How to use HTML to create web pages?
  7. What is tag?
  8. What is element?
  9. HTML tag
  10. Head tag
    1. Title tag
    2. Style tag
    3. Script tag
    4. Noscript tag
    5. Link tag
    6. Meta tag
    7. Base tag
  11. Body tag
  12. Attributes
 2
2
9
  1. Text Editing tags
    1. H1, h2, h3, h4, h5, h6, p, pre, center, br, hr, b, strong, i, em, u, ins, s, strike, del, sup, sub, big, small
  2. Lists
    1. Ordered List (ol, li)
    2. Unordered list (ul, li)
    3. Definition list (dl, dt, dd)
  3. Table (table, tr, th, td, thead, tbody, tfoot)
  4. Marquee (marquee)
  5. Image (img)
  6. Hyperlink (a)
 2
10
  1. Form
    1. input (type=text, number, date, email, password, url, range, button, submit, reset, radio, checkbox)
    2. textarea
    3. label
    4. fieldset
    5. legend
    6. select
    7. option
    8. optgroup
    9. button
    10. datalist
 2
11
  1. div
  2. span
  3. iframe
  4. video
  5. audio
 2
12
  1. Introduction of CSS
  2. Selectors
  3. Properties & values
  4. Text Styling Properties
    1. Font -family
    2. Font -size
    3. Font -weight
    4. Text -decoration
    5. Text -transform
    6. Color
    7. Line -height
    8. Word -spacing
    9. Text -shadow
  5. Text -align
  6. Box Modal Properties
    1. Width
    2. Height
    3. Padding
    4. Margin
    5. Border
    6. Box -shadow
    7. Border -radius
    8. Float
    9. Outline
 2
13
  1. Background
    1. Background -color
    2. Background -image
    3. Background -repeat
    4. Background -size
    5. Background -position
    6. Background -attachment
    7. Background (rbga)
  2. List (list -style -type, list -style -image
  3. Table (border, border -collapse)
  4. Position
  5. Z -index
  6. opacity
 2
14
  1. Pseudo -classes
    1. Hover
    2. Focus
    3. Active
    4. Visited
    5. Link
    6. Disabled
    7. Enabled
    8. First-child
    9. Last-child
    10. Nth-child (odd,even,2n+1,1)
  2. Designing a simple menu
  3. Designing a menu have sub menu
 2
15
  1. Designing a simple home page of a website
  2. Designing a Registration page of a website
  3. Designing a login page of a website
 2
Foundation of ‘JavaScript’
L.N. Content Hours
16
  1. Introduction of Scripting language
  2. Difference between Client & Server Side Scripting
  3. Introduction of JavaScript
  4. JavaScript Tokens
    1. Keywords
    2. Identifiers
    3. Variables
    4. Data types
    5. Operators
    6. Variable declaration
  5. Document object Modal
  6. Write & writeln & message (alert) box
  7. Events
  8. DOM traversing
 2
17
  1. Conditional Statements (if, else if, nested if, else if ladder)
  2. Looping Statements (while, for, do while)
  3. Arrays
  4. Objects
  5. Functions
  6. Call function on events
 2
18
  1. Dialog boxes
    1. Alert Box
    2. Confirm Box
    3. Prompt Box
  2. String Functions
  3. Number Functions
  4. Math’s Functions
  5. Date Functions
 2
19
  1. Creating a Simple Slider
  2. Form validation using JavaScript (using regular expression)
Fundamentals of ‘Python’
L.N. Content Hours
20
  1. Introduction of Python
  2. Overview of Python
  3. History of Python
  4. Features of Python
  5. Python Environment Setup
  6. Setting Up Path Variable
  7. Python Environment Variable
  8. Running Python
  9. First Program in Python
2
21
  1. Python Identifiers
  2. Python Keywords
  3. Line and Indentations
  4. Multi-Line Statements
  5. Comments in Python
  6. Quotations in Python
  7. Multiple Statements in Single Line
  8. Command Line Arguments
  9. Display Output in various format
  10. User Input
  11. Input Parsing
 2
22
  1. Variable Declarations
  2. Accessing / Assigning Value to Variables
  3. Multiple Assignments
  4. Standard Data Types
  5. Python String
  6. Python Operators
  7. Arithmetic, Logical and Assignment Operators
  8. Members Operators
  9. Identity Operators
2
23
  1. If Statement
  2. If…Else Statement
  3. Nested if Statement
  4. Elseif Statement
  5. Single Statements
  6. Looping in Python
  7. While Loop
  8. Using Single and Multiple Statements in Loop
  9. Using Else Statement with loop
2
24
  1. For Loop
  2. Nested Loops
  3. Loop Control Statements
  4. Break Statement
  5. Continue Statement
  6. Pass Statement
  7. Python Number and its Operations
  8. Random Number
  9. String Functions in Python
 2
25
  1. List in Python
  2. List Operations
  3. List Functions
  4. Tuple in Python
  5. Tuple Operations
  6. Tuple Functions
  7. Dictionary in Python
  8. Dictionary Operator
  9. Dictionary Functions
 2
26
  1. Date and Time in Python
  2. Date Time Operations in Python
  3. Date Time Functions in Python
  4. Function in Python
  5. User Define Functions
  6. Defining a Functions
  7. Calling a Function
2
27
  1. Passing by Reference Versus Passing by Values
  2. Function Arguments
  3. Required Arguments
  4. Keyword Arguments
  5. Default Arguments
  6. Variable length Arguments
  7. The return Statement
  8. Scope of Variable
  9. Global vs. Local Variables
 2
28
  1. Python Modules
  2. Import module
  3. From…..import statement
  4. From…..import * statement
  5. Locating Modules
  6. Namespaces and scoping
  7. Packages in Python
  8. Exceptions in Python
  9. Exceptions Handling in Python
 2
29
  1. OOPs in Python
  2. Class and object in python
  3. Creating Class
  4. Creating Object
  5. Accessing Attributes
  6. Destroying objects
  7. Overriding Methods
  8. Base Overloading Methods
  9. Data Hiding
 2
Fundamentals of ‘Python CGI’
L.N. Content Hours
30
  1. CGI Introduction
  2. CGI Environment Setup for Python
  3. CGI Architecture
  4. Web Server Configuration
  5. First CGI Program
  6. CGI Scripting
  7. Python Scripting on Web Server
 2
31
  1. Form Designing
  2. Form data Handling
  3. Receiving Form Data
  4. Form Validation on Server
  5. Validating Form Data using Python
  6. Send Form Data using Get Method
  7. Send Form Data using Post Method
2
32
  1. Receiving Radio Button Data
  2. Passing Form Data Using Checkbox
  3. Passing Text area data to CGI Program
  4. Passing Dropdown Data to CGI Program
  5. Complete Form Data Receiving
  6. Complete Form Validation on Server Side
  7. Python HTTP Headers
 2
33
  1. Python Cookies
  2. Setting Cookies
  3. Retrieve Cookies
  4. File Upload Control in Python
  5. File Uploading to Server
  6. Deleting File from Server
  7. Download File from Server
 2
Fundamentals of ‘MySQL DBMS’
L.N. Content Hours
34
  1. Introduction of database
  2. Introduction of DBMS / RDBMS
  3. Introduction of SQL (Structured Query Language)
  4. Introduction of DDL commands
  5. Introduction of DML commands
  6. Introduction of DCL commands
  7. Create Command
    1. Create Database
    2. Create table
  8. Drop Command
    1. Drop database
    2. Drop table
  9. Truncate Command
    1. Truncate table
 2
35
  1. Alter Command
    1. Modify table column
    2. Drop Table column
    3. Add new column into table
  2. Insert Command
    1. Insert single record into table
    2. Insert multiple records into table
  3. Select Command
    1. Select all columns from table
    2. Select specific columns from table
    3. Select using where clause
  4. Update Command
    1. Update all records of table
    2. Update single record of table using where clause
  5. Delete Command
    1. Delete all records from table
    2. Delete single multiple records from table using where clause
2
36
  1. Keys
    1. Unique Key
    2. Primary Key
    3. Foreign key
  2. Not Null
  3. Default
  4. Auto Increment
  5. AND & OR Operators
  6. Order By (Ascending or Descending Orders)
  7. Top or Limit
  8. Like
2
37
  1. Distinct
  2. Between
  3. Joins
    1. Inner join
    2. Left Join
    3. Right Join
  4. Full Join
  5. SQL Aggregate Functions
    1. Avg()
    2. Count()
    3. Min()
    4. Max()
    5. Sum()
    6. Now()
 2
Python Database Access using MySQL
L.N. Content Hours
38
  1. Overview of Database Access
  2. Environment Setup for MySQLdb
  3. Database Connection
  4. Connection Exception Handling
  5. Connection validating
  6. First Query Execution
  7. Displaying Query Results
 2
39
  1. Establishing Database Connection Object
  2. Receiving Form Data
  3. Insert for Data into Database
  4. Insert Multiple Data
  5. Fetching Data from Database
  6. Displaying All Records
  7. Displaying Single Record
 2
40
  1. Complete Form Data Insertion into Database
  2. Uploading Media File on server and Database
  3. Retrieving Data from Database
  4. Show Media File from Database
  5. Create Delete Button
  6. Perform Delete Operation
 2
41
  1. Delete Operation
  2. Delete File from Server
  3. Delete Single Data
  4. Delete multiple Data
  5. Create Edit button
  6. Perform Edit Operation
  7. Display Data into text box after clicking edit
 2
42
  1. Perform Edit Operation
  2. Perform Update Operation
  3. Prepare Complete Form
  4. Edit, Update, Delete Operation Combination
  5. Full Details Displaying with All Required Actions
 2
43

Project Distribution Project Team Divide 6 to 7 days to Complete project

2*7
-->
Register For Training
Assessment Portal