Categories
All Tutorials SQL Tutorials

SQL Server Integration Services (SSIS) – An Introduction Course Catalog

SQL Server Integration Services (SSIS) – An Introduction Course Catalog

Learn the basics of SQL Server Integration Services (SSIS) – with Practical Activities. Useful for 70-763 certification.

What you’ll learn

SQL Server Integration Services (SSIS) – An Introduction Course Catalog

  • Do Extraction, Transform and Load (ETL) tasks.
  • You can use SQL Server tables, Excel spreadsheets and text files as your source.
  • You’ll be able to change data types, add columns, aggregate, split, sort and join
  • You can then view what has been created, and save it to spreadsheet, database tables, or the clipboard.

Requirements

  • You don’t need to have any prior experience with SQL Server.
  • You don’t even need to have it installed – we’ll install the full Developer edition for free on your Windows machine.
  • It would help if you have had some prior experience with T-SQL, but it is not essential.

Description

Reviews:

Instructor is easy to follow. He gives very clear examples. Course moves quickly enough to be engaging without skipping over material.” — Sarah Hale


This course works for me because it progresses with a level of detail that will be useful as I think through each step necessary to execute my own integration packages. There are several courses to choose from and I’m glad I chose this one.” — David McNickle

Very good introductory course. Didn’t really know what SSIS was until recently. Working through the course opened my eyes to past projects that would have benefited from an SSIS ETL package or two.” — Stephen Benton

Welcome to this course about SQL Server Integration Services.

In this course, you’ll be downloading and installing the latest 2016 SQL Server Developer – a full version for free so that you can use it on your machine. And previous versions of SQL Server Developer have previously retailed for around $100, and now it’s free.

So what is SSIS? It’s a way to automate in the importing and exporting and data – or ETL: extract, transform, and load. It’s a very visual part of SSIS, using tasks, components, and flowcharts, so it’s easy to learn the basics of it.





We’ll start by extracting some data, and then loading it into another table. I’ll take nice as slow as we start to introduce transformations, such as aggregation, a conditional split, merging, and auditing. There’ll be plenty of practice activities too, so you can get to practice your new-found skills. And if you are doing Microsoft certificates, it can help towards your 70-463 certification as well.

By the end of this course, you’ll be confident in using the main Data Flow components and Control Flow tasks, and would be able to use it in your own work.

Who this course is for:

  • You should take this course if you are not experienced in SSIS, or if you want to know what it is for.
  • SSIS is good for automating certain processes and is very visible.
  • It is great for beginners, and good if you have had a little prior experience.
  • As it is going through the basics, it is not useful if you commonly use SSIS.
  • It can help with your 70-463 certification.
  • Last updated 3/2020




Download Now
Content From: https://www.udemy.com/course/sql-server-ssis-an-introduction/



SEE MORE COURSE: Using Barcode Scanner in C# and SQL, SQL Server Database Course

Categories
All Tutorials SQL Tutorials

Learn MS SQL Server 2017 With Db Design Techniques Course Catalog

Learn MS SQL Server 2017 With Db Design Techniques Course Catalog

With real-time database designing techniques, SQL, Joins, SPs, Functions, Views, Transactions, Triggers and lot more…

What you’ll learn

Learn MS SQL Server 2017 With Db Design Techniques Course Catalog

  • By the end of this course, you will be in a position to do the following:-
  • Creating, Altering And Dropping DataBase Creating Tables
  • Primary Keys, Identity Columns and Unique Keys DataBase Diagram and Creating Relationships between tables
  • DataTypes In SQL Server
  • Insert Statement, Update Statement and Delete Statement
  • Select Statement with Top(), Order by, Where, in, not in, between, not between and Like Clauses, Aggregate Functions like Sum(), Avg(), Min(), max(), Count() etc.,
  • DateTime Functions Like getDate(), Day(), Month(), Year(), DateDiff(), DateAdd(), etc.,
  • Group By and Having Clause with Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join. Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
  • Creating Stored Procedures With No Input And Output Params Creating Stored Procedures With Input And No Output Params Creating Stored Procedures With Input And Output Params and Creating Functions

Requirements

  • Need MS SQL Server express of any version higher than 2005 installed on your system.

Description

Q: Is it possible for me to learn query writing against the MS SQL Server database, even if I don’t have any basics of DBMS?


A: Yes! you can learn and this course is perfect for those who are absolute beginners in MS SQL Server technology. In this course we are going to learn everything from scratch i.e., right from installing MS SQL Server Management Studio, creating a database, tables, understanding relationships, performing basic insert, update, delete and select operations, using basic built-in functions till all types of joins.

