The top 20 Database Administration courses you need to take

1. Oracle Database Administrator DBA

4.5

(973)

Hello there, Welcome to the Oracle Database Administrator DBA course. Oracle Database Administration DBA become Oracle Database Administrator, Oracle DBA and get six figures jobs as DBAThis Oracle DBA course is one of the most awesome Udemy courses which teaches step-by-step and follow the methodology in introducing concepts and demos ( Learn by doing ) to the students so that they can learn with ease Oracle Database Administration. Oracle dba, dba oracle, oracle 12c dba, oracle dba 12c, oracle 11g dba, oracle cloud dba, oracle dba 11gOracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for enterprise resource planning (ERP). Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data. In this course you will learn;Downloading Oracle Software, Database and RDBMS Concepts, DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ), Retrieving Data, Restricting And Sorting Data, Using Single-Row Functions and Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using The Group Functions, Defining Table Joins and Displaying Data from multiple Tables, Using Subqueries, Using The Set Operators, Schema Objects And Managing Schema, Controlling User Access, Manipulating Large Data Sets and more! Oracle DatabaseOracle Database administrationOracle dbaOracle 12c DBAWhether you're interested in preparing for an Oracle Administrator certification exam or simply using Oracle DB for your enterprise-grade application, Udemy has a range of top-rated courses to help you get the job done. Why would you want to take this course?Our answer is simple: The quality of teaching. When you enroll, you will feel the OAK Academy`s seasoned developers expertise. No Previous Knowledge is needed! This course will take you from a beginner to a more experienced level. If you are new to Oracle Database, or have no idea about what a DBA does no problem, you will learn anything you need to start Oracle Database. If you are a DBA or familiar to the Oracle Database / Oracle SQL  and you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples. What is oracle SQL?SQL stands for Structured Query Language-the language developers use to interact with databases to create, read, update, and delete database records and manage other aspects of those databases. ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language. Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system. This RDBMS was released as the first commercially available relational database management system in 1977 and holds the top market share worldwide for relational database management systems. Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language. What careers use Oracle SQL?Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle database management system. But SQL dialects are pretty similar, and knowledge of Oracle SQL can apply to many types of relational databases and doesn't limit you to Oracle. Database developers also use Oracle SQL all day long to create new databases and table structures. Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently. Data scientists must access data to create machine learning models and find trends, and a lot of this data will get stored in databases that require a knowledge of SQL to retrieve and transform. Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage. What skills should I have before learning Oracle SQL?There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English. Most people can understand what a SQL query is trying to do before they even know the language. All you need is an interest in the language and a commitment to learning. That said, some things could help with your Oracle SQL education if you are already familiar with them. If you are familiar with Excel spreadsheets and understand how columns and rows work, you can apply that knowledge to Oracle database tables. It also helps to know at least the concepts of how a relational database management system works. Also, if you already know a programming language, that will help learn Oracle's extended features like PL/SQL. Fresh ContentYou will find DBA's in almost every organization/business, to maintain the organization's database. Becoming a DBA is totaly depends on the knowledge you have in the overall architecture of Oracle Database. It's no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it's crucial to stay on top of the latest knowledge. With this course you will always have a chance to follow latest trends. Video and Audio Production QualityAll our contents are created/produced as high quality video/audio to provide you the best learning experience. You will be,· Seeing clearly· Hearing clearly· Moving through the course without distractionsYou'll also get: Lifetime Access to The CourseFast & Friendly Support in the Q & A sectionUdemy Certificate of Completion Ready for DownloadDive in now! Oracle Database Administrator DBA courseWe offer full support, answering any questions. See you in the course!...

2. 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...

3. Complete MySQL Database Administration Course

4.4

(619)

MySQL Server continues to be one of the world's most popular, FREE and top databases.  Database is a heart of IT which is needed to stored all critical data and information.  MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone.  MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machineIf you want to become an expert in SQL database administration then this is the course for YOU. This training course will provide you all the necessary skills you need to be a successful database administrator. Here is the course outline: Course SyllabusSection 1: Introduction to DatabaseRDBMSWhat is SQL?Top 5 RDBMSIntroduction to MySQL ServerDifferent editions of MySQLSection 2: MySQL Server pre-requisiteLab designWhat is virtualization?Download and Install VMWare Workstation PlayerOptional - Download and Install Oracle VirtualBoxCreate a Virtual MachineDownload and Install Linux ServerVirtual Machine ManagementSection 3: Important things to remember in LinuxLinux navigation commandsWhat is root?Directory listing attributesLinux command syntaxCreating files and directories and its permissionsChanging passwordHelp commandsAdding text to filesPipes ()File maintenance commandsFile display commandsLinux file editorUser account management and sudo accessProcess monitor commandsCrontabLinux network files and commandsSecure copy (SCP)System updates and repos (rpm and yum). Section 4: Forks of MySQL and Cloud ComputingMySQL installationDownload, Install and Configure MySQLInstall MySQL WorkbenchDownload and restore sample Sakila DBQuizSection 5: What is Data and Database and RDBMS?How is data stored?How is data saved in MySQL (Linux)MySQL Storage engine and TypesWhat is a Table, COLUMN and ROW ?What is a Key?What is Primary Key, Foreign Key, Unique Key etc. What is a Transaction and ACID properties?Database Normalization AND its different formsCreate your first Database, Table and Populate table with dataQuizSection 6: SQL Statement and TypesDML Statement with examplesDDL Statements with examplesDCL Statements with examplesTCL Statements with examplesQuizSection 7: Create TABLE(s) and Temp Table(s)SELECT Statement in detailOperators, Expressions and ConditionsWHERE Clause, ORDER BY, HAVING BY, GROUP BY ClauseSelect from two tables - JOINS and different Types of JOINSWhat is a Sub Query?INSERT, UPDATE, and DELETE statementsLoad data from a CSV file to MySQL and vice versaStored procedureWhat is view, function, trigger and indexClustered, non-clustered Indexes and Index Design considerationsINDEX Cardinality, Table Fragmentation, USE INDEX, FORCE INDEX and LABQuizSection 8: MySQL Architecture OverviewMySQL Programs and invocationSpecifying Program Options and Option FilesHow to edit the configuration file (. cnf)Options scopeWhat options are in affect?QuizSection 9: MySQL Backups, why we need backup, RTO and RPOType of Backups in MySQL, offsite storage, encryption and restore testingBinary logsThe mysqldump utilityRestore of database using mysql and WorkbenchTable level Backup and RestorePoint In Time Recovery in MySQLXtraBackup Utility by Percona, Functionality and InstallationFull Backup and Restore using Percona XtraBackupLab for mysqldump and Backups using MySQL WorkbenchIncremental Backup and Restore using Percona XtraBackupSchedule backups (cronjobs)QuizSection 10: Understanding MySQL SecurityRoot User in MySQLCREATE USER and ALTER USER StatementCreate New User (MySQL Workbench)MySQL Privileges , Privileges Control and Some important Privileges in MySQLGRANT Statement , WITH GRANT Option and Granting Privileges to MySQL UserGRANT Tables and Checking PrivilegesREVOKE Statement and Revoking PrivilegesDROP USER StatementRoles in MySQLQuizSection 11: MySQL Server Performance Monitoring BasicsThe General Query LogThe Slow Query LogThe Error LogOptimizing configuration for MySQL performanceDB Engine StatusQuery Optimization TIPS, EXPLAIN Statement and Execution PlansQuery Optimization DemoQuizSection 12: MySQL Replication and its AdvantagesMySQL Replication MethodsSynchronization TypesReplication FormatsMySQL Replication Setup DemoQuiz...

