70-461, 761: Querying Microsoft SQL Server with Transact-SQL

 

70-461, 761: Querying Microsoft SQL Server with Transact-SQL - From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022

Created by Philip Burton | 29.5 hours on-demand video course

This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012” and 70-761 “Querying Data with Transact-SQL”. Please note – these certificates are no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

What you’ll learn

• create tables in a database and ALTER columns in the table.
• Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
• retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
• JOIN two or more tables together, finding missing data.
• INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
• Create constraints, views and triggers
• Use UNION, CASE, MERGE, procedures and error checking
• Apply ranking and analytic functions, grouping, geography and geometry database
• Create subqueries and CTEs, PIVOTs, UDFs, APPLYs, synonyms.
• Manipulate XMLs and JSONs.
• Learn about transactions, optimise queries and row-based v set-based operations

Recommended Course

Complete SQL and Databases Bootcamp: Zero to Mastery [2023]

The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL”

Preview this Course - GET COUPON CODE

Next JS & Open AI / GPT: Next-generation Next JS & AI apps

 

Next JS & Open AI / GPT: Next-generation Next JS & AI apps Course

Next JS & OpenAI GPT3: Build an SEO-friendly blog post gen app with auth0, GPT, stripe payments, tailwind, & MongoDB

Welcome to the exciting world of AI-powered, next-generation, Next JS apps! In this course we will create a fictional Software-As-A-Service (SAAS) product called “BlogStandard”. We’ll build “BlogStandard” using a combination of Next.js, OpenAI’s GPT, MongoDB, Auth0, Stripe, and Tailwind CSS. BlogStandard allows users to create an account (handled by auth0), purchase tokens (handled by stripe), and spend those tokens to generate blog posts, powered by OpenAI’s GPT API. User’s tokens and generated blog posts will be stored using MongoDB.

In this comprehensive online course, you’ll learn how to harness the power of these cutting-edge technologies to build a fast, responsive, and dynamic web application that generates high-quality blog posts using AI. With step-by-step guidance, you’ll gain hands-on experience working with each of these technologies to bring your vision to life.

Best Seller Course: The Complete ChatGPT Web Development Code Along – Javascript

What you’ll learn

• Build your own SAAS products powered by AI and Next JS
• Use OpenAI’s GPT to implement AI generated content in your apps
• Authenticate your Next JS apps with Auth0
• Style your Next JS apps with Tailwind CSS
• Store data for your Next JS apps with MongoDB
• Charge customers using stripe

Recommended Course: The Next.js 13 Bootcamp – The Complete Developer Guide

Preview this Course  -  GET COUPON CODE

Certified Ethical Hacker v12. Practice Exams #UNOFFICIAL# NEW 2023!

 Certified Ethical Hacker v12. Practice Exams #UNOFFICIAL# NEW 2023!

CEH v11 / CEH v12 312-50 . Tests with complete explanations. Be Certified Ethical Hacker!

Created by Viktor Avimov| 4 practice tests video course

UPDATE: This course will update in the future after the release of CEH v12 (September 7). Since I maintain the high quality of my courses, it will take some time. “Certified Ethical Hacker” and “CEH” is a registered trademarks of EC-Council and this course is not licensed, endorsed, or affiliated with EC-Council in any way.”

The Certified Ethical Hacker (CEH) program is the most comprehensive ethical hacking course on the globe to help information security professionals grasp the fundamentals of ethical hacking. The hacking course outcome helps you become a professional who systematically attempts to inspect network infrastructures with the consent of its owner to find security vulnerabilities which a malicious hacker could potentially exploit. The CEH is the first of a series of 3 comprehensive courses (CEH, ECSA and the APT course) to help a cyber security professional master penetration testing.

The Certified Ethical Hacker is the most desired information security training program any information security professional will ever want to be in. To master the hacking technologies, you will need to become one, but an ethical one! The accredited hacking course provides the advanced hacking tools and techniques used by hackers and information security professionals alike to break into an organization. As we put it, “To beat a hacker, you need to think like a hacker”.

Recommended Course

CompTIA Pentest+ (Ethical Hacking) Course & Practice Exam

CompTIA Pentest+ PT0-002 (Ethical Hacking) Complete Course

Preview this Course  -  GET COUPON CODE

5 Days of Matlab, Simulink & SimScape – New 2023!

 

5 Days of Matlab, Simulink & SimScape – New 2023!

Build & Simulate Powerful Models in Matlab, Simulink & SimScape. Master Transfer Functions, PID, AI/ML & Live Scripts!