We will also understand how to write different kinds of stored procedures and user-defined functions. Then we will go for writing subqueries which include scalar, multi-valued and correlated subqueries.

Moving ahead we see the programming logic in query writing using T-SQL and understand how to write conditional statements in your large complex stored procedures. And finally, we will try to understand the advanced concepts like viewsscope identity functiontransactions, and triggers.

So, I ensure you that you will enjoy every minute of the videos by learning something new



Topics Covered are :

  • Introduction-Database-Table-Keys (36:14)
  • DataTypes-ForeignKey-DB design-Techniques (37:26)
  • Insert-Update-Delete-Select Start (37:42)
  • OrderBy-Where-String-Aggregate (48:11)
  • DateTime functions-GroupBy-IntroToJoins (40:46)
  • Implementing 2 And 3 Tables Joins (24:16)
  • SelfJoin-Union-Simple-Correlates-SubQueries (34:26)
  • Views And Common Table Expression (CTE) (31:25)
  • StoredProcedures-Functions (33:00)
  • Table Variables – Transactions – Slowly Changing Dimensions – ScopeIdentity (36:26)
  • Triggers – Admin Tasks – Assignment (34:00)

Who this course is for:

  • Fresh Graduates

Learn MS SQL Server 2017 With Db Design Techniques Course Catalog




Download Now
Content From: https://www.udemy.com/course/learn-ms-sql-server-from-scratch/



Categories
All Tutorials SQL Tutorials

The Complete SQL Bootcamp Course Catalog – Learn Complete SQL

The Complete SQL Bootcamp Course Catalog – Learn Complete SQL

Become an expert at SQL!

What you’ll learn

The Complete SQL Bootcamp Course Catalog – Learn Complete SQL

  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume

Requirements

  • No prior technical experience is required! All you need a computer!

Description

Learn how to use SQL quickly and effectively with this course!

You’ll learn how to read and write complex queries to a database using one of the most in-demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in-demand tech skills! In this course, you’ll learn quickly and receive challenges and tests along the way to improve your understanding!

Check out the free preview videos for more information!

Who this course is for:




Download Now
Content From: https://www.udemy.com/course/the-complete-sql-bootcamp/



Categories
All Tutorials Mysql Tutorials SQL Tutorials

SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

What you’ll learn

SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

  • Become an expert in SQL
  • Learn how to code in SQL
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with SQL databases
  • Start using MySQL – the #1 Database Management System
  • Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Adopt professionally tested SQL best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient SQL user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge
  • The freedom to query anything you like from a database

Requirements

  • No prior experience is required. We will start from the very basics

Description

How important is database management in the age of big data and analytics?

It is really important.


How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.

How many people have these skills?

Not enough.

This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $92,000! That’s a lucrative career. SQL – MySQL for Data Analytics and Business Intelligence – Web Courses

How come?   

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.

Worried that you have no previous experience?

Not an issue. We will start with the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.



Why take this course in particular? Isn’t it like the rest of the SQL courses out there?

We would like to think it isn’t. Our team worked hard to create a course that is:

  • Easy to understand
  • Time-efficient and concise
  • Shows how SQL can be crucial for data analytics and business intelligence
  • Comprehensive – it covers several topics not shown in other SQL courses
  • Practical – it teaches you how to work with a real-life database
  • Corresponds to professional best practices
  • Taught in MySQL – The most popular SQL database management system
  • Contains plenty of downloadable exercises, course notes, and quiz questions

Others haven’t. However, no one provides such a variety of topics in one place.

We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment. SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

We love teaching

So far, over 210,000 students have enrolled in our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the best content for you, our students.



Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.

So, why do you need to enroll in this course and learn SQL?

  1. Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how
  2. The profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come
  3. Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics

What about certificates? Do you provide a certificate?

Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.

Sounds awesome, right?

So, what are you waiting for? Click the “Take this course” button, and let’s begin this journey together!

Who this course is for:

SQL – MySQL for Data Analytics and Business Intelligence – Course Catalog




Download Now
Content From: https://www.udemy.com/course/sql-mysql-for-data-analytics-and-business-intelligence/



Categories
All Tutorials SQL Tutorials

Entity Framework in Depth: The Complete Guide Course Catalog

Entity Framework in Depth: The Complete Guide Course Catalog

Connect your applications to a SQL Server database

What you’ll learn

