Definitive VPNs training course description A hands on course covering VPNs from the basics of benefits and Internet vs. Intranet VPNs through to detailed analysis of the technologies involved in VPNs. All the major VPN protocols are covered including PPPoE, L2TP, SSL, IPsec and dynamic VPNs. MPLS L3 VPNs are also covered. What will you learn Describe what a VPN is and explain the difference between different VPN types. Recognise the design and implementation issues involved in implementing a VPN. Explain how the various technologies involved in a VPN work. Describe and implement: L2TP, IPsec, SSL, MPLS L3 VPNs. Evaluate VPN technologies. Definitive VPNs training course details Who will benefit: Network personnel. Prerequisites: IP Security foundation for engineers. Duration 3 days Definitive VPNs training course contents VPN overview What is a VPN? What is an IP VPN? VPNs vs. Private Data Networks, Internet VPNs, Intranet VPNs, Remote access VPNs, Site to site VPNs, VPN benefits and disadvantages. VPN Tunnelling VPN components, VPN tunnels, tunnel sources, tunnel end points, hardware based VPNs, Firewall based VPNs, software based VPNs, tunnelling topologies, tunnelling protocols, which tunnelling protocol should you use? requirements of tunnels. VPN security components Critical VPN security requirements, Encryption and authentication, Diffie Hellman, DES, 3DES, RSA, PKI, Ca server types, pre shared keys versus certificates, Enrolling with a CA, RADIUS in VPNs. PPP Encapsulation, operation, authentication. Hands on Setting up PPPoE and analysing PPP packets. PPTP Overview, Components, How it works, control and data connections, GRE. Hands on Building a PPTP VPN. L2TP Overview, components, how it works, security, packet authentication, L2TP/IPSec, L2TP/PPP, Layer 2 versus layer 3 tunnelling. Hands on Implementing a L2TP tunnel. IPSec AH, HMAC, ESP, transport and tunnel modes, Security Association, use of encryption and authentication algorithms, manual vs automated key exchange, NAT and other issues. Hands on Implementing an IPSec VPN. Intranet VPNs Headers, architecture, label switching, LDP, MPLS VPNs. VPN products and services PE and CPE, management, various VPN products. VPN issues and architectures VPN architectures: terminate VPN before/on/ after/in parallel with firewall, resilience issues, VRRP, performance issues, QoS and VPNs. documentation.
Description Your Dream 100 is a list of 100 influencers you'd most like to get next to. These 100 people share your values and stand to help you communicate those values - in any number of ways - to your prospects and customers. When you create your Dream 100 list and communicate with them in the unique ways I've laid out, you'll be able to reach meag-influencers within your industry. And JUST ONE of these people on your Dream 100 list is worth 1,000 CUSTOMERS. So you can imagine where your time is best spent in business creating relationships with your Dream 100 list! This Dream 100 Email Training Course will teach you how to create a Dream 100 list. You will learn how to communicate to your Dream 100, how to email your Dream 100, how to send lumpy mailers to your Dream 100, how to Success Hack your competition, and much more! Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Dream 100 Email Training Course 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 Dream 100 Email Training Course 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. Introduction FREE 00:02:00 Dream 100 Overview 00:14:00 Email Your Dream 100 00:17:00 Lump Mailers for Your Dream 100 00:18:00 Social Media and Your Dream 100 00:09:00 Assessment
Learn how to get more done and become a master of time management Do you want to be a good communicator? Become a master of time management Learn the latest time organization techniques, how to plan your calendar, manage your team and delegate tasks. Learn from the best The course is taught by a time management expert that will reveal effective methods and techniques based on his years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you try to manage your time, but still struggle to get anything done? If yes, then it’s time to take matters into your own hands and learn how to manage your time. Being able to manage your time wisely is crucial for anyone who wants to keep their life under control, no matter whether you run your own business or work for a company. We carefully designed this course in time management to answer all your needs. During the course, you will learn not only the most important theoretical issues of time planning methods, but above all, you will gain new practical skills on how to plan, organize your work time, rest time, and manage your calendar. We have prepared for you a series of repetition materials, practical tasks, tests, and necessary tools needed for skillful planning and increasing efficiency. If you are interested in increasing personal effectiveness, managing yourself and others, you are in the right place. We’ll introduce you to the best time management techniques and teach you planning and organizational skills for your career and life. Note: the training is designed for those with previous experience in time management, but also for those with no experience in the field. On the top of everything, at the end of the course, you will receive a certificate, which you can proudly display in your office or room, as well as boast about your experience in your CV. Join the communication course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Robert Sotelo Time Management Expert The time management course will be delivered by a time management expert, the best one in the field, with many years of experience. The trainer will share all the knowledge and experience with you and will teach you the most important theoretical issues of time planning methods. They will also teach you how to plan and organize your work time and your free time. At the end of the course, you’ll be a master of effectively managing your time; you’ll be the one who controls time. You’ll learn how to manage your schedule and how to arrange your weekly, monthly and yearly calendar. Your expert trainer will assist you and guide you through several knowledge repetitions, practical tasks and tests to make sure you remember all the important information and to consolidate your knowledge even better. Overview of the course: I. Video presentations Effective time managementOutline the most important aspects of controlling your time and calendar. Theoretical introduction and beyond. Personal effectiveness, managing yourself and others over timeSome tips on how to get the most efficiency. Tips related to human resource management. Time organization apps – essential toolsA presentation of the best apps to keep your calendar well organized. Time management methodsDiscuss the most important methods of managing time, your own and others. Use of specific techniques in theory and practice. Organizing your own workWork organizational systems in a professional context. How to handle pair duties well? II. Training videos Tools to support effective time managementA set of tools, apps and traditional forms of time organization. Guide how to use them properly. Making a task list and setting prioritiesExercises to consolidate the acquired theoretical knowledge. The 4-step method and its application in practiceDiscuss the 4-step method and the tasks involved in using it. Goal setting and implementationHow to set your goals and, with the help of a calendar, make them happen? Practical tasks and exercises to help manage time and combine it with goal setting Expert CalendarHow to arrange your calendar wisely? Expectations vs. reality. The most common time planning mistakes. III. Tests Tests and repetitions of acquired knowledgeAt the end of each section, you will receive a summary and a short test to make sure you remember all the important information. Final testAt the end of the course, you will have a final test, after which you will get your certificate. IV. Tasks Tasks and practical exercisesPractical tasks will allow you to consolidate your knowledge even better, e.g. adjusting time management techniques depending on the situation or developing a plan and calendar based on a case study. V. Bonus materials for the course Additional materials for daily work You will receive a collection of time management applications, a set of techniques for increasing efficiency or an example of time management training games, and more. A letter from your expert instructor: Are you overwhelmed by the amount of responsibilities? Are you still short on time? Do you feel time is slipping through your fingers? Are you constantly on the run? Do you have a lot of time, but you don’t know how to use it? Would you like to use every moment of the day effectively?Good news for you: We offer you an effective solution to all your time management problems. We are pleased to invite you to our time management course, carefully designed to teach you how to manage your time. You will gain new practical skills on how to plan and organize your work time, get more free time and manage your calendar.Through the course, you will go through tests and repetitions to make sure you remember all the important information. You will also complete tasks and practical exercises that will allow you to better consolidate your gained knowledge.After successfully completing the course, you will receive a certificate that will serve as a proof of your newly developed skills.Learn how to manage and control your time and become a master of time management!Join us today!Faustine ParsonsCommunication expert
Take The SIA Door Supervisor Course + First Aid, This Will Take You 6 Days To Complete. Enrol Now On To The Course! What Is SIA Door Supervisor Course? The SIA (Security Industry Authority) Door Supervisor Training is a comprehensive training program designed to prepare individuals for roles as door supervisors within the security industry in the United Kingdom. Door supervisors play a critical role in ensuring safety and security at licensed premises, including bars, clubs, and events. This SIA Door Supervisor Course + First Aid is 6 days, this is a compulsory course in order to attain the Door Supervisor Licence. Furthermore, this will allow you to work as a doorman, nightclub security, retail security, corporate security, construction security and many other security sectors. Enrol now or contact us for any further details. Course Overview: 6 Days Course | 09:00 – 18:30 | Mon – Sat Every Week SIA Door Supervisor Course Road Map 1. Book Course Book your SIA Door Supervisor Training and First Aid Course in London (6 Days) 2. Attend Course Attend a 6-day course, and successfully pass all your SIA Door Supervisor exams. 3. Apply SIA Register for an account with SIA, and apply for your SIA Door Supervisor Licence. Course Information Why Choose SIA Door Supervisor Course? Expert Instructors Learn from seasoned professionals who bring real-world insights to the classroom. Our instructors are dedicated to your success, offering guidance and support throughout the training. Practical Training Gain hands-on experience in simulated security scenarios, preparing you for the challenges you’ll face in the field. Our practical sessions enhance your problem-solving skills and decision-making abilities SIA Compliance Stay ahead in the security industry by understanding and complying with SIA regulations. Our course covers the latest guidelines, ensuring you are well-versed in the legal and ethical aspects of security operations Job Placement Assistance We go beyond training by offering job placement assistance. Our network of industry connections helps you kickstart your security career with confidence. Ready To Begi Your SIA Journey? Your journey toward a rewarding and responsible career as a Door Supervisor starts here. Contact us today to enrol in our Door Supervisor Training at London Construction College, and take the first step towards an exciting and impactful career in security. Your future awaits! SIA Door Supervisor Course Content Unit 1 : Working In The Private Security Industry Legal Considerations in the Private Security Industry. Ensuring Health and Safety for Private Security Operatives . Awareness of Fire Safety. Procedures for Emergency Situations. Effective Communication Skills and Customer Care. Unit 2: Working As A Door Supervisor Adherence to Behavioral Standards. Understanding Civil and Criminal Law. Procedures for Search Operations. Protocols for Arrest Situations. Awareness of Drugs and Their Impact. Documentation of Incidents and Preservation of Crime Scenes. Compliance with Licensing Laws. Emergency Procedures. Unit 3: Conflict Management For The Private Security Industry Conflict Avoidance and Personal Risk Mitigation. De-escalation of Conflicts. Resolution and Lessons from Conflicts . Application of Communication and Conflict Management Skills for Door Supervisors. Unit 4: Physical Intervention Skills For The Private Security Industry Overview of Physical Intervention Skills. Essential Legislation Awareness . Fun Fact: The persuasive Communication and Conflict Management skills acquired in this course are applicable both professionally and personally in conflict situations. This standalone component alone holds a value exceeding the course price. SIA Door Supervisor Exam On the last day of the course, you’ll encounter four multiple-choice exams along with a practical assessment. We acknowledge that exams can be intimidating, but rest assured, there’s no cause for concern. The Door Supervisor course comprehensively covers all exam topics, and your skilled instructor will thoroughly equip you for success in these assessments. Embarking on an exciting career in the security industry as a Door Supervisor or Security Guard starts with the initial step of acquiring the right training. Throughout your Door Supervisor training, we guide you through the entire process, offering essential training and providing the necessary materials to assist you in obtaining your SIA Door Supervisor license. Document Checks Proof Of Identity You will need to provide documents that prove you are who you say you are. Address history You need to provide two proofs of address. Bank or building society statement issued within the last three months. Utility bill issued within the last three months. A credit card statement was sent to your current address within the last three months. Council Tax statement issued in the last 12 months. Mortgage statement issued in the last 12 months. Age You must be 18 or over to hold an SIA licence. Criminal record Please be aware, that even if you pass the SIA door supervisor, you will still need to pass SIA criminal record checks. If you live outside the UK, or you have spent 6 continuous months or more outside the UK in the last 5 years, you need to provide evidence of overseas criminal record checks to the SIA. SIA will only issue a licence after completing background checks. Right to work in the UK You must have the right to work in the UK to get a front-line or non-front-line licence. Important Things You Should Know FAQ SIA Door Supervisor Training What is the SIA Door Supervisor course, and why do I need it? The SIA Door Supervisor course is a training program designed for individuals seeking employment in the security industry, specifically in roles such as door supervision. The Security Industry Authority (SIA) requires this qualification for those working in designated roles to ensure a standard level of competence and professionalism. What does the SIA Door Supervisor Course cover? The SIA course covers a range of topics essential for door supervisors, including conflict management, physical intervention, emergency procedures, legal responsibilities, and customer service. It provides a comprehensive skill set needed to excel in the role. Can I take the course in London? Yes, the SIA Door Supervisor course is available in London. How long does the course take to complete? The SIA Door Supervisor and First Aid is completed over 6 days of training. Is there an age requirement for taking the SIA Door Supervisor course? Yes, you must be at least 18 years old to take the SIA Door Supervisor course as it is a legal requirement for working in the security industry. What are the job prospects after completing the course? Successfully completing the SIA Door Supervisor course enhances your employability in the security industry. Door supervisors are in demand in various establishments, including nightclubs, bars, and events, and having the SIA qualification opens up job opportunities in these sectors. Do I need any prior experience in security to enrol in the course? No, prior experience in security is not a prerequisite for enrolling in the SIA Door Supervisor course. The course is designed to provide comprehensive training for individuals at various levels, including those new to the security industry. Can I take the SIA Door Supervisor course if I’m not a UK citizen? Yes, the SIA Door Supervisor course is open to individuals regardless of nationality. However, it’s essential to ensure that you meet the legal requirements for working in the UK, including visa regulations.
IP broadcast training course description A current hot topic in recent years has been the provision of multimedia services over IP networks aka triple or quadruple play. This course investigates the characteristics of video transmission and then studies the impact on IP networks. What will you learn Use Wireshark to analyse and troubleshoot TV streams. Describe techniques, which can be used in IP to provide low uniform delay. Evaluate IPTV technologies. Design data networks, which will support IPTV. IP broadcast training course details Who will benefit: Anyone working in broadcast. Prerequisites: TCP/IP foundation for engineers Duration 3 days IP broadcast training course contents What is IPTV? What is IP? What is TV? Pixels, frames, colour, digital modulation, digital video broadcasting. SDTV, HDTV, 4K. IPTV architectures, Contribution, distribution, delivery. IPTV standards. Hands on Base IP connectivity, VLC. IPTV protocol stacks IP, TCP, UDP, RTP. IPv6. HTTP. Bandwidth requirements. Hands on IPTV bandwidth calculations. Video codecs What is a CODEC, pictures and audio, digitisation, sampling, quantisation, encoding, compressing. MPEG, bit rates, resolution. I, B, P frames, GOP. MPEG 2, MPEG 4, H.264, H.265, VP9, AV1. Hands on Analysing MPEG frames. IP issues Quality vs. bandwidth. Bandwidth, delay, latency, jitter, signalling. Routers. Hands on Analysing jitter and other performance issues. IPTV performance and QoS IP DSCP field, queuing strategies; FIFO, WFQ, custom, priority, RED. Differentiated services, Diffserv. 802.1Q. Traffic shaping. QoE. Hands on best effort versus prioritisation. UDP versus TCP Reliable, unreliable, connection oriented, connectionless. Broadcasts, multicasts and unicasts. TCP flow control, TCP and performance. Hands on TCP window sizes. RTP RTP, ports, mixers, translators, RTCP, SMPTE, FEC. Hands on RTP analysis with Wireshark. Multicasting Multicasting compared to unicasting and broadcasting, when to use and when not to use multicasting. IGMP, PIM-SM, SSM. MLD. Hands on Analysing multicast streams. OTT TV HTTP, HTTPS, Chunked HTTP. Adaptive streaming. HTML5. DASH vs HLS. Hands on Analysing HTTP streams. Security Firewalls, TLS, DRM, watermarking. Encryption. Geolocation. VPNs. IPTV architecture and other protocols Content providers, Service providers, delivery networks, home networks. Caching, Service discovery. RTSP. SAP, SDP. DHCP, DNS, NTP
IPTV training course description A current hot topic in recent years has been the provision of multimedia services over IP networks aka triple or quadruple play. This course investigates the characteristics of video transmission and then studies the impact on IP networks. What will you learn Use Wireshark to analyse and troubleshoot TV streams. Describe techniques, which can be used in IP to provide low uniform delay. Evaluate IPTV technologies. Design data networks, which will support IPTV. IPTV training course details Who will benefit: Anyone working with IPTV. Prerequisites: TCP/IP Foundation for engineers Intro to data communications & networking. Duration 3 days IPTV training course contents What is IPTV? What is IP? What is TV? Pixels, frames, colour, digital modulation, digital video broadcasting. SDTV, HDTV, 4K. IPTV architectures, Contribution, distribution, delivery. IPTV standards. Hands on Base IP connectivity, VLC. IPTV protocol stacks IP, TCP, UDP, RTP. IPv6. HTTP. Bandwidth requirements. Hands on IPTV bandwidth calculations. Video codecs What is a CODEC, pictures and audio, digitisation, sampling, quantisation, encoding, compressing. MPEG, bit rates, resolution. I, B, P frames, GOP. MPEG 2, MPEG 4, H.264, H.265, VP9, AV1. Hands on Analysing MPEG frames. IP issues Quality vs. bandwidth. Bandwidth, delay, latency, jitter, signalling. Routers. Hands on Analysing jitter and other performance issues. IPTV performance and QoS IP DSCP field, queuing strategies; FIFO, WFQ, custom, priority, RED. Differentiated services, Diffserv. 802.1Q. Traffic shaping. QoE. Hands on best effort versus prioritisation. UDP versus TCP Reliable, unreliable, connection oriented, connectionless. Broadcasts, multicasts and unicasts. TCP flow control, TCP and performance. Hands on TCP window sizes. RTP RTP, ports, mixers, translators, RTCP, SMPTE, FEC. Hands on RTP analysis with Wireshark. Multicasting Multicasting compared to unicasting and broadcasting, when to use and when not to use multicasting. IGMP, PIM-SM, SSM. MLD. Hands on Analysing multicast streams. OTT TV HTTP, HTTPS, Chunked HTTP. Adaptive streaming. HTML5. DASH vs HLS. Hands on Analysing HTTP streams. Security Firewalls, TLS, DRM, watermarking. Encryption. Geolocation. VPNs. IPTV architecture and other protocols Content providers, Service providers, delivery networks, home networks. Caching, Service discovery. RTSP. SAP, SDP. DHCP, DNS, NTP Hands on Fixing the network.
This level two course is aimed at beginners with no previous electrical knowledge or experience who want to enter the electrical industry. Once this course is completed, candidates will be able to get a job as an electrician’s mate, gaining further skills and real-life experience. Once you have passed this level two course, you can move on to the next step of becoming a fully qualified electrician and take the 2365 level three course. You must be over 18 to take this course. Please note this course incorporates weeks 1 to 4 of the Total Electrical 20 course.
4G & 5G Roaming Scenarios & Procedures course description This course is designed to explain the roaming procedures of modern mobile networks, based on the GSMA roaming specification the course explains all scenarios where a mobile subscriber may find themselves whilst visiting a preferred mobile network partner. Interconnection between MNOs and the use of GRX & IPX as an interworking process. The course will work through the registration & authentication procedure, download of the user profile, the APN configuration & DIAMETER process to verify user authenticity. VoLTE roaming and IMS registration procedures for voice support & SMS delivery will be discussed and explained. What will you learn Architecture Models Technical requirements for interfaces - 4G Roaming Scenarios Technical requirements & recommendations for services Other Technical Requirements & Recommendations Technical Requirements for QoS support Technical Requirements & Recommendations for Interfaces - 5G Scenarios Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Technical Requirements & Recommendations for Services Other Technical Requirements & Recommendations 4G & 5G Roaming Scenarios & Procedures course details Who will benefit: Those working in mobile networks. Prerequisites: None. Duration 3 days 4G & 5G Roaming Scenarios & Procedures course contents Architecture Models 4G Evolved Packet System 5G Core Network SGs Interface for CSFB& SMS over SGs Technical Requirements for Interfaces - 4G Roaming Scenarios General requirements for inter-PLMN interfaces Stream Control Transmission Protocol (SCTP) IAMETER S8 Interface SGW selection PGW selection GTP Transport Layer engineering S9 interface Implementation requirements Guidelines for DIAMETER over S9 S6a & S6d interface Gy interface Guidelines for DIAMETER over Gy Legacy interworking scenarios VPLMN has not implemented LTE HPLMN has not implemented LTE Co-existence scenarios Possible scenarios 2G/3G roaming agreement only 2G/3G LTE roaming agreement LTE roaming registrations Consequences of different APN approaches when roaming Guidance regarding the APN approach when roaming Inter-RAT handover Handover & access restrictions to/from 2G/3G & LTE (Active mode) Access restriction for 2G/3G and/or LTE (Idle mode) Handover of PDN Connections between GERAN/UTRAN & LTE Handover to/from non-3GPP accesses & LTE Bandwidth considerations ARP considerations at handover from LTE to 2G/3G Tech requirements & recommendations for Services SMS SMS over SGs Voice CSFB Roaming retry for CSFB Roaming Forwarding for CSFB Coexistence of Roaming Forwarding & Roaming Retry Recommended procedures IMS Voice Roaming Architecture Other Technical Requirements & Recommendations Access Control Addressing APN for IMS based services IMS Well Known APN APN for Home Operator Services Gateway Selection Inter-PLMN roaming handover Data off related functionality Emergency Services Emergency PDN connectivity Emergency Call indicator Security GTP Security DIAMETER Security DIAMTER Roaming hubbing Default APN E-UTRA NR Dual Connectivity with EPC GW Selection for E-UTRA-NR Dual Connectivity TAC/LAC Restriction Guidelines Technical Requirements for QoS support QoS parameters definition QoS Management in the Home Routed architecture QoS control for IMS APN in the S8HR architecture Support of QoS in GRX/IPX QoS Control in Local Breakout architecture Technical Requirements & Recommendations for Interfaces - 5G Scenarios General requirements for inter-PLMN interfaces Transport protocol - TCP/IP Serialisation protocol - JSON Interface Definition language - OpenAPI Application Protocol - HTTP2 Inter-PLMN (N32) Interface N32c N32f ALS & IPX HTTP Proxy SMF & UPF in HPLMN & VPLMN Requirements related to Service Based Architecture Naming, addressing & routing for 5G SA roaming SEPP load distribution SEPP administration, naming convention & routing SEPP HTTP redirections Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Interworking scenarios Coexistence scenarios Inter-RAT Handover Handover & Access restriction between 5GC & EPC Technical Requirements & Recommendations for Services Network slicing Voice, Video & Messaging Location support UE Route Selection Policy Other Technical Requirements & Recommendations Access control IP Addressing DNN for IMS based services Emergency PDU Session Emergency Services Fallback Security Steering of Roaming in 5GS Technical Requirements for QoS support 5G QoS model 5G QoS profile QoS Control
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.