The top 20 Database courses you need to take

1. Database systems

This specialized program is aimed at computer people who want to enter the field of information systems and learn their different types of requirements, architectures, performance, techniques and tools so you can know when to use business intelligence, data mining, data science, databases , databases in memory or big data in order to have reliable, maintainable and scalable data intensive systems. Through 4 courses, you will cover [transactional relational databases, business intelligence and Data warehousing, NoSQL technologies, and reliable, scalable and maintainable data intensive applications that will prepare you for a specialized information system consultant or data scientist...

2. Implement a Relational database in Azure SQL database

In this 1 hour long project based course,you will learn to create an azure account and implement an azure sql database.You’ll get to know various purchasing models and select the one that suits best in accordance with your needs. You will learn to use Azure cloud based query editor and change the firewall settings to whitelist your IP. You will also learn to Use SSMS(SQL Server Management Studio) to connect and query Azure SQL Database.Also, you will learn to write a few queries to create tables and insert values.Finally you will also learn to add new users to an azure sql database. It is recommended that you know basic concepts on SQL and relational data concepts. But even if you don’t have this background knowledge, you’ll be able to complete the project...

3. Java Database Connectivity

The intent of Java Database Connectivity (JDBC) Introduction is to get some hands-on experience with foundational JDBC concepts. On our journey we’ll learn about why and how the API makes working with databases easy for Java Developers. After this course you should not only be able to demonstrate the mechanics of JDBC but furthermore, you should be able to explain the design and intent...

4. Meta Database Engineer

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more.\n\nIn this program, you’ll learn:\n\nCore techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts. MySQL database management system (DBMS) and data creation, querying and manipulation. How to code and use Python Syntax How to prepare for technical interviews for database engineer roles.\n\nAny third-party trademarks and other intellectual property (including logos and icons) referenced in the learning experience remain the property of their respective owners. Unless specifically identified as such, Coursera’s use of third-party intellectual property does not indicate any relationship, sponsorship, or endorsement between Coursera and the owners of these trademarks or other intellectual property...

5. Oracle SQL Databases

This Specialization is intended for beginners to learn how to become proficient writing Oracle SQL code to create, modify, and edit Oracle SQL Databases.\n\nYou will learn the Oracle database foundations, explore the platform, try your hand at the basics, and become proficient at building and modifying databases...

6. Relational Database Design

Have you ever wanted to build a database but don't know where to start? This course will provide you a step-by-step guidance. We are going to start from a raw idea to an implementable relational database. Getting on the path, practicing the real-life mini cases, you will be confident and comfortable with Relational Database Design. Let's get started! Relational Database Design can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder...

7. Database Management Essentials

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle, MySQL, or PostgreSQL...

8. Enterprise Database Migration

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal...

9. Introduction to Databases

In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: • Fundamental concepts in database • Basic MySQL syntax and commands • Database management systems • MySQL software • Relational databases...

10. Database Relationships

4

(184)

The hardest part about databases is that there is a huge mountain of knowledge needed before even beginning to understand how to design and create them. It doesn't have to be this way. This course will take you from knowing nothing about databases to being able to decisively design relationships between tables. Now, if you're a beginner, you might be asking... What are database relationships and why do they matter? The answer is simple, every database is built off the fundamentals of database relationships. If you want to really understand what a database is, how it works, and how to design your very first set of database tables, this course is for you. Every lecture is taught in an easy to follow method using on-screen illustrations, drawings, and examples. This course will bring you to a level of understanding that will allow you to develop skills quickly and use them at home, in school, and even in the work setting. These are practical skills. The skills learned in this course are skills that can help you get a job in IT or Database design. Do you want even better news? These skills are easy. No more confusion, no more fright, no more being a step behind everybody else in database technology. Here is just some of the information you will learn in this course: The basics of databases - what they are, how they work, and how they structure data. Data management - How do we keep millions of pieces of information organized and up-to-date? Data structure - How do we organize data so that our database is protected from anomalies? How to structure the three types of relationships between tables - one-to-one, one-to-many, and many-to-many. Each with practical examples. I didn't create this course to sell you something that's going to waste your time. I created this course because I have a passion for databases and I love teaching in a fun way. This course is fun, easy to follow, and worth every penny...

11. Database Design

4.3

(3,399)

Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course for relational database design. Here are some examples of the most popular databases: MySQL Oracle Microsoft SQL Server PostgreSQL SQLite MiariaDB and MORE! We start off this course by taking our time to first look at what a database is and how it differs from a spreadsheet, website, filing cabinet, and so forth. We introduce SQL and talk about data definition language and data manipulation language. After about 4 solid videos of explaining databases and SQL, we dive into learning about entities and attributes. We apply all of these concepts to structure tables and relationships. We learn to design all of the relationships and I explain everything in depth. Most of the videos are on my chalkboard, explaining concepts. This is because it helps to fully understand database design before you dive into designing your own database. Once we go over all of the concepts of database design we will be designing databases from start to finish. No programming skills are required. This course does not program a database. This course will only be teaching how to best design your database. You may be wondering why such a large course is required for only designing a database. Well, designing a database is an extremely important part of database management. The best design will get us the best results and make programming our database really easy. After this course you should be able to tackle almost any database design project with confidence and skill. Keep in mind though that learning database design takes a lot of time and effort. Be sure to take notes and stop after each video to reflect on what you've learned. Keeping notes will make this video course a whole lot easier!...

12. Databases for Data Scientists

Whether you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer seeking to learn about the database layer of the stack this specialization is for you! We focus on the relational database which is the most widely used type of database. Relational databases have dominated the database software marketplace for nearly four decades and form a core, foundational part of software development. In this specialization you will learn about database design, database software fundamentals, and how to use the Structured Query Language (SQL) to work with databases. The specialization, will conclude with an overview of future trends in databases, including non-relational databases (NoSQL) and Big Data. Upon completion of this specialization you will be well prepared to design and create efficient and effective relational databases, fill them with data, and work with them using SQL...

13. Google Cloud Database Engineer

A Database Engineer designs, creates, manages, migrates, and troubleshoots databases used by applications to store and retrieve data. This learning path guides you through a curated collection of on-demand courses, labs, and skill badges that provide you with real-world, hands-on experience using Google Cloud technologies essential to the Database Engineer role. Once you complete the path, check out our catalog for 700+ labs and courses to keep going on your professional journey...

14. Relational Databases for Beginners

In Relational Databases for Beginners, you will learn invaluable information about how data is stored with the MySQL database. This guided project provides hands-on lessons with an Integrated Development Environment (IDE) and relational databases to give you the skills to process data. In this guided project, you will learn how to explore the IDE interface, create a Python program using the IDE, create, populate, backup, and restore a database, how to create and populate a table, and how to use several statements to modify the data. No experience is necessary to take part in this guided project. All you need are basic computer operating skills. After you’ve completed this guided project, you can take your database skills a step further by taking the Introduction to Relational Databases, which is part of the Information Technology (IT) and Cloud Fundamentals Specialization. The IT and Cloud Fundamentals Specialization provides prerequisite skills for almost all IT careers, including technical support specialist, data analyst, data scientist, software engineer, systems administrator, and IT manager. With this specialization, you'll acquire hardware, operating systems, programming, database, networking, storage, cybersecurity, and cloud computing knowledge and skills that prepare you for an entry-level IT role. Also, this specialization will help you understand and manage IT responsibilities within your organization. Learn without limitations. Enroll today!...

15. MySQL Database Administration: Beginner SQL Database Design

4.6

(2,750)

If you're looking to develop practical, real-world analytics and BI skills and learn how to create and maintain databases, you've come to the right place. This course is unlike anything you've seen before, guaranteed. We'll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator. You'll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases. Throughout the course, you'll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day. COURSE OUTLINE: SQL Intro & MySQL SetupFor students who haven't completed one of our other SQL courses, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course. Creating, Altering, and Deleting Schemas & Tables In this section we'll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one). Inserting, Updating, and Deleting RecordsAfter we get up to speed creating and altering tables, we will learn how to populate those tables with records of data, and update and delete records as needed. Database DesignNow that we have covered the basic mechanics, we will learn how tables relate to one another optimally, and discuss best practices for database design. We will explore the EER Diagram Editor, and you will have some opportunities to create your own database models. ***MID-COURSE PROJECT: Normalize this database for your client! Advanced ConceptsIn this section, we will get into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers. This is powerful stuff! Server & User ManagementIn our last section before the Final Project, we will learn how to monitor servers to make sure they are running, and how to restart them when needed. You will also get your hands on user management tools to assign roles and manage permissions, just like a real DBA. ***FINAL COURSE PROJECT: Design and build an entire database from scratch! IMPORTANT NOTE: This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses). Enroll today and get LIFETIME access to:7 hours of high-quality videoDownloadable MySQL ebook and cheat sheetsQuizzes and homework assignmentsMid-course and Final SQL projects30-day money-back guaranteeIf you're looking for a hands-on, practical guide to mastering database administration skills using SQL/MySQL, this is the course for you! Happy administering!-John (Lead SQL Instructor & MySQL Expert, Maven Analytics) Looking for the full business intelligence stack? Search for Maven Analytics to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses! See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy: I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning - I wanted to keep charging on to the next lesson!- Ann S. This is an excellent advanced course! I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!- Dan S. John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!- Steven M...

