Preparation for entry into net bridging program databases
Download
1 / 25

Preparation for Entry into .NET Bridging Program (Databases) - PowerPoint PPT Presentation


  • 99 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Preparation for Entry into .NET Bridging Program (Databases)' - daxia


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Preparation for entry into net bridging program databases
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.


Preparation for entry into net bridging program programming
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.


Preparation for entry into net bridging program web
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.


Object oriented programming using c
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.


Microsoft produced videos
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.




First words
First Words?

Grrrrrr

Ugghh

Brrrrrr

Arrrrrghh


Language starts
Language Starts

Something

Thing

This

That


One word
One Word

Object

Object

Object

Object


Different words
Different Words

Bird

Fruit

Plant

Rock

Fish

Fire


Nouns
Nouns

Bird

Fruit

Plant

Rock

Fish

Fire


Adjectives
Adjectives

Size

Colour

Height

Texture

Weight

Temperature


Verbs
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


Full sentences
Full Sentences

Bird (Eagle)

Fruit (Banana)

Actions -

Fly ( ), Eat ( ),

Walk ( )

Size –

Small,

Medium, Large

Action -

beaten ( )

Colour –

Yellow


Objects with properties and methods
Objects with Properties and Methods

Thing -> Object -> Noun -> Banana

Adjective (e.g. colour)=Property=Yellow

Verbs = Action = functionality (e.g. beEaten ( ))


Closer to programming
Closer to Programming

Object

Functions, methods, procedures

Properties, fields, variables, data


Representation
Representation

A Student Object

00010100101010111011011100

Student kim = new Student ( ) ;

A Student


Representation of a student
Representation of a Student

A Student Object

Properties1, Properties2,

Properties3

Function1, Function2,

Function3

A Student


Representation using a class
Representation using a Class

class Student {

string Name

dateDoB

float GPA

Register ( )

AddCourse ( )

DropCourse ( )

Graduate ( )

A Student

}


Representation in general
Representation in General

class Student {

string Name

date DoB

float GPA

Register ( )

AddCourse ( )

DropCourse ( )

Graduate ( )

A Student

}


Representation of a student1
Representation of a Student

class Student {

Name

DoB

GPA

Register ( )

AddCourse ( )

DropCourse ( )

Graduate ( )

A Student

}


Class becomes object
Class becomes Object

Bob

class Student {

Jane

Name

Age

GPA

new

new

new

Lin

Register ( )

AddCourse ( )

DropCourse ( )

Graduate ( )

new

John

}


Many objects
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 ( )

}

}

}


Relationships among objects
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


ad