Entity Framework in Depth: The Complete Guide Course Catalog

  • Understand the di
  • differences between database-first and code-first workflows
  • Build a domain model using database-first workflow
  • Build a domain model using code-first workflow (with an existing or a new database)
  • Use code-first migrations to upgrade or downgrade your database
  • Override code-first conventions (using data annotations and fluent API)
  • Query data using LINQ (using query syntax and extension methods)
  • Use eager loading, lazy loading, and explicit loading effectively
  • Add, update and remove objects
  • Use additional tools to profile and troubleshoot your applications
  • Understand what the repository pattern is, what and if you need it, and how to implement it
  • Apply best practices with Entity Framework

Requirements

  • Good understanding of advanced C# constructs (generics, lambda expressions)

Description

In this course, Mosh teaches you the core concepts of Entity Framework through a series of clear, concise and hands-on lectures.




Whether you’re new to Entity Framework, or been using it for a while but are looking for a comprehensive course with a clean structure to fill the missing parts, you’re going to love this course.

By the end of watching this course, you’ll be able to:

  • Understand the differences between code-first and database-first workflows
  • Build a domain model using database-first workflow
  • Build a domain model using code-first workflow (with a new or an existing database)
  • Use code-first migrations to upgrade or downgrade your database
  • Override code-first conventions (using data annotations and fluent API)
  • Query data using LINQ (using query syntax and extension methods)
  • Use eager loading, lazy loading, and explicit loading effectively
  • Add, update and remove objects
  • Use additional tools to profile and troubleshoot your applications
  • Understand what the repository pattern is, why and when to use it and how
  • Apply best practices with Entity Framework

Unlike other books or courses that teach Entity Framework like a manual, Mosh walks you through real-world scenarios using his extensive experience in the field. Not only does he teach you the fundamentals of Entity Framework, but he’ll also teach you best practices along the way.





In each section, you’ll find exercises to help you reinforce the materials. Also, some sections include cheat sheets so you can quickly review what you learn in that section.

If you’re using an older version of Entity Framework, you can still take this course as long as your version of Entity Framework is 4.1 or higher.

PREREQUISITES

In order to take this course, you should have at least 3 months of experience programming in C#. If you need to strengthen your C# fundamentals, you can take Mosh’s related courses:

  • C# Basics for Beginners
  • The C# Intermediate: Classes, Interfaces, and Object-oriented Programming
  • C# Advanced

Who this course is for:

Entity Framework in Depth: The Complete Guide Course Catalog




Download Now
Content From: https://www.udemy.com/course/entity-framework-tutorial/



Categories
All Courses SQL Tutorials

The Complete SQL Bootcamp – Learn SQL Course Site

The Complete SQL Bootcamp – Learn SQL Course Site

Become an expert at SQL!

What you’ll learn

The Complete SQL Bootcamp – Learn SQL Course Site

  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume

Requirements

  • No prior technical experience is required! All you need a computer!

Description

Learn how to use SQL quickly and effectively with this course!

You’ll learn how to read and write complex queries to a database using one of the most in-demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in-demand tech skills! In this course, you’ll learn quickly and receive challenges and tests along the way to improve your understanding!

Check out the free preview videos for more information!

Who this course is for:

Categories
All Tutorials Java Tutorials MongoDB Mysql Tutorials React and Redux Tutorials SQL Tutorials

Java Programming for Complete Beginners Course Catalog

Java Programming for Complete Beginners Course Catalog

Learn Java Programming with 200+ code examples. For Absolute Java Beginners! Start Learning Java Programming Now!

What you’ll learn

Java Programming for Complete Beginners Course Catalog

  • You will Learn Java the MODERN WAY – Step By Step – With 200 HANDS-ON Code Examples
  • You will Understand the BEST PRACTICES in Writing High-Quality Java Code
  • Will Solve a Wide Range of Hands-on Programming EXERCISES with Java
  • You will Learn to Write AWESOME Object-Oriented Programs with Java
  • You will Acquire ALL the SKILLS to demonstrate an EXPERTISE with Java Programming in Your Job Interviews
  • Will learn ADVANCED Object-Oriented Programming Concepts – Abstraction, Inheritance, Encapsulation, and Polymorphism

Requirements

  • You have an attitude to learn while having fun 🙂
  • You have ZERO Programming Experience and Want to Learn Java

Description

Zero Java Programming Experience? No Problem.

Java is one of the most popular programming languages. Java offers both object-oriented and functional programming features.