16. Database Design for Relational Databases using SQL Server

4.4

(174)

Start learning Database Design Today! A lot of IT professionals have a good working knowledge of SQL yet lack the foundational knowledge of relational database design. Learning database design and the relational model will put you ahead of the game. This course covers all the essential aspects of relational database design with practical demos given in SQL Server. You will learn how to spot un-normalized data structures and how to correct them. You will learn all about the process of data normalization and why it is important. This includes the various normal forms such as Boyce-Codd normal form and fourth normal form. This course also covers tips on how to identify relationships between entities and how to correctly model them in a relational database. You will be able to understand advanced database design concepts with the aid of intuitive diagrams and practical examples. You will learn how to identify functional dependencies and transitive dependencies in your data. You will learn the different types of keys and when to use them. In addition, you will learn the different types of relationships such as one-to-one, one-to-many, many-to-many, and self-referencing relationships. More importantly, the end of the course you will know how to enforce these relationships by using integrity constraints. Note that you will need either a Windows or Linux computer to install SQL Server...

17. Using MySQL Database with PHP

In this 1.5 hour project, you will combine your knowledge of HTML, object-oriented PHP, SQL, and MySQL to make a dynamic website that uses MySQL database on the web server. You will learn two different methods, one applies to 12 other SQL databases and one specific to MySQL. Basic HTML, object-oriented PHP, relational database, and SQL required as prerequisites. Completing my courses "Build an Automobile Listing Website with PHP" and "Learn Object-Oriented Programming with PHP" first is highly recommended...

18. Creating Database Tables with SQL

In this course you will experience the process of defining, creating, and managing relational database tables using the SQL language. Tables are used as the containers for the data in a database. As such, the structure, or makeup, of each table in a relational database is critical, since it must be designed and created specifically to meet the needs of the data it will contain. The table’s structure indicates which pieces of data are stored in a table, as well as the type and size of each piece of data. Throughout the course, you’ll be exposed to guidelines and rules that database designers use to make sure that the tables will keep the data as safe and accurate as possible. You’ll learn to use SQL code to incorporate the constraints that help the database management enforce those rules. As you work through and complete hands-on tasks, you’ll become familiar with SQLiteStudio, the database management system used in the course. Tables that are well-designed and created correctly improve data integrity--and make data retrieval easier! Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions...

19. Access Bioinformatics Databases with Biopython

In this 1-hour long project-based course, you will learn how to access, parse, and visualize data from various bioinformatics sequence and structural online databases such as ENTREZ, PDB, KEGG and NCBI using Biopython. You will also interact with various bioinformatics file formats such as FASTA, PDB, GENBANK and XML along with various parsers to read and modify these files using Biopython. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions...