SQL For .NET Content

SQLN1  Intro to SQL Server 2005 for .NET

Special topics in Computer and information sciences, general. (ITSC1091)

Topics address recently identified current events, skills, knowledge and or attitudes and behaviors pertinent to the technology or occupation and relevant to the professional development of the student.

This course introduces developers to programming database applications using Transact SQL and SQL Server 2005. Students learn how to write standard SQL and create and extract data from a database and analyze code for performance gains. Students utilize Microsoft Transact SQL Server 2005 to create stored procedures and triggers to enhance the power, efficiency and flexibility of SQL and dramatically improve the performance the performance of SQL statements and batches

Course Content:

• Using Studio manager and its tools
• Transact-SQL
• Stored procedures and functions
• Data Transformation Services
• Basic system administration
• Installing SQL Server 2005 and SQL Server EXPRESS
• SQL Server Security
• User Defined Types
• SQL and XML outputs

SQLN2  Advanced SQL Server 2005 for .NET

Special topics in Computer and information sciences, general. (ITSC1091)

Topics address recently identified current events, skills, knowledge and or attitudes and behaviors pertinent to the technology or occupation and relevant to the professional development of the student.

This course introduces developers to programming database applications using Transact SQL and SQL Server 2005. Students learn how to write standard SQL and create and extract data from a database and analyze code for performance gains. Students utilize Microsoft Transact SQL Server to create stored procedures and triggers to enhance the power, efficiency and flexibility of SQL and dramatically improve the performance the performance of SQL statements and batches

Course Content:

• Installing SQL Server 2005
• Enterprise Manager tools
• SQL Server Security
• SQL Server Runtime
• User Defined Types
• SQL and XML
• SQL Server 2005 System administration

ORAN Intro to Oracle for .NET

Special topics in Computer and information sciences, general. (ITSC1091)

Topics address recently identified current events, skills, knowledge and or attitudes and behaviors pertinent to the technology or occupation and relevant to the professional development of the student.

This course provides an introduction to the design and creation of relational databases. Topics include storing, retrieving, updating and displaying data using structured Query Language (SQL) and Procedural Language (PL)

Course Content:

• SQL
• Creating an Oracle database
• Data retrieval
• Oracle dictionary
• PL-SQL