Prepare for a SQL interview in 2019
What you'll learn
Learn how to answer SQL questions on interview
Prepare for a SQL interview
Practice SQL knowledge on +55 queries
Practice SQL knowledge on +95 quiz questions
Requirements
Know SQL basics
Description
Are you getting ready for an SQL interview or do you just want to check you SQL knowledge?
Then you have come to the right place.
In this course I will prepare you for a SQL interview. By showing you all kinds of SQL Interview questions that you may get on an SQL interview.
What is in the course?
Over 95 SQL Interview questions
Over 55 SQL Interview queries
I also explain how to solve each query in a video lectures, so that if you don't know how to solve some problem you have the opportunity to learn.
Everyone is afraid of failure and that is why after finishing this course you should be well prepared and ready for an SQL interview. This course is designed to help you master SQL interview question. SQL is one of the most highly in-demand skills in the computer science sector today. So when you are able to write SQL queries you should be just fine.
NOTE: This course is not designed for beginners, I expect you know at least the basics of SQL
Who this course is for:
Anyone who wants to check their SQL knowledge
Anyone who wants to go to an SQL interview
Anyone who is preparing for a SQL interview
Anyone who wants to practice SQL knowledge on queries

Learn Aseprite to make Pixel Art!
What you'll learn
You will know how to use Aseprite
You will be able to make animations on Aseprite
Requirements
Aseprite
A computer and a mouse
Description
In this course you will learn how to make Pixel Art with Aseprite. You will learn the interface of Aseprite and his tools, you will also learn how to make animations in Aseprite. You will gain all the knowledge that you need to start creating Pixel Art for videogames or illustrations.
You will start by learning the basics of Aseprite:
The interface
The tools
How to manage the color palette
How to export your files
After learning the basics you are going to take a look at different tips and tricks to have a better workflow in Aseprite, you will learn:
How to make a dithering brush
How to work with indexed palettes
How to automatically make an outline
How to reduce the number of colors
How to make tileable textures and tiles
And more...
In the third section you will have an introduction to animation:
The interface of animation
How to move, create, remove, duplicate frames
How to use the onion skinning tools
How to animate a bouncing ball
How to export your animation
The course contains short lectures that will teach you step by step the learning process of making pixel art.
At the end of the course you will also get a really important lecture that will show you where you can keep learning and improving in your pixel art creation quest.
I offer full feedback on the work that you produce, I will also answer all the questions that you can have about pixel art in the Q&A section of the course.
So if you are a begginner pixel artist, game designer, artist or programmer wanting to learn how to create pixel art for videogames or just beautiful pixel art illustrations this course is for you!
Who this course is for:
Begginners on Pixel Art
Pixel artists who want to learn Aseprite
Artists who want to learn a new style.

Flutter is quickly becoming a well-known framework for developing cross-platform apps for both Android and iOS devices. Now developers don't have to learn Java, Kotlin, Objective-C, or Swift to have their apps on Play Store or the App Store. While there are other frameworks for building cross-platform apps, Flutter excels by using a great new language called Dart.
With Dart and Flutter, you will develop apps for both stores with just one codebase. It compiles apps into native code without webview. Apps made with Flutter are very fast because of their high rendering power. Hence, they feel super-smooth, thus providing a rich user experience.
With this course, you will be able to build app layouts, create widget animations, pull and push data to servers, and compile and release code to both stores.
The code bundle for this video course is available at-

