Preparation for Entry into .NET Bridging Program (Databases)

1. Preparation for Entry into .NET Bridging Program (Databases) In order to be successful in this program, it is important for you to have some theoretical knowledge of many concepts in software development. You should have an idea of what a database is and how it stores data. You should also be able to write a simple SQL statement to retrieve data from a table. Know about the relational aspect of a Database, how we can join tables and the difference between the Foreign and Primary keys. Be able to Create, Update and Delete records in a Database.

2. Preparation for Entry into .NET Bridging Program (Programming) For the C# programming part of the course it is important for you to understand the fundamental concepts (in any programming language): Variables and assignmentOperators like +-*/% as well as AND/OR/NOT etc.Control structures like decisions, iteration and loopingArrays-initialization, elements, indexing etc.Methods (functions)-parameters, return values etc. It is also important for you to know the Microsoft Windows environment and be comfortable with files, folders, copying, moving and very basic knowledge of the Office products.

3. Preparation for Entry into .NET Bridging Program (Web) You should be familiar with the Internet, using the Internet, searching, finding information knowing the difference between good information and bad information. Be able to write a simple web page using Notepad, so you should have knowledge of the HTML tags like Paragraphs, Ordered Lists, Body, Table and Div, all the major ones. It would be helpful if you have used JavaScript in some way, perhaps to check the value inside of a textfield, or to cause a popup message.

4. Object Oriented Programming using C# If you are a complete beginner to the OOP world, please review this entire slide presentation from slide number 6 onwards. You will need to run the presentation in full-screen mode (F5) in order to hear the audio. After the presentation you may follow the links given on slide #5 to view the two videos on the official Microsoft website. For those with some exposure to OOP or to C# itself, please proceed to the videos, you may skip the slides in this presentation.

5. Microsoft Produced Videos Please go to this url address: http://www.microsoftvirtualacademy.com/training-courses/c-fundamentals-for-absolute-beginners Start with this video (towards the middle of the page): 15 | Understanding and Creating Classes Then watch this video: 16 | More About Classes and Methods Of course you may watch as many as you like, but we will be testing specifically on 15 and 16.

6. Prehistoric Humans & Communication

7. Natural World

8. First Words? Grrrrrr Ugghh Brrrrrr Arrrrrghh

9. Language Starts Something Thing This That

10. One Word Object Object Object Object

11. Different Words Bird Fruit Plant Rock Fish Fire

12. Nouns Bird Fruit Plant Rock Fish Fire

13. Adjectives Size Colour Height Texture Weight Temperature

14. Verbs Fly, eat, walk, sing Be eaten Germinate, grow, die Exert force on the earth, broken, provides shade for insects Swim, eat, sleep Provide heat, burn, start Put out

15. Full Sentences Bird (Eagle) Fruit (Banana) Actions - Fly ( ), Eat ( ), Walk ( ) Size – Small, Medium, Large Action - beaten ( ) Colour – Yellow

16. Objects with Properties and Methods Thing -> Object -> Noun -> Banana Adjective (e.g. colour)=Property=Yellow Verbs = Action = functionality (e.g. beEaten ( ))

17. Closer to Programming Object Functions, methods, procedures Properties, fields, variables, data

18. Representation A Student Object 00010100101010111011011100 Student kim = new Student ( ) ; A Student

19. Representation of a Student A Student Object Properties1, Properties2, Properties3 Function1, Function2, Function3 A Student

20. Representation using a Class class Student { string Name dateDoB float GPA Register ( ) AddCourse ( ) DropCourse ( ) Graduate ( ) A Student }

21. Representation in General class Student { string Name date DoB float GPA Register ( ) AddCourse ( ) DropCourse ( ) Graduate ( ) A Student }

22. Representation of a Student class Student { Name DoB GPA Register ( ) AddCourse ( ) DropCourse ( ) Graduate ( ) A Student }

23. Class becomes Object Bob class Student { Jane Name Age GPA new new new Lin Register ( ) AddCourse ( ) DropCourse ( ) Graduate ( ) new John }

24. Many Objects class Classroom { class Student { class Course { string RoomName intRoomNum Name Age GPA intCourseID string Name string Professor addCourseTaught ( ) removeCourseTaught ( ) Register ( ) AddCourse ( ) DropCourse ( ) Graduate ( ) assignToCurriculum ( ) removeFromCurriculum ( ) assignToRoom ( ) } } }

25. Relationships among Objects Course object History Student object Bob Student Object Registers ( ) for a Course Object Course Object is Assigned ( ) to a Room Object Room object K144