Simulink is a powerful MATLAB-based tool used to design and simulate mechanical, electrical, electromechanical, and hydraulic systems using a large comprehensive drag and drop library. This course is unique and exceptional in many ways. Every day, we will spend 1-2 hours together and learn how to build and simulate Matlab, Simulink and simscape models. The course is designed in a unique project-based learning approach, and you will learn by doing! The course includes several practice opportunities, quizzes, and final capstone projects.

Best Seller Course: Machine Learning for Data Science using MATLAB

What you’ll learn

• Model and simulate Mechanical Systems Using Physical Modeling techniques in SimScape
• Model and Simulate Systems in the Time Domain Using Simulink
• Analyze Systems Response and Change Model Parameters Using Matlab Live Scripts
• Understand the Basic Concepts of Control Systems and Develop their Own Controllers in Simulink
• Understand Control System Theory, Develop PID controllers, and Tune Controllers in Simulink
• Convert Systems from Time Domain to S-Domain Using Laplace Transform
• Understand the Concept of Transfer Functions
• Understand the Impact of Stiffness and Damping Coefficients on Second-Order Systems
• Understand the Theory and Intuition Behind Artificial Intelligence, Machine Learning, Deep Learning, and Artificial Neural Networks
• Train Artificial Intelligence Classifier Models in Matlab to Detect and Classify Diabetes and Cancer diseases
• Understand classifier model Key Performance Indicators (KPIs) such as accuracy, Area Under Curve (AUC) and Receiver Operating Characteristic (ROC) Curve

Recommended Course: Digital Signal Processing (DSP) From Ground Up™ with MATLAB

Preview this Course - GET COUPON CODE

[NEW] AWS Certified Security Specialty Complete Course 2023

 

[NEW] AWS Certified Security Specialty Complete Course 2023

Pass the AWS Certified Security Specialty (SCS-C01) Exam in 2023 with Confidence: A Comprehensive Video Course

Created by Neal Davis | AWS Certified Solutions Architect & Developer, Digital Cloud Training | AWS Certified Cloud Practitioner AWS Certified Solutions Architect, AWS Developer Associate | 9 hours on-demand video course

Are you looking to take your AWS knowledge to the next level and pass the AWS Certified Security Specialty (SCS-C01) exam? Our 9-hour instructor-led video course is designed for intermediate to advanced level candidates who need to apply security best practices to AWS.

This AWS training includes advanced guided hands-on practice activities focusing on security-specific scenarios, security deep dive lessons, and an exam-difficulty practice exam to test your progress.

Your highly experienced instructor will guide you through the key concepts and best practices for securing your AWS environment and passing the SCS-C01 exam. The course includes all the materials you need to succeed, including diagrams, code, links, files, and slides – all available for download.

By enrolling in our video course, you will not only pass the AWS Certified Security Specialty exam but also gain a comprehensive understanding of AWS security. Enhance your AWS knowledge, set yourself apart in the industry, and improve your chances of getting hired by taking our AWS Certified Security Specialty exam preparation course today.

What you’ll learn

• 9 HOURS OF INSTRUCTOR-GUIDED LECTURES: With our practical exercises, you’ll learn how to secure applications on Amazon Web Services
• EXAM CRAM LECTURES : These fast-paced lectures are perfect for quick revision of the most important facts before you sit your exam
• PRACTICE EXAM: Exam-Difficulty Practice Exam included to test your progress and knowledge
• ACTIVE Q&A FORUM: In this discussion board, students ask questions and share their recent exam experience offering feedback on which topics were covered
• RESPONSIVE SUPPORT: Our team of AWS experts respond to all of your questions, concerns or feedback

Preview this Course - GET COUPON CODE

ChatGPT: Build Solutions and Apps with ChatGPT and OpenAI Course

 

ChatGPT: Build Solutions and Apps with ChatGPT and OpenAI Course

Integrate ChatGPT into your no-code apps and solutions | Create 6+ ChatGPT integrations | Build 4+ ChatGPT Applications

This course has one objective: start building applications and solutions with ChatGPT. We do that by first learning more about OpenAI and ChatGPT, and how to use its APIs in our platforms. We then create a serverless function that can take ChatGPT prompts and return responses – the first step to integrate your ChatGPT into your application. After that, we learn to integrate the ChatGPT API into many platforms, like Outlook, Power Apps, Power Automate, Teams, Bubbe, Airtable, and more. Finally, we take all we’ve learned, and create full applications and solution examples, like TravelPlan, a web application that helps users create itineraries through the power of ChatGPT.

Best Seller Course: ChatGPT chatbot for Salesforce Admin and Developers Chat GPT

What you’ll learn