4. Full Oracle Database Administration with RAC

4.4

(296)

Hello there, Welcome to the Full Oracle Database Administration with RAC course. Learn Oracle Database Administration, 12C R2 RAC Administration, Oracle Backup and Recovery concepts in this courseWe prepared this course of Oracle Database which includes not only database administration but also RAC (Real Application Clusters). While preparing the course, we first covered the basic issues of database management.  Then you will find a detailed explanation of Backup and Recovery concepts in Oracle as a part of database administration. Oracle database administration, oracle rac, oracle dba, rac, oracle, database administration, oracle database, oracle rac 12c, oracle 19c database administration, oracle 12c database administration, oracle golden gate, oracle 12c rac, oracle administrationBackup and recovery is a life-saving topic for DBAs so we tried to explain this topic as detailed as possible. Finally, you will see the administration of the RAC database system.  You can run two or more servers on a database as if one server by using RAC.  You will set up a two-node cluster database during the course. Then you will see many hands-on practices to administer the RAC environment. Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for enterprise resource planning (ERP). Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data. In this course, you will learn everything with hands-on practices.  I'll also teach you the best practices and shortcuts. All my students will have a chance to learn not only the whats but also learn the whys and hows. One of the things you will learn in this course Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files. RMAN also reduces the administration work associated with your backup strategy. RMAN keeps an extensive record of metadata about backups, archived logs, and its own activities, known as the RMAN repository. In restore operations, RMAN can use this information to eliminate the need for you to identify backup files for use in restores in most situations. You can also generate reports of backup activity using the information in the repository. Fresh ContentOracle is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. But DBAs also should aware of the recent development and it's no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it's crucial to stay on top of the latest knowledge. With this course, you will always have a chance to follow the latest trends. In this course you will learn;Downloading Oracle Software, Database and RDBMS Concepts, DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ), Retrieving Data, Restricting And Sorting Data, Using Single-Row Functions and Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using The Group Functions, Defining Table Joins and Displaying Data from Multiple Tables, Using Subqueries, Using The Set Operators, Schema Objects And Managing Schema, Controlling User Access, Manipulating Large Data SetsWhat is RAC ( Real Application Cluster )Installing Oracle VirtualboxSetting Up Oracle Enterprise LinuxInstalling Oracle SoftwareOracle RACCreating Virtual MachinesInstalling Oracle RAC Database to VMsInstalling Grid Infrastructure, Database Software, and Creating DatabaseAdminister Database Instances and Cluster DatabasesOracle RAC One NodeHow to Convert RAC Database to RAC One NodeWorkload ManagementMonitoring PerformanceDesign and Deployment TechniquesCloning Oracle RACManaging backup, and restoring cluster databaseAdd and Delete Node From ClusterBackup and recovery concepts in OracleSetting up the laboratory environmentCreating and managing the recovery catalogUsing flashback Technologies in OracleBacking up the databaseReporting on RMAN operations. Managing RMAN backupsUsing Data Recovery Advisor of OracleRestoring and recovering database and database objects. The point-in-time recovery concept in Oracle will be crystal clear for you. Managing Physical Standby DatabaseBasic usage of Data Guard Broker UtilityCreating and managing snapshot databasesSwitchover and failover operations on physical standby database via both SQLPlus and Data Guard BrokerCreating Far Sync InstanceConfiguring primary and standby databases for far sync instanceCreating Logical Standby databaseManaging Logical Standby databaseSwitchover and failover operations on logical standby database via both SQLPlus and Data Guard BrokerWhy would you want to take this course?Our answer is simple: The quality of teaching. When you enroll, you will feel the OAK Academy`s seasoned developers' expertise. No Previous Knowledge is needed! This course will take you from a beginner to a more experienced level. If you are new to Oracle Database or have no idea about what a DBA does no problem, you will learn anything you need to start Oracle Database. If you are a DBA or familiar with the Oracle Database / Oracle SQL  and you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples. What is oracle SQL?SQL stands for Structured Query Language-the language developers use to interact with databases to create, read, update, and delete database records and manage other aspects of those databases. ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language. Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system. This RDBMS was released as the first commercially available relational database management system in 1977 and holds the top market share worldwide for relational database management systems. Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language. What careers use Oracle SQL?Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle database management system. But SQL dialects are pretty similar, and knowledge of Oracle SQL can apply to many types of relational databases and doesn't limit you to Oracle. Database developers also use Oracle SQL all day long to create new databases and table structures. Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently. Data scientists must access data to create machine learning models and find trends, and a lot of this data will get stored in databases that require a knowledge of SQL to retrieve and transform. Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage. What skills should I have before learning Oracle SQL?There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English. Most people can understand what a SQL query is trying to do before they even know the language. All you need is an interest in the language and a commitment to learning. That said, some things could help with your Oracle SQL education if you are already familiar with them. If you are familiar with Excel spreadsheets and understand how columns and rows work, you can apply that knowledge to Oracle database tables. It also helps to know at least the concepts of how a relational database management system works. Also, if you already know a programming language, that will help learn Oracle's extended features like PL/SQL. Video and Audio Production QualityAll our content is created/produced as high-quality video/audio to provide you the best learning experience. You will be, Seeing clearlyHearing clearlyMoving through the course without distractionsYou'll also get: Lifetime Access to The CourseFast & Friendly Support in the Q & A sectionUdemy Certificate of Completion Ready for DownloadDive in now! We offer full support, answering any questions. See you in the course!...