What you'll learn
SQL Server installation, creating entities like database , tables , rows and columns. Covers fundamentals like primary key,foreign key , referential integrity , constraints , normalization ( first , second and third normal forms), Denormalization,OLTP , OLAP, StarSchema and SnowFlake design.
Writing DML and DDL query like inner join,left join,right join, outer join, union , co-related queries, union all, alias,case statements,cartesian,ISNULL, aggregate( sum/count),wild card , top, order by, create , insert, bulk insert , update , backup , restore,ISNULL,Coalesce,Row_Number, Partition, Rank ,DenseRank , Pivot and Unpivot.
Understanding importance of indexes , how it makes our search faster , non-clustered indexes vs clustered indexes , page splits in indexes and column store indexes.
Triggers,Insteadof , After trigger ,Inserted , deleted tables ,Stored Procedures,CDC,8 KB page and SQL Server agent.
Requirements
No experienced required , should have the will to learn
Description
It has 20 labs which covers the below syllabus.
Lab 1:- Basic Fundamentals Database, Tables, rows and columns.
Lab 2:- Primary key, foreign key, referential integrity and constraints.
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
Lab 4: - SQL basics(Select, Insert, Update and Delete)
Lab 5 :- DDL (Data definition language) Queries.
Lab 6: - ISNULL and Coalesce functions.
Lab 7: - Row_Number, Partition, Rank and DenseRank
Lab 8: - Triggers, inserted and deleted tables
Lab 9: - Instead of and after triggers.
Lab 10: - Denormalization, OLTP and OLAP
Lab 11: - Understanding Star schema and Snow flake design.
Lab 12: - SQL Server 8 kb pages.
Lab 13 :- Index and performances
Lab 14 :- Page Split and indexes
Lab 15 :- Clustered vs non-clustered
Lab 16: - Stored procedures and their importance.
Lab 17: - Change Data Capture.
Lab 18: - Explain Columnstore Indexes?
Lab 19: - SQL Server agent
Lab 20: - How can we implement Pivot & Unpivot in SQL Server?
Who this course is for:
Developers who want to become SQL Server developers

This class is an example of my complete post processing workflow for portrait photography (v3.0).

Make films with an impact
Spike Lee didn't just direct his award-winning 1986 feature debut, She's Gotta Have It. He was also the writer, star, truck driver, location scout, electrician, and caterer-because that's what it took to get his film made. In his first-ever online class, the visionary behind Do the Right Thing, Malcolm X, and BlacKkKlansman lets you in on his uncompromising approach to filmmaking. Learn about writing, self-producing, working with actors, and making movies that break down barriers.
Spike Lee is an auteur and master storyteller who has written, directed, produced, and acted in films ranging from big studio pictures to micro-budget independents. His work stands as a testament to cinema's power to entertain, explore, celebrate, and critique American culture and social political issues.
Spike Lee's MasterClass teaches students how to tell stories that need to be told. He analyzes his work both on the page and on the screen, and dives into the technicalities of writing stories, working with actors, camera angles, financing, and choosing music. Lee addresses the hurdles facing first-time filmmakers, and shares learnings from his own experiences with overcoming obstacles in the film industry. He discusses his drive to impact culture with his movies, and urges students to be conscious of the relationship between their work and the world.
In this online filmmaking class, you'll learn about:
* Screenwriting
* Producing
* Casting
* Working with Actors
* Cinematography
* Editing
* Film Score
* Financing


