Database Management is about the monitoring, administration, and maintenance of databases and database groups across an enterprise. Managing a database involves designing, implementing, and supporting stored data, to maximize its value. Often categorized in various types, which includes centralized, distributed, federated, and blockchain, Database Management plays a vital role in creating efficient ways that data is stored throughout an entire organization.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Advance your knowledge of SQL in this flexible online course. You will learn how to write, design, and test complex SQL queries.
When it comes to query language for relational database management systems, SQL is the industry benchmark. This hands-on course will help you advance your knowledge and keep pace with today's SQL standards. You will practice designing, writing, and testing complex SQL queries to execute on a practice database using SQL Server Express.
Learn how to create an interactive website, allowing visitors to post and retrieve information provided by you or your site's visitors. In this online course, you'll see how to create dynamic web pages using the PHP programming language and the MySQL database server.
....During the course, you'll walk through the development of a complete content management system web application. You'll receive clear, step-by-step, instructions demonstrating how to create a complete website capable of dynamically displaying data from a MySQL database.
You'll discover how you can allow your site's visitors to add new information to an online database, search through posted data, and create meaningful printed reports. By the end of this course, you'll have plenty of useful code templates that will help you create your very own dynamic, web-based, content management system.
Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. In this online course, you'll see how to create a commercial online store using the PHP programming language and the MySQL database server.
....You'll walk through the steps for developing a complete online store web application. During the course, you'll see step-by-step how to create all of the software and database objects used in the application. The application consists of two parts, an administrative web application allowing a store manager to post new products, alter product information, and process customer orders, and a customer web application allowing customers to browse the catalog of products, select products for purchase, and check out using a shopping cart. At the end of the course, you'll be able to use these code templates to create your own online store application.
Master more advanced techniques for this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks.
Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.
From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. Finally, you'll build a navigation form to make it easy for your users to find their way around your database. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.
