1265 Courses

Harness the power of Microsoft SQL Server, the world's leading relational database management system, and gain valuable skills that are in high demand by employers.

Got a new machine? Let me help you get to know your machine and then create a simple tote bag to apply your newly learned knowledge

Overview This comprehensive course on Microsoft SQL Server Development for Everyone will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Microsoft SQL Server Development for Everyone comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft SQL Server Development for Everyone . It is available to all students, of all academic backgrounds. Requirements Our Microsoft SQL Server Development for Everyone is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 31 lectures • 05:48:00 total length •Introduction to SQL Server and Databases: 00:04:00 •Download and Install SQL Server Express: 00:05:00 •Connect to Database Instance and Create a Database: 00:06:00 •Drop or Remove Database: 00:04:00 •What is a Database Table?: 00:02:00 •Create an SQL Database Table: 00:32:00 •Insert Data into the Table with SQL Script: 00:15:00 •Insert Data into the Table with Management Studio: 00:05:00 •Select Data from the Table with SQL Script: 00:09:00 •More Advanced Select Queries Part 1: 00:18:00 •Update Data in the Table: 00:10:00 •Update Data in the Table with Management Studio GUI: 00:02:00 •Delete Data from the Table with SQL Script: 00:06:00 •Delete Data from the Table with Management Studio GUI: 00:01:00 •What are Relationships, Foreign Keys and Normalization: 00:11:00 •Create a Relationship in SQL Server: 00:19:00 •Insert Records in Related Tables: 00:13:00 •Run Queries on Related Tables: 00:19:00 •Left, Right and Full Joins: 00:11:00 •Grouping Data using SQL GROUP BY Clause: 00:12:00 •SQL AVG Aggregate Function: 00:11:00 •SQL COUNT Aggregate Function: 00:04:00 •SQL MAX and MIN Aggregate Functions: 00:04:00 •SQL SUM Aggregate Function: 00:04:00 •Create and Manage Views: 00:23:00 •Scalar Valued Functions: 00:27:00 •Inline Table Valued Functions: 00:09:00 •Stored Procedures: 00:28:00 •Table Triggers: 00:19:00 •Database Scripting, Backup and Restore: 00:15:00 •Assignment - Microsoft SQL Server Development for Everyone: 00:00:00

Playing with Fire (safely) to create copper jewellery is an introduction into copper smithing where you will amaze yourself by using an age old technique to make unique jewellery.

Make your own Christmas Stocking using woven fabrics and a sewing machine.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Google Analytics mega bundle. This 40 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Google Analytics bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Google Analytics bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Google Analytics Bundle consists of the following premium courses: Course 01: Google Data Studio: Data Analytics Course 02: Diploma in Data Analysis Fundamentals Course 03: Learn How To Optimize Your Google My Business Page In 2016 Course 04: How To Do Keyword Research For SEO & Ranking On Google Course 05: Excel Pivot Tables for Data Reporting Course 06: Research Methods in Business Course 07: Business Intelligence and Data Mining Course 08: Microsoft Power BI - Master Power BI in 90 Minutes! Course 09: PowerBI Formulas Course 10: Digital Marketing for Beginners to Advanced Course 11: Digital Marketing Starting an online E-Commerce Store Course 12: Marketing Strategies for Business Course 13: Strategic Planning and Analysis for Marketing Course 14: Statistical Analysis Course 15: Ultimate Social Media Marketing course Course 16: Python Course Course 17: Complete Online Marketing & Advertising Course Course 18: Social Media Marketing-The Step by Step Guide Course 19: Create Your First Responsive Website Course 20: Data Science & Machine Learning with Python Course 21: Fundamentals of Business Analysis Course 22: Excel Data Analysis Course 23: Quick Data Science Approach from Scratch Course 24: Basics of WordPress: Create Unlimited Websites Course 25: The Ultimate SEO Blueprint - Easily Ranking #1 On Google Course 26: Complete Communication Skills Master Class for Life Course 27: Public Speaking Course 28: Minute Taking Executive Training Course 29: Receptionist Skills Course 30: Time Management Training - Online Course Moreover, this bundles include 10 career-focused courses: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile Course 06: Business English Perfection Course Course 07: Networking Skills for Personal Success Course 08: Boost Your Confidence and Self-Esteem Course 09: Public Speaking Training Course 10: Learn to Fight Procrastination Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Google Analytics mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to Google Analytics to uplift your morale The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free for all 40 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Google Analytics bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This Google Analytics bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Google Data Studio: Data Analytics) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Our masterclass series goes behind the studio door and explores the processes of globally respected designers.

BRIT Creative Coaching is structured for Performing Arts Students to reach their goals. Discover and build new skills that you need outside the studio.

Our 6 week pole dance courses available from Beginners/Stage 1, right up to Stage 10!