We take a hands-on approach using a combination of JShell and Eclipse as an IDE to illustrate more than 200 Java Coding Exercises, Puzzles and Code ExamplesThis course assumes no previous ( beginner ) programming or Java experience. If you’ve never programmed a computer before, or if you already have experience with another programming language and want to quickly learn Java, this is a perfect course for you. Java Programming for Complete Beginners Course Catalog

In more than 250 Steps, we explore the most important Java Programming Language Features

  • Basics of Java Programming – Expressions, Variables, and Printing Output
  • Java Operators – Java Assignment Operator, Relational and Logical Operators, Short Circuit Operators
  • Java Conditionals and If Statement
  • Methods – Parameters, Arguments, and Return Values
  • Object-Oriented Programming – Class, Object, State, and Behavior
  • Basics of OOPS – Encapsulation, Abstraction, Inheritance, and Polymorphism
  • Basics about Java Data Types – Casting, Operators and More
  • Java Built-in Classes – BigDecimal, String, Java Wrapper Classes
  • Conditionals with Java – If Else Statement, Nested If Else, Java Switch Statement, Java Ternary Operator
  • Loops – For Loop, While Loop in Java, Do While Loop, Break and Continue
  • Immutability of Java Wrapper Classes, String and BigDecimal

******* What You Can Expect from Every in28Minutes Course *******

in28Minutes created 20 Best Selling Courses providing Amazing Learning Experiences to 250,000 Learners across the world.

Introduction to Java Programming with Jshell using Multiplication Table

00 – Getting Started with Programming
01 – Introduction to Multiplication Table challenge
02 – Launch JShell
03 – Break Down Multiplication Table Challenge
04 – Java Expression – An Introduction
05 – Java Expression – Exercises
06 – Java Expression – Puzzles
07 – Printing output to console with Java
08 – Printing output to console with Java – Exercise Statements
09 – Printing output to console with Java – Exercise Solutions
10 – Printing output to console with Java – Puzzles
11 – Advanced Printing output to console with Java
12 – Advanced Printing output to console with Java – Exercises and Puzzles
13 – Introduction to Variables in Java
14 – Introduction to Variables in Java – Exercises, and Puzzles
15 – 4 Important Things to Know about Variables in Java

Introduction to Method with Multiplication Table

00 – Section 02 – Methods – An Introduction
01 – Your First Java Method – Hello World Twice and Exercise Statements
02 – Introduction to Java Methods – Exercises and Puzzles
03 – Programming Tip – Editing Methods with JShell
04 – Introduction to Java Methods – Arguments and Parameters (Java Programming for Complete Beginners Course Catalog)
05 – Introduction to Java Method Arguments – Exercises
06 – Introduction to Java Method Arguments – Puzzles and Tips
07 – Getting back to Multiplication Table – Creating a method
08 – Print Multiplication Table with a Parameter and Method Overloading
09 – Passing Multiple Parameters to a Java Method
10 – Returning from a Java Method – An Introduction
11 – Returning from a Java Method – Exercises
12 – Methods – Section Review

Introduction to Java Platform

00 – Section 03 – Overview Of Java Platform – Section Overview
01 – Overview Of Java Platform – An Introduction – java, javac, bytecode and JVM
02 – Java Class and Object – First Look
03 – Create a method in a Java class
04 – Create and Compile Planet.java class
05 – Run Planet class with Java – Using a main method
06 – Play and Learn with Planet Class
07 – JDK vs JRE vs JVM

Introduction to Eclipse – First Java Project

01 – Creating a New Java Project with Eclipse
02 – Your first Java class with Eclipse
03 – Writing Multiplication Table Java Program with Eclipse
04 – Adding more methods for Multiplication Table Program
05 – Programming Tip 1: Refactoring with Eclipse
06 – Programming Tip 2: Debugging with Eclipse
07 – Programming Tip 3: Eclipse vs JShell – How to choose?

Introduction To Object-Oriented Programming

00 – Introduction to Object-Oriented Programming – Section Overview
01 – Introduction to Object-Oriented Programming – Basics
02 – Introduction to Object-Oriented Programming – Terminology – Class, Object, State, and Behavior
03 – Introduction to Object-Oriented Programming – Exercise – Online Shopping System and Person
04 – Create a Motor Bike Java Class and a couple of objects
05 – Exercise Solutions – Book class and Three instances
06 – Introducing State of an object with speed variable
07 – Understanding the basics of Encapsulation with Setter methods
08 – Exercises and Tips – Getters and Generating Getters and Setters with Eclipse
09 – Puzzles on this and initialization of member variables
10 – First Advantage of Encapsulation