• Create full business applications and solutions with the OpenAI API and ChatGPT AI
• The inner workings of OpenAI, chatGPT, its capabilities, advantages, disadvantage, and more
• Integrate ChatGPT into several business platforms, like Outlook, Teams, Excel, Power Automate, and more
• Integrate ChatGPT into several no-code development applications, like Power Apps, Bubble, Airtable, and mofre
• Create a ChatGPT app that replies to your emails in a professional and polite manner
• Create a ChatGPT app from scratch that automatically creates real cover letters based on job ads and resumes
• Create a ChatGPT app from scratch that plans itineraries based on location, trip length, and interests
• Create a ChatGPT chatbot with Teams
• Create a ChatGPT app that generates stock photos to be used in pitch presentations and other slide decks
• Integrate ChatGPT API into Azure Functions, enabling you to put ChatGPT anywhere

Recommended Course: ChatGPT: Complete ChatGPT Course For Work 2023 (Ethically)!

Preview this Course  -  GET COUPON CODE

The Data Analyst Course: Complete Data Analyst Bootcamp 2023

 The Data Analyst Course: Complete Data Analyst Bootcamp 2023

Complete Data Analyst Training: Python, NumPy, Pandas, Data Collection, Preprocessing, Data Types, Data Visualization

Created by 365 Careers | 20.5 hours on-demand video course

Most data analyst, data science, and coding courses miss a critical practical step. They don’t teach you how to work with raw data, how to clean, and preprocess it. This creates a sizeable gap between the skills you need on the job and the abilities you have acquired in training. Truth be told, real-world data is messy, so you need to know how to overcome this obstacle to become an independent data professional.

The bootcamps we have seen online and even live classes neglect this aspect and show you how to work with ‘clean’ data. But this isn’t doing you a favour. In reality, it will set you back both when you are applying for jobs, and when you’re on the job.

What you’ll learn

• The course provides the complete preparation you need to become a data analyst
• Fill up your resume with in-demand data skills: Python programming, NumPy, pandas, data preparation – data collection, data cleaning, data preprocessing, data visualization; data analysis, data analytics
• Acquire a big picture understanding of the data analyst role
• Learn beginner and advanced Python
• Study mathematics for Python
• We will teach you NumPy and pandas, basics and advanced
• Be able to work with text files
• Understand different data types and their memory usage
• Learn how to obtain interesting, real-time information from an API with a simple script
• Clean data with pandas Series and DataFrames
• Complete a data cleaning exercise on absenteeism rate
• Expand your knowledge of NumPy – statistics and preprocessing
• Go through a complete loan data case study and apply your NumPy skills
• Master data visualization
• Learn how to create pie, bar, line, area, histogram, scatter, regression, and combo charts
• Engage with coding exercises that will prepare you for the job
• Practice with real-world data
• Solve a final capstone project

Preview this Course  -  GET COUPON CODE

QuickBooks Online 2023 Full Course Bookkeeping Accounting

 

QuickBooks Online 2023 Full Course Bookkeeping Accounting

QuickBooks Online + Shopify Store Integration

This course is taught by a designated CPA who also has over 12 years of software experience. We will be starting from the very beginning, first first setting up a file from scratch and then working our way through every topic in QuickBooks Online. We will be tackling every challenging topic but presenting it in a very digestible and understandable way. Accounting doesn’t need to be hard

This course is based on practical real-life scenarios. We will fully walkthrough examples together end to end. We even go as far as taking a look at the email notifications we will be receiving from the system and logging in as different users to see various user permissions. We will also be learning how to use the data import and integration functionality as you likely wouldn’t be entering transactions manually one by one in your business. Less theory and more practicality!

As a bonus, we will also be connecting to our Shopify store so that we can bring over product information and auto-generate invoices based on orders received in our store.

The end goal is to have you feeling confident and comfortable with using QuickBooks Online so that you can fully utilize this in your business or implement it for other businesses. Overall, you will finish this course and be fully equipped to tackle any business problem with QuickBooks Online!

Best Seller Course: The Data Analyst Course: Complete Data Analyst Bootcamp 2023

What you’ll learn

• Setup QuickBooks Online file from the very beginning
• Setup products, customers, vendors
• Create users and assign permissions
• Setup and analyze impact to chart of accounts
• Create invoices, bills, purchase orders, expenses, credits, discounted invoices, recurring invoices, sales receipts and more
• Connect to your bank or import your data through a CSV file import
• Categorize and automate your transactions
• Track and approve employee time at a basic level
• Create projects and analyze profitability
• Create custom reports
• Create management reports
• Export reports to excel and setup scheduled emailing of reports
• Create custom fields and modify invoice design templates
• Import data through excel and CSV file formats
• Connect to your Shopify store

Recommended Course: Business Data Analytics & Intelligence with Python 2023

