4301 Technology courses

Description Introduction To Neobanks Diploma Welcome to the Introduction To Neobanks Diploma, an engaging and comprehensive online course designed to enlighten you on the emergence of Neobanks and their significant role in reshaping the financial services landscape. This course offers a deep understanding of Neobanks, their business models, regulatory environment, technology, infrastructure, and their impact on traditional banking. The Introduction To Neobanks Diploma starts by unfolding the concept of Neobanks, their origin, evolution and why they have become a significant topic in the contemporary banking sector. It sets a solid foundation for further modules by providing a detailed explanation of what Neobanks are, their unique selling points, and how they are different from traditional banks. Next, the course elaborates on the business model of Neobanks. It provides an extensive review of how these digital banks operate, make profits, and how they manage to offer low-cost, customer-centric services. Participants will get insights into the cost structure, revenue streams, and value proposition of these modern banks. Understanding the regulatory environment of Neobanks is paramount, and this course shines a light on this critical area. It discusses the regulatory hurdles that Neobanks face, how they navigate this complex environment, and the effects of regulatory changes on their operations. A key strength of Neobanks lies in their technology and infrastructure. This course examines the advanced technologies, such as artificial intelligence and blockchain, that underpin Neobanks and facilitate their seamless, 24/7 services. It reveals how these technologies power innovative features and offer a superior customer experience. Talking of customer experience, the course analyses the ways in which Neobanks have revolutionised this aspect. It offers a detailed understanding of how they use technology to provide personalised services, swift transactions, and how they manage to create a seamless and delightful experience for their users. An essential segment of the Introduction To Neobanks Diploma involves looking at how Neobanks operate in different market segments. It explores their strategies for catering to diverse demographic groups, their approach to global expansion, and the opportunities and challenges they face in various markets. The risks and challenges in Neobanking cannot be overlooked. The course delves into the possible hurdles that Neobanks face, including cybersecurity threats, operational risks, and competitive pressures. It also considers how they mitigate these risks and the contingency plans they have in place. Investment and funding play a crucial role in the growth of Neobanks, and the course provides a comprehensive view of this aspect. It covers the funding landscape, the role of venture capital, and how Neobanks attract and utilise investments for their growth and expansion. A core part of this course focuses on the impact of Neobanks on traditional banking. It examines the competitive pressure they exert on established banks, their disruption of the status quo, and the response of traditional banks to this digital onslaught. Finally, the Introduction To Neobanks Diploma looks at future trends in Neobanking. It discusses the possible trajectory of this sector, the emerging trends, and how Neobanks are likely to evolve in response to changes in customer needs and technological advances. In a nutshell, this course provides a holistic understanding of Neobanks and prepares you to navigate and succeed in this rapidly evolving financial landscape. Enrol now and begin your journey into the world of Neobanks. What you will learn 1:Introduction to Neobanks 2:The Business Model of Neobanks 3:Neobanks and Regulatory Environment 4:Technology and Infrastructure in Neobanks 5:Customer Experience in Neobanks 6:Neobanks in Different Market Segments 7:Risks and Challenges in Neobanking 8:Investment and Funding in Neobanks 9:Impact of Neobanks on Traditional Banking 10:Future Trends in Neobanking Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Discover EnergyEdge's course for decision-based geothermal field development. Unlock your potential and excel in this dynamic industry.

Become an expert in the art of nail technology with our Nail Technician Course. Learn about manicures, pedicures, acrylics, safety, and business strategies. Begin now!