Primitive Data Types And Alternatives

00 – Primitive Data Types in Depth – Section Overview
01 – Basics about Java Integer Data Types – Casting, Operators and More
02 – Java Integer Data Types – Puzzles – Octal, Hexadecimal, Post and Pre increment
03 – Java Integer Data Types – Exercises – BiNumber – add, multiply and double
04 – Java Floating-Point Data Types – Casting, Conversion, and Accuracy
05 – Introduction to BigDecimal Java Class (Java Programming for Complete Beginners Course Catalog)
06 – BigDecimal Puzzles – Adding Integers
07 – BigDecimal Exercises – Simple Interest Calculation
08 – Java Boolean Data Type – Relational and Logical Operators
09 – Java Boolean Data Type – Puzzles – Short Circuit Operators
10 – Java Character Data Type char – Representation and Conversion

Conditionals

00 – Conditionals with Java – Section Overview
01 – Introduction to If Else Statement
02 – Introduction to Nested If Else
03 – If Else Statement – Puzzles
05 – If Else Problem – How to get number 2 and choice from the user?
06 – If Else Problem – Implementing with Nested If Else
07 – Java Switch Statement – An introduction
08 – Java Switch Statement – Puzzles – Default, Break and Fall Through
09 – Java Switch Statement – Exercises – isWeekDay, name of the month, nameOfDay
10 – Java Ternary Operation – An Introduction
11 – Conditionals with Java – Conclusion

Loops

00 – Java Loops – Section Introduction
01 – Java For Loop – Syntax, and Puzzles
02 – Java For Loop – Exercises Overview and First Exercise Prime Numbers
03 – Java For Loop – Exercise – Sum Upto N Numbers and Sum of Divisors
04 – Java For Loop – Exercise – Print a Number Triangle
05 – While Loop in Java – An Introduction
06 – While Loop – Exercises – Cubes and Squares up to limit
07 – Do While Loop in Java – An Introduction
08 – Do While Loop in Java – An Example – Cube while the user enters positive numbers
09 – Introduction to Break and Continue
10 – Selecting Loop in Java – For vs While vs Do While

Reference Types

00 – Java Reference Types – Section Introduction
01 – Reference Types – How are they stored in Memory?
02 – Java Reference Types – Puzzles
03 – String class – Introduction and Exercise – Print each word and char on a new line
04 – String class – Exercise Solution and Some More Important Methods
05 – Understanding String is Immutable and String Concat, Upper Case, Lower Case, Trim methods
06 – String Concatenation and Join, Replace Methods
07 – Java String Alternatives – StringBuffer and StringBuilder
08 – Java Wrapper Classes – An Introduction – Why and What?
09 – Java Wrapper Classes – Creation – Constructor and valueOf
10 – Java Wrapper Classes – Auto Boxing and a Few Wrapper Constants – SIZE, BYTES, MAX_VALUE, and MIN_VALUE

Arrays and ArrayLists

00 – Introduction to Array and ArrayList – Section Introduction with a Challenge
01 – Understanding the need and Basics about an Array
02 – Java Arrays – Creating and Accessing Values – Introduction
03 – Java Arrays – Puzzles – Arrays of Objects, Primitive Data Types, toString, and Exceptions
04 – Java Arrays – Compare, Sort and Fill
05 – Java Arrays – Exercise – Create Student Class – Part 1 – Total and Average Marks
06 – Java Arrays – Exercise – Create Student Class – Part 2 – Maximum and Minimum Mark
07 – Introduction to Variable Arguments – Need
08 – Introduction to Variable Arguments – Basics
09 – Introduction to Variable Arguments – Enhancing Student Class
10 – Java Arrays – Using Person Objects and String Elements with Exercises

Object-Oriented Programming Again

00 – Object-Oriented Programming – Level 2 – Section Introduction
01 – Basics of Designing a Class – Class, Object, State and Behavior
02 – OOPS Example – Fan Class – Deciding State and Constructors
03 – OOPS Example – Fan Class – Deciding Behavior with Methods
04 – OOPS Exercise – Rectangle Class (Java Programming for Complete Beginners Course Catalog)
05 – Understanding Object Composition with Customer Address Example
06 – Understanding Object Composition – An Exercise – Books and Reviews
07 – Understanding Inheritance – Why do we need it?
08 – Object is at top of Inheritance Hierarchy
09 – Inheritance and Overriding – with toString() method
10 – Java Inheritance – Exercise – Student and Employee Classes
11 – Java Inheritance – Default Constructors and super() method call
12 – Java Inheritance – Puzzles – Multiple Inheritance, Reference Variables, and instanceof

