169 Database Management Systems courses delivered On Demand

Description: This Microsoft Office Business Contact Manager 3 will help you to learn everything you need to teach Microsoft Office Business Contact Manager 3. In this course you will learn how to install business contact manager, use express setup and advanced setup, use the business contact manager dashboard, use the business contact manager folder list, menus, and toolbar, create and remove a database, use shared database, manage your database, access the welcome email, use the dashboard links, use 'learn about business contact manager', use the help menu, and more. This course will help you to get skilled and improve your knowledge. Learning Outcomes: Understand and install Business Contact Manager, and use express and advanced setup View folders, use dashboard, menu and toolbar in the Business Contact Manager Create, remove, share and manage database, along with connections to other shared databases Get to know welcome emails, use dashboard links, 'Learn about Business Contact Manager', and help menu Open folders, create, edit and view Accounts, Business Contacts, Opportunities and Business Projects and Project Tasks Discover how to create a history item, business note in and outside an item, view the communication history folder and use link to record and emails to auto-links Learn to open the dashboard, customize it and about the home, sales, marketing and projects tab Setup and use the Product and Service Items List, import and export data, generate reports and utilize the reports window in the information management tools Go through marketing campaigns by creating basic campaigns, campaigns through Word and Publisher, and track campaign results Create custom forms, edit lists in and outside a form Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office Business Contact Manager 3 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office Business Contact Manager 3 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Configuring Business Contact Manager Getting Started 00:30:00 Using Business Contact Manager 00:15:00 Working with Business Contact Manager Data 00:15:00 Getting Help in Business Contact Manager 00:15:00 Using Business Contact Manager Accounts 00:15:00 Business Contacts 00:15:00 Opportunities 00:15:00 Business Projects and Project Tasks 00:30:00 Communications History and Linking 00:15:00 Business Contact Manager Tools Using the Dashboard 00:15:00 Information Management Tools 00:30:00 Marketing Campaigns 00:15:00 Customizing Forms 00:15:00 Mock Exam Mock Exam- Microsoft Office Business Contact Manager 3 00:20:00 Final Exam Final Exam- Microsoft Office Business Contact Manager 3 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unlock the power of data-driven decision-making with our Business Intelligence Analyst Course. Gain essential skills in data analysis, visualization, and interpretation to extract valuable insights for business growth. Whether you're a seasoned professional or new to the field, this course provides comprehensive training in business intelligence tools and techniques. Enroll now and become proficient in transforming raw data into actionable intelligence, empowering organizations to make informed strategic decisions.

Unlock the potential of business intelligence with our specialized Business Intelligence Analyst Course. Learn to analyze data, extract insights, and drive strategic decisions to optimize business performance. Gain practical skills in data visualization, reporting, and predictive analytics using industry-leading tools and techniques. Whether you're a business professional or aspiring analyst, this course equips you with the expertise to excel in leveraging data for business intelligence.

Are you tired of companies making decisions that seem to have no rhyme or reason? Do you want to be part of the solution? Introducing our Business Intelligence Analyst course - designed to equip you with the skills and knowledge to help businesses make better decisions. Learning Outcomes: Upon completion of the Business Intelligence Analysts course, you can expect to: Gain a comprehensive understanding of business intelligence principles and concepts. Develop the ability to analyse real-time data for informed decision-making. Acquire the fundamentals of statistics and data science to drive actionable insights. Master the basics of SQL for efficient data manipulation and analysis. Learn essential techniques for effective database management. Explore data warehouse concepts and their role in business intelligence. In today's fast-paced business landscape, data is king. The ability to harness and analyse data effectively has become a crucial skill for professionals looking to make a significant impact. Our comprehensive Business Intelligence Analyst course is designed to equip you with the knowledge and expertise to drive better decision-making within organisations. Through a series of engaging and practical modules, you'll embark on a journey to unlock the power of business intelligence. From understanding the fundamentals and concepts to discovering real-time data analysis techniques, you'll gain invaluable insights into the world of data-driven decision-making. Our Business Intelligence Analysts course takes a deep dive into statistics and data science, arming you with the necessary knowledge to extract meaningful insights from complex datasets. You'll also learn the fundamentals of SQL, enabling you to manipulate and analyse data efficiently. Database management essentials and data warehouse concepts will further enhance your understanding of the role data plays in business intelligence. Enrol right now! Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The target audience for the Business Intelligence Analysts course is: Aspiring data analysts seeking to specialise in business intelligence. Professionals looking to enhance their decision-making abilities through data analysis. Managers and executives aiming to gain a deeper understanding of data-driven strategies. Entrepreneurs and business owners eager to leverage data for improved business outcomes. Career path This Business Intelligence Analysts course will help you to pursue a range of career paths, such as: Business Intelligence Analyst: £30,000 - £60,000 per annum Data Analyst: £25,000 - £45,000 per annum Business Analyst: £35,000 - £65,000 per annum Database Administrator: £30,000 - £55,000 per annum Data Scientist: £40,000 - £80,000 per annum Analytics Manager: £45,000 - £90,000 per annum