Getting Started The CMI Level 5 Certificate in Management and Leadership course is designed for practising or aspiring middle managers and leaders at operations, division, departmental or specialist level, who are typically accountable to a senior manager or business owner. Leading and managing individuals and teams to deliver in line with the organisational strategy is the primary role of a practising manager. You'll develop the key strategic skills and competencies required to manage teams and individuals effectively, enabling you to deliver long-lasting results. The CMI Level 5 Certificate in Management and Leadership is a shorter course focusing on improving your capabilities and core management skills to the next level. Achieving the CMI Level 5 Certificate in Management and Leadership qualification will enhance your credibility and enable you to outperform in demanding roles and situations. You'll have a wide range of modules to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits For Learners: Improve your capabilities and core management skills Develop the knowledge and skills required for managing and leading individuals and teams Provide an extensive knowledge of skills to excel in specific management areas For Organisations: Deliver aims and objectives in line with wider organisational strategy Provide you with a fully wider range of skills and knowledge required to be a manager as part of an organisation Focus on the areas that are most appropriate to your role and organisation Key Highlights Are you an aspiring Manager or Leader looking for career development? Then, the CMI Level 5 in Management and Leadership qualification offered by School of Business and Technology London is the right solution for you. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The CMI Level 5 Management & Leadership can open many career pathways including, but not limited to: Operations Manager, with an estimated salary of £51,577 per annum Divisional Manager, with an estimated salary of £48,613 per annum Departmental Manager, with an estimated salary of £34,997 per annum Regional Manager, with an estimated salary of £51,372 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 10 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Get Foundation Chartered Manager status upon course completion Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 3000 to 4,000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for current or aspiring mid-level managers. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 19 years of age and over Have some team leading or supervisory experience or managerial experience in the junior or middle management level Possess the ability to complete the Level 5 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression A possible progression route on successful completion of a CMI Level 5 in Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to level 6 or 7 Certificate) Why gain a CMI Qualification? This online CMI Level 5 Certificate in Management and Leadership course is perfect if you are a current or aspiring mid-level manager looking to advance in your career. The globally recognised CMI Level 5 Certificate is perfect for you if you want to increase your opportunities for obtaining a middle management position. The key leadership skills and knowledge you'll develop with this course will be remarkably effective. Upon completing this course, you can progress to further learning within the suite of Level 5 courses in Management and Leadership - i.e. achieving a certificate and topping up to a Diploma. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 6 or Level 7 courses in Management and Leadership, with the goal of becoming a Chartered Manager. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 5 Certificate in Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must complete any combination of units to a minimum of 130 TUT hours, 13 credits to achieve this qualification. There is a barred combination of units - learners taking 502 cannot select 503, 505 or 511, and learners taking 526 cannot select 501 or 502. Learners cannot select unit 608 as part of this qualification. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Principles of Management and Leadership in an Organisational Context Reference No : CMI 501 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand factors which impact on an organisation's internal environment. 2. Understand the application of management and leadership theories. 3. Understand the knowledge, skills and behaviours to be effective in a management and leadership role UNIT2- Principles of Developing, Managing and Leading Individuals and Teams to Achieve Success Reference No : CMI 502 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand approaches to developing, managing and leading teams 2. Understand approaches to achieving a balance of skills and experience in teams. 3. Know techniques for leading individuals and teams to achieve success. UNIT3- Managing Performance Reference No : CMI 504 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the rationale for managing performance within organisations. 2. Know how to manage performance. 3. Understand frameworks, diagnostic and evaluation tools used for performance management. UNIT4- Principles of Developing a Skilled and Talented Workforce Reference No : CMI 508 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the benefits of developing a skilled and talented workforce. 2. Understand the factors which influence workforce development. 3. Understand the scope of learning and development as part of a workforce development strategy. UNIT5- Managing Stakeholder Relationships Reference No : CMI 509 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the different types and value of stakeholder relationships. 2. Understand the frameworks for stakeholder management. 3. Know how to manage stakeholder relationships. UNIT6- Managing Conflict Reference No : CMI 510 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the types, causes, stages and impact of conflict within organisations. 2. Understand how to investigate conflict situations in the workplace. 3. Understand approaches, techniques, knowledge, skills and behaviours for managing conflict. UNIT7- Planning, Procuring and Managing Resources Reference No : CMI 516 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the importance of effective and efficient resource use in organisations. 2. Know how to plan resources to meet organisational objectives. 3. Know how to procure resources. UNIT8- Principles of Innovation Reference No : CMI 517 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role of innovation within organisations. 2. Understand the process of managing innovation in an organisation. UNIT9- Principles of Marketing Products and Services Reference No : CMI 523 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of marketing to support the achievement of organisational objectives. 2. Understand the factors in the organisation's marketing environment which impact on the marketing of a product or service. 3. Know how to market a product or service. UNIT10- Managing Finance Reference No : CMI 520 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand finance within organisations. 2. Know how to set and manage budgets. UNIT11- Using Data and Information for Decision Making Reference No : CMI 521 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the use of data and information in decision making. 2. Be able to interpret data and information to support decision making. 3. Know how to present data and information used for decision making. UNIT12- Managing Change Reference No : CMI 514 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for change in organisations. 2. Understand approaches to change management. 3. Understand how to initiate, plan and manage change in an organisation. UNIT13- Creating and Delivering Operational Plans Reference No : CMI 515 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the principles of operational planning in an organisation. 2. Know how to create an operational plan in line with organisational objectives. 3. Know how to manage and lead the delivery of an operational plan. UNIT14- Principles of Managing and Leading Individuals and Teams to Achieve Reference No : CMI 503 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand approaches to managing and leading teams. 2. Know how to achieve a balance of skills and experience in teams. 3. Know techniques for managing and leading individuals and teams to achieve success. UNIT15- Forming Successful Teams Reference No : CMI 505 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose and characteristics of successful teams. 2. Understand approaches to team formation. 3. Know how to analyse and respond to the challenges of team formation. UNIT16- Managing Equality, Diversity and Inclusion Reference No : CMI 506 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand legal and organisational approaches to equality, diversity and inclusion. 2. Understand the role and responsibilities of a manager in relation to equality, diversity and inclusion. 3. Know how to develop and implement plans which support equality, diversity and inclusion within an organisation. UNIT17- Principles of Delivering Coaching and Mentoring Reference No : CMI 507 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role and purpose of coaching and mentoring within an organisation. 2. Understand the use of models and processes used in workplace coaching and mentoring. 3. Know how to manage the delivery of effective coaching and mentoring. UNIT18- Principles of Recruiting, Selecting and Retaining Talent Reference No : CMI 511 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the factors that impact on recruitment and selection. 2. Know how to plan for recruitment and selection. 3. Understand approaches to the recruitment and selection of a diverse and talented workforce. UNIT19- Workforce Planning Reference No : CMI 512 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the rationale for workforce planning. 2. Understand the principles and practices of workforce planning. UNIT20- Managing Projects to Achieve Results Reference No : CMI 513 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of projects in delivering organisational strategy. 2. Understand processes for initiating, planning and managing projects. 3. Understand the factors which contribute to effective project management. UNIT21- Managing Risk Reference No : CMI 518 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope of business risk management. 2. Understand the process for managing business risk. UNIT22- Managing Quality and Continuous Improvement Reference No : CMI 519 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope and purpose of quality management within organisations. 2. Understand approaches for managing quality. 3. Understand the application of continuous improvement within organisations. UNIT23- Managing the Customer Experience Reference No : CMI 522 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the principles of managing the customer experience. 2. Understand the customer journey in the context of an organisation. 3. Know how to manage the customer experience. UNIT24- Conducting a Management Project Reference No : CMI 524 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Know how to plan a management project. 2. Be able to conduct a management project. UNIT25- Using Reflective Practice to Inform Personal and Professional Development Reference No : CMI 525 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the value of reflective practice to inform personal and professional development. 2. Know how to apply reflective practice to inform personal and professional development. UNIT26- Principles of Leadership Practice Reference No : CMI 526 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand leadership practice in an organisation. 2. Understand leadership styles 3. Understand the impact of leadership within organisations. UNIT27- Strategic Corporate Social Responsibility and Sustainability Reference No : CMI 608 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand corporate social responsibility and sustainability in organisational contexts. 2. Know how corporate social responsibility and sustainability is applied in an organisational setting. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Explore capture-the-flag exercises that will strengthen your ethical hacking skills

Get hands-on with advanced Microsoft Windows Server 2019 administration

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Take Your First Steps to become a Software Architect Today!

Gain valuable insights into LNG shipping economics and freight cost calculations with EnergyEdge's engaging classroom training course.

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.