5. MongoDB: A Complete Database Administration Course

4.1

(272)

MongoDB is one of the leading NO-SQL database. MongoDB is designed for handing  high volume data , while providing high performace. Most courses available in the market are designed for developers and has very less course for database admistrators, especially for those who comes with RDBMS background. This course tries to fill that gap. This course on MongoDB administration is designed for DBAs, escpecially for those who comes with RDBMS backgroud. I have tried to include almost all the common administrative tasks performed by DBAs on a daily basis. In this course, you'll learn all about MongoDB Administration from scratch. No prior MongoDB  experience is required!.  But refreshing your unix skills will give added advantage. You will find this course more  enagaing if you are database administration working on RDBMS liks Oracle , SQL Server, Db2, PostgreSQL etc. This course is covered with Udemy's 30 days refund policy , so you can try this course risk-free. We will  be covering the following topicsInstallation and configuration of mongoDBDatabase Creation and ManagementCRUD oprations ie Data insert/select/Update/Delete Operations Securing MongoDBAuthentication and AuthorizationAuditing Backup and RecoveryDisaster Recovery  & High AvailabilityReplicationSharding or distributed data managementEnabling Journelling & EncryptionCommon day to day  database administration activitiesThis course is a hands-on course - you'll learn by writing  commands. But to make certain concepts clear , I have included theory classes as well. I am sure that you will find this combination of theory and practical as engaging.  This course is for you.. If you are absolutely new to MongoDBYou have some basic understanding on mongoDB , but looking forward to learn in detailIf You are DBA working with RDBMS liks Oracle , SQL Server etc and want to learn MongoDB administration...

6. Oracle Database Administration for Absolute Beginners

4.3

(1,230)