Collections

01 – Java Collections – Section Overview with Need For Collections
02 – List Interface – Introduction – Position is King
03 – List Interface – Immutability and Introduction of Implementations – ArrayList, LinkedList, and Vector
04 – List Interface Implementations – ArrayList vs LinkedList
05 – List Interface Implementations – ArrayList vs Vector
06 – List Interface – Methods to add, remove and change elements and lists
07 – List and ArrayList – Iterating around elements
08 – List and ArrayList – Choosing iteration approach for printing and deleting elements
09 – List and ArrayList – Puzzles – Type Safety and Removing Integers
10 – List and ArrayList – Sorting – Introduction to Collections sort static method
11 – List and ArrayList – Sorting – Implementing Comparable Interface in Student Class
12 – List and ArrayList – Sorting – Providing Flexibility by implementing Comparator interface

Generics

01 – Introduction to Generics – Why do we need Generics?
02 – Implementing Generics for the Custom List
03 – Extending Custom List with a Generic Return Method
04 – Generics Puzzles – Restrictions with extends and Generic Methods
05 – Generics and WildCards – Upper Bound and Lower Bound

Introduction to Functional Programming

01 – Introduction to Functional Programming – Functions are First-Class Citizens
02 – Functional Programming – First Example with Function as Parameter
03 – Functional Programming – Exercise – Loop a List of Numbers
04 – Functional Programming – Filtering – Exercises to print odd and even numbers from List
05 – Functional Programming – Collect – Sum of Numbers in a List
06 – Functional Programming vs Structural Programming – A Quick Comparison
07 – Functional Programming Terminology – Lambda Expression, Stream and Operations on a Stream
08 – Stream Intermediate Operations – Sort, Distinct, Filter and Map
09 – Stream Intermediate Operations – Exercises – Squares of First 10, Map String List to LowerCase and Length of String
10 – Stream Terminal Operations – 1 – max operation with Comparator

Introduction to Threads And Concurrency

01 – Introduction to Threads and MultiThreading – Need for Threads
02 – Creating a Thread for Task1 – Extending Thread Class
03 – Creating a Thread for Task2 – Implement Runnable Interface
04 – Theory – States of a Thread
05 – Placing Priority Requests for Threads
06 – Communication between Threads – join method
07 – Thread utility methods and synchronized keyword – sleep, yield
08 – Need for Controlling the Execution of Threads
09 – Introduction to Executor Service
10 – Executor Service – Customizing number of Threads
11 – Executor Service – Returning a Future from Thread using Callable
12 – Executor Service – Waiting for completion of multiple tasks using invoke
13 – Executor Service – Wait for only the fastest task using invokeAny
14 – Threads and MultiThreading – Conclusion

Introduction to Exception Handling

01 – Introduction to Exception Handling – Your Thought Process during Exception Handling
02 – Basics of Exceptions – NullPointerException and StackTrace
03 – Basics of Handling Exceptions – try and catch
04 – Basics of Handling Exceptions – Exception Hierarchy, Matching and Catching Multiple Exceptions
05 – Basics of Handling Exceptions – Need for finally
06 – Basics of Handling Exceptions – Puzzles
07 – Checked Exceptions vs Unchecked Exceptions – An Example
08 – Hierarchy of Errors and Exceptions – Checked and Runtime
09 – Throwing an Exception – Currencies Do Not Match Runtime Exception
10 – Throwing a Checked Exception – Throws in method signature and handling
11 – Throwing a Custom Exception – CurrenciesDoNotMatchException
12 – write less code with Try with Resources – New Feature in Java 7
13 – Basics of Handling Exceptions – Puzzles 2
14 – Exception Handling – Conclusion with Best Practices

Files and Directories

01 – List files and folders in Directory with Files list method
02 – Recursively List and Filter all files and folders in Directory with Step Files walk method and Search with find method
03 – Read content from a File – Files read all lines and lines methods
04 – Writing Content to a File – Files write method
05 – Files – Conclusion

Who this course is for:

  • You have ZERO programming experience and want to learn Java Programming
  • You are a Beginner at Java Programming and want to Learn to write Great Java Programs
  • Learn the Basics of Object-Oriented Programming with Java
  • You want to learn the Basics of Functional Programming with Java
  • Content From: https://www.udemy.com/course/java-programming-tutorial-for-beginners/
  • Object Oriented Programming for beginners
  • Last updated 1/2020