Overview This comprehensive course on Business Intelligence Analyst Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Intelligence Analyst Course 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 Business Intelligence Analyst Course. It is available to all students, of all academic backgrounds. Requirements Our Business Intelligence Analyst Course 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 8 sections • 8 lectures • 05:21:00 total length •An Introduction to Business Intelligence: 00:46:00 •Real-time Business Intelligence: 00:35:00 •Fundamentals of Statistics and Data Science: 00:50:00 •Fundamentals of SQL: 00:40:00 •Database Management Essentials: 00:50:00 •Data Warehouse Concepts: 00:38:00 •Data Visualisation in Business Intelligence: 00:35:00 •Basics of Python: 00:27:00

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

Course Overview: The demand for web developers is snowballing. According to the Bureau of Labor Statistics, employment of web developers is projected to grow 22 percent from 2020 to 2030, much faster than the average for all occupations. Are you eager to craft powerful web applications that captivate users and drive business growth? Look no further! This Building Web Applications with Django and PostgreSQL course will equip you with the essential skills to master Django, a versatile web framework, and PostgreSQL, a robust database management system. "Numbers don't lie" - the soaring popularity of Python-based web frameworks like Django is a testament to their relevance and demand in the industry. As you delve into this course, you'll be pleased to know that recent surveys have highlighted Django's dominance in the web development market. Gain a competitive edge as you learn from seasoned professionals, and dive into the world of web development with confidence.  Take advantage of this golden opportunity! Enrol now to embark on an exciting journey of learning and transformation. Key Features of the Course: Unleash your potential with a CPD certificate upon course completion, solidifying your expertise in web application development. Enjoy an uninterrupted learning experience with our 24/7 Learning Assistance, ensuring that you have the support you need whenever you need it. Embrace an interactive and engaging learning journey with captivating materials, real-world projects, and quizzes that inspire you. Who is This Course For? If you aspire to become a web developer, programming virtuoso, or IT enthusiast, this Building Web Applications with Django and PostgreSQL course is tailor-made. Whether you're just starting or an experienced developer looking to enhance your skill set, our course caters to learners of all levels, fostering an inclusive and supportive learning environment. What You Will Learn: Seamlessly set up Python and PyCharm IDE on diverse platforms. Unravel the architectural marvels of Django, and build your first Django app. Embrace the power of PostgreSQL for web applications and configure it flawlessly. Harness the potential of Django's built-in ORM for streamlined database interactions. Implement foolproof user authentication and authorisation mechanisms. Craft dynamic web pages using HTML, templates, and Bootstrap. Design visually stunning product card items to elevate your web applications. Why Enrol in This Course: Your success story begins with us, where you'll gain in-demand skills to create sophisticated web applications that thrive in today's digital landscape. Experience the best as you join our top-reviewed course, regularly updated to stay ahead of industry trends. With hands-on experience and industry-relevant skills, you'll elevate your employability and unlock doors to exciting opportunities. Requirements: A basic understanding of Python A computer with Python installed Career Path: Upon completion, embark on a rewarding career path in web development with diverse options, including: Web Developer - £35,000 to £55,000 per annum Full-Stack Developer - £40,000 to £65,000 per annum Django Developer - £45,000 to £70,000 per annum Python Developer - £40,000 to £65,000 per annum Frontend Developer - £30,000 to £50,000 per annum Backend Developer - £40,000 to £65,000 per annum Database Administrator - £35,000 to £55,000 per annum Certification: The crowning achievement of your learning endeavour awaits as you earn your well-deserved CPD certificate. Recognised and esteemed across industries, this certificate will validate your proficiency in building web applications with Django and PostgreSQL. Take the first step towards excellence and enrol in our course today! Course Curriculum 10 sections • 53 lectures • 04:52:00 total length •Introduction: 00:04:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:02:00 •FAQs: 00:01:00 •Installing Python: 00:07:00 •Installing PyCharm IDE for development: 00:12:00 •Creating the first Python project: 00:09:00 •Write and Run Hello World program: 00:05:00 •Command line basics: 00:06:00 •Installation and access pip command: 00:10:00 •Introduction to web framework and Django: 00:04:00 •Installing Django and setting up a project: 00:07:00 •Understanding Django architecture and structured: 00:08:00 •Creating a simple Django app: 00:06:00 •Introduction to PostgreSQL and its advantages for web applications: 00:04:00 •Installing PostgreSQL and setting up a database: 00:13:00 •pgAdmin Secure login and create database: 00:10:00 •Connection Django to PostgreSQL: 00:09:00 •Creating a Basic HTTP view method request: 00:04:00 •URL pattern on app: 00:05:00 •Include apps to project urls: 00:05:00 •Installing the psycopg2 module for DB connection: 00:05:00 •Defining models and creating database tables: 00:08:00 •Using Djangos built-in ORM to interact with the database: 00:06:00 •Migration to create DB tables: 00:06:00 •Assessment Test: 00:01:00 •Solution for an Assessment Test: 00:04:00 •Creating Superuser as Admin: 00:07:00 •Authentication and Authorization: 00:03:00 •User access permissions: 00:04:00 •Registering user models to the admin Dashboard: 00:04:00 •Creating data using CRUD functionality: 00:06:00 •View data on the PostgreSQL database table: 00:04:00 •Understanding the MVC: 00:05:00 •Creating views and handling HTTP requests and rendering templates: 00:10:00 •Creating a template with HTML page: 00:10:00 •Building dynamic form and handling: 00:10:00 •Creating Bootstrap template: 00:06:00 •Applying Bootstrap to Django form: 00:04:00 •Creating Stunning Product Card items: 00:09:00 •Creating model: 00:04:00 •Creating forms: 00:03:00 •Creating views: 00:07:00 •Applying ORM - migrations: 00:03:00 •Creating my_form template: 00:05:00 •Adding urls: 00:03:00 •Creating success_view template: 00:04:00 •Project urls update and adding Installed apps: 00:02:00 •Run project and submit data to database: 00:06:00 •Creating report_view method: 00:03:00 •Creating report_template: 00:03:00 •Update urls pattern: 00:02:00 •Run project and test reports: 00:03:00

