SQL - CPD Accredited

Description

Give a compliment to your career and take it to the next level. This SQL (Structured Query Language) will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this coursewill help you keep ahead of the pack.

The course incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this SQL (Structured Query Language) will add extra value to your resume to stand out to potential employers.

Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the SQL (Structured Query Language), you can equip yourself with the essentials to keep you afloat into the competition.

Along with this SQL (Structured Query Language) course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free.

This Bundle Consists of the following Premium courses:

• Course 01: SQL Server for Beginners
• Course 02: Microsoft SQL Server Development for Everyone
• Course 03: Python for Data Analysis
• Course 04: Coding with HTML, CSS, & JavaScript
• Course 05: Modern Web Designing - Level 2
• Course 06: Diploma in PHP Web Development
• Course 07: Front End Web Development Diploma
• Course 08: Secure Programming of Web Applications
• Course 09: Linux for Absolute Beginners!
• Course 10: Ethical Hacking
• Course 11: Creativity and Problem Solving Skills

So, enrol now to advance your career!

Benefits you'll get choosing Apex Learning for this SQL (Structured Query Language):

• One payment, but lifetime access to 11 CPD courses
• Certificate, student ID for the title course included in a one-time fee
• Full tutor support available from Monday to Friday
• Free up your time - don't waste time and money travelling for classes
• Accessible, informative modules taught by expert instructors
• Learn at your ease - anytime, from anywhere
• Study the course from your computer, tablet or mobile device
• CPD accredited course - improve the chance of gaining professional skills

How will I get my Certificate?

After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.

• PDF Certificate: Free (Previously it was £6*11 = £66)
• Hard Copy Certificate: Free (For The Title Course: Previously it was £10)

Curriculum of the Bundle

Course 01: SQL Server for Beginners

• Introduction
• Setup
• Basic queries
• Security
• MSSQL and different drivers
• Files
• General

Course 02: Microsoft SQL Server Development for Everyone

• Introduction
• Manipulating Tables and Data
• Relationships Foreign Keys
• Group By and Aggregate Functions
• Advanced Server Objects and Concepts

Course 03: Python for Data Analysis

• Welcome, Course Introduction & overview, and Environment set-up
• Python Essentials
• Python for Data Analysis using NumPy
• Python for Data Analysis using Pandas
• Python for Data Visualization using matplotlib
• Python for Data Visualization using Seaborn
• Python for Data Visualization using pandas
• Python for interactive & geographical plotting using Plotly and Cufflinks
• Capstone Project - Python for Data Analysis & Visualization
• Python for Machine Learning (ML) - scikit-learn - Linear Regression Model
• Python for Machine Learning - scikit-learn - Logistic Regression Model
• Python for Machine Learning - scikit-learn - K Nearest Neighbors
• Python for Machine Learning - scikit-learn - Decision Tree and Random Forests
• Python for Machine Learning - scikit-learn -Support Vector Machines (SVMs)
• Python for Machine Learning - scikit-learn - K Means Clustering
• Python for Machine Learning - scikit-learn - Principal Component Analysis (PCA)
• Recommender Systems with Python - (Additional Topic)
• Python for Natural Language Processing (NLP) - NLTK - (Additional Topic)

Course 04: Coding with HTML, CSS, & Javascript

• Welcome
• HTML 5
• CSS 3
• Bootstrap
• Project 1 - Design a Landing Page
• Project 2 - Business Website
• SProject 3 - Portfolio

Course 05: Modern Web Designing - Level 2

Module: 01

• 1.1 Intro
• 1.2 Install the Tools and Get Started

Module: 02

• 2.1 Intro to HTML
• 2.2 What is HTML
• 2.3 Start a New HTML File & Use Tags
• 2.4 Header Tags
• 2.5 Edit Text
• 2.6 Links
• 2.7 Images
• 2.8 Lists
• 2.9 Challenge
• 2.10 HTML Outro

Module: 03

• 3.1 CSS Intro
• 3.2 Add CSS Styles
• 3.3 Classes and IDs
• 3.4 Borders
• 3.5 Sizing
• 3.6 Padding and Margin
• 3.7 Text Styles
• 3.8 DIVs
• 3.9 Postioning
• 3.10 Hover
• 3.11 Easily Center Elements
• 3.12 Fonts
• 3.13 Challenge
• 3.14 CSS Outro

Module: 04

• 4.1 Intro to Bootstrap
• 4.2 Install Bootstrap
• 4.3 Indenting and Containers
• 4.4 The Grid System
• 4.5 Images
• 4.6 Buttons
• 4.7 Challenge
• 4.8 Bootstrap Outro

Module: 05

• 5.1 Landing Page Intro
• 5.2 Sketch Your Landing Page
• 5.3 The Top Section
• 5.4 Polish the Top Section
• 5.5 Adding Images
• 5.6 The Main Points Section
• 5.7 Collecting Emails With an Opt-In Form
• 5.8 Challenge
• 5.9 Landing Page Outro

Module: 06

• 6.1 Business Site Intro
• 6.2 Sketch Up
• 6.3 Using Fancy Font Logo
• 6.4 Carousel Basics
• 6.5 Carousel Extras
• 6.6 Text on Images
• 6.7 Phone Number Icon
• 6.8 Google Maps
• 6.9 Font Awesome
• 6.10 Challenge
• 6.11 Business Site Outro

Module: 07

• 7.1 Intro
• 7.2 Portfolio Sketch
• 7.3 Jumbotron
• 7.4 Nav Bar
• 7.5 Panels
• 7.6 Challenge
• 7.7 Portfolio Outre

Module: 08

• 8.1 Hosting
• 8.2 Bluehost
• 8.3 Uploading
• 8.4 Tips
• 8.5 Hosting Outro

Course 06: Diploma in PHP Web Development

• Unit 01: Introduction
• Unit 02: Environment Configuration
• Unit 03: PHP Basics and Syntax
• Unit 04: PHP Forms and MySQL and User Authentication

Course 07: Front End Web Development Diploma

• Welcome to the course!
• Web Development Basics - HTML
• Advanced HTML Concepts
• Introduction to Cascading Style Sheets (CSS)
• Advanced CSS
• JavaScript for Begeinners
• More JavaScript Concepts
• Getting Started with jQuery
• More jQuery
• Bootstrap Basics
• Project #2 - Pipboy from Fallout 4
• Project #3 - Google Chrome Extension
• BONUS - Coding Another Google Chrome Extension

Course 08: Secure Programming of Web Applications

• Section 01: Introduction
• Section 02: Well-known Vulnerabilities and Secure Programming
• Section 03: Conclusion and Summary

Course 09: Linux for Absolute Beginners!

• Introduction to Linux
• Linux Installation
• Linux Command Line Interface (CLI) Essentials
• Advanced CLI Usage
• Linux Development Tools
• Web Development Project
• Web Server Setup, Host Cofiguration and App Deployment
• Linux User Management
• Linux Network Administration

Course 10: Ethical Hacking

• Introduction to Ethical Hacking
• Reconnaissance - Surveying the Attack Surface
• Scanning and Enumeration - Getting Down to Business
• Network Presence
• Attacking
• Web Hacking
• Social Engineering - Hacking Humans

Course 11: Creativity and Problem Solving Skills

• Getting Started
• The Problem Solving Method
• Information Gathering
• Problem Definition
• Preparing for Brainstorming
• Generating Solutions (I)
• Generating Solutions (II)
• Analyzing Solutions
• Selecting a Solution
• Planning Your Next Steps
• Recording Lessons Learned

CPD

Who is this course for?

Requirements

Career path

Certificates