(Update on 18-Nov-2015: Added additional lectures to keep this course updated with Oracle 12c Release 2. Also, if you just want to start with some basic theory before doing any hands-on lessons in here, please checkout the Section 'Concepts Illustrated' first.) 'Oracle Database Administration for Absolute Beginners' course explains about the basic concepts of Relational Database Management Systems (RDBMS). It will help you to become an Oracle Database Administrator(Oracle DBA). Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team. This course is absolutely for beginners. This is applicable for those who would want to learn Oracle Database 12c as well as Oracle Database 11g. This would be ideal for.. those who are already in IT and would like to jump into the world of Database Administration. college students who would like to learn about Database concepts so that they can achieve high grades in their RDBMS related curriculum. college students who would like to get into Oracle Database Administration as soon as they finish their college. fresh graduates who are looking for a job in the IT industry. anyone with the determination of getting into IT in order to have a better career. This course is mainly based on video lectures. However it also has theoretical sections for reference and LAB exercises for hands-on practice. The course has been structured to start with videos explaining basic database concepts. They provide simplified real world examples. Then it introduces Oracle Database Architecture. After that, it provides 'hands-on' video lectures about 'How to install Oracle Database 11g in your desktop or Laptop'. (In the bottom, there is also a section about 'How to install Oracle Database 12c' which is the newest version from Oracle as of now, which is Aug 2013). It then explains about various Oracle Internals such as Storage Structures, Memory Structures, Database Objects etc. Then it goes into operational aspects such as creating USERS, granting access, creating objects such as tables etc. After that it explains about Backup/Recovery concepts and Dianostic Data. Finally, there is a section of extensive video lectures about LAB sessions with examples. You can use those for hands-on practice, using the Database software that you would have installed (as explained in this course) in your PC/Laptop. I would like to thank you sincerely for reading this and wishing you all the best..! Sam Dhanasekaran p. s: This started as YouTube video series. I experimented having my own background music initially. Later I removed the music, based on user feedback. So pardon the background music please:-(...

7. PostgreSQL Database Administration (DBA) for Beginners

3.9

(464)

PostgreSQL is commonly known as Postgres and it is also  open source database. PostgreSQL is a powerful, open source object-relational database system. A database administrator's (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed. The PostgreSQL administration covers some of  the most important PostgreSQL database server administration activities. Some of the Key Responsibilities of a Database Administrator includes: Database ManagementDatabase Backup and restoreTablespace managementRole ManagementManaging users Securing database via proper role managementA DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more. The course also covers the basics of creating tables, storing data with data types, and working with expressions,  operators, and strings. Topics also includes: Installing PostgreSQLLoading sample databaseCreating database and tablesPerforming CRUD operationsJoining TablesUsing aggregate and analytic functionsCreating views and triggersThis is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL...

8. Become an Oracle Database Administrator (DBA)

4.2

(155)

Oracle Database Administrator's are in constant demand in the IT industry. The  rapid growth of data has fuelled the demand for database administrator's in general.  We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook, Instagram Whatsapp , Twitter and may more data rich applications. This course is designed for beginners who are considering a career as a database administrator. It will guide youthrough some of the tasks that an Oracle database administrator has to perform. Oracle DBA Responsibilities includes: Installing new versions of the Oracle database and its toolsInstalling tools  required to access the Oracle database. Shutting down and Starting the databaseBacking up and Recovering DataExporting and Importing DataManaging UsersManaging security of the databaseMonitoring the databaseCreating database objects like databases, tables and viewsCreate new database users as required. Upgrading the databasePlans and implements backup and recovery of the Oracle database. Assists with impact analysis of any changes made to the database objects. Provides technical support to application development teamsEnforces and maintains database constraints to ensure integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Troubleshooting  problems regarding the databases, applications and development tools. This course is a  practical hands-on workshop that will guide you through performing some of the task an oracle databaseadministrator performs. By the end of this course you will gain some useful skills that will give you enough confidenceto progress your journey towards becoming a database administrator. Looking forward to welcoming you to the course...

9. Oracle Cloud: Oracle cloud database administration

3.9

(99)

After completing this course  you will be become expert on the new features of Oracle 12c Release 2 and have hands on release experience in creating databases using the Oracle Cloud. 1-  How to Create new databases in the Oracle Cloud, start and stop Oracle database using the Oracle Cloud web interface.  2-  How to Hot clone PBDs without down time, flash back PBDs to a previous point in time, create automatically list partition tables and more. 3-  How to  resources management in oracle 12.2 database...

10. Oracle 11g 18c: Database Administration,Data Analysis

3.8

(102)

Oracle Database Administrator's are in constant demand in the IT industry. The  rapid growth of data has fueled the demand for database administrator's in general.  We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook, Instagram Whatsapp , Twitter and may more data rich applications. This course is designed for beginners who are considering a career as a database administrator. It will guide you through some of the tasks that an Oracle database administrator has to perform. Oracle DBA Responsibilities includes: Installing new versions of the Oracle database and its toolsInstalling tools  required to access the Oracle database. Shutting down and Starting the databaseBacking up and Recovering DataExporting and Importing DataManaging UsersManaging security of the databaseMonitoring the databaseCreating database objects like databases, tables and viewsCreate new database users as required. Upgrading the databasePlans and implements backup and recovery of the Oracle database. Assists with impact analysis of any changes made to the database objects. Provides technical support to application development teamsEnforces and maintains database constraints to ensure integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Troubleshooting  problems regarding the databases, applications and development tools. What is Oracle APEX?Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest. SQL is everywhere, and I'm not saying that because I want you to use it. It's just a fact. I bet you have some in your pocket right now. All Android Phones and iPhones.  SQL for several years and currently is the most in demand IT Skill requested by recruiters and employers. It is used anywhere there is a database present.  It runs banks, hospitals, universities, governments, small businesses, large ones, just about every computer and every person on the planet eventually touches something running SQL. SQL is an incredibly successful and solid technology that has been around for years and will be here for a long time to come. By learning SQL, you actually will learn important theoretical and practical concepts that apply to nearly every data storage system past and present. SQL Skills will greatly improve your job prospects either as a contractor or full time employment. It is a useful skill that is always in demand due to its usefulness. It's everywhere there is a database. The skills you learn on this course will be enough to confidently work as an SQL professional. The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data-from electronic medical records to customer transaction histories-lives in organized collections of tables called relational databases. To be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL. This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle...

11. Full Oracle Database Administration With High Availability

4.4

(176)

Hey there, Welcome to my Full Oracle Database Administration With High Availability course. Oracle Database Administration, Oracle DBA, Oracle 12C RAC, Oracle Database 12C R2 Backup and Recovery, Oracle RMANThis course is a complete set of Oracle Database Administration with High Availability. Oracle database administration, oracle RAC, oracle dba, database administration, oracle, oracle 12c database administration, rman, oracle database, oracle rman, rac, oracle database rac administration, oracle RAC 12cThrough this course, you will learn all the features of High Availability and will become an expert in Oracle Database Administration. We gathered all the subjects like Oracle DBA, Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard, and all High Availability features that you need to know about Oracle Databases in the real world in one course. If you say I want to specialize in the database and want to learn database subjects in every aspect, you are at the right place! In the course, you will have down-to-earth way explanations with hands-on examples. During the course, we focus more on the practical side of Oracle Databases. All my students will have a chance to learn not only the whats but also learn the whys and hows. This course starts with the very basics. First, you will learn how to install the tools. Then the show will start and we will start with introducing the Oracle Database architecture, this course will take you all away from performing basic database operations up to implementing advanced operation options. Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for enterprise resource planning (ERP). Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data. At the end of the course;DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ), Retrieving Data, Restricting And Sorting Data, Using Single-Row Functions and Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using The Group Functions, Defining Table Joins and Displaying Data from Multiple Tables, Using Subqueries, Backup and recovery concepts in OracleSetting up the laboratory environmentCreating and managing the recovery catalogUsing flashback Technologies in OracleBacking up the databaseReporting on RMAN operations. Managing RMAN backupsUsing Data Recovery Advisor of OracleRestoring and recovering database and database objects. The point-in-time recovery concept in Oracle will be crystal clear for you. What is RAC ( Real Application Cluster )Creating Virtual MachinesAdminister Database Instances and Cluster DatabasesOracle RAC One NodeHow to Convert RAC Database to RAC One NodeWorkload ManagementMonitoring PerformanceDesign and Deployment TechniquesCloning Oracle RACManaging backup, and restoring cluster databaseAdd and Delete Node From ClusterWhat is DataguardCloning Virtual MachinesInstalling Database Software and Creating DatabaseCreating Physical Standby DatabaseManaging Physical Standby DatabaseBasic usage of Data Guard Broker UtilityCreating and managing snapshot databasesSwitchover and failover operations on physical standby database via both SQLPlus and Data Guard BrokerCreating Far Sync InstanceConfiguring primary and standby databases for far sync instanceCreating Logical Standby databaseManaging Logical Standby databaseOracle Database AdministrationOracle RACOracle DBAOracle 12c Database AdministrationOracle RMANWhat is Oracle SQL?SQL stands for Structured Query Language-the language developers use to interact with databases to create, read, update, and delete database records and manage other aspects of those databases. ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language. Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system. This RDBMS was released as the first commercially available relational database management system in 1977 and holds the top market share worldwide for relational database management systems. Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language. What careers use Oracle SQL?Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle database management system. But SQL dialects are pretty similar, and knowledge of Oracle SQL can apply to many types of relational databases and doesn't limit you to Oracle. Database developers also use Oracle SQL all day long to create new databases and table structures. Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently. Data scientists must access data to create machine learning models and find trends, and a lot of this data will get stored in databases that require a knowledge of SQL to retrieve and transform. Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage. What skills should I have before learning Oracle SQL?There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English. Most people can understand what a SQL query is trying to do before they even know the language. All you need is an interest in the language and a commitment to learning. That said, some things could help with your Oracle SQL education if you are already familiar with them. If you are familiar with Excel spreadsheets and understand how columns and rows work, you can apply that knowledge to Oracle database tables. It also helps to know at least the concepts of how a relational database management system works. Also, if you already know a programming language, that will help learn Oracle's extended features like PL/SQL. Fresh ContentOracle is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. And this course introduces all the Oracle Database High Availability features fundamental to managing Oracle Database and designing a backup and recovery. Why would you want to take this course?  Our answer is simple: The quality of teaching. When you enroll, you will feel our seasoned developers' expertise.  Step-by-Step Way, Simple and Easy With Exercises By the end of the course, you'll have a firm understanding of the Oracle Database in all aspects and valuable insights on how things work under the hood and you'll also be very confident, and hungry to learn more. Video and Audio Production QualityAll our videos are created/produced as high-quality video and audio to provide you the best learning experience. You will be, Seeing clearlyHearing clearlyMoving through the course without distractions You'll also get: Lifetime Access to The CourseFast & Friendly Support in the Q & A sectionUdemy Certificate of Completion Ready for DownloadDive in now to our Full Oracle Database Administration With High Availability courseWe offer full support, answering any questions. See you in the course!...

