96 Microsoft SQL Server courses

Unlock the power of SQL with the Mastering SQL Programming course. This comprehensive program takes you from the fundamentals to advanced techniques in SQL programming. Starting with setting up your tools, you'll delve into browsing, filtering, and sorting data. Explore complex operations, including mathematical calculations and string concatenation, while learning to manage NULL values and use CASE statements effectively. Dive into SQL functions, nested queries, and join operations, gaining mastery over data manipulation and database definition. Whether you're a beginner or seeking to enhance your SQL skills, this course equips you with the knowledge to become a proficient SQL programmer. Learning Outcomes: * Establish a solid foundation in SQL programming principles. * Efficiently browse, filter, and sort data for data retrieval. * Utilize AND, OR, and NOT operators for precise data filtering. * Perform mathematical operations and string concatenation in SQL. * Apply sorting, alias names, and record limiting to enhance result readability. * Handle NULL values and implement DISTINCT and CASE statements. * Master multiple-row and single-row functions for complex data processing. * Create nested queries and perform data manipulation using SQL. Why buy this Mastering SQL Programming?  * Unlimited access to the course for forever * Digital Certificate, Transcript, student ID all included in the price * Absolutely no hidden fees * Directly receive CPD accredited qualifications after course completion * Receive one to one assistance on every weekday from professionals * Immediately receive the PDF certificate after passing * Receive the original copies of your certificate and transcript on the next working day * Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Mastering SQL Programming you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Mastering SQL Programming course is ideal for * Aspiring database administrators and SQL developers. * Individuals looking to enhance their data management skills. * Business analysts seeking SQL proficiency for data analysis. * Anyone interested in learning SQL programming from basics to advanced concepts. Prerequisites This Mastering SQL Programming was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path * SQL Developer: £30,000 - £60,000 per year. * Database Administrator (DBA): £35,000 - £70,000 per year. * Data Analyst: £25,000 - £55,000 per year. * Business Intelligence Analyst: £35,000 - £65,000 per year. * SQL Instructor/Trainer: Earnings vary based on experience and location.

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: * Acquire a foundational understanding of SQL, its role, and importance in database management. * Master the creation, organization, and manipulation of databases. * Implement constraints to ensure data integrity and enforce business rules. * Utilize SQL functions to transform and manipulate data effectively. * Employ SQL clauses to filter, sort, and analyze data for specific purposes. * Perform alterations on databases and tables to accommodate evolving data needs. * Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. * Harness the power of wild cards to perform flexible and dynamic data searches. WHY BUY THIS SQL DATABASE MANAGEMENT? * Unlimited access to the course for forever * Digital Certificate, Transcript, student ID all included in the price * Absolutely no hidden fees * Directly receive CPD accredited qualifications after course completion * Receive one to one assistance on every weekday from professionals * Immediately receive the PDF certificate after passing * Receive the original copies of your certificate and transcript on the next working day * Easily learn the skills and knowledge from the comfort of your home CERTIFICATION After studying the course materials of the SQL Database Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. WHO IS THIS COURSE FOR? This SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  * Aspiring Database Administrators and SQL Developers. * Software Engineers Seeking Proficiency in SQL for Application Development. * Data Analysts and Business Intelligence Professionals. * IT Professionals Looking to Enhance Their Database Management Skills. PREREQUISITES This SQL Database Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CAREER PATH * SQL Developer - $70,000 to $110,000/year. * Database Administrator - $60,000 to $100,000/year. * Data Analyst - $60,000 to $90,000/year. * Business Intelligence Developer - $70,000 to $120,000/year. * Database Manager - $80,000 to $130,000/year. COURSE CURRICULUM Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: 1. Comprehend the fundamental architecture of SQL and its environment. 2. Acquire proficiency in basic and advanced SQL statements. 3. Understand and implement GROUP BY statements for data aggregation. 4. Master the concepts and applications of JOINS in databases. 5. Cultivate the ability to create and structure databases and tables. 6. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. 7. Construct efficient database models, fostering optimal data storage and retrieval.   Video Player https://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp4 00:00 00:00 00:00 Use Up/Down Arrow keys to increase or decrease volume. WHY CHOOSE THIS SQL FOR DATA ANALYTICS & DATABASE DEVELOPMENT COURSE? 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the SQL For Data Analytics & Database Development Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. WHO IS THIS SQL FOR DATA ANALYTICS & DATABASE DEVELOPMENT COURSE FOR? * Aspirants seeking to transition into data-driven roles in various industries. * Database administrators aiming to broaden their analytical capabilities. * Business analysts eager to enhance their data querying skills. * Researchers in need of comprehensive data management tools. * Tech enthusiasts wanting to grasp the underpinnings of database systems. CAREER PATH * Data Analyst - Average salary: £35,000 - £50,000 Per Annum * Database Developer - Average salary: £40,000 - £55,000 Per Annum * Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum * SQL Developer - Average salary: £42,000 - £58,000 Per Annum * Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum * Data Engineer - Average salary: £47,000 - £63,000 Per Annum PREREQUISITES This SQL For Data Analytics & Database Development was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. COURSE CURRICULUM Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes 1. Establish a strong foundation in SQL database administration, covering setup and configuration. 2. Master SQL statement basics, including querying, filtering, and sorting data effectively. 3. Utilize GROUP BY statements for data aggregation and summarization. 4. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. 5. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. WHY CHOOSE THIS SQL DATABASE ADMINISTRATOR AT QLS LEVEL 5 COURSE? * Unlimited access to the course for a lifetime. * Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. * Structured lesson planning in line with industry standards. * Immerse yourself in innovative and captivating course materials and activities. * Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. * Flexibility to complete the course at your own pace, on your own schedule. * Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. WHO IS THIS SQL DATABASE ADMINISTRATOR AT QLS LEVEL 5 COURSE FOR? 1. Aspiring Database Administrators and SQL Professionals. 2. Software Developers Seeking to Expand Their Database Management Skills. 3. IT Professionals Interested in Database Administration. 4. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge CAREER PATH 1. SQL Database Administrator - $60,000 to $110,000/year. 2. Database Developer - $70,000 to $120,000/year. 3. Data Engineer - $80,000 to $130,000/year. 4. Database Manager - $90,000 to $150,000/year. 5. Database Architect - $100,000 to $160,000/year PREREQUISITES This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. COURSE CURRICULUM Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

