ITS 305 Software Development made easy: Objective 5 study guide - Databases

Objective 5 of Software development made easy: Databases

This 59-page, downloadable pdf study guide is aimed at making Objective 5 of the ITS 305 exam content easy and understandable through:

• Thorough, yet concise, explanations
• Examples
• Tabular Summaries
• Coding exercises to implement knowledge
• Review Questions (Q&A)

Knowledge areas covered:

Understanding Databases

Database Management systems

• Understanding Relational database design
• Types of databases

Understanding ER diagrams

Understanding Normalization

• Benefits of Normalization
• Normal forms

Structured Query Language (SQL)

• DDL and DML
• SQL data types
• DDL objects and terms
• SQL DDL: From scratch to completing your first database

Understanding database query methods

SQL DML: Querying your database

• SQL query keywords summary
• Insert statement
• Update statement
• Delete statement
• Select statement
• Using stored procedures to query data

Understanding database connections methods (& working with data in C# and Visual Studio)

Working with data in C# and Visual Studio

System.Data.SQLCLient objects and classes summary

• SQLConnection
• SQLDataReader
• SQLCommand
• SQLDataAdapter
• DataSets
• DataTables
• DataViews
• SQLTransaction

Working with data in C# and Visual Studio exercises

Reading from and writing to files

• System.IO namespace
• BinaryReader and BinaryWriter
• FileStream
• StreamReader and StreamWriter
• TextReader and TextWriter
• System.XML namespace
• XMLReader
• XMLWriter

+Discount codes and special offers on other products.