Java Programming for Complete Beginners Course Catalog

Download Tutorial (Size: 4.2 GB)

Categories
All Tutorials MongoDB Mysql Tutorials React and Redux Tutorials SQL Tutorials

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

Be able to advise customers and translate business requirements into Azure solutions by taking the AZ-301 exam!

What you’ll learn

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

  • Learn how to design and architect Azure solutions

Requirements

  • Azure Solution Architects who advise stakeholders and translates business requirements into secure, scalable, and reliable solutions.
  • This role requires managing how decisions in each area affect an overall solution. Candidates must be proficient in Azure administration, Azure development, and DevOps, and have expert-level skills in at least one of those domains.
  • Candidates should have advanced experience and knowledge across various aspects of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data management, budgeting, and governance.

Description

In order to understand core architect technologies, Skylines Academy will lead you through a series of sections, modules, and demos to prepare you for taking, and ultimately passing, the Microsoft Azure AZ-301 exam.

This course curriculum is as follows:

  • Determine Workload Requirements
  • Design Identity Management
  • Design a Data Solution
  • Establish Business Continuity
  • Design Deployment and Migrations
  • Design and Infrastructure Strategy
  • Example Designs

Lectures will educate you on the fundamental terms and principles of the Azure platform and demos will enable you with a hands-on experience using scenarios to empower you in the real world.

Welcome to the Skylines Academy AZ-301 course! We’re happy you’re joining us!

Note: If you took the AZ-300 course, there will be some overlap. There is a lot to repeat around subjects covered in AZ-300 to make sure you have the basis on core technologies that align with the curriculum. Where possible, I try to make the distinction but you will find that we need to cover core infrastructure topics again before moving onto design elements.

Who this course is for:

  • Azure Architects
  • IT Administrators
  • Content From: https://www.udemy.com/course/microsoft-az-301-certification-azure-architect-design/
  • Investment Banking Course 2020
  • Last updated 1/2020

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

Download Tutorial (Size: 3.5 GB)

Categories
All Tutorials MongoDB Mysql Tutorials React and Redux Tutorials SQL Tutorials

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

Master MongoDB Development for Web & Mobile Apps. CRUD Operations, Indexes, Aggregation Framework – All about MongoDB!

What you’ll learn

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

  • Use MongoDB to its full potential in future projects
  • Write efficient and well-performing queries to fetch data in the format you need it
  • Use all features MongoDB offers you to work with data efficiently

Requirements

  • General web development or mobile development knowledge will help you but is not a must-have
  • You can use any operating system – Windows, macOS, Linux, it’ll all work!

Description

MongoDB is one of the most important NoSQL databases you can work with these days. It’s extremely popular and MongoDB developers are in high demand.

No matter if you’re building web applications, mobile applications or any other kind of application or if you’re a data scientist – you’ll need to work with data. Storing data, querying it efficiently and minimizing complexities whilst optimizing performance are crucial tasks.

In this course, you’ll learn all about MongoDB from scratch. MongoDB – The Complete Developer’s Guide 2020 Course Catalog

In detail, you’ll learn:

  • … how to install and use MongoDB locally and in the cloud (MongoDB Atlas)
  • … how to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases
  • … learn how to filter for data efficiently
  • … how to work with both the Mongo Shell and drivers (e.g. Node.js driver)
  • … how to increase performance by using indexes (and how to use the right indexes!)
  • … what replica sets and sharding are
  • … how to use MongoDB Atlas – the cloud solution offered by MongoDB
  • … how to use the serverless platform (Stitch) offered by MongoDB
  • … and much more!

This course is a hands-on course – you’ll learn by writing code/ commands. We’ll work on a wide variety of example data and use-cases and by the end of the course, you’ll have all the knowledge you need to work with MongoDB in your next project!

This course is for you:

  • … if you’re brand-new to MongoDB and databases in general
  • … if you got some basic database or even MongoDB experience – in this course, there are different entry points you can choose from!
  • … you are a web or mobile app (or desktop app) developer who considers using MongoDB
  • … if you’re working in a team that considers using MongoDB (or already does use it)
  • … if you are primarily using SQL-based databases so far and you want to explore the most popular NoSQL alternative

