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!

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

In this course we will build a simple application to show how to perform full CRUD (create, read, update, delete) operations within Node.js.

We'll be using the Node module MongooseJS. Mongoose allows us to define our models in the form of a schema, along with a simple to use API that abstracts away a lot of the pain of working directly with the MongoDB driver.

First, we will create a Book schema using MongooseJS. We will use string data types to add a title, author and description. Next, we will build a simple server using Express.js. Then we will build 4 routes to query, update and delete Books from our Schema. We will use Postman to perform actions on these routes and check the results in our browser.

What You Will Learn

• Build CRUD Applications
• Create Mongoose Schemas
• Design Routes using Express.js
• Create a Server using Express.js
• Build a RESTful API

This is a beginners level course to understanding the basics of what mongoDB is.

The intention of this course is to provide a foundational level knowledge of mongoDB so that you can start developing applications that require a database storage.

In this course we will cover:

• How to install mongoDB.

• How to create new collections that store documents.

• You'll learn about the most used mongo shell commands to manage your documents.

• We'll cover the different types of data that can be stored.

• You will gain confidence in how to Create, Read, Update and Delete data.

• Learn how to build models for the database in code using Mongoose Schemas.

• Learn how to query for specific data your looking for using $in.

Course Format:

You will be presented with slides and command line examples. This will help you to learn how to use local instances of mongoDB.

There will be a quiz at the end to help reinforce what you've learned.

This course is a brief presentation of SQL Server.

We will install SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at all the various programs that you can use:

1. SQL Server Management Studio (SSMS, which allows you to learn T-SQL and DBA)
2. SQL Server Integration Services (SSIS), which automates the conversion of data.
3. SQL Server Analysis Services (SSAS), which allows the creation of cubes, and
4. SQL Server Reporting Services (SSRS), which allows for the creation of reports.

We'll also look at some resources for learning these.

No prior knowledge is required - just a willingness to learn.

See you on the course.

This course introduces the student to Oracle WebLogic 12c. Students will learn skills necessary to understand basic WebLogic concepts and administrative tasks. At the end of this course the student will learn how to install WebLogic, create WebLogic domains, and administer WebLogic.

This course is geared toward administrators, developers, or architects who are looking to understand fundamental WebLogic concepts and how to spin up a WebLogic environment quickly.

Screencasts will be used so the student can follow along at home. There will also be lab exercises and a quiz that can be done by the student offline to further develop their skills.

Congratulations are in order for having chosen to pursue the path of the DBA. YOU'VE made an EXCELLENT decision and one that I have no doubt will be very rewarding should you so wish.

As with any serious endeavor, YOU want to give YOURSELF the very best possible start in order to ensure things can move forward.

This course focuses on what YOU need to know in order to become a REAL WORLD SQL Server DBA.

SQL Server is one of the most complicated software offerings Microsoft has. It requires YOU have a foundation in networks, databases and programming. This wide range of skills is often difficult to obtain without rigorous learning and years of hands on experience.

The REWARDS YOU will OBTAIN are worth effort. Here are just a few. DBAs are very well compensated. YOU will get to work with some of the SMARTEST people in the IT world. You'll LEARN something EVERY DAY. The profession has been and will continue to be one of the highest growth professions.

SQL Server Database Administrators are responsible for the design, implementation, support and maintenance of SQL Server Databases. The role also includes architecting, building and scaling databases for future data growth and capacity.

DBA are also responsible for security, performance and availability of data to users and customers.

This course will give you some direction on how to begin your journey as a SQL Server DBA. I don't want to create any false promises. In addition to years of experience most Senior Level SQL Server resources have read a voluminous amount of product related material.

WE have to start somewhere and THIS COURSE will provide you with the REAL WORLD insight YOU need in order to start your journey.

If YOU are seriously interested in either starting out on the path to becoming a SQL Server Database Administrator the YOU'LL need two key ingredients. Experience and product knowledge. Experience might not be easy to get but it will be impossible if you don't have a very solid foundation in SQL Server.

ENROLL now. Let's get started!!!

This course will cover Java SE 7 fundamentals and equip the students to find the OCA Java SE 7 Programmer certification (IZ0-803) easy to pass. This certification is hard to achieve without proper guide and teaching. I have organised this course from top to bottom approach which will start with variables and end with abstracts, interfaces and exceptions handling in java. By the end of this course, students will not just follow any java App course but would fully understand and easy to follow without looking on google for every single error. Remember, looking for errors to resolve takes hours of your valuable time.

This course is designed to point out key points in order to make it easy for students to pass the exam. OCA certificate is an achievement that should proud of and Employers respect the certification and you will be better equipped in the interview.

The course is organized in a way that you would easily follow without any extra animation to divert your attention from the course materials.

I have put a lot of questions during the lessons and made it clear why a particular question is right or wrong. Those questions are not easy but tricky and misleading and these are exactly the questions which makes you ready for exam.

I would strongly recommend that even if you are an experienced java programmer and would like to to pass the exam IZ0-803 then you have to follow each lesson step by step and would notice that a lot of question will be confusing without proper guide-lines and instructions.