Join ICSA
to
improve your career
change you life
develop your skill
learn new technologies
get better opportunities
0
100
Job Oriented
Computer Programming
| Learn by Professional |
| Hands On Training |
| Most In Demand Course |
Timing and Duration
| Course Duration | 3 Months |
| Flexible Schedule | 10:00 AM – 8:00 PM |
| Each Class Duration | 2-3 Hours |
STUDENT REVIEWS
Computer Programming
Course Description
The course is design for students who wants to pursue a career on being a programmer. This is a skill-based course so hands-on training is implemented.
Course Index
Course Contents
* MySQL
* MS Access
* VB.Net
Course Outline
MySQL
NO TOPIC 1 SQL Fundamentals 2 SQL Terminologies 3 Creating database 4 SQL Data Types 5 Creating a table 6 Adding a table 7 Exercise # 1 8 Renaming tables in CPanel 9 Editing table Structure in CPanel 10 Adding Data to a Table 11 Exercise # 2 12 phpMyAdmin Environment 13 SQL Query 14 Database Normalization 15 Database Keys 16 Unique Key 17 Primary Key 18 Foreign Key 19 Table Relationships 20 One-to-many 21 Many-to-Many 22 One-to-One 23 Modeling Table Relationships 24 The Shopping Cart Database 25 Getting Data from the Database 26 SQL Alias 27 Where keyword 28 Data in SQL 29 CRUD Operations 30 Adding Data to the Database 31 Updating Rows in a table 32 Removing Data in a table 33 Reporting with SQL 34 Handling Data 35 Order by keyword 36 Limit keyword 37 SQL text functions 38 Length keyword 39 Aggregate and numeric functions 40 Count() function 41 Distinct function() 42 Group by keyword 43 Sum function() 44 Min() and max() function 45 Now() and curdate() function 46 Subqueries 47 Project Microsoft Access
NO TOPIC 1 ACCESS FUNDAMENTALS 2 MS Access Terminologies 3 MS ACCESS ENVIRONMENT 4 Create a Blank Database 5 Save Database 6 MS Access Data Types 7 Design View vs. Datasheet View 8 Create a Table 9 Primary Key 10 Create a New Table 11 Create Table Using Design View 12 Set the Field Properties for an Existing Table 13 Create an Input Mask 14 Add Data to a Table 15 Exercise # 1: 16 Quiz # 1: 17 Other Methods to Create a Form 18 Form Sections 19 Form Properties 20 Adding Combo Box to a Form 21 Creating Relationship 22 Types of Relationships 23 Lookup Table 24 Assignment # 1: 25 Import Data from an External Source 26 Export Data from an External Source 27 Activity # 1: 28 Activity # 2 29 Modify Table Data 30 Sort and Filter Records 31 Saving a Filter as a Query 32 Activity # 3: 33 Create a Query 34 Query Design 35 Query with User Input 36 Activity # 4 37 Sort and Filter Data in a Query 38 Query Criteria 39 Wildcards 40 Comparison Operators 41 Logical Operators 42 Assignment # 2: 43 Perform Calculations in a Query 44 Arithmetic Operators 45 Generating Report 46 Activity # 5 – Creating Reports 47 Adding Controls to a Report 48 Adding Controls 49 Exercise # 2 50 Labels and Images 51 Activity # 6 – Adding Controls to a Report 52 Themes 53 Activity # 7 – Enhancing the Appearance of a Report 54 SQL Fundamentals 55 TYPES OF DATA 56 The Shopping Cart Database 57 Getting Data from the Database 58 SQL ALIAS (AS) 59 The WHERE Keyword 60 DATA in SQL 61 FOUR MAIN DATA OPERATIONS: 62 Adding Data to the Database 63 Updating Rows in a Table 64 Removing Data in a Table 65 Reporting with SQL 66 Handling Data 67 The Keyword ORDER BY 68 The Keyword TOP 69 SQL FUNCTIONS in Text 70 The Keyword Len 71 Aggregate and Numeric Functions 72 The Function Count() 73 The Function DISTINCT() 74 The Keyword GROUP BY 75 The NOW(), DATE() and TIME() Functions 76 Subqueries 77 Database Normalization 78 Database Keys 79 Unique key 80 Primary Keys 81 Foreign Keys 82 Table Relationships 83 One-to-many 84 Many-to-many – 85 One-to-One – 86 Modeling Table Relationships 87 Creating Report Based on Query 88 Back Up a Database 89 Final Project: VB.Net
NO TOPIC 1 Visual Basic 2 Installing Visual Studio 3 Visual Studio IDE Environment 4 Placing Controls on a Form 5 Control Properties 6 Debugging your Project 7 Visual Basic Comments 8 Introduction to Variables 9 Working with Numbers 10 User Input 11 The Math Class 12 Programming Exercise # 1: Rolling a Dice using Random Number 13 The Conditional Statements 14 Programming Exercise # 2: Creating an Electronic Quiz 15 Conditional Operators 16 Programming Exercise # 3 17 Logical Operators 18 Operator 19 Description 20 And 21 Or 22 Not 23 Boolean Values 24 Programming Multiple Outcomes 25 Programming Exercise # 4: Improving the Random Number Guessing Game 26 Combining Multiple Tests on a Condition 27 Programming Exercise # 5: eQuiz 28 Select case Statement 29 How Switch – Case Works: 30 Flow Diagram 31 Programming Exercise # 6: 32 VB Strings 33 VB Loops 34 Do Until Loop 35 For Next Loop 36 MessageBox Dialog 37 Seat Work 38 VB Functions 39 VB Subroutines 40 ByVal and ByRef 41 VB ARRAYS 42 Accessing Items in an Array 43 Adding data to Arrays 44 Using For loops with Array 45 Programming Exercise # 7 46 Date and Time Format 47 Setting the value for DateTimePicker 48 Displaying the Current Time and Date 49 VB .NET Controls 50 TextBoxes in VB .NET 51 ListBox in VB .NET 52 Progress Bar in VB .NET 53 Radio Button and Check Box in VB .NET 54 Menu Strip in VB .NET 55 Linking Forms in VB .NET 56 Programming Exercise # 8: Zodiac Sign App 57 Programming Exercise # 9: Text to Speech App 58 Splash Screen in VB .NET 59 VB .NET Modules 60 Programming Projects: 61 Prepare for a Summative Test 62 VB .NET Try-Catch 63 VB .NET ArrayList 64 Adding Data or Elements to an ArrayList 65 Size of an ArrayList 66 Remove an element in the ArrayList 67 Connecting your VB .NET Program to Access Database 68 Seatwork # 1: 69 Seatwork # 2 70 Seatwork # 3 71 Seatwork # 4 72 Seatwork 73 Seatwork 74 Seatwork # 7 75 Publish an Application 76 Final Project:
