Introduction to Database Development

Trace the history of databases from early hierarchical systems and IMS to the relational model for large shared data banks, then examine non-normalized and observational databases shaping web data markets.

Explore major database providers Oracle, MySQL, and Microsoft SQL Server, including open source relational DBMS MySQL, and editions such as Oracle enterprise, standard, personal, and SQL Server express.

Build an MS Access database for HR interviews by creating tables for location, applicant, questions, and answers; design forms and reports, implement lookup fields and default call date using now.

Create a questions table with an auto-number key and long text; import from a text file via external data, then build an answers table with applicant, question, answer, and timestamp.

Build an input form in MS Access for the application table, switch between form view and design view, and refine labels and field widths using the Format tab and Properties.

Create and customize forms in MS Access using the form wizard. Add navigation buttons, a subform for questions and answers, and build a full name field via the expression builder.

Copy and integrate data from Excel into a new Access database by appending records, adding a rate field, and configuring a read field in a subform.

Design and run queries to join the applicant and answer tables, select fields, group by and sum ratings, and sort by criteria like city and years of work.

Create an MS Access report of applicants grouped by province and CTA, bind years of work and rating via a query, and refine layout.

Explore how databases power web applications by handling browser requests and backend code, with technologies like Java, dot net, sql server, apache, javascript, and platforms such as WordPress.

Install and start a database server for web development with PHP and MySQL, then use the MySQL Workbench interface to create and manage databases.

Discover HeidiSQL, a free, easy-to-learn tool for working with databases; connect to multiple servers, manage users, browse and edit table data, and run queries, with password hashing explained.

Start the MySQL server, open HeidiSQL, create a database named intro to gbm with utf8, and build an applicants table with first name, last name, address, city, province, and phone.

Explore MySQL data design by creating tables with primary keys and appropriate data types like integer, varchar, and timestamp, and practice inserting records using My School documentation.

Learn how to run MySQL queries to view table data, compare results, and handle missing fields, while verifying hashed passwords in a Drupal-based database.

Explore MS ASP.NET within the .NET ecosystem by building a web application using Visual Studio, IIS Express, and SQL Server, including registration forms, migrations, and a login workflow.

Create a new database in MS SQL Server, define an id column as a primary key with identity, and query the location table using SQL Server Management Studio.

Explore SQL Server database design by inspecting location, applicant, questions, and answer tables, and configuring identity fields. Seed data with insert queries, enable and disable identity insert as needed.

Explore data types in SQL Server and Azure, including numeric, date and time, character sets and Unicode, binary data, and large objects like images.

Explore how data constraints establish relationships and enforce uniqueness to maintain data integrity using primary keys and foreign keys, illustrating with unique emails and foreign key references.

Explore data definition language and data manipulation language, learning to create, alter, truncate, drop tables, and perform insert, update, delete, and select queries on the applicant table.

Thank you for being with me in this course, and I hope it was helpful for you.