This is an introductory course for the student with little or no experience with computers. The students become familiar with the different hardware components comprising an IBM compatible personal computer. They install and configure a Windows based operating system, memory and hard drives. They also learn the basics of using a Windows operating system, file structure, DOS commands, property maipulation etc. The students then learn the basics of networking computers, setting up both a server based and peer-to-peer networking infrastructure. IP Addressing and Subnet masks, topologies and web services will also be covered.
- Write a concise and interesting paragraph here that explains what this course is about
- Write a concise and interesting paragraph here that explains what this course is about
- This is an advanced course in client-server programming using VB.NET, C#.NET and ADO.NET technologies. Emphasis is on creating database driven "n-tier client-sever" style applications to run under the Microsoft Windows environment. Students create data-aware projects using ADO (Active X Data Objects) for .NET and Microsoft SQL Server. Database querying and maintenance is accomplished using ANSI SQL. Business logic is enforced with class modules. Connection objects, data adapters, datasets, data readers and command objects are used to extract and update data in SQL Server databases. Object-oriented programming concepts including inheritance, interfaces, polymorphism and instantiating objects are covered. In addition, use of pre-existing objects for reporting such as Microsoft Word is covered in a unit on OLE Automation. Students incorporate all of these technologies into a project of their own design.
- This course is designed for the student who is already familiar with basic relational database theory. The focus of this course is on the database portion of the n-tier client/server development model and data warehousing. Microsoft SQL Server for Windows is the primary tool. Students learn Structured Query Language (Transact SQL) and receive hands-on instruction in how to administer an enterprise database server. Administrative topics include database creation and administration, user management, security, and performance tuning. Development topics include relational database normalization concepts, writing queries (including joins and nested queries), stored procedures, triggers, cursors, transactions and creation of schemas using Data Definition Language. Appropriate use of indexes are also covered. There is an introduction to data warehousing topics including analysis of business requirements, defining technical architecture for a data warehouse, deriving the physical design, creating data services and creating the physical database.
- Writing course
- Write a concise and interesting paragraph here that explains what this course is about
- This is an advanced course in web application development. Students design and develop a web-based applications using database connectivity (Microsoft SQL Server) ADO.NET, client-side scripting JavaScript and server-side coding using Active Server Page (ASP .NET) technology with web forms. Business logic is created using server-based components written in Visual Basic.NET or C#. Extensible Markup Language (XML) and use of web services is covered and used by students in the creation of their web applications.