This course is NOT for you:

  • … if you’re looking for a guide on administrating MongoDB servers => This course focuses on the commands/ queries you write, it’s NOT an administration course. I will show (in detail) how to deploy a ready-to-use cloud MongoDB solution that follows best practices though.

Who this course is for:

  • Developers or data scientists who plan on (or are already) working with MongoDB
  • Everyone who’s interested in NoSQL databases
  • Both beginner and advanced MongoDB users who want to explore all the core features
  • Content From: https://www.udemy.com/course/mongodb-the-complete-developers-guide/
  • The Ultimate Excel Programmer Course
  • Last updated 11/2019

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

Download Tutorial (Size: 5.5 GB)

Categories
All Tutorials Mysql Tutorials React and Redux Tutorials SQL Tutorials

Elasticsearch 7 and the Elastic Stack – In Depth & Hands On! Course Catalog

Elasticsearch 7 and the Elastic Stack – In Depth & Hands On! Course Catalog

Search, analyze, and visualize big data on a cluster with Elasticsearch, Logstash, Beats, Kibana, and more.

What you’ll learn

Elasticsearch 7 and the Elastic Stack – In Depth & Hands On! Course Catalog

  • Install and configure Elasticsearch 7 on a cluster
  • Create search indices and mappings
  • Search full-text and structured data in several different ways
  • Import data into Elasticsearch using several different techniques
  • Integrate Elasticsearch with other systems, such as Spark, Kafka, relational databases, S3, and more
  • Aggregate structured data using buckets and metrics
  • Use Logstash and the “ELK stack” to import streaming log data into Elasticsearch
  • Use Filebeats and the Elastic Stack to import streaming data at scale
  • Analyze and visualize data in Elasticsearch using Kibana
  • Manage operations on production Elasticsearch clusters
  • Use cloud-based solutions including Amazon’s Elasticsearch Service and Elastic Cloud

Requirements

  • You need access to a Windows, Mac, or Ubuntu PC with 20GB of free disk space
  • You should have some familiarity with web services and REST
  • Some familiarity with Linux will be helpful
  • Exposure to JSON-formatted data will help

Description

New for 2019! Elasticsearch 7 is a powerful tool not only for powering search on big websites but also for analyzing big data sets in a matter of milliseconds! It’s increasingly popular technology, and a valuable skill to have in today’s job market. This comprehensive course covers it all, from installation to operations, with over 90 lectures including 8 hours of video.

We’ll cover setting up search indices on an Elasticsearch 7 cluster (if you need Elasticsearch 5 or 6 – we have other courses on that), and querying that data in many different ways. Fuzzy searches, partial matches, search-as-you-type, pagination, sorting – you name it. And it’s not just theory, every lesson has hands-on examples where you’ll practice each skill using a virtual machine running Elasticsearch on your own PC.

We’ll explore what’s new in Elasticsearch 7 – including index lifecycle management, the deprecation of types and type mappings, and hands-on activity with Elasticsearch SQL. We’ve also added much more depth on managing security with the Elastic Stack, and how backpressure works with Beats.

We cover, in-depth, the often-overlooked problem of importing data into an Elasticsearch index. We’ll also stream data into Elasticsearch using Logstash and Filebeat – commonly referred to as the “ELK Stack” (Elasticsearch / Logstash / Kibana) or the “Elastic Stack“.

Elasticsearch 7 and the Elastic Stack – In Depth & Hands On! Course Catalog

Elasticsearch isn’t just for search anymore – it has powerful aggregation capabilities for structured data. We’ll bucket and analyze data using Elasticsearch, and visualize it using the Elastic Stack’s web UI, Kibana.

You’ll learn how to manage operations on your Elastic Stack, using X-Pack to monitor your cluster’s health, and how to perform operational tasks like scaling up your cluster and doing rolling restarts. We’ll also spin up Elasticsearch clusters in the cloud using Amazon Elasticsearch Service and the Elastic Cloud.

Elasticsearch is positioning itself to be a much faster alternative to Hadoop, Spark, and Flink for many common data analysis requirements. It’s an important tool to understand, and it’s easy to use! Dive in with me and I’ll show you what it’s all about.

Who this course is for:

  • Any technologist who wants to add Elasticsearch to their tool chest for searching and analyzing big data sets.
  • Content From: https://www.udemy.com/course/elasticsearch-7-and-elastic-stack/
  • Last updated 12/2019
  • The Ultimate Excel Programmer Course

Elasticsearch 7 and the Elastic Stack – In Depth & Hands On! Course Catalog

Download Tutorial (Size: 3.2 GB)