687 Courses delivered Online

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data 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 Relationships and Foreign Keys 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 Group By and Aggregate Functions 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 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Recent developments in data analytics and statistics underscore the critical importance of understanding both data structure and analytics methodologies in today's data-driven world. With the exponential growth of data, businesses are increasingly relying on skilled professionals who can harness the power of data to drive informed decision-making. Our comprehensive Data Structure, Data Analytics with Statistics & Data Science QLS Endorsed Diploma bundle, endorsed by the Quality Licence Scheme (QLS) and accredited by the CPD Quality Standards (QS), offers a holistic approach to mastering data structure, data analytics, and statistical techniques. In an era where data reigns supreme, organisations seek individuals who can navigate complex datasets with confidence and precision. This Data Structure, Data Analytics bundle equips learners with the essential skills and knowledge needed to excel in the field of data science and analytics. By delving into topics such as data manipulation, statistical analysis, and database management, participants gain a deep understanding of how to extract valuable insights from raw data. Moreover, our guided courses in career development and communication empower learners to effectively communicate their findings and advance their professional journey. Bundle Include includes: QLS Endorsed Courses: Course 01: Certificate in Data Analytics with Tableau at QLS Level 3 Course 02: Diploma in Data Structure at QLS Level 5 Course 03: Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 CPD QS Accredited Courses: Course 04: Business and Data Analytics for Beginners Course 05: Learn Financial Analytics and Statistical Tools Course 06: SQL For Data Analytics & Database Development Course 07: Big Data Analytics with PySpark Power BI and MongoDB Course 08: Google Data Studio: Data Analytics Course 09: Business Intelligence Analyst Course 10: Spatial Data Visualization and Machine Learning in Python Course 11: Data Analysis In Excel Take your career to the next level with our Data Structure, Data Analytics bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive Data Structure, Data Analytics bundle, endorsed by the prestigious QLS and accredited by CPD.Data Structure, Data Analytics with Statistics & Data Science QLS Endorsed Diploma. Learning Outcomes: Upon completion of this Data Structure, Data Analytics bundle, participants will be able to: Demonstrate proficiency in data analytics tools such as Tableau, SQL, and Google Data Studio through Data Structure, Data Analytics courses. Apply statistical techniques to analyse and interpret data for informed decision-making. Design and implement data structures to efficiently store and retrieve information. Utilise machine learning algorithms for predictive analysis and pattern recognition. Develop effective communication and presentation skills to convey insights to stakeholders. Navigate career development pathways in the field of data science and analytics. This Data Structure, Data Analytics course bundle provides a deep dive into the foundational principles of data structure, data analytics, and statistical methodologies. Participants will explore the fundamental concepts of data manipulation, including sorting, searching, and storing data efficiently. Through hands-on exercises and theoretical discussions, learners will gain a solid understanding of various data structures such as arrays, linked lists, trees, and graphs, along with their applications in real-world scenarios. Moreover, the Data Structure, Data Analytics bundle encompasses a comprehensive exploration of data analytics techniques, equipping participants with the skills to extract actionable insights from complex datasets. From descriptive and inferential statistics to predictive modelling and machine learning algorithms, learners will discover how to uncover patterns, trends, and correlations within data, enabling informed decision-making and strategic planning. Throughout the Data Structure, Data Analytics course, emphasis is placed on practical applications and case studies, allowing participants to apply their knowledge to solve real-world problems in diverse domains. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Structure, Data Analytics course is perfect for: Aspiring data analysts seeking to enhance their analytical skills acrod Data Structure, Data Analytics courses. Professionals transitioning into roles requiring proficiency in data analytics. Students pursuing careers in data science, statistics, or related fields. Business professionals looking to leverage data for strategic decision-making. Individuals interested in advancing their career prospects in the field of data analytics. Anyone seeking to gain a comprehensive understanding of data structure, analytics, and statistics. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Data Structure, Data Analytics courses, you will be able to: Data Analyst Business Intelligence Analyst Data Scientist Statistician Database Administrator Machine Learning Engineer Data Engineer Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

24 Hour Flash Deal **25-in-1 Mobile App Developer Diploma Mega Bundle** Mobile App Developer Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Mobile App Developer Diploma package online with Studyhub through our online learning platform. The Mobile App Developer Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Mobile App Developer Diploma course provides complete 360-degree training on Mobile App Developer Diploma. You'll get not one, not two, not three, but twenty-five Mobile App Developer Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Mobile App Developer Diploma courses are yours for as long as you want them once you enrol in this course This Mobile App Developer Diploma Bundle consists the following career oriented courses: Course 01: Mobile and Web Development with Ionic & Angular JS Course 02: Flutter & Dart Development Course Course 03: Code Your Own Drawing Application in Android Studio Course 04: Building a TodoMVC Application in Vue, React and Angular Course 05: Learn Spring & Angular Material with a Full Web Application Course 06: Learn How To Create a Web App for iPad Course 07: Program Your Own Photo Editor App in Android Studio! Course 08: Build Progressive Web Apps with Angular Course 09: Web Applications for Specialisation on Development Course 10: Complete Web Development Course 11: Penetration Testing with OWASP ZAP: Mastery course Course 12: Web Application Penetration Testing Course 13: HTML and CSS Coding: Beginner to Advanced Course 14: Basics of WordPress Course 15: PHP Web Development with MySQL Course 16: JavaScript Functions Course 17: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 18: Python Basic Programming Course 19: C Programming Language Course 20: C++ Programming Course 21: Advanced Diploma in User Experience UI/UX Design Course 22: Diploma in Front-End Web Development Course 23: Responsive Web Design Course 24: Secure Programming of Web Applications Course 25: Maya & Unity 3D: Modeling Environments for Mobile Games The Mobile App Developer Diploma course has been prepared by focusing largely on Mobile App Developer Diploma career readiness. It has been designed by our Mobile App Developer Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Mobile App Developer Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Mobile App Developer Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Mobile App Developer Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Mobile App Developer Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Mobile App Developer Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Mobile App Developer Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Mobile App Developer Diploma lessons One to one assistance from Mobile App Developer Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Mobile App Developer Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Mobile App Developer Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Mobile App Developer Diploma certificate and transcript on the next working day Easily learn the Mobile App Developer Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Mobile App Developer Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Mobile App Developer Diploma Requirements To participate in this Mobile App Developer Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Mobile App Developer Diploma Career path You will be able to kickstart your Mobile App Developer Diploma career because this course includes various courses as a bonus. This Mobile App Developer Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Mobile App Developer Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

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.

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.

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

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

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

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