12. Oracle Database Administration from Zero to Hero

4.8

(84)

Do you want to be a professional Oracle database administrator DBA but you do not know how to start? I have been providing courses for Oracle DBAs since 2016. This training experience, combined with my more than 20 years of Oracle DBA experience, inspired me to create this thorough course for beginners who wish to learn Oracle database administration professionally. Whatever degree of Oracle database knowledge you have, this course starts you from scratch and develops your abilities all the way to the professional level. It provides in-depth explanations of the principles while also placing a significant emphasis on their application in like-real-world situations. You'll create a virtual environment on your computer that resembles the real world systems. You will have a lot of practical expertise carrying out Oracle DBA duties on Linux and Windows platforms. With all the practical exercises, students can download the step-by-step documents so that they can easily implement the exercises in their own environment. Furthermore, the practical lectures are supported by videos that demonstrate how to implement the practices. I will be available to support you and assist you in overcoming any challenges you may encounter if, for whatever reason, you had trouble implementing any practice. By the end of this course, you should have the following skills: Create Oracle databases, Implement Oracle database backup and recovery plans, Administer Oracle database storage, Apply patches and upgrade Oracle databases, Manage Oracle database multitenancy, Troubleshoot Oracle database issues, Deploy Oracle Restart configuration, Perform fundamental Oracle database performance tunning tasks. By getting into this course, you can be rest assured that the course is carefully developed. There are explanatory animations that describes all the difficult concepts and the videos include the latest versions of Oracle database. Although the course practices is built on Oracle database 19c, the curriculum takes into considerations the major differences between the releases 11g, 12c R1, 12c R2, 18c, and 19c. In addition to that, you will experience upgrading the 19c database to release 21c. Starting with introducing RDBMS in general and Oracle, this course will cover all the topics that you need in your journey to become a DBA, like the following: Oracle Database installation and creationOracle database basic administrationManaging database users and securityDatabase connectivityManaging Oracle database multitenancyBackup and recoveryPatching and upgradeOracle automatic storage management (ASM)Do not waste your time watching Youtube videos that just leave you confused or uncertain if you reach to your goal or not. Do not waste your money on attending pricey courses that will set you back a fortune. The content offered in this course are identical to, or even superior to, the courses offered for corporate. Do not pass up this chance to enroll into this course if you want a solid learning route to become a skilled Oracle DBA!...

13. Oracle Database Administration Workshop ( 12c and Higher)

4.7

(2,158)

