Learn Python + JavaScript + Microsoft SQL for Data science

Learn JavaScript variables through the four declaration styles, with let and const as modern keywords. See how assignment works and when to use const versus let.

Explore JavaScript data types, including strings with single or double quotes, numbers, booleans, arrays, and objects, and learn variable declaration with let and basic usage in a document context.

Explore numbers as a data type, including integers and decimals, and practice arithmetic with plus, minus, multiplication, and division. Learn how quotes turn numbers into strings, changing calculations.

Explore working with strings in JavaScript, including declaring with let or const, using single or double quotes, concatenation with plus, and measuring length to validate user input such as names.

Learn string formatting in JavaScript by concatenating variables to build names and addresses, and explore using backslashes to create multi-line outputs and preserve structure.

Learn JavaScript operators across arithmetic, assignment, comparison, and logical categories, with hands-on examples of plus, minus, multiply, divide, power, and pre/post increment and decrement.

Learn assignment operators and how the equals sign assigns values to variables. See how +=, -=, *=, and /= update existing values through arithmetic operations.

Master JavaScript comparison operators, including equals, not equal to, less than, greater than, and their inclusive forms, and learn how type affects comparisons between numbers and strings with boolean results.

Explore logical operators in JavaScript, including and, or, and not, with true/false outcomes and simple comparisons like less than ten to show how not negates results.

Explore implementing an if-else statement to validate variables, map dynamic input to messages, and output good evening or good day based on hours.

Explore if-else-if statements to handle multiple conditions with elif, using examples like good morning, good evening, and good day, and learn when to use else if blocks.

Learn to use a while loop to execute code while a condition holds, increment a counter, print numbers up to ten, and build a simple multiplication table with string concatenation.

Explore the do-while loop and its execution flow: enter the block of code, then verify the condition, with practical examples in JavaScript that apply across languages.

Master the for loop by setting an index i, testing i < 10, and incrementing with i, to print numbers and iterate over fruits array, displaying each fruit.

Complete a JavaScript coding exercise that prints the multiplication table for the number two up to ten, testing your knowledge from prior lectures and preparing for the next solution.

Explore a coding exercise solution that demonstrates string formatting, operator usage, and numeric input handling, then prints the result by updating a paragraph element with a specific id.

Learn how to create and use JavaScript functions, pass parameters and arguments, return values, and reuse code through function constructors and examples.

Learn how to define a JavaScript function and invoke it with the call method to pass arguments to build a full name from first name, last name, city, and country.

Define a function with parameters that accepts arguments to sum values in loop, returning total, and note that arguments are passed by value while objects are by reference in JavaScript.

Learn to handle JavaScript errors using try-catch blocks, implement catch blocks, and display error messages to debug and identify issues in code.

Learn to use try-catch-finally in JavaScript for robust error handling and input validation. Implement finally blocks to ensure code runs, even after errors, with clear user messages.

Demonstrate on submit form validation using JavaScript, validating name and email fields, enforcing required input, error messages, and choosing post or get method, with browser-based validation.

Explore Python as an interpreter and high-level language that emphasizes reliable code through significant indentation and supports object-oriented programming for reusable, clear data science projects.

Compare Python and Java for data science, highlighting Python's easy syntax and web app capabilities, open-source and free, against Java's speed and longer code.

Discover why Python is popular for data science. Leverage Python’s vast libraries and Python packages index for analytics, visualization, ML, AI, robotics, IoT, mobile and web apps, and DevOps.

Learn command line basics across Windows and Linux, using cd, dir, and clear screen commands, navigate directories, and check the current directory to prepare Python installation.

Install Python on Windows by downloading the official installer, selecting the latest Python 3.10.2, and adding Python to the path.

Install the PyCharm community edition and use its code editor to write and run Python programs, then launch the IDE and create your first project.

Launch PyCharm to create a new Python project with a virtual environment and a base interpreter, then learn the setup for your first app.

Write and run a simple hello world program in Python using an IDE, creating a new Python file and using print statements to display output.