COURSE OVERVIEW: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass.  This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively. By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! -------------------------------------------------------------------------------- KEY FEATURES OF THE COURSE: * CPD certificate upon completion * 24/7 learning assistance and support -------------------------------------------------------------------------------- WHO IS THIS COURSE FOR? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. -------------------------------------------------------------------------------- WHAT YOU WILL LEARN: * Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. * Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. * Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. * Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. * Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. * Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. * Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. -------------------------------------------------------------------------------- WHY ENROL IN THIS COURSE: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. -------------------------------------------------------------------------------- REQUIREMENTS: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. -------------------------------------------------------------------------------- CAREER PATH: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: * Data Analyst - Average UK salary: £35,000 per year * Database Administrator - Average UK salary: £40,000 per year * Business Intelligence Analyst - Average UK salary: £45,000 per year * SQL Developer - Average UK salary: £40,000 per year * Data Engineer - Average UK salary: £55,000 per year * Software Developer - Average UK salary: £45,000 per year * Data Scientist - Average UK salary: £60,000 per year -------------------------------------------------------------------------------- CERTIFICATION: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. -------------------------------------------------------------------------------- COURSE CURRICULUM 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. RELATIONAL DATABASE BASICS * Brief History of SQL * Relational Databases * Popular Databases * SQL Statements SIMPLE SELECTS * Introduction to the Northwind Database * Some Basics * SELECTing All Columns in All Rows * Exploring the Tables * SELECTing Specific Columns * Sorting Records * The WHERE Clause and Operator Symbols * Using the WHERE clause to check for equality or inequality * Using the WHERE clause to check for greater or less than * Checking for NULL * Using WHERE and ORDER BY Together * The WHERE Clause and Operator Words * More SELECTs with WHERE * Checking Multiple Conditions * Writing SELECTs with Multiple Conditions ADVANCED SELECTS * Calculated Fields * Calculating Fields * Aggregate Functions and Grouping * Working with Aggregate Functions * Built-in Data Manipulation Functions * Data Manipulation Functions SUBQUERIES, JOINS AND UNIONS * Subqueries * Joins * Using Joins * Outer Joins * Unions * Working with Unions IF TIME ALLOWS, ONE OR MORE OF THE FOLLOWING MAY BE COVERED: * Conditional Processing with CASE * INSERT, UPDATE, DELETE * Student Challenges - Design your own reports