The Business Intelligence Analyst Course aligns with current industry trends and market needs, addressing emerging opportunities and challenges in data-driven decision-making. As businesses increasingly rely on data for strategic planning, this course provides the foundational knowledge and skills required to interpret and leverage data effectively. It prepares learners to meet the growing demand for data analysis and interpretation in various sectors. The primary problem this course addresses is the gap in practical, accessible knowledge for analysing and interpreting business data. By bridging this gap, the course enables learners to transform raw data into meaningful insights. This ability is crucial for driving business growth, improving operational efficiency, and enhancing strategic decision-making processes across industries. In today's data-centric business environment, possessing skills in business intelligence and data analysis is not just advantageous but essential. This course equips learners with the knowledge to analyse data accurately, leading to informed decision-making and competitive advantage in various business contexts. Learning Outcomes Understand the basics and importance of Business Intelligence in modern business. Grasp real-time applications of Business Intelligence in industry scenarios. Learn statistical and data science fundamentals crucial for analysis. Gain proficiency in SQL for effective data management and querying. Master essential aspects of database management and operations. Explore data warehouse concepts and their relevance in data storage. Develop skills in data visualisation techniques for business insights. Acquire basic Python knowledge for data analysis applications. Why choose this Business Intelligence Analyst Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Business Intelligence Analyst Course for? Individuals aspiring to become Business Intelligence Analysts. Professionals seeking to enhance their data analysis skills. Entrepreneurs needing to understand data for better business decisions. Managers and team leaders requiring data-driven decision-making abilities. Anyone interested in pursuing a career in data analysis and business intelligence. Career path Business Intelligence Analyst: £30,000 - £50,000 Data Analyst: £27,000 - £40,000 Database Administrator: £30,000 - £45,000 Data Scientist: £35,000 - £60,000 Business Analyst: £32,000 - £52,000 Prerequisites This Business Intelligence Analyst Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Business Intelligence Analyst 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. Course Curriculum Module-1: An Introduction to Business Intelligence An Introduction to Business Intelligence 00:46:00 Module-2: Real-time Business Intelligence Real-time Business Intelligence 00:35:00 Module-3: Fundamentals of Statistics and Data Science Fundamentals of Statistics and Data Science 00:50:00 Module-4: Fundamentals of SQL Fundamentals of SQL 00:40:00 Module-5: Database Management Essentials Database Management Essentials 00:50:00 Module-6: Data Warehouse Concepts Data Warehouse Concepts 00:38:00 Module-7: Data Visualisation in Business Intelligence Data Visualisation in Business Intelligence 00:35:00 Module-8: Basics of Python Basics of Python 00:27:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

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 Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. 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? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. 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