01. Introduction
Meet your new instructor, writer/director/producer/professor-Spike Lee. Spike explains what he hopes you'll gain from his class: the tools of film grammar-or visual storytelling-and the DIY spirit to make your own original, independent films.
02. Putting Words On Paper
Spike provides you with a blueprint of his writing process to help you write your script. Learn his index card technique, his disciplined writing practice, and his advice for writing with a partner.
03. Storytelling
Spike teaches you his techniques for writing bold, distinct characters, capturing two sides of a story, and creating stories that react to social injustice.
04. Speaking Truth to Power: On the Waterfront
Breaking down the director's choices in one of his favorite films, Elia Kazan's On the Waterfront, Spike demonstrates how cinema can be a powerful tool for speaking the truth.
05. Spike's Film 101s Pt. 1
Learn Spike's tips for creating realistic budgets and shooting schedules (and sticking to them), working on location, and how to make your crew feel appreciated.
06. Case Study: Financing Malcolm X
Spike recounts his battle to secure additional funds for Malcolm X to show you how self-reliance, self-determination, and dedication to your story can help finance a project.
07. Importance of Casting
"The wrong actors, the wrong roles could turn out the wrong movie." Spike shares his tips for successful casting and his experiences casting some of his most infamous roles.
08. Collaborating With Your Director of Photography
Learn what to look for in a director of photography, including how to "audition" a DP and how to create a plan of action, once you've found the right collaborator.
09. Storytelling with Camera Coverage
Spike walks you through the iconic camera angles and techniques that have come to define his visual style. Then, he breaks down how he uses each to increase tension and heighten the drama.
10. Storyboards: Malcolm X
Using his original storyboards for the assassination scene in Malcolm X, Spike illustrates the construction of a scene, and the level of detail required to create the illusion of chaos.
11. Spike's Film 101s Pt. 2
For Spike, the take is a sacred moment. Learn his rules for managing your crew and running a set effectively in order to deliver the best possible takes.
12. Directing Actors
How can you inspire the best performance from your actor? Spike teaches his techniques for directing your actors with sensitivity and respect, including how to communicate and establish trust.
13. Collaborating and Improvising with Actors
Spike believes that a good director both commands and surrenders to the moment. Using scenes from He Got Game and School Daze, he shares tips on how to harness improvisational moments and adjust to story changes on-the-fly.
14. Opening Title Sequences
Analyzing opening title sequences from Mo' Better Blues, 25th Hour, and BlacKkKlansman, Spike teaches the art of establishing tone in the first few minutes of your film.
15. Music Is Key
Spike shares his strategies for enhancing drama through music. Learn his advice for working with a composer, turning source into score, and using music as a counterpoint.
16. Editing
By taking a look at the inter-cutting technique in BlacKkKlansman, Spike demonstrates how he was able to create heightened drama and tonal balance in pivotal scenes.
17. Film as an Agent of Change
Spike discusses the filmmaker's responsibility to bring diversity to the film industry-both on screen and behind the scenes.
18. Storytelling for Documentaries
Examining his powerful nonfiction films When the Levees Broke and 4 Little Girls, Spike shares insights on how to handle true stories with passion and respect.
19. Closing
In his parting words, Spike reflects on what it takes to be an independent filmmaker and encourages you to take his tools and be a student of cinema.
More Info

A short, sharp course to tackling life's biggest challenges: Understanding ourselves and making the right choices.
What you'll learn
Learn how to make better decisions and plan strategically
Use the models to resolve conflicts and deliver great feedback
Conduct a product analysis
Requirements
Nothing: Arrive ready to learn
Working Internet Connection
Description
ACCORDING TO WORKFORCE: "Decision making and problem-solving skills are the most important skills in the 21st century."
SPECIAL FREE BONUS** EXCEL DECISION MAKING WORKBOOK INCLUDED. In order to further improve the student experience, there is a free download of an Excel workbook packed with activities and ready to use models. This helps ensure everything is even easier to understand & even more fun and engaging!
Are you ready to take your career to the next level? In this course, you will learn a range of problem solving and decision making strategies. This course covers important topics such as decision making skills, conflict resolution models, product analysis and strategic thinking. You will learn or remind yourself of these concepts that will help make you more successful!
The contents of this course are all based on my work experience as a Policy Analyst in The Office of the Presidency of South Africa, founder of Grow2Lead, a leadership and non-profit organization in South Africa and a Data Associate for a leading Education nonprofit in New York City. I received a PhD from Texas A&M University and a Master's degree in Public Administration from the Bush School of Government. This course ties together both my theoretical knowledge and practical experience in a dynamic, practical and applicable way.
Students of this course will enjoy learning a range of problem solving and decision making strategies....from the Eisenhower Model, SWOT analysis, to the Long Tail, and Integration Techniques. Use this course to take your career to the next level!
What are the requirements?
Come ready to learn
What am I going to get from this course?
Join a global community of students!
Superb reviews!
Over fifteen decision making and problem solving strategies!
Learn how to make better decisions!
Use the models to resolve conflicts and deliver great feedback!
After this course you will have the tools / skills needed to make important decision to take you to the next level!
Who is the target audience?
Anyone interested in learning about or brushing up on their decision making skills.
Who this course is for:
Anyone interested in learning about or brushing up on their decision making skills.