This Course is one of the best courses ever in Oracle Administration (12c, 18c, 19c ). Be ready to become very good Oracle DBA after finishing this course. The course is more than 27 Hours of HD videos. Very helpful course for exam 1Z0-072 or 1Z0-082. All the presentations , PDFS and scripts are available for download. my courses are the best seller and the highest rated in udemy, i do not create content that you find it easily in free websites and YouTube. The course start from zero knowledge in Oracle Administration , but remember that SQL is a must. simply this course is the best...

14. Oracle Database RAC Administration (12c and 19c)

4.4

(962)

Learn how to build and manage Oracle RAC databases (including releases 12c and 19c) of types: administrator-managed, policy-managed, CDB and RAC One node. Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them. Describe Oracle RAC database architecture   Install and create Oracle 12c and 19c RAC database    Perform the administration tasks on Oracle RAC    Manage backup and recovery in Oracle RAC    Monitor and tune Oracle RAC databases    Manage dynamic database services    Implement load balancing, TAF, FAN, and application continuity     Apply patch sets on Oracle RAC   Upgrade Oracle RAC    Create and manage the following:    Oracle RAC One Node databases    Oracle RAC CDB databases    Oracle Policy-managed RAC databases    Describe Oracle Flex ClusterRemove and Add a node to an Oracle cluster  Content and Overview Information presented in this course provides Oracle Database Administrators the knowledge  and experience to manage Oracle 12c and 19c RAC databases, including administrator-managed, policy-managed, CDB and RAC One node databases. Through this extensive course of good 58 lectures and more than 18 hours of video-based sessions, you'll learn all of the managing Oracle 12c RAC databases. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents. Starting with introducing the Oracle RAC Architecture, this course will take you all the away from creating Oracle 12c and 19c two-node RAC databases on a Linux platform of any type: administrator-managed, policy-managed, and CDB, performing administration tasks on Oracle RAC databases, managing backup and recovery in Oracle RAC, managing dynamic database services, implementing load balancing, TAF, FAN, and application continuity, applying patch sets on Oracle RA, upgrading Oracle RAC, and understanding Oracle Flex Cluster. This is an opportunity for the students to gain practical experience on this Oracle cutting-edge technology without the need for complex hardware components. Upon completing this course, you will be able to build up an Oracle 12c and 19c RAC database and have the knowledge and experience to manage it. Join the author in this learning journey to experience this amazing technology!...

15. Oracle Database Multitenant Administration (12c to 19c)

4.6

(499)

Learn how to build and manage Oracle Multitenant Architecture (including releases 12.1, 12.2, 18c, and 19c)Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them. Describe the Oracle multitenant architectureCreate multitenant container databaseCreate a pluggable database using different methods: Creating a PDB from the seedCloning PDBs from local or remote PDBs including the refreshable PDBsPlugging in an Unplugged PDBRelocating a PDBCreating a PDB from a non-CDB databaseCreating Proxy PDBsManage the security in a multitenant container: Create and manage common and local user accounts and rolesManage PDB lockdown profilesPerform backup and recovery, PITR and flashback database in a multitenant containerUse the Resource Manager in a multitenant containerUse Data Pump utility with PDBsManage the applications, application containers, application PDBs, and common objectsManage Oracle database 18c and 19c multitenant new features: Manage CDB fleetManaging a PDB Snapshot CarouselSwitching Over a Refreshable Clone PDBPDB Cloning and Relocation using DBCAContent and Overview  Information presented in this course, will get the Oracle Database Administrators ready for the next generation of Oracle database. Through this course of 72 lectures and more than 13 hours of video-based sessions, you'll learn all of the managing Oracle Multitenant Architecture. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents. Starting with introducing the Oracle Multitenant Architecture, this course will take you all the away from creating an Oracle 12c multitenant CDB container on a Linux platform, creating new PDBs using all the possible methods of creating them, managing the security in a multitenant container,  implementing the backup and recovery, flashback database, PITR, using the Resource Manager, applying the auditing policies, using the data pump utility, up to managing the applications, application containers, and common objects. The course will cover the multitenant capabilities in the releases: 12.1, 12.2, 18c, and 19c. This is an opportunity for the students to gain practical experience on this new Oracle cutting-edge technology, and get themselves ready for managing Oracle databases on the cloud. Upon completing this course, you will be able to build up an Oracle multitenant container and have the knowledge and experience to manage it. Join the author in this learning journey to experience this amazing technology!...

16. Oracle Database: Oracle 12C R2 RAC Administration

4.3

(252)