Preview this Course  -  GET COUPON CODE

Tailwind CSS and Alpine JS – Essentials Training

 

Tailwind CSS and Alpine JS – Essentials Training

In this course we are going to get up and running with Tailwind CSS and Alpine JS.

Created by Malcolm Knott, Daniel Walter Scott | 2.5 hours on-demand video course

This course is for people who have a basic understanding of html and css, that want to get started with either Tailwind CSS or Alpine JS. This course also includes some javascript basics, but don’t worry if don’t have much or any javascript experience, we take the time to learn these basics where needed as we complete the course. We start off by quickly building a homepage of a website to give you an overview of what is like working with Tailwind CSS and Alpine JS. Then we pump the brakes and take our time to explain each part of the homepage.

This course isn’t so much about building a complete website from start to finish, it’s about giving you the tools to get started with, and complete your own project. We will build a homepage and also talk about some practical examples. Things you are going to need are a text editor and web browser. In this course I use Sublime Text and Google Chrome, it’s 100% ok for you to use whatever you are comfortable with. We are combining Tailwind CSS and Alpine JS into one course is so we’ll have a working web page or two at the end, rather than a static pages.

What you’ll learn

• Learn and understand the basics of Tailwind CSS
• Learn and understand the basics of Alpine JS
• Create a new project with Tailwind CSS and Alpine JS
• Make website components with Tailwind CSS and Alpine JS

Recommended Course

CSS – The Complete Guide 2023 (incl. Flexbox, Grid & Sass)

50 Projects In 50 Days – HTML, CSS & JavaScript

Preview this Course  -  GET COUPON CODE

The Complete WebdriverIO Course: From Zero to Expert! [2023]

 The Complete WebdriverIO Course: From Zero to Expert! [2023]

Automation testing with the WebdriverIO next-generation framework using JavaScript & Node.js

Created by Gianni Bruno | 32 hours on-demand video course

WebdriverIO is an open-source testing automation framework written in JavaScript and running on NodeJS. It is particularly useful for testing web applications. It supports both Behavior Driven Development (BDD) and Test Driven Development (TDD), making it a highly preferred choice for automation testers.

This course is designed to be effective, efficient and easy to follow. I have been teaching for several years on Udemy with over 6 highly successful courses to date. I have refined this course using proven teaching techniques. This course is carefully structured from start to finish and I provide downloadable code examples after each coding lecture.

What you’ll learn

• WebdriverIO in detail using JavaScript and NodeJS
• How to create a highly advanced framework using WebdriverIO
• The basics all the way to advanced subjects
• Advanced reporting and continuous integration using Jenkins
• Everything you need to know to write automation tests using WebdriverIO

Recommended Course

Selenium Webdriver with PYTHON from Scratch + Frameworks

WebdriverIO Certification Course with JavaScript & Node.js

Preview this Course  -  GET COUPON CODE

Ultimate AWS Certified Solutions Architect Associate SAA-C03

 

Ultimate AWS Certified Solutions Architect Associate SAA-C03

Full Practice Exam | Learn Cloud Computing | Pass the AWS Certified Solutions Architect Associate Certification SAA-C03!

The AWS Certified Solutions Architect Associate certification is one of the most challenging exams. It’s great at assessing how well you understand not just AWS, but making sure you are making the best architectural decisions based on situations, which makes this certification incredibly valuable to have and pass. Rest assured, I’ve passed it myself with a score of 982 out of 1000. Yes, you read that right, I only made one mistake! Next, I want to help YOU pass the AWS Certified Solutions Architect Associate certification with flying colors. This is going to be a long journey, but passing the AWS Certified Solutions Architect Associate exam will be worth it! This AWS Certified Solutions Architect Associate course is different from the other ones you’ll find on Udemy.

What you’ll learn

• FULLY UPDATED FOR SAA-C02: Pass the AWS Certified Solutions Architect Associate Certification
• Full Practice Exam with Explanations included!
• All 600+ slides available as downloadable PDF
• Perform Real-World Solution Architecture on AWS
• Learn the AWS Fundamentals (EC2, ELB, ASG, RDS, ElastiCache, S3)
• Learn the Serverless Fundamentals (Lambda, DynamoDB, Cognito, API Gateway)
• Analyze 10+ Solution Architectures (traditional & serverless)
• Understand the Well Architected Framework, Disaster Recovery
• Master all the differences of Databases on AWS
• Secure your entire AWS Cloud using KMS, IAM Policies & SSM

Recommended Course

Ultimate AWS Certified Solutions Architect Professional 2022

Ultimate AWS Certified SysOps Administrator Associate 2022

Preview this Course  -  GET COUPON CODE