What you'll learn
Improve your physical state
Improve your emotional state
Acquire basic bodyweight exercise skills
Become well-toned
Manage your body weight
Requirements
Great for both beginner and advanced
Three 20-minute workouts per week are ideal for those who do not like to work out for hours in the gym
You can watch and take a course on your phone, tablet or computer
You can train anywhere and anytime
No special equipment needed
Description
The course consists of 5 parts of exercises: warm-up, arm training, leg training, abs training and full body workout.
The course is developed in a way that you can train anytime and anywhere: at home, in a hotel room, on the street, in the gym - anywhere. All you need is yourself, 12-20 minutes of free time and a few square meters of the floor!
Since you use your bodyweight in all exercises of the course, you don't have to worry too much about injuries or overtraining.
This course is the best way to start training, lose weight, fill yourself with energy and get in shape.
Who this course is for:
All who want to lose weight and strengthen muscles
Who want to stay always in a good shape
For those who want to train anywhere, anytime

What you'll learn
Teaching Skills
Requirements
A passion to teach towards excellence
Description
The module nurtures learning through re-visiting classroom strategies towards excellence. It laminates teaching skills for a better qualitative learning outcome in totality. The approach is towards empowerment and timely solution of concerns and issues of classroom management. It encapsulates encouraging learning among students, schools, collaboration and shared resources through exchange mechanism for competitive teaching and modulating learning through connect mechanism within classrooms.
Who this course is for:
Teachers/ Educators/ Heads of Schools

Getting started with JavaScript robotics using Johnny-Five
This course is actually composed of a series of different "mini courses" that are divvied up in the various sections, which will introduce you to the Johnny-Five framework, and get you up and running with different examples for working with various components.
Johnny-Five is for those of you who would like to get into robotics, but don't really care to learn languages like C or C++. Johnny-Five is a JavaScript framework that allows you to use any existing skills you may have picked up from web or Node.js development to control hardware.
What you'll learn
Set up and install the Johnny-Five robotics framework
Control LED's wired to a Raspberry Pi with JavaScript
Control LED's wired to an Arduino with JavaScript
Trigger a relay wired to an Arduino with JavaScript
Control an Arduino-powered tank using an Xbox 360 controller

Acheiving More by Managing Your Focus
This course will teach you to be effective and efficient with how you manage your time. You will learn how to take control of your life. Controlling your life will allow you to be more productive and achieve your goals. Break down the barriers to success using the techniques that you learn in the course.
Develop the mindset necessary to be successful. One of the most important characteristic traits of successful goal oriented individuals is conscientiousness. Conscieniousness turns into focus. This course will teach you how to develop your focus and maintain your focus with deliberate time management techniques. This course will teach you the backward planning technique and enable you to achieve your goals.
What you'll learn
Learn the importance of prioritization and how to prioritize
Understand how to set goals and objectives effectively
Learn backwards planning in order to create a step-by-step process towards goal completion

Do you wake up everyday feeling miserable?
Are you doing the same things over and over again, while feeling completely empty inside?
Do you feel like your life has no purpose?
Are you simply existing, one tiring day after another?
Do you feel like every time you decide to make a change, life seems to get in the way?
Throwing you obstacles, struggles, pain and suffering?
I'm here to remind you that:
You were born to stand out in this world.
You are a pure and powerful creative being.
You have gifts inside you that are just waiting to come out.
Your purpose in life is to bring these gifts out to serve the world.
All it takes is for you to have the courage to take your first step out of your comfort zone.