Hello there, Welcome to the Oracle RAC: Oracle Database 12C R2 RAC Administration online course. Oracle Database, 12C R2 RAC Administration and become a RAC expert with Oracle DBA `s favorite online RAC courseAre you a junior Oracle DBA?Are you a DBA who is managing other RDBMS and want to immigrate to Oracle?  orDo you want to become an Oracle DBA at an international company?If you think so, you are at the right place. Oracle database administration, oracle dba, oracle, oracle sql, oracle database, oracle rac, sql, exadata, dba, database administrationThis time I've designed for you Oracle RAC: Oracle Database 12C R2 RAC Administration" straightforward course for the Oracle Database 12C Release 2 (12.2). In the course, you will have a down-to-earth way explanations with hands-on examples. With my course, you will learn Oracle RAC step-by-step. I made RAC simple and easy with real-life examples. This course is expertly designed to teach everyone from complete beginners, right through to professionals ( as a refresher). In this course you will learn;What is RAC ( Real Application Cluster )Installing Oracle VirtualboxSetting Up Oracle Enterprise LinuxInstalling Oracle SoftwareOracle RACCreating Virtual MachinesInstalling Oracle RAC Database to VMsInstalling Grid Infrastructure, Database Software, and Creating DatabaseAdminister Database Instances and Cluster DatabasesOracle RAC One NodeHow to Convert RAC Database to RAC One NodeWorkload ManagementMonitoring PerformanceDesign and Deployment TechniquesCloning Oracle RACManaging backup, and restoring cluster databaseAdd and Delete Node From ClusterOracleOracle DatabaseOracle Database AdministrationOracle RacOracle Rac 12cWhy would you want to take this course?Our answer is simple: The quality of teaching. When you enroll, you will feel the OAK Academy`s seasoned developers' expertise. This course will take you from a beginner to a more experienced level. If you are a DBA or familiar to the Oracle Database / Oracle SQL or if you want to become an Oracle DBA at an international company oryou are a DBA that manage other RDBMS and want to immigrate Oracle or you are already in the field and active RAC user but you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples. Fresh ContentOracle RAC is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. But DBAs also should be aware of the recent development and it's no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it's crucial to stay on top of the latest knowledge. With this course, you will always have a chance to follow the latest trends. Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for enterprise resource planning (ERP). Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data. What is Oracle SQL?SQL stands for Structured Query Language-the language developers use to interact with databases to create, read, update, and delete database records and manage other aspects of those databases. ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language. Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system. This RDBMS was released as the first commercially available relational database management system in 1977 and holds the top market share worldwide for relational database management systems. Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language. What careers use Oracle SQL?Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle database management system. But SQL dialects are pretty similar, and knowledge of Oracle SQL can apply to many types of relational databases and doesn't limit you to Oracle. Database developers also use Oracle SQL all day long to create new databases and table structures. Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently. Data scientists must access data to create machine learning models and find trends, and a lot of this data will get stored in databases that require a knowledge of SQL to retrieve and transform. Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage. What skills should I have before learning Oracle SQL?There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English. Most people can understand what a SQL query is trying to do before they even know the language. All you need is an interest in the language and a commitment to learning. That said, some things could help with your Oracle SQL education if you are already familiar with them. If you are familiar with Excel spreadsheets and understand how columns and rows work, you can apply that knowledge to Oracle database tables. It also helps to know at least the concepts of how a relational database management system works. Also, if you already know a programming language, that will help learn Oracle's extended features like PL/SQL. Video and Audio Production QualityAll our content is created/produced as high-quality video/audio to provide you the best learning experience. You will be,· Seeing clearly· Hearing clearly· Moving through the course without distractionsYou'll also get: Lifetime Access to The CourseFast & Friendly Support in the Q & A sectionUdemy Certificate of Completion Ready for DownloadDive in now! We offer full support, answering any questions. See you in the course!...

17. Complete Oracle Database Administration course (19C,21C)

4.4

(1,277)

After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career. You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real world production scenario ( in 99% there is no GUI on production servers ). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup & Recovery section of the course. We don't forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments. According to the U. S. BUREAU OF LABOR STATISTICS employment of database administrators is projected to grow 15 percent from 2019 to 2029, much faster than the average for all occupations. Growth in this occupation will be driven by the increased data needs of companies across the economy. After the pandemic the demand doubles. There is a lack of DBAs even in the Oracle itself! Follow my Instagram page - @it. rockstars, where I post new opening positions on a regular basis. The long-term support Oracle Database 19c version was chosen for this course to teach you the database administration skills. It provides the highest level of release stability and longest duration of support and bug fixes, giving you the most stable platform for your applications. At the end of the course we will learn different ways to Upgrade from the 19c to 21c version. Upgrades are crucial to satisfy business high growing demands for the new features released in the new product versions. All operation manuals provided for the 19c version still work on 21c...

18. Advanced SQL Database Administration with MySQL Workbench

4.7

(640)

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you'll take your database administration skills to the next level, expanding into advanced concepts like replication, automation, and database security. We'll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we'll work through more advanced concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events. Throughout the course, you'll be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments. 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. Importing Data to the Database We'll quickly review some basic concepts like creating, inserting, and deleting records. Then we'll learn how to tackle large data imports with ease, using the table data import wizard. We'll be using this handy tool throughout the course. You will construct and populate a database from the ground up as the business grows, just like a real DBA as part of the course project. Altering, Updating & Mapping KeysWe'll briefly review critical concepts like altering tables and updating records, discuss the ins and outs of primary and foreign keys, and from there you'll jump right into your assignments and quizzes for this section. Replication, Backup & RecoveryHere we'll introduce the critical DBA concepts of replication, backup and recovery. We'll discuss the various benefits of replication, different methods of backing up your databases, and you'll learn how to restore your data should the need arise. This is getting into some pretty serious stuff! ***MID-COURSE PROJECTYou will need all of the skills you've learned so far to complete this hands on mid-course project. You'll help your CEO by enhancing the data structure to accommodate changing business needs, and insert new data into various places within your database. Trigger AutomationHere we'll dive into one of the most powerful automation tools you'll use as a DBA... triggers! You'll learn how you can create triggers to look for changes in the database via create, update, and delete statements, and then automatically enact changes on one of more of your tables. Triggers will be your best friend as a DBA, and can be extremely handy for Analysts to understand as well. Creating ViewsSometimes you don't need to create a table, and a view (aka a virtual table) is a better option. We'll walk through what views are, how you create them, and some of the major benefits of using views in certain situations. The EER Diagram EditorOne of the best tools at your disposal for understanding your database and communicating its structure to others in your organization is leveraging EER Diagrams. We'll review some of the basics that we discussed in the Beginner course, and we'll also learn how to use the EER Diagram Editor to reverse engineer your schema, which is an extremely handy tool! Stored Procedures & Scheduled EventsNext, we'll dive deeper into automation by learning how to create stored procedures and scheduled events. If you liked triggers, you're going to love these! You can use stored procedures to simplify your processes, make your code more modular and easier to understand, and centralize certain parts of complex queries that you can leverage throughout your organization. Scheduled events will allow you to run one-time or recurring processes on your database, which you can schedule on whatever cadence you want. These are really fun! Automating Data from Website ActivityHere we'll be talking about the different types of data businesses typically track from their website activity, including traffic source data, on-site behavior, product purchases, and more. We'll discuss the various methods used to capture the various data types, and discuss the DBA's role in partnering with Engineering to make sure this is all working as it should. Database SecurityIn the last section before the final project, we'll discuss some of the most common types of database security threats you should be aware of as a DBA, as well as security best practices to mitigate your risk. Again, we'll discuss the DBA's role in the organization, how a DBA will partner with Engineering here, and who typically owns what. ***FINAL COURSE PROJECTThis hands-on project will test all of your DBA skills. You will need to alter tables, import lots of data, design an optimal structure for an entirely new set of tables for a new business initiative, create an EER Diagram describing your new tables, and then you'll actually create them. After that, you'll need to create a stored procedure and a view, which will both used for reporting on the new data the company will be collecting. Finally, you'll need to come up with a comprehensive security plan to make sure your organization is aware of threats and following best practices. I know this sounds like a lot, but at this point you'll be ready for it! IMPORTANT NOTE: This course does NOT go deep on 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:8 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 unique and engaging way to develop advanced MySQL database administration skills, 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...

19. Complete Microsoft SQL Server Database Administration Course

4.5

(4,993)

Microsoft SQL Server continues to be one of the world's most popular and top databases.  Database is a heart of IT which is needed to stored all critical data and information.  If you want to become SQL database administrator then this is the course for YOU. This training course will provide you all the necessary skills you need to be a successful database administrator.  Plus, this course will prepare you for the SQL Server MCSA certification. Here is the course outline: Section 1 - IntroductionIntroduction to DatabaseRDBMSWhat is SQL?Top 5 RDBMSIntroduction to MS SQL ServerDifferent editions of MS SQLSection 2 - Download, Install and Configure WindowsMS SQL Server prerequisiteLab setupWhat is virtualization?Download and Install VMWare Workstation PlayerOptional - Download and Install Oracle VirtualboxCreate a Virtual MachineDownload and Install Windows ServerVirtual Machine ManagementSection 3 - Download, Install and Configure MS SQL ServerPrerequisites for MSSQL InstallationDownload MSSQL and SQL Server Management StudioInstall and Configure MSSQLInstall SQL Server Management StudioDownload and Install AdventureWorks DatabaseSection 4 - Database Fundamentals and DesignWhat is Data and Database?How is data stored?What is a Table, COLUMN and ROW ?What is a key? primary, foreign, unique keys etc. What is Relational Database and Relational Database Management System (RDBMS)?What is a Transaction and ACID properties?Database Normalization AND Different forms of Database NormalizationCreate your first Database, Table and Populate table with data…Section 5 - Introduction to SQL CommandsWelcome to Basic SQL CommandsWhat is a SQL Statement and types of SQL statementsDML Statement with examplesDDL Statements with examplesDCL Statement with examplesTCL Statement with examplesSection 6 - Query and Manipulation of Data using SQLCreate TABLE(s) and Temp Table(s)What Is a View?SELECT Statement in detailOperators, Expressions and ConditionsWHERE Clause, ORDER BY, HAVING BY, GROUP BY ClauseSelect from two tables - JOINSDifferent Types of JOINSWhat is a Sub Query?INSERT, UPDATE, DELETE and Truncate StatementsWhat is a Store Procedure?Function, Trigger and INDEXClustered , Non-clustered Indexes and Index Design considerationsIndex Fragmentation and Lab for IndexSection 7 - Microsoft SQL Database AdministrationOverview of MSSQL Management ToolsExploring SQL Server Management Studio (SSMS)Exploring SQL Server Configuration ManagerMSSQL System Databases, DO's and DONT's of System databasesWhat is master, etmpdb, msdb and other system databases?Section 8 - Deep Dive into MSSQL WorkingWhat are Pages , Extents, Page Architecture and PFS?MSSQL ArchitectureMSSQL Database ArchitectureOperation and working of transaction logConfiguring user DatabaseBest practices while creating user DatabaseSection 9 - MSSQL Backup and RestoreBackup of a Database, Importance for DBA and Different Media used for BackupsRecovery Models in MSSQL and how that impact backups an restoreFull and differential backupsTransaction Log Backups, Log Backup Chain and Tail-log BackupLab for Full, Differential and Transaction Log BackupsRestore and Recovery OverviewFull, Differential and Transaction Log database restorePoint in time restore of a databaseComplete Backup , Restore and Restore in Time LabMS SQL Server DBCC CHECKDB commandPage Level Restore / Recovery using Full BackupsCreating Maintenance Plan Backups/Re-indexing etc. Section 10 - MSSQL User ManagementMSSQL Security ModelMSSQL Server Authentication ModesServer LoginsServer RolesDatabase UsersDatabase RolesPermissions (GRANT , DENY, and REVOKE)Section 11 - MSSQL Server Agent ManagementSQL Server Agent IntroductionSQL Server Agent Jobs and SchedulesAgent AlertsOperatorsDatabase MailActivity MonitorSection 12 - Advanced SQL Server Administration TopicsHigh Availability and its TypesWhat Is Replication and Transactional ReplicationTransactional Replication Setup (LAB)Log Shipping and Configuring Log ShippingSQL Server Encryption and Encryption TypesTransparent Data Encryption (TDE) and configurationSection 13 - Course